CA IDMS Generate DMCL DB003044 Access has been denied

Products

• IDMS

Issue/Introduction

Generating a DMCL in IDMSBCF fails with error:

GENERATE DMCL GLBLCV20;                                        
Status = -4       SQLSTATE = 42503        Messages follow:     
DB003044 C-4M6015: Access has been denied                      

 

Environment

Release : 19.0

Component : CA IDMS/DB

Resolution

To be able to modify or generate a DMCL requires the following security:                             

• ALTER or DEFINE privilege on the DMCL:                                    

     GRANT ALTER ON DMCL dmcl_name TO userid; 

• DBADMIN privilege on the dictionary in which the DMCL definition resides:

     GRANT DBADMIN ON DB SYSTEM TO userid;

If security for DMCL is external then you have to grant the privilege in the external security system.
There may be additional external security error messages in the joblog to indicate what resource you need to grant access to.

Additional Information

See the IDMS Documentation in TechDocs sections GRANT Physical Database Definition Privileges and GRANT Administration Privilege