Information
Space announcement: 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.

Load reports


File-AID/RDX generates the reports described below during the load process:

SQL Insert - DB2 Authority Report

Contains information about the Db2 authority of the SQLID to be used for the load.

DB2 Load - DB2 Authority Report

Contains information about the Db2 authority of the SQLID to be used for the load.

Create DB2 Target Environment Report

Contains information about the Db2 tables to be created during the execution phase of the Load function.

Pre-Load Summary Report

Contains a summary of the tables and rows to be loaded. This report is generated when you use the Db2 Load Utility option.

SQL Insert: DB2 Totals Report

Contains information about rows inserted, updated, and discarded. This report is generated when you use the SQL INSERT option.

MVS Load - MVS Totals Report

Contains information about records inserted, updated, and discarded. This report is generated when you load MVS files.

SQL Insert: DB2 Committed Rows Report

Contains information about how many times Db2 COMMITS were issued and how many rows were affected. This report is generated when you use the SQL INSERT option.

SQL Insert - DB2 Delete Report

Contains information about rows deleted during load. This report is generated when you use the SQL INSERT option.

DB2 Load - DB2 Delete Report

Contains information about rows deleted during load. This report is generated when you use the Db2 Load option.

SQL Insert: DB2 Discard Report

Contains information about rows that were not inserted or updated during load. This report is generated when you use the SQL INSERT option.

MVS Load: VSAM Discard Report

Contains information about records that were not inserted or updated during load. This report is generated when your load includes VSAM objects.

SQL Insert - DB2 Authority Report

The SQL Insert - Db2 Authority Report shown in the following figure contains information about the authority of a given SQLID.

SQL Insert - DB2 Authority Report

File-AID/RDX  21.1                                   SQL Insert - DB2 Authority Report                               PAGE  1
                                                                                                                    DATE  2005-08-15
Extract File. . : TSOID01.R42.EXTRACT(Member)                                                                       TIME  12.01.53
                                                                                                                   
SQLID. . . . . .: TSOID01

Objects With Errors                                                  
------------------------------------------------------------------------------------------------------------------------------------
 Error: E273 The SQLID does not have authority to execute SQL Insert
Target: D-FADB2.ORDER_1

 Error: E273 The SQLID does not have authority to execute SQL Insert
Target: D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6 ____+____7____+____8____+____9_____+___10___
          _+___11____+___12____+___.TABLE____1____+____2__+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10_
          ___+___ 11____+___12____+___
 
                                                      * *  END OF REPORT  * * *

The header part of the report shows the following:

  • The name of the extract file. If the extract file is a PDS, the member name is also displayed.
  • The SQLID used for the load request.

The SQL Insert - Db2 Authority Report provides the following information:

Objects With Errors

Lists the errors and the name of the target object the error applies to.

Error

Lists the File-AID/RDX error message associated with the object in error.

Target

Lists the name of the target object the error applies to.

DB2 Load - DB2 Authority Report

The Db2 Load - Db2 Authority Report shown in the following figure contains information about the authority of a given SQLID.

DB2 Load - DB2 Authority Report

File-AID/RDX  21.1                                    DB2 Load - DB2 Authority Report                                PAGE  1
                                                                                                                    DATE  2005-08-15
Extract File. . : TSOID01.R42.EXTRACT(Member)                                                                       TIME  12.01.53
                                                                                                                   
SQLID. . . . . .: TSOID01

Objects With Errors                                                  
------------------------------------------------------------------------------------------------------------------------------------
 Error: E273 The SQLID does not have authority to execute Load Utility
Target: D-FADB2.ORDER_1

 Error: E273 The SQLID does not have authority to execute Load Utility
Target: D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6 ____+____7____+____8____+____9_____+___10___
          _+___11____+___12____+___.TABLE____1____+____2__+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10_
          ___+___ 11____+___12____+___
 
                                                      * *  END OF REPORT  * * *

The header part of the report shows the following:

  • The name of the extract file. If the extract file is a PDS, the member name is also displayed.
  • The SQLID used for the load request.

The Db2 Load - Db2 Authority Report provides the following information:

Objects With Errors

Lists the errors and the name of the target object the error applies to.

Error

Lists the File-AID/RDX error message associated with the object in error.

Target

Lists the name of the target object the error applies to.

Create DB2 Target Environment Report

The Create Db2 Target Environment Report shown in the following figure contains information about tables created during the execution phase of the Load function.

