Rocket DevOps (formerly Aldon)

 View Only

Preparing for LMe upgrade - verify and constraint checking messages

  • 1.  Preparing for LMe upgrade - verify and constraint checking messages

    ROCKETEER
    Posted 09-30-2022 11:51
    Edited by Dale Asher 09-30-2022 11:51

    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
    ------------------------------