Loudwater
Systems
Management

Setting up another tablespace with copies of the tables

For test purposes, say. The solution I chose was
  1. copy all relevant DEFS from SDRLDEFS to EPDM.DEFS
  2. keep table names the same
  3. use PREFIX to differentiate
  4. change UPDATE names by substituting one char (eg TB2 for DB2)
  5. don't make the names longer
  6. add SET cmds for CURRENT SQLID, DBNAME, TABSPACE, PREFIX, USERS etc see DEFS(SETVARS)
  7. take an IC
  8. run in batch (to be sure to catch error msgs)
  9. don't just DROP via EPDM dialog, DROP also via SQL in QMF *** BE VERY SURE YOU HAVE correct CURRENT SQLID
  10. use COLLECT INCLUDE(mypref.DB2%) to get proper tables *** NB EPDM system tables only show objects that have DRL or DRLSYS prefix