If you get an SQLCODE -497 while trying to run a QMF PROC, read this:
SQLCODE -497 means "THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN
EXCEEDED FOR DATABASE database"
You need to run the MODIFY utility with RECOVERY option to fix this issue.
The MODIFY online utility with the RECOVERY option deletes records from the SYSIBM.SYSCOPY catalog table, related log records from the SYSIBM.SYSLGRNX directory table, and entries from the DBD. You can remove records that were written before a specific date or you can remove records of a specific age. You can delete records for an entire table space, partition, or data set.
Sample SYSIN for MODIFY:
MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(365)
No comments:
Post a Comment