Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Massachusetts
    Posts
    27

    Red face Unanswered: Online Reorg with LISTDEF & TEMPLATE

    Platform & version : DB2 V7 on OS/390

    Hi,

    Has any1 successfully run an online reorg using LISTDEF and TEMPLATE options ? If so, can u please post the Reorg parameters/control cards here?
    I wanted to know to allocate SYSREC dynamically using TEMPLATE.

    These are my control cards:

    LISTDEF REORGLST
    INCLUDE TABLESPACE MDD1.* PARTLEVEL
    TEMPLATE SYSCOPY DSN 'DB2A.DBA.FIC.&DB..&TS..A&PART.(+1)'
    UNIT CART DISP(NEW,CATLG,CATLG) STACK YES
    MODELDCB MODLDSCB RETPD 7 GDGLIMIT (7)
    TEMPLATE RCVCOPY DSN 'FST.DBA.DB2A.&DB..&TS..A&PART.(+1)'
    UNIT CART DISP(NEW,CATLG,CATLG) STACK YES
    MODELDCB MODLDSCB RETPD 7 GDGLIMIT (3)
    TEMPLATE UNLD00 DSN 'DBA.TEMP.B2A.&JO..&ST..SYSREC.(+1)'
    UNIT 3390 DISP(NEW,DELETE,DELETE)
    MODELDCB MODLDSCB GDGLIMIT (7)
    REORG TABLESPACE LIST REORGLST LOG NO
    SHRLEVEL CHANGE SORTDATA SORTKEYS
    DRAIN_WAIT 40 RETRY 25 RETRY_DELAY 300
    COPYDDN (SYSCOPY) RECOVERYDDN (RCVCOPY)
    SORTDEVT WORK SORTNUM 16
    STATISTICS TABLE(ALL) INDEX(ALL) UPDATE(ALL)
    MAPPINGTABLE MDD1DBO.T_MDMP_MAP_TBL
    TIMEOUT TERM

    When the job is run, it runs for the first 3 tablespaces and then failed in the 4th. I am not sure why. the only error message I got was
    DSNU047I DSNURULD - A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=SYSREC
    DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

    A TEMPLATE name cannot be allocated as SYSREC, so I gave it as UNLD00. I am wondering why it ran for 3 tablespaces and failed in the 4th one????

    For more info, please ask.

    THANKS !!
    "It is Monday morning 3:02 AM. What is your SQL response time ?"

  2. #2
    Join Date
    Jan 2004
    Location
    Zuerich, Switzerland
    Posts
    13

    Smile

    Your table number 4 has no clustering index. Therfore you cannot use the SORTDATA option on REORG. The utility ignores SORTDATA, but must now write the data to an unload dataset. as you did not allocate one, REORG terminates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •