DMLO: List ALL PROFILE names and the USER id who owns it using OLQ?

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

How can I get a list of all PROFILE names and the DMLO account (user-id) who owns it?

Environment

Release : 19.0

Component : CA IDMS/DB

Resolution

Entities involved:

- The TOOLDICT dictionary contains the Dictionary Schema: USDSCHEM
- The Dictionary Schema: USDSCHEM has Record CLUSTER owns PARMFILE in set CLUSTER-PARMFILE
- The CLUSTER Record has a field called CLUUSER.
- The PARMFILE Record has a field called PARMNAME

In OLQ if you select both the CLUSTER and PARMFILE Records and select the CLUUSER and PARMNAME fields it will produce a report that shows each PARMFILE name and the USER who owns it.

For Example:

In OLQ Command Mode:

SET DICTNAME TOOLDICT
SIGNON SS=USDSUB00

Then the following SELECT statement:

SELECT 'CLUSTER'.'CLUUSER' 'PARMFILE'.'PARNAME' FROM 'CLUSTER', 'PARMFILE'  
WHERE ('CLUSTER-PARMFILE')!DISPLAY  

Or in OLQ Menu Mode, specify the following selections:

Dictionary name : TOOLDICT
Subschema : USDSUB00  

-  Select Records: CLUSTER and PARMFILE
- Select Fields: CLUUSER and PARNAME                    

                                   
Hit enter until the last page and the query executes.
The resultant report is a list of all of the PARMFILE names and the USER who owns it.