Which PTI table stores the entries for the objects which get listed in the RC/Secure Recover Dropped Object Security screen

Products

• RC/Secure for DB2 for z/OS

Issue/Introduction

Doing a RECOVER DROPPED OBJECT SECURITY (Option R) display in RC/Secure for Db2 for z/OS (RCS) allows you to recover object authorities
that were dropped outside of SRS. You must be an administrator named at installation time, RCSADM or RCSADM2 to perform this function.

Resolution

The RECOVER DROPPED OBJECT SECURITY option reads the PTI.PTRCS_APLDIM_0200 table to get the records.

	SELECT DISTINCT OBJTYPE, OBJNAME, QUALIFIER
	FROM PTI.PTRCS_APLDOM_0200
	WHERE DB2ID LIKE :HDB2ID
	AND DEPT LIKE :HDEPT
	AND OBJNAME LIKE :HNAME
	AND QUALIFIER LIKE :HQUAL
	AND OBJTYPE LIKE :HTYPE
	AND OBJTYPE ^= 'SY'
	AND AUTHS ^= '' ;