Replacing one partition while allowing concurrent READ access

The following example illustrates how to replace one partition of the table space and leave the existing data in the other partitions. In this example, the partition that is being loaded is in RO status and the remaining partitions, as well as the indexes on the table space, are in RW status.

If the data for other partitions is in the input file, BMC AMI Load discards that data because it does not belong in the partition being loaded.

Important

For the assumptions made in this example, see Assumptions made in the syntax examples.

Related topics

LODPARMS

SYSREC

SYSIN 


Example 1
//LODPARMS  DD *
  +WRITETO(B)
//SYSREC    DD DISP=SHR,DSN=USER.DATA
//SYSIN     DD *
  LOAD DATA INDDN SYSREC
  INTO TABLE NGT.TABLE1 PART 1 REPLACE
  (ID POSITION(2),
   MESSAGE POSITION(*)  CHAR(34) NULLIF(1:1) = '?',
   LANGUAGE POSITION(*)  CHAR(10) DEFAULTIF(1:1) = '?')


Example 2
//LODPARMS  DD *  
//SYSREC    DD DISP=SHR,DSN=USER.DATA
//SYSIN     DD *
  LOAD DATA INDDN SYSREC SHRLEVEL REFERENCE
  INTO TABLE NGT.TABLE1 PART 1 REPLACE
  (ID POSITION(2),
   MESSAGE POSITION(*)  CHAR(34) NULLIF(1:1) = '?',
   LANGUAGE POSITION(*)  CHAR(10) DEFAULTIF(1:1) = '?')

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*