DSNT408I SQLCODE = -497, ERROR: THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE DSNDB07

book

Article ID: 18213

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Compile/PRF for CICS and TSO CA Report Facility CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

Running the PRFCNVRT job results in the following message:

DSNT408I SQLCODE = -497, ERROR: THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE DSNDB07

Solution:

The INTERVAL controls the commit frequency. The INTERVAL value is set in the CONTROL card - INTERVAL(0).

The default value of 0 means no commit is taken.

The INTERVAL value should be changed to a value greater than 0. The recommendation is 10.

Environment

Release:
Component: BIPRF