Create DB2 Target Environment Report

File-AID/RDX  21.1                         Create DB2 Target Environment Report                                      PAGE  1
                                                                                                                    DATE  2005-08-15
Extract File. . : TSOID01.R42.EXTRACT(Member)                                                                       TIME  12.01.53
                                                                                                                    SSID  D810
Status      Action             Object Name                                      
----------  -----------------  ----------------------------------------------------------------------------------------------------
Successful  CREATE DATABASE    D-DSNLOCAT.PFHIAFDB

Successful  CREATE TABLESPACE  D-DSNLOCAT.PFHIAFTS

Successful  CREATE TABLE       D-DSNLOCAT.TSOID01.CONTACT_TABLE
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.CONTACT_IDX          

Successful  CREATE TABLE       D-DSNLOCAT.TSOID01.CUSTOMER_TABLE                                    
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.CUSTOMER_IDX       

Successful  CREATE TABLE       D-DSNLOCAT.TSOID01.DEPT                                               
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XDEPT1            
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XDEPT2                                  
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XDEPT3                                  

Successful  CREATE TABLE       D-DSNLOCAT.TSOID01.EMP                                                
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XEMP1                                    
Failed      CREATE INDEX       D-DSNLOCAT.TSOID01.XEMP2  
                                            Error:  Eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

Successful  CREATE TABLE       D-DSNLOCAT.TSOID01.EMPPROJACT                                         
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XEMPPROJACT1                      
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XEMPPROJACT2                      

Successful  CREATE TABLE       D-DSNLOCAT.TSOID01.PROJ                                               
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XPROJ1                                  
Successful  CREATE INDEX       D-DSNLOCAT.TSOID01.XPROJ2                                  

Successful  CREATE TABLE       D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8__
                                 __+____9_____+___10____+___11____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5__
                                 __+____6____+____7____+____8____+____9____+___10____+___11____+___12____+___
Successful  CREATE INDEX       D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8__
                                 __+____9_____+___10____+___11____+___12____+___.INDEX____1____+____2____+____3____+___4____+____5__
                                 __+____6____+____7____+____8____+____9____+___10____+___11____+___12____+___


Successful  ALTER  TABLE       D-DSNLOCAT.TSOID01.CONTACT_TABLE                                      

Successful  ALTER  TABLE       D-DSNLOCAT.TSOID01.DEPT                                               

Successful  ALTER  TABLE       D-DSNLOCAT.TSOID01.DEPT                                               

Successful  ALTER  TABLE       D-DSNLOCAT.TSOID01.EMPPROJACT                                         

Successful  ALTER  TABLE       D-DSNLOCAT.TSOID01.EMPPROJACT                                         

Successful  ALTER  TABLE       D-DSNLOCAT.TSOID01.PROJ                                               

                                                          * * *  END OF REPORT  * * *

The header part of the report shows the following:

  • The name of the extract file. If the extract file is a PDS, the member name is also displayed.
  • The Db2 subsystem ID.

The Create Db2 Target Environment Report lists all Db2 objects created for the load request with status and action columns.

Status

A list of messages indicating the success or failure of the action. If status is failed, the error message is listed in the following line.

Action

A list of Db2 operations taken for the Db2 object.

Object Name

A list of objects that were not created during the load.

Error

The File-AID/RDX error message associated with the object that was not created successfully.

Pre-Load Summary Report

The Pre-Load Summary Report shown in the following figure is summary of the objects and records to be loaded. This report is generated when you use the Db2 LOAD Utility option or load MVS objects. At the end of the report, File-AID/RDX lists the total number of records loaded into n target objects as well as how many objects had no records extracted.

Pre-Load Summary Report

File-AID/RDX  21.1                                     Pre-Load Summary Report                                       PAGE  1
                                                                                                                    DATE  2005-08-15
Extract File. . : TSOID01.R42.EXTRACT(Member)                                                                       TIME  12.01.53
                                                                                                                   

      Delete    Replace   Extracted             
ID    All Data  Matches        Rows  Source Object Extracted and Target Object to be Loaded                                           
----  --------  -------  ----------  -----------------------------------------------------------------------------------------------
D001  No        -                43  Source: D-DSNLOCAT.TSOID01.EMP  
                                     Target: D-DSNLOCAT.TSOID01.EMP  

D002  No        -                 3  Source: M-TSOID01.FASAMP.EMPMAST    
                                     Target: M-TSOID01.FASAMP.EMPMAST.AC                          

