CA7 URI (Unique Row Identifier) Display Amount Assigned

Products

• CA 7 Workload Automation

Issue/Introduction

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.

 

Environment

Release : 12.1

Component :

Resolution

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.