Enabling the Expert Profile in RC/Migrator
search cancel

Enabling the Expert Profile in RC/Migrator

book

Article ID: 11246

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS RC Compare for DB2 for z/OS

Issue/Introduction

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:

  • Utility Model Services to maintain RC/Migrator Models
  • Copy Group Services to maintain RC/Migrator and RC/Compare Copy Groups
  • Import ICL to obtain already generated ICL from other locations.

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?

Resolution

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.

Additional Information