IDMS DB005521 identifying unknown entity resource name
search cancel

IDMS DB005521 identifying unknown entity resource name

book

Article ID: 45960

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction

When trying to access a table or view or any other DB type entity, the following abend message may be seen:

SELECT * FROM SYSCA.ACCESSIBLE_TABLES;
*+ DB005521 T7587 C-4M321: Missing authorization for *DYNAM*.

What does this mean and in particular what is the meaning of the message component *DYNAM* in this case?

Environment

IDMS - all supported releases

Cause

When RESTYPE=DB is secured externally (SECBY=EXT), it is essential to also have TYPE=ENTRY entries in the RHDCSRTT assembly for the various DB sub-types. These sub-types are AREA, NRU, QSCH, NSCH, TABL, DACC and SACC.

These entries must be there so that the central security system knows how to construct the external resource name for resources of each sub-type.

The appearance of *DYNAM* in the DB005521 message (or any other value which does not obviously identify something in your environment) is an indication that no TYPE=ENTRY entry for the relevant resource type has been included in your RHDCSRTT assembly.

Resolution

Make sure that all of the DB sub-types are included in the RHDCSRTT assembly.

The DB005521 may still occur but it will identify the entity for which the user does not have the appropriate authority.

Additional Information

Security Administration” section "Securing Database Resources", "Securing Common Database Resources", particularly the paragraph under External Security for Databases

.