Replacing some partitions, adding data to some partitions, and leaving remaining partitions available
The following example illustrates replacing the data in some partitions, adding to existing data in other partitions, and leaving the remaining partitions in RW status.
This particular example replaces partitions 2, 4, and 6, and adds data to partitions 1, 3, and 5. During this load, BMC AMI Load stops partitions 1 through 6. All other partitions and all indexes remain in RW status.
//SYSREC DD DISP=SHR,DSN=USER.DATA
//SYSIN DD *
LOAD DATA RESUME YES INDDN SYSREC
INTO TABLE NGT.TABLE1 PARTS 2,4,6 REPLACE
(fieldSpecification)
INTO TABLE NGT.TABLE1 PARTS 1,3,5 RESUME YES
(fieldSpecification)
//SYSIN DD *
LOAD DATA RESUME YES INDDN SYSREC
INTO TABLE NGT.TABLE1 PARTS 2,4,6 REPLACE
(fieldSpecification)
INTO TABLE NGT.TABLE1 PARTS 1,3,5 RESUME YES
(fieldSpecification)
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*