The RC/Migrator for Db2 for z/OS (RCM) Expert profile allows a user to access additional administrative type functions for expert users such as:
When the RC/Migrator Profile screen is accessed, there are only five options plus managed output and the screen does not
reflect an EXPERT PROFILE. What needs to be done to enable the other options?
If Expert Profile is Not enabled the screen will appear as follows:
RMPROFA 20.0 ------------- RC/M Expert Profile ------------- yy/mm/dd hh:mm
OPTION ===>
--------------------------------------------------------------------- authid1
1 - Global Profile Variables
2 - RC/Migrator Profile Variables
3 - Global Change Services
4 - Compare Rule Database Services
5 - Compare Automapping Mask Services
M - Managed Output Maintenance
P - Analysis Profile Services
U - Utility Profile Services
The reason that the Expert Profile is not displayed is that, the User ID accessing the RCM profile option has not been granted the authority to use the Expert Profile.
To Enable Expert Profile the following steps must be completed:
Someone with the authority to do so should access Product Authorizations from the products main menu. This can be done by placing an 'A' at the command line and then press enter.
Enter the ID that requires this access in the TO ID field.
TO ID ==> authid1
Go down the list to___ RC/Migrator and enter an "E" in the command line to display the following lines:
___ RC/Migrator
___ RCM Expert Profile
Enter a "G" into the command line next to RCM Expert Profile and press enter.
This message should be displayed:
___ RC/Migrator
___ RC/Migrator GW GW
___ RCM Expert Profile GW GW Authority Granted
Return to the RCM Profile by selecting 0 from the RCM Menu, The Expert Profile options will now be displayed:
RMPROFA 20.0 ------------- RC/M Expert Profile ------------- yy/mm/dd hh:mm
OPTION ===>
--------------------------------------------------------------------- authid2
1 - Global Profile Variables
2 - RC/Migrator Profile Variables
3 - Global Change Services
4 - Compare Rule Database Services
5 - Compare Automapping Mask Services
6 - Utility Model Services
7 - Copy Group Services
8 - Import ICL
M - Managed Output Maintenance
P - Analysis Profile Services
U - Utility Profile Services
If an error message like this one is seen:
___ RCM Expert Profile GW GW * Failing SQL Statement:
Enter the "M" line command on the same line and the SQL error will be displayed to explain the problem in detail along with the SQL command having the problem. This will inform your next steps.
In order to grant authority to access expert options the granting authid should have the privilege in Db2 to Grant execute to PLAN RCMXxxxx otherwise someone else with the authority
must carry this out.
Below is just an example of a Db2 error that might be seen among many other possible ones when granting authority in Db2.
-------------- PRODUCT AUTHORIZATIONS MESSAGES -------------- yyyy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
LINE 1 OF 33
********************************* TOP OF DATA *********************************
RC/Migrator
RCM Expert Profile
Failing SQL Statement:
GRANT EXECUTE ON PLAN RCMXxxxx TO "authid1"
DSNT408I SQLCODE = -554, ERROR: AN AUTHORIZATION ID OR ROLE CANNOT
GRANT A PRIVILEGE TO ITSELF
DSNT418I SQLSTATE = 42502 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXA07 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -120 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF88' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION
SQL error in PLAN AUTHP200 in DBRM (| statement 0
An authorization ID cannot grant a privilege to itself.
The plan name may vary at each site. The GRANT statement that will be executed can be seen by entering the "D" line command on the same line as the "G" command
D__ RCM Expert Profile
------------------- Product Authorizations ------------------ yyyy/mm/dd hh:mm
Command ===> SCROLL ===> CSR
LINE 1 OF 9
Authorization Detail Information for Selected Authorizations
********************************* TOP OF DATA ********************************
What follows are not complete Grant statements. They lack a "TO userid"
clause. The purpose of these incomplete Grant statements is to
contextually list the objects managed for each product authorization.
For tables, the permissions listed are the permissions granted and
revoked for the listed product authorization.
RC/Migrator
RCM Expert Profile
GRANT EXECUTE ON PLAN RCMXxxxx
The plan name being used at a given site can be found in the hlq.CDBAPARM(PLANSxx) member.
Look for a line in this member like this:
RCMPLN05=RCMXxxxx RCM Expert Profile
While plan name "RCMXxxxx" is the standard name, customers are able to alter these at installation time.