DatacomDATACOM - ADCISCOMMON SERVICES FOR Z/OS90S SERVICESDATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OSCOMMON PRODUCT SERVICES COMPONENTCommon ServicesCA ECOMETER SERVER COMPONENT FOCEASYTRIEVE REPORT GENERATOR FOR COMMON SERVICESINFOCAI MAINTENANCEIPCUNICENTER JCLCHECK COMMON COMPONENTMainframe VM Product ManagerCHORUS SOFTWARE MANAGERCA ON DEMAND PORTALCA Service Desk Manager - Unified Self ServicePAM CLIENT FOR LINUX ON MAINFRAMEMAINFRAME CONNECTOR FOR LINUX ON MAINFRAMEGRAPHICAL MANAGEMENT INTERFACEWEB ADMINISTRATOR FOR TOP SECRETXpertware
Issue/Introduction
We have a couple of concern to provide the admin authority for the user who needs to make the data structure change in data dictionary. 1. How to locate the user ID -68K in Data dictionary? 2. How to get the display name of the user 3. Steps to authorize the user as admin Kindly provide the solution for the above concerns.
Environment
z/os, CA Datacom/DB 14.0 and higher
Resolution
There are different ways to locate the Userid and related name (entity_name).
1- Via SQL, Using DBSQLPR, the requests could be: Select entity_name, userid from sysadm.person where status = 'P'; Select entity_name, userid from sysadm.person where status = 'P' and userid = '68K';
2- Via DDUTILTY report using SYSIN: //SYSIN DD * +USR DATACOM-INSTALL,NEWUSER +RPT DETAIL,PERSON /* Report, among other fields, displays Userid and Name. Do a find in your report output for '68K' in userid column.
3- Via DDOL, CICS transaction. a- signon b- go to Authorize and enter password (like 'Datacom-Install', 'Newuser' and then 'Newuser' on the next screen when asked to provide password). c- enter 1 - Maintain Person - option will list all the Name and userid. Scroll until you find ID '68K'
It displays panel T41U. It also displays column 'Profile' ($DD-ADM, $DD-UPD....etc) You may enter $DD-ADM in front of userid '68K' to give that user the profile $DD-ADM. $DD-ADM profile gives authority for managing (display,update) database structure.
The following DDUTILTY SYSIN will display all userid having $DD-ADM profile: //SYSIN DD * -RPT RELAT,AUTHORIZATION,$DD-ADM(PROD) -END and replace $DD-ADM with any other profile you may want.