Failure during upgrade to R6.0 due to missing CLRTAB rule.
book
Article ID: KB0089436
calendar_today
Updated On:
Products
Versions
TIBCO Object Service Broker for z/OS
-
Not Applicable
-
Description
Description: While upgrading an OSB MetaStor to R6.0, if you have already applied the assembler hotfix04 maintenance, you may encounter a situation where a promotion fails with "unable to find the rule CLRTAB". This causes subsequent promotion steps to be bypassed and the upgrade ends with RC=4.
Symptoms: The promotion job will fail with RC=4 and the OSB error log will show the following:
Unable to find rule "CLRTAB" in library
Cause: In R6.0 the CLRTAB built-in is replaced by a CLRTAB rule. The R60 base upgrade DB maintenance installs the CLRTAB rule. Hotfix04 deletes the CLRTAB built-in function. If you apply hotfix04 prior to the DB maintenance, which is the correct/normal practice, you may in certain situations get failures in the DB maint as CLRTAB does not exist early in the DB maintenance process.
Issue/Introduction
Failure during upgrade to R6.0 due to missing CLRTAB rule.
Resolution
There are 3 possible resolutions.
1). If you spot this advice before you apply hotfix 04 then remove AP14015 from the list of PTFs to be applied. You can then apply it later once the DB maintenance is applied.
2). If you have already installed hotfix04 then you can back it off by copying the APPLY JCL to another member and changing the control cards to the following:
You can then re-apply AP14015 once the DB maintenance is on.
3). There are 3 rules in the promotions system that use CLRTAB, These are PREP_SYS_TBLS, RCLRTAB, & SUB_SYS_TABLES. You can logon as a level 7 user, set your local library to common and edit these 3 rules and replace the 4 isntances of "CALL CLRTAB." with "CALL $CLRTAB." .
All three of the above should work so chose whichever is easier.