SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

For example, if an SQL/MX table to be dumped has the definition:
CREATE TABLE CAT.SCH.T056T11
(
WREN INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, JUNCO INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, BLACKBIRD INT DEFAULT NULL
, CONSTRAINT CAT.SCH.T056T11_104569472_0002 PRIMARY KEY (WREN
ASC, JUNCO ASC) NOT DROPPABLE
, CONSTRAINT CAT.SCH.T056T11_104569472_0001 CHECK
(CAT.SCH.T056T11.WREN IS NOT NULL AND CAT.SCH.T056T11.JUNCO
IS NOT NULL) NOT DROPPABLE
)
LOCATION \NSK.$DATA1.ZSDADLON.NSPD2Q00
PARTITION
(
ADD FIRST KEY (30)
LOCATION \NSK.$DATA2.ZSDADLON.N0FK2Q00
, ADD FIRST KEY (170)
LOCATION \NSK.$DATA3.ZSDADLON.N75R2Q00
, ADD FIRST KEY (190)
LOCATION \NSK.$DATA4.ZSDADLON.OFVY2Q00
, ADD FIRST KEY (300)
LOCATION \NSK.$DATA5.ZSDADLON.ONL42Q00
)
STORE BY (WREN ASC, JUNCO ASC)
;
CREATE UNIQUE INDEX T056IN6 ON CAT.SCH.T056T11
(
BLACKBIRD ASC
)
LOCATION \NSK.$DATA1.ZSDADLON.R70U5Q00
PARTITION
(
ADD FIRST KEY (150)
LOCATION \NSK.$DATA2.ZSDADLON.SFQ15Q00
, ADD FIRST KEY (180)
LOCATION \NSK.$DATA3.ZSDADLON.SNG85Q00
);
The corresponding DUMP FILES command to dump only the files in this table would be:
DUMP FILES &
( &
$DATA1.ZSDADLON.NSPD2Q00,&
$DATA2.ZSDADLON.N0FK2Q00,&
$DATA3.ZSDADLON.N75R2Q00,&
$DATA4.ZSDADLON.OFVY2Q00,&
$DATA5.ZSDADLON.ONL42Q00,&
$DATA1.ZSDADLON.R70U5Q00,&
$DATA2.ZSDADLON.SFQ15Q00,&
$DATA3.ZSDADLON.SNG85Q00,&
$DATA1.ZSDADLON.NSPD2Q01,&
$DATA2.ZSDADLON.N0FK2Q01,&
$DATA3.ZSDADLON.N75R2Q01,&
$DATA4.ZSDADLON.OFVY2Q01,&
$DATA5.ZSDADLON.ONL42Q01,&
$DATA1.ZSDADLON.R70U5Q01,&
$DATA2.ZSDADLON.SFQ15Q01,&
$DATA3.ZSDADLON.SNG85Q01 &
)
54 Planning Database Security and Recovery