When preparing for an LMe (or any Rocket|Aldon product) upgrade, there is a step in the Installation/Upgrade Guide to verify the state of the database prior to running the actual upgrade. This step exposes any potential data issues that might roll back an upgrade or cause delays.
For LMe, the customer will run the AFFTVALCST command interactively to validate the constraint status'. Output will contain some of these typical messages:
AFF1519 Missing trigger APP_BU
on file AFFTCTL.APP_BU
AFF1519 Missing trigger ARCIINS_BU
on file AFFTCTL.ARCIINS_BU
AFF1519 Missing trigger ARCPDEF_BU
on file AFFTCTL.ARCPDEF_BU
……..
AFF1519 Missing trigger VPSET_BU
on file AFFTCTL.VPSET_BU
AFF1519 Missing trigger VPSETXVP_BU
on file AFFTCTL.VPSETXVP_BU
Press ENTER to end terminal session.
These messages may seem like errors, but if all the errors shown contain only the messages "AFF1519 Missing trigger…", they may not really indicate a problem (i.e. red herring).
The LMe data base is shipped with a minimal set of triggers to ensure maximum performance. However, the default command option for AFFTVALCST is checking for '*ALL' triggers and constraints. So, in most cases, these 'Missing trigger' messages are expected and do not indicate a problem (as only the 'MANUAL' or '*LOBS' sets of triggers were installed - *ALL would only be applied if advised by Rocket support).
In other words, if all the errors shown contain only the messages "AFF1519 Missing trigger…", you are likely OK to proceed with the upgrade. Running the command again with these options should produce a 'clear' verify of the constraints and triggers:
AFFTLIB/AFFTVALCST MANUAL
AFFTLIB/AFFTVALCST *LOBS
Reference of AFFTVALCST default options:
AFFTLIB/AFFTVALCST [F4]
Validate Cnstrs on LMe files (AFFTVALCST)
Type choices, press Enter.
File to validate cstrs on . . . *ALL Character value, *ALL, *LOBS, MANUAL
Verbose reporting . . . . . . . *NO *YES, *NO
Check if triggers defined . . . *YES *NO, *YES
If you have any questions, please contact us in support and we'll be happy to assist you.
Expect to see more in the guides for our forthcoming release for RDOe 10.2 regarding file constraint checking and future plans for enhanced application monitoring in Rocket DevOps portal dashboarding.
------------------------------
Jiqing Fan (Rico)
Rocket Internal - All Brands
------------------------------