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

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

book

Article ID: 52335

calendar_today

Updated On:

Products

Repository

Issue/Introduction

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.   
   *  

Environment

Release:
Component: XTR