Which PTI table stores the entries for the objects which get listed in the 'RC/S Recover Dropped Object Security' screen (panel id - RSPRECV)?

Products

• CA RC/Migrator
• CA Endevor SCM Interface
• DB2 Administration
• CA RC Compare for DB2 for z/OS
• CA RC Extract for DB2 for z/OS
• CA RC/Query
• CA RC Secure for DB2 for z/OS
• CA RC Update for DB2 for z/OS

Issue/Introduction

Description:

Doing a RECOVER DROPPED OBJECT SECURITY (Option R) display in RC/Secure 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.

Solution:

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 ^= '' ;

Environment

Release:
Component: RCSDB2