How can the SHAREOPTION for a CA DATABASE ANALYZER (PDA)Extract or Action Procedure be updated.

book

Article ID: 19768

calendar_today

Updated On:

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 CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle CA Database Analyzer (IMS Tools) CA Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC CA Compress Data Compression (IMS Tools) CA Database Analyzer for IMS for z/OS CA Database Copier for IMS for z/OS CA Database Organizer for IMS for z/OS CA Mainframe Extended Terminal Manager (IMS Tools) CA High Performance Recovery for IMS for z/OS CA Database Organizer (IMS Tools) CA Mainframe Program Restart Manager for IMS for z/OS CA Secondary Index Builder for IMS for z/OS CA Secondary Index for IMS for z/OS

Issue/Introduction

Description:

How can the SHAREOPTION for an CA DATABASE ANALYZER (PDA) Extract or Action Procedures be updated

For example when the Creator USERID doesn't exist anymore, but had been previously used to create PDA Procedures with the Share option set to N

Solution:

The DBA who has the authority need to edit table PTI.RACR_PROC_xxxx and update column RACR_SHROPTION to Y/N/U


Values: Y The procedure is shareable by other users. 	  
        N The procedure is not shareable by other users.
        U The procedure is updateable by other users.

For the future this can be solved with using the following highlvl.CDBAPARM(PDA) Member parameter:

  • DEF_PROC_CREATOR (nnnnnn)

  • ALLOW_DPC_PROFILE_OVERRIDE (n)

for example , define DEF_PROC_CREATOR (SQLID) and ALLOW_DPC_PROFILE_OVERRIDE (N) within the highlvl.CDBAPARM(PDA) Member. This may be a better option for a group of DBAs working on Extracts. For detail description of these parameter, please refer to the highlvl.CDBAPARM(PDA) Member.

Environment

Release:
Component: DBA