Skip to Content
Information
Limited support BMC 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 Apptune for Db2 13.1.

DB2LOAD statement and parameter

The DB2LOAD statement specifies that the data collected to produce the reports is also written to a data set in a format that can be loaded into Db2 tables using the Db2 Load utility.

The DB2LOAD statement applies to the data that is collected for all reports that are produced by subsequent REPORT statements in the same job stream. The NODB2LOAD statement specifies that no data set is produced. NODB2LOAD is the default.

When used as a parameter of the REPORT statement, DB2LOAD applies only to the reports specified in that REPORT statement. A DB2LOAD or NODB2LOAD parameter of a REPORT statement overrides any DB2LOAD or NODB2LOAD statement that was previously specified.

The only valid abbreviation for DB2LOAD is DB2L, and the only valid abbreviation for NODB2LOAD is NODB2L. The following figure displays the syntax of the DB2LOAD statement and parameter.


GUID-A5A4A0B0-A8C0-4D18-AC98-95A99427B15C-low.png

To use DB2LOAD, you must define a DB2LOAD DD statement in your JCL to show the data set to hold the loaded data. For an example, see Loading-Apptune-data-into-Db2-tables.

The reports listed in the following table were designed specifically to be used with the DB2LOAD statement or parameter to produce data in a tabular format. There is a field in each group that corresponds to each field in the relevant record, and a group that corresponds to each record.

Reports used with DB2LOAD statement or parameter

Report

Description

LOAD004

SQL exceptions

LOAD007

SQL errors (SQLCA)

LOAD008

Object statistics (per SQL statement)

LOAD009

Object statistics (per interval)

LOAD307

SQL statement summary (all qualifiers)

Warning

Note

The DB2LOAD statement is supported only when used with one of the LOADxxx reports described in the preceding table. The content of the report determines the format of the data produced and the results are unpredictable when used with a report other than a LOADxxx report. It is recommended that the DB2LOAD statement and parameter be used only with the LOADxxx reports.

Because the format of the loaded data or DDL generated by this statement or parameter is determined by the definition of the report that is used to generate the data, any change to the report definition also changes the format of the data or DDL that is generated. The data that is generated using the changed report no longer matches the Db2 table definition that was generated using the previous version.

The DB2LOAD reports shown in the Reports used with DB2LOAD statement or parameter table can change from one release of Apptune to another to accommodate changes in the records. To keep these changes from affecting your report, take one of the following actions:

  • Create a new table or tables corresponding to the new report without attempting to load data from the old report

Modify the old tables to include the changes in the new report

Information
Example

The DB2LOAD statement produces a report that includes all SQL records in the input data set that are associated with the COMPANY application profile.

APPPROF(COMPANY.SYSTEM)
REPORT(NAME(LOAD307) DB2LOAD)

The data that is produced by this DB2LOAD parameter is used as input to the DOMBLOD1 utility to produce appropriate CREATE TABLE DDL and Load utility control statements. For instructions, see DOMBLOD1-utility.

Related topic

DOMBRPT1-utility



 

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

BMC AMI Apptune for Db2 12.1