Loudwater
Systems
Management


Tivoli-supplied DB2 tables

_H tables do exact match instead of pattern match on PLAN name.
See SDRLDEFS members DRLTD2UT, DRLTD2DU.
How I fixed this;
    1. Copy the members to EPDM.DEFS
    2. Hack out all defs/creates/grants etc etc except for the _H.
       Change the Updates to do LIKE instead of = (equals)
       NB There are three (3) updates in UT.
    3. Add a DROP statement in front of each DEFINE.
       NB Remember the ; which ends the statement.
    4. In Admin dialog/Tables/Other select Process EPDM Statements.
    5. Fill in full name of EPDM.DEFS(member) and 1 for LOG COLLECTOR
    6. Press either
       ENTER to check them one more time
       PF5/17 to execute them
       PF12/24 to exit without executing
    7. Browse the results CAREFULLY; read EVERY message to ensure you know
       whether it has worked or not.