D003  No        -                 3  Source: M-TSOID01.FASAMP.EMPLOYEE    
                                     Target: M-TSOID01.FASAMP.EMPLOYEE.AC  

D004  No        -                 0  Source: D-DSNLOCAT.TSOID01.PROJ
                                     Target: D-DSNLOCAT.TSOID01.PROJ

D005  No        -                 9  Source: D-DSNLOCAT.TSOID01.DEPT  
                                     Target: D-DSNLOCAT.TSOID01.DEPT

D006  No        -                 0  Source: D-DSNLOCAT.TSOID01.ACT
                                     Target: D-DSNLOCAT.TSOID01.ACT

D007  No        -                 0  Source: D-DSNLOCAT.TSOID01.PROJACT
                                     Target: D-DSNLOCAT.TSOID01.PROJACT  

D008  No        -                 0  Source: D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6 ____+__
                                               __7____+____8____+____9_____+___10____+___11____+___12____+___.TABLE____1____+____2__
                                               __+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10____+___
                                               11____+___12____+___
                                     Target: D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6 ____+__
                                               __7____+____8____+____9_____+___10____+___11____+___12____+___.TABLE____1____+____2__
                                               __+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10____+___
                                               11____+___12____+___

*****  58 TOTAL rows will be loaded to 4 objects  *****

*****  8 Objects included in the Extract File, 4 objects had no rows extracted  *****

                                                    * * *  END OF REPORT  * * *

The header part of the report the name of the extract file. If the extract file is a PDS, the member name is also displayed.

The Pre-Load Summary Report consists of the following columns:

ID

The File-AID/RDX extract object identifier for the object to be loaded.

Delete ALL data

(Db2 only) Indicates whether or not File-AID/RDX deletes ALL of the data residing in the target objects before it loads data from the extract file. For Db2 tables, Db2 delete rules are in effect.

Yes

Delete all rows from the specified object before loading data.

New

Indicates that objects are to be created; they do not exist and, therefore, do not contain data to be deleted.

No

Indicates that the data is to be loaded into objects without deleting all existing rows.

Delete/Define

(MVS files only) Indicates whether or not File-AID/RDX deletes the target file and then redefines it before it loads data from the extract file.

Yes

File-AID/RDX deletes the object and then creates it again before loading data.

No

File-AID/RDX appends data to the existing target object.

Replace Matches

When adding data to an object that is not empty and the INSERT operation fails because the row or record already exists, this setting indicates whether or not the data should be replaced.

Yes

For MVS:
If the target object is indexed (KSDS), data from the extract file replaces existing data in the target object.

For Db2:
If the target Db2 table has a unique index, data from the extract file replaces existing data in the target table.

No

For MVS:
If the target object is indexed and an existing target record has a unique key that matches the data from the extract file, the data from the extract file is discarded.

For Db2:
If the target table has a unique index and an existing target row has a unique key that matches the data from the extract file, the data from the extract file is discarded. If the target table does not contain a unique index and rows to be loaded already exist, no data is discarded.

Extracted Rows

Indicates the number of extracted records (rows) to be loaded into each target object.

Source Object Extracted and Target Object to be Loaded

A list of the source and target objects to be loaded.

Source

Name of the source object from which records were extracted.

Target

Name of the target object to be loaded.

At the end of the Pre-Load Summary Report, messages summarize how many total records will be loaded into the number of total objects, as well as, how many objects are in the extract file, including the number of objects with no records extracted.

SQL Insert: DB2 Totals Report

The SQL Insert: Db2 Totals Report shown in the following figure is a summary of the tables and rows that were loaded.

SQL Insert: DB2 Totals Report

File-AID/RDX  21.1                                    SQL Insert: DB2 Totals Report                                  PAGE  1
                                                                                                                    DATE  2005-08-15
                                                                                                                    TIME  15.04.48
                                                                                                                   
                                                                   
                                                   
 Inserted   Replaced  Discarded  Load Object
---------- ---------- ----------  ---------------------------------------------------------------------------------------------------
         0         43          0  D-DSNLOCAT.TSOID01.EMP
         9          0          0  D-DSNLOCAT.TSOID01.DEPT                                             
         1          0          0  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8
                                    ____+____9_____+___10____+___11____+___12____+___.TABLE____1____+____2____+____3____+___4____+___
                                    _5____+____6____+____7____+____8____+____9____+___10____+___11____+___12____+___

