It it possible to run a REORG TABLESPACE SHRLEVEL REFERENCE with DISCARD
but with no DISCARDDDN and no SYSREC?
In the manual it states:
Specifies that the output of sorting (if there is a clustering index and you
specify SORTDATA) is the input to reloading, without using an unload data
set. You can specify this option only if you specify REORG TABLESPACE,
SORTDATA, SHRLEVEL REFERENCE, or SHRLEVEL NONE, and only if you do not
specify UNLOAD PAUSE or UNLOAD ONLY.
My reorg is SHRLEVEL REFERENCE, I have specified NOSYSREC and I do not
have UNLOAD PAUSE or UNLOAD ONLY.
The utility abends with:
DSNU047I DSNURULD - A REQUIRED DD CARD OR TEMPLATE IS MISSING.
I haven't specified a DISCARD dataset as I'm not interested in keeping the
Why is the SYSREC necessary? I can't see why DB2 would need to unload the
entire tablespace to a file in order to handle the discard processing.
My SYSIN for the reorg is as follows:
REORG TABLESPACE DBADAM.TSADAM
SORTDEVT 3390 SORTNUM 29
DEADLINE CURRENT TIMESTAMP
+ 900 MINUTES
STATISTICS UPDATE ALL TABLE(ALL)
INDEX(ALL KEYCARD FREQVAL NUMCOLS 3 COUNT 10 )
DISCARD FROM TABLE ADAM.MYTABLE
WHEN (TIMEST < CURRENT TIMESTAMP - 6 MONTHS)
What am I missing? I'm probably just being dense!!
* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html