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 data while allowing concurrent read access

This example illustrates how to run a LOAD REPLACE job while leaving the table space in read-only (RO) status.

This example uses the SHRLEVEL REFERENCE option to tell BMC AMI Load to leave the original table space in RO status during the load and create shadow data sets. BMC AMI Load loads the new data to these shadow data sets, and then stops the table space to perform rename or fastswitch processing.

Important

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

The benefit of this job is data availability; the cost is the additional DASD required for the shadow copies during the load process.

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

Important

Alternatively, you can use the +WRITETO(B) parameter instead of SHRLEVEL REFERENCE.

Related topics

LODPARMS

WRITETO

SYSREC

SYSIN 


 

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