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 LOADPLUS for DB2 13.1.

SYSIDCIN data set in LOADPLUS


SYSIDCIN is the input data set that contains your IDCAMS command statements.

LOADPLUS uses these statements to delete and redefine user-defined (VCAT-defined) data sets or the staging data sets for your VCAT-defined data sets. LOADPLUS issues the commands that the SYSIDCIN data set contains. You are responsible for command specifications and results.

LOADPLUS requires a SYSIDCIN data set if the value of the REDEFINE option is YES and either of the following conditions exists:

  • You want to delete and redefine your existing VCAT-defined VSAM data sets as part of the load.
  • You specify a load job that uses staging data sets and you are loading VCAT-defined data sets.

If you specify REDEFINE YES and do not provide a SYSIDCIN data set, LOADPLUS operates as if you specified REDEFINE NO.

Important

You still have the option of deleting and redefining VCAT-defined data sets when you specify PRELOAD PAUSE. However, when you specify PRELOAD CONTINUE or PRELOAD LOAD, the only way to delete and redefine VCAT-defined data sets as part of the load is to specify REDEFINE YES and provide a SYSIDCIN data set that contains the necessary IDCAMS command statements.

If any referenced object is VCAT-defined, the UTILINIT phase reads, parses, and performs minimal verification checks on the commands in this data set. LOADPLUS issues the commands during load processing.

SYSIDCIN can be either a single or concatenated list of sequential data sets, partitioned data set members, or both. You must define this data set as fixed length with blocked records (RECFM=FB), and the record length must be 80 bytes (LRECL=80). LOADPLUS uses only columns 1 through 72. To override the default ddname, SYSIDCIN, use the IDCDDN command option.

For important restart information, see Restarting-LOADPLUS

Guidelines for providing IDCAMS commands in the SYSIDCIN data set

LOADPLUS supports the following IDCAMS commands and their parameters as defined in the IBM DFSMS Access Method Services for Catalogsdocument:

  • DELETE
  • DEFINE
  • SET
  • IF-THEN-ELSE command sequence
  • DO/END (with restrictions)

LOADPLUS does not allow the following IDCAMS command specifications. LOADPLUS checks for these specifications during the UTILINIT phase and terminates with an error message if it finds any of them.

  • An IF statement without a DEFINE, DELETE, or SET command
  • A nested IF statement
  • Different data set names specified in an IF statement
  • More than one DO/END statement within a single THEN or ELSE clause
  • A DO/END statement existing outside of an IF statement
  • An embedded comment (a comment within a comment)
  • A comment on a DO statement that continues to the next line
  • A keyword that continues to the next line

To avoid a failure during processing, ensure that each DEFINE has a corresponding DELETE specified before it and that each DELETE has a corresponding DEFINE specified after it. Ensure that both commands specify the same data set name.

You can use the SET command to reset the IDCAMS condition code if a failure occurs in the LOAD or COMBINED phase and you do not want LOADPLUS to terminate.

When you specify SHRLEVEL NONE

Using the guidelines in the preceding section, specify commands only for those VCAT-defined data sets that you want to delete and redefine. LOADPLUS reuses any data sets participating in the load that have no corresponding IDCAMS commands. LOADPLUS ignores any command that references a data set that does not participate in the load and issues message BMC50604I. LOADPLUS ignores any empty SYSIDCIN data set and continues processing. 

When you specify SHRLEVEL CHANGE (except an SQLAPPLY load) or SHRLEVEL REFERENCE

Using the Guidelines for providing IDCAMS commands in the SYSIDCIN data set, specify commands that operate only on the staging data sets for your VCAT-defined data sets. Always use the naming conventions outlined in Staging-data-sets.

To define the staging data sets and avoid definition errors, provide a DELETE statement followed by a SET MAXCC=0 command (in case the delete process fails) before each DEFINE statement. LOADPLUS processes this set of statements (DELETE, SET MAXCC, DEFINE) for each object as the LOAD or COMBINED phase begins for that object. LOADPLUS ignores any command that references one of the original VCAT-defined data sets and issues message BMC50604I.

 

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