*****  53 TOTAL rows were Loaded to 3 objects  *****

*****  0 TOTAL rows were Discarded  *****

                                                     * * *  END OF REPORT  * * *

The SQL Insert: Db2 Totals Report report consists of the following columns:

Inserted

The number of rows inserted into each object.

Replaced

The number of rows updated in each object.

Discarded

The number of extracted rows not loaded, but discarded, for each object.

Load Object

A list of the objects to which rows will be inserted.

MVS Load - MVS Totals Report

The MVS Load - MVS Totals Report shown in the following figure is a summary of the objects that were loaded, showing how many records have been inserted, replaced, or discarded.

MVS Load - MVS Totals Report

File-AID/RDX  21.1                                    MVS Load - MVS Totals Report                                   PAGE  1
                                                                                                                    DATE  2005-08-15
                                                                                                                    TIME  15.04.48

                                                             

  Inserted   Replaced  Discarded  Load Object
---------- ---------- ----------  ----------------------------------------------------------------------------------------------  
         3          -          -  M-TSOID01.FASAMP.EMPMAST.EMPM                           
         0          0          3  M-TSOID01.FASAMP.EMPLOYEE.EMPM                             

***** 3 TOTAL rows were Loaded to 1 object  *****

***** 3 TOTAL rows were Discarded for 1 object  *****

                                                     * * *  END OF REPORT  * * *

The MVS Load - MVS Totals Report consists of the following columns:

Inserted

The number of records inserted into each file.

Replaced

The number of records updated in each file.

Discarded

The number of extracted records not loaded, but discarded, for each file.

Load Object

A list of the files to which records are loaded.

SQL Insert: DB2 Committed Rows Report

The SQL Insert: Db2 Committed Rows Report shown in the following figure is a summary of information about the rows inserted and committed.

SQL Insert: DB2 Committed Rows Report

File-AID/RDX  21.1                                 SQL Insert: DB2 Committed Rows Report                             PAGE  1
                                                                                                                    DATE  2005-08-15
                                                                                                                    TIME  15.04.49
                                                                                                                   

Note:  Use the last entry in the "Restart Point" column when you restart the job.                                Commit Interval:  2

Target Table: D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8____+____9_____+___
                10____+___11____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5____+____6____+____7____+____8____+_
                ___9____+___10____+___11____+___12____+___

                Restart Point                Committed  
                --------------------------  ----------  
                RESTART=00000002/00000000            2
                RESTART=00000004/00000000            2
                RESTART=00000006/00000000            2
                RESTART=00000008/00000000            2
                RESTART=00000010/00000000            2
                RESTART=00000012/00000000            2
                RESTART=00000014/00000000            2
                RESTART=00000016/00000000            2
                RESTART=00000018/00000000            2
                RESTART=00000020/00000000            2
                RESTART=00000022/00000000            2
                RESTART=00000024/00000000            2
                RESTART=00000026/00000000            2
                RESTART=00000028/00000000            2
                RESTART=00000032/00000000            2
                RESTART=00000034/00000000            2
                RESTART=00000036/00000000            2
                RESTART=00000038/00000000            2
                RESTART=00000040/00000000            2
                RESTART=00000042/00000000            2
                Next Restart Point                   1


Target Table: D-TSOID01.DEPT

                Restart Point                Committed  
                --------------------------  ----------  
                RESTART=00000044/00000000            1
                RESTART=00000046/00000000            2
                RESTART=00000048/00000000            2
                RESTART=00000050/00000000            2
                RESTART=00000052/00000000            2

The SQL Insert: Db2 Committed Rows Report displays the location of the tables into which rows were inserted and the commit interval you specified in the Commit Every Nth Row field on the Processing Options screen. In addition, the SQL Insert: Db2 Committed Rows Report contains the following columns:

Target Table

A list of the tables to which rows have been committed. Entries in this column are arranged such that each grouping represents the tables to which rows were committed within any given commit interval.

Restart Point

For each group of rows committed in a given commit interval, this column displays the values for the RESTART parameter in the DD EXTPARMS data set necessary to restart the load job without causing errors.

Committed

Displays the number of rows committed at each commit interval. If you specified a value other than an asterisk (*) in the Maximum Rows to Discard field on the SQL Insert Processing Options screen and you reach that value, the last entry in this column may contain a number less than the commit interval.

SQL Insert - DB2 Delete Report

The SQL Insert - Db2 Delete Report shown in the following figure is a summary of the data deleted during the load process.

