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.