1.) While trying to update the utility model in RC/Migrator a user receives this error :
RO034E You do not have authority to update this model.
User has RCM ADMINISTRATOR USER ID (ADMINID) as his ID.
2.) Does PTXMAN need to be recycled if CDBAPARM(MIGRATOR) member and ADMINID is modified to add an ID or to change an ID?
No, recycling the xmanager will not help at all.
The Model in question has a share option Y. This means:
Y - Yes. Other users can use the model ID, but cannot update or delete it.
This is by design.
The users added an ADMINID to CDBAPARM(SETUPxx) in hopes of being able to use that ID to Update the model.
The ADMINID in CDBAPARM(SETUPxx) does not control access to RC/Migrator models. This is used regarding the running of utilities like Fastload and it is also used during install.
Control of the authority to update strategies in RC/Migrator is done via the ADMINID in hlq.CDBAPARM(MIGRATOR) member.
One option is to Template the Model using the "T" line command , changing the name and then using share option U for update.
See: "RC/Migrator : RO034 RO034E You do not have authority to update this model."
This knowledgebase article explains in detail about how this error message can be handled.
See "RC/Migrator for DB2 for Z/OS: How do I get rid of old/unwanted RCM Strategies?" that adds further info on updating/Deleting Models.
This knowledgebase article describes how to delete unwanted strategies in batch using the hlq.CDBAJCL(RCMMAINT) utility.
There is also information about how to change the hlq.CDBAPARM(MIGRATOR) member to add an adminid so that the ID can see and update strategies that have a Share Option of N or Y.
To report on usage of Model IDs there is a query to access table PTI.PTMG1_STRAT_0200, which shows when a particular Model ID was used during Analysis of a strategy.
Use the following query to list when a Model ID was used. In this example the query finds a Model IDs named '@DEFAULT'.
SELECT STRATEGY_CREATOR , STRATEGY_NAME,
SUBSTR(DATA,967,8) AS "MODEL ID",
SUBSTR(DATA,975,8) AS "MODEL CREATOR",
SUBSTR(DATA,1,8) AS "ANALYSIS DATE"
WHERE ( SEQUENCE_FIELD > 25000 ) AND
SUBSTR(DATA,967,8) = '@DEFAULT'
ORDER BY "ANALYSIS DATE" ASC
This will show which @DEFAULT Model IDs, for which creator, have not been used for a while and which could therefore potentially be deleted.