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

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

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.