SQL Insert - DB2 Delete Report

File-AID/RDX  21.1                                    SQL Insert - DB2 Delete Report                                 PAGE  1
                                                                                                                    DATE  2005-08-15
                                                                                                                    TIME  15.04.48
                                                                                                                    SSID  D810

      Rows  Deleted ALL EXISTING Data From Object
----------  ------------------------------------------------------------------------------------------------------------------------
                                                   
         4  D-DSNLOCAT.TSOID01.DEPT                         

         1  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8____+____9_____+___10
              ____+___11____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5____+____6____+____7____+____8____+____9
              ____+___10____+___11____+___12____+___

*****  5 TOTAL rows were Deleted from 2 objects  *****

                                                    * * *  END OF REPORT  * * *

The header part of the report shows the Db2 subsystem ID.

The SQL Insert - Db2 Delete Report displays the location of the tables from which rows were deleted. In addition, it contains the following columns:

Rows

The number of rows deleted from each table.

Warning

Important

If the number of rows shows -1, it indicates that Db2 executed a mass delete from a table in a segmented tablespace.

Deleted ALL EXISTING Data From Object

A list of tables from which rows were deleted.

DB2 Load - DB2 Delete Report

The Db2 Load - Db2 Delete Report shown in the following figure is a summary of the data deleted during the load process.

DB2 Load - DB2 Delete Report

File-AID/RDX  21.1                                     Db2 Load - Db2 Delete Report                                  PAGE  1
                                                                                                                    DATE  2005-08-15
                                                                                                                    TIME  15.04.48
                                                                                                                    SSID  D810
                                                                                                                   
Deleted ALL EXISTING Data From Object:
  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+ ____7____+____8____+____9_____+___10____+___11
    ____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10____+___11_
    ___+___12____+___
-------------------------------------------------------------------------------------------------------------------------------------

Referential constraint successfully dropped from table:
  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+ ____7____+____8____+____9_____+___10____+___11
    ____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10____+___11_
    ___+___12____+___


There were no rows to delete from table:
  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+ ____7____+____8____+____9_____+___10____+___11
    ____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10____+___11_
    ___+___12____+___

Referential constraint successfully restored on table:
  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+ ____7____+____8____+____9_____+___10____+___11
    ____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5____+____6____+____7____+____8____+____9____+___10____+___11_
    ___+___12____+___

                                                     * * *  END OF REPORT  * * *

The header part of the report shows the Db2 subsystem ID.

The Db2 Load - Db2 Delete Report displays an execution message for each table from which rows were deleted. The following are possible messages:

  • Deleted ALL EXISTING Data From Object
  • Referential constraint successfully dropped from table
  • Referential constraint successfully restored on table
  • There were no rows to delete from table

SQL Insert: DB2 Discard Report

The SQL Insert: Db2 Discard Report  shown in the following figure is a summary of rows discarded during load processing.

SQL Insert: DB2 Discard Report

File-AID/RDX  21.1                                     SQL Insert: DB2 Discard Report                                PAGE  1
                                                                                                                    DATE  2005-08-15
                                                                                                                    TIME  15.04.48
                                                                                                                    SSID  D810
Discard File . .: TSOID01.R43.DISCARD                          
  
   Note: 1) The "Record Number" indicates the relative data record within the Discard File; the line number when Viewing the file.
         2) Detailed information on the SQL code or RDX error code causing the discard can be found in the RDERRORS DDNAME

Target Object:  LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8____+____9_____+__
                _10____+___11____+___12____+___.TABLE____1____+____2____+____3____+___4____+____5____+____6____+____7____+____8____
                +____9____+___10____+___11____+___12____+___

