How many rows (records) can be inserted from the SYSRC00 Input File into program DBXLOAD?

Document ID : KB000052335
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The maximum number of rows (records) are only limited by the version.

Solution:

The DBXLOAD utility program can accept an input file with a maximum of 32,767 rows (records) per version.

If the DBXLOAD utility program exceeds 32,767 rows, warning messages will be visible in the sysout as follows

      * 
      *********************************************** 
            PROCESSING BEGINNING FOR 
       DIALOG: DB2 ENTITY: TABLE
   ***********************************************   
        MESSAGE: EDT00049   
   
        No versions available.   
   *