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

Document ID : KB000019768
Last Modified Date : 14/02/2018
Show Technical Document Details

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.