Error   Record(1)  ID    First 45 characters of the discarded record.  Source Column                  Target Column
----- -----------  ----- --------------------------------------------- ------------------------------ ------------------------------  
-803          325  D001  000010  CHRISTINE   I RUSK           A00   39
-803          326  D001  000020  MICHAEL     L BENNETT        B01   34
-803          327  D001  000030  SALLY       A ALLE           C01   47
-803          328  D001  000050  JOHN        B KENNE          E01   67
-803          329  D001  000060  IRVING      F HEMIN          D11   64
-803          330  D001  000070  EVA         D DARROW         D21   78
-803          331  D001  000090  EILEEN      W MORAGA         E11   54
-803          332  D001  000100  THEODORE    Q ANDREWS        E21   09
-803          333  D001  000110  VINCENZO    G ZIEGFELD       A00   34
-803          334  D001  000120  SEAN          HEMINGWAY      A00   21
-803          335  D001  000130  DOLORES     M FRANKLIN       C01   45
-803          336  D001  000140  HEATHER     A MARTIN         C01   17
-803          337  D001  000150  BRUCE         RUSK           D11   45
-803          338  D001  000160  ELIZABETH   R MULSTR         D11   37
-803          339  D001  000170  MASATOSHI   J JONES          D11   28
-803          340  D001  000180  MARILYN     S STRANDEL       D11   16
-803          341  D001  000190  JAMES       H SAVAGE         D11   29
-803          342  D001  000200  DAVID         STRAN          D11   45
-803          343  D001  000210  WILLIAM     T SIMPS          D11   09
-803          344  D001  000220  JENNIFER    K ELLI           D11   06
-803          345  D001  000230  JAMES       J BENNETT        D21   20
-803          346  D001  000240  SALVATORE   M JACKSO         D21   37
-803          347  D001  000250  DANIEL      S MORAG          D21   09
-803          348  D001  000260  SYBIL       V JONES          D21   89
-803          349  D001  000270  MARIA       L FRANK          D21   90
-803          350  D001  000280  ETHEL       R RUSK           E11   89
-803          351  D001  000290  JOHN        R RICHAR         E11   45
-803          352  D001  000300  PHILIP      X BENNY          E11   20
-803          353  D001  000310  MAUDE       F BARNETT        E11   33
-803          354  D001  000320  RAMLAL      V JONES          E21   99
-803          355  D001  000330  WING          JAC            E21   21

***** 31 of 43 rows from the Extract File were Discarded *****

                                                     * * *  END OF REPORT  * * *

The header part of the report shows the following:

  • The Db2 subsystem ID.
  • The name of the discard file.

The SQL Insert: Db2 Discard Report  lists all target objects for which rows were discarded.

Target Object

The name of the target object the discarded record came from.

For each target object, The SQL Insert: Db2 Discard Report  displays the following columns:

Error

The SQLCODE or File-AID/RDX error code indicating the error that caused the row to be discarded.

Record

The "Record Number" indicates the relative data record within the Discard File, the line number when viewing the file.

ID

The File-AID/RDX extract object identifier for the object to be loaded.

First 45 characters of the discarded record

Displays the first 45 characters of the discarded record.

Source Column

If the error that caused the row to be discarded was a column mapping error, this column contains the name of the source column in error.

Target Column

If the error that caused the row to be discarded was a column mapping error, this column contains the name of the target column in error.

MVS Load: VSAM Discard Report

The MVS Load: VSAM Discard Report  shown in the following figure is a summary of records discarded during load processing.

MVS Load: VSAM Discard Report

File-AID/RDX  21.1                                     MVS Load: VSAM Discard Report                                 PAGE  1
                                                                                                                    DATE  2005-08-15
                                                                                                                    TIME  15.04.48
                                                                
Discard File . .: TSOID01.R43.DISCARD.SQL.EMPM                 
  
   Note: 1) The "Record Number" indicates the relative data record within the Discard File; the line number when Viewing the file.

Target Object: M-TSOID01.FASAMP.EMPLOYEE.EMPM                     

                 Error   Record(1)  ID    First 45 characters of the discarded record.  
                 ----- -----------  ----- --------------------------------------------
                 DUP           322  D003  00090MARTIAN        EDWARD    M  AIRPLANE
                 DUP           323  D003  00100MULSTROM       ROBERTA   A  HOLLYWOO
                 DUP           324  D003  00200JACKSON        JOSEPH    C  ORATOR

                 *****  3 of 3 rows from the Extract File were Discarded *****

"* *  END OF REPORT  * * *

The header part of the report shows the name of the discard file.

The MVS Load: VSAM Discard Report  lists all target objects for which records were discarded.

Target Object

The name of the target object the discarded record(s) came from.

The MVS Load: VSAM Discard Report  for each object consists of the following columns:

Error

The File-AID/RDX error code indicating the error that caused the record to be discarded.

Record

The "Record Number" indicates the relative data record within the Discard File, the line number when viewing the file.

ID

The File-AID/RDX extract object identifier for the object to be loaded.

First 45 characters of the discarded record

Displays the first 45 characters of the discarded record.

 

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

BMC Compuware File-AID/RDX 21.01