Default language.

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Load for Db2 13.1.

Replacing one partition without allowing concurrent 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 stopped 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.

//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) = '?')


Related topics

Syntax-diagrams-for-BMC-AMI-Load

SYSREC

SYSIN 


 

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