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

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.