CA 7 Release 12.1 assigns URI's to rows in a data area. The maximum number of URI's that can be assigned is 4 billion.
Besides message DB2801W being issued when 3 billion URI's have been reached is there a way to find out how many URI's have been already been assigned.
Release : 12.1
Component :
Sample SQL code as input for the CA 7/CA DATACOM DBSQLPR Utility Report:
Run DBSQLPR with this statement
SELECT AREA_NAME, HIGH_URI FROM DIR_AREA
WHERE DBID = 770 ;
The JCL required to execute the DBSQLPR Utility and to produce reports from the database is in member AL2SQL in the CAL2JCL library.
If you have 'AUTHID=MFWA' specified under the OPTIONS DD, please remove it for this SQL statement. You need it when accessing CA 7 database tables but not for system tables. 'AUTHID=SYSADM' is the default, but you could also specify it if you prefer to do that rather than removing AUTHID altogether.