BMC AMI Load parameters (LODPARMS DD)


BMC AMI Load parameters (LODPARMS DD) in alphabetical order

Parameter

Use and value

Specifies the ACCESS parameter of the DB2 -START command to use after the load is complete.

Controls the value that BMC AMI Load use for the primary allocation quantity for a new table space.

Specifies the number of records to insert before performing a commit during a LOAD RESUME YES SHRLEVEL CHANGE job.

Enables you to tell BMC AMI Load whether to retain or delete a discard data set if no rows were discarded after successfully completing the load process. 

Specifies the minimum return code that the BMC AMI Load product uses when the number of discarded input records is greater than the discard limit specified with the DISCARDS keyword.

Specifies the minimum return code that the BMC AMI Load product uses when the number of discarded input records is greater than 0.

Indicates the maximum number of discard messages that you want BMC AMI Load to print per partition.

Helps LOADPLUS users transition to BMC AMI Load and minimize the impact for existing BMC AMI Load users.

Specifies the number of thousands of records in the input file.

Specifies the size of the cache that BMC AMI Load uses when generating values for an identity column.

Specifies whether the VARCHAR input values are padded.

Updates statistics.

Enables you to tell BMC AMI Load whether to set CHECK pending status on table spaces that are involved in RI (referential integrity) constraints.

Enables you to tell BMC AMI Load whether to sort data in clustering index order.

Enables BMC AMI Load to use static Copy DDs for taking copies. 

Overrides the default that is in the configuration options.

Enables you to tell BMC AMI Load whether to write to source or shadow data sets during the load.

Specifies the minimum return code that the BMC AMI Load product uses when there are no loaded rows.

You can include these parameters in the LODPARMS DD in the configuration job stream and override them in the BMC AMI Utilities job stream.

 

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