DSNT408I SQLCODE = -497 ERROR THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED for database DSNDB07 Report Facility PFRCNVRT

Products

• Report Facility

Issue/Introduction

Running the Report Facility (PRF) PRFCNVRT job results in the following message:
DSNT408I SQLCODE = -497, ERROR: THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE DSNDB07

Resolution

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.