search cancel

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

RC Compare for DB2 for z/OS Report Facility Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS 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