Help with syntax of doing REORG on LOB and base table for LOB

Lizette Koehler

Help with syntax of doing REORG on LOB and base table for LOB
Sorry, this is a new process for me



I need to run an online Reorg on a LOB table and its base table.



I am not finding any examples of how I do that. Does anyone have a working
REORG example of how to do this?

Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately



Lizette Koehler

Help with syntax of doing REORG on LOB and base table for LOB
(in response to Lizette Koehler)
I forgot to add, this is a V10 system



Lizette





From: Lizette Koehler <[login to unmask email]>
Sent: Saturday, July 07, 2018 8:02 PM
To: [login to unmask email]
Subject: [DB2-L] - Help with syntax of doing REORG on LOB and base table for LOB



Sorry, this is a new process for me



I need to run an online Reorg on a LOB table and its base table.



I am not finding any examples of how I do that. Does anyone have a working
REORG example of how to do this?

Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately





-----End Original Message-----

Bruce Williamson

RE: Help with syntax of doing REORG on LOB and base table for LOB
(in response to Lizette Koehler)

Howzit Lizette?

Here is a typical job deck I use for DB2 11 but I don't believe there is anything in there that's not backwardly compatible with DB2 10:

//...JOB CARD...
//*
//*---------------------------------------------------------------------
//* DB2 ONLINE REORG UTILITY SHARELEVEL CHANGE
//*---------------------------------------------------------------------
//STEP010 EXEC DSNUPROC,
// SYSTEM=$$$G,
// UID='U$$$RLOB'
//DSNUPROC.SORTDIAG DD SYSOUT=*
//DSNUPROC.SYSUDUMP DD SYSOUT=*
//DSNUPROC.UTPRINT DD SYSOUT=*
//DSNUPROC.SYSPRINT DD SYSOUT=*
//DSNUPROC.SYSOUT DD SYSOUT=*
//DSNUPROC.SYSIN DD *
TEMPLATE SREC
DSN('hlq.&SS(1,3)..&DB..&SN..P&PA(2,4)..SYSREC')
DISP(MOD,DELETE,CATLG)
DATACLAS blahblahblah
UNIT SYSALLDA

TEMPLATE SCOPY
DSN('hlq.&SS(1,3)..IC.&DB..&SN..P&PA(2,4)..&UQ.')
DISP(MOD,CATLG,DELETE)
DATACLAS blahblahblah
UNIT blahblahblah

OPTIONS EVENT(ITEMERROR,SKIP)
DIAGNOSE TYPE(100,101,102,370)

LISTDEF BASE_TABLES
INCLUDE TABLE schema."blahblahblah" BASE

REORG TABLESPACE LIST BASE_TABLES
SHRLEVEL CHANGE
DEADLINE CURRENT_TIMESTAMP + 3 HOURS
DRAIN_WAIT 1
RETRY 100
RETRY_DELAY 15
MAXRO 1
DRAIN ALL
LONGLOG CONTINUE
FASTSWITCH YES
AUX NO
UNLDDN SREC
COPYDDN (SCOPY)
SORTDEVT SYSALLDA
STATISTICS
TABLE(ALL)
INDEX(ALL)
KEYCARD

LISTDEF AUX_TABLES
INCLUDE TABLE schema."blahblahblah" LOB

REORG TABLESPACE LIST AUX_TABLES
SHRLEVEL CHANGE
DEADLINE CURRENT_TIMESTAMP + 3 HOURS
DRAIN_WAIT 1
RETRY 100
RETRY_DELAY 15
MAXRO 1
DRAIN ALL
LONGLOG CONTINUE
UNLDDN SREC
COPYDDN (SCOPY)
SORTDEVT SYSALLDA

RUNSTATS TABLESPACE LIST AUX_TABLES
SHRLEVEL CHANGE
INDEX(ALL)

DIAGNOSE END
OPTIONS OFF
/*
//*
//*------------------------------------------------------------------
//*- - - - - - - - - - - E N D - O F - J O B - - - - - - - - - - -
//*------------------------------------------------------------------

Cheers
Bruce

 

In Reply to Lizette Koehler:

I forgot to add, this is a V10 system



Lizette





From: Lizette Koehler <[login to unmask email]>
Sent: Saturday, July 07, 2018 8:02 PM
To: [login to unmask email]
Subject: [DB2-L] - Help with syntax of doing REORG on LOB and base table for LOB



Sorry, this is a new process for me



I need to run an online Reorg on a LOB table and its base table.



I am not finding any examples of how I do that. Does anyone have a working
REORG example of how to do this?

Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately





-----End Original Message-----



P.S. Want to make a difference to DB2 but don't know how? Join the RFE Community?

P.P.S. While you're at it why not join the "All DB2 for z/OS" group and vote on community proposals

Lizette Koehler

Help with syntax of doing REORG on LOB and base table for LOB
(in response to Bruce Williamson)
This is awesome. Thank you so much



Lizette





From: Bruce Williamson <[login to unmask email]>
Sent: Sunday, July 08, 2018 6:36 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Help with syntax of doing REORG on LOB and base table for LOB



Howzit Lizette?

Here is a typical job deck I use for DB2 11 but I don't believe there is anything in there that's not backwardly compatible with DB2 10:

//...JOB CARD...
//*
//*---------------------------------------------------------------------
//* DB2 ONLINE REORG UTILITY SHARELEVEL CHANGE
//*---------------------------------------------------------------------
//STEP010 EXEC DSNUPROC,
// SYSTEM=$$$G,
// UID='U$$$RLOB'
//DSNUPROC.SORTDIAG DD SYSOUT=*
//DSNUPROC.SYSUDUMP DD SYSOUT=*
//DSNUPROC.UTPRINT DD SYSOUT=*
//DSNUPROC.SYSPRINT DD SYSOUT=*
//DSNUPROC.SYSOUT DD SYSOUT=*
//DSNUPROC.SYSIN DD *
TEMPLATE SREC
DSN('hlq.&SS(1,3)..&DB..&SN..P&PA(2,4)..SYSREC')
DISP(MOD,DELETE,CATLG)
DATACLAS blahblahblah
UNIT SYSALLDA

TEMPLATE SCOPY
DSN('hlq.&SS(1,3)..IC.&DB..&SN..P&PA(2,4)..&UQ.')
DISP(MOD,CATLG,DELETE)
DATACLAS blahblahblah
UNIT blahblahblah

OPTIONS EVENT(ITEMERROR,SKIP)
DIAGNOSE TYPE(100,101,102,370)

LISTDEF BASE_TABLES
INCLUDE TABLE schema."blahblahblah" BASE

REORG TABLESPACE LIST BASE_TABLES
SHRLEVEL CHANGE
DEADLINE CURRENT_TIMESTAMP + 3 HOURS
DRAIN_WAIT 1
RETRY 100
RETRY_DELAY 15
MAXRO 1
DRAIN ALL
LONGLOG CONTINUE
FASTSWITCH YES
AUX NO
UNLDDN SREC
COPYDDN (SCOPY)
SORTDEVT SYSALLDA
STATISTICS
TABLE(ALL)
INDEX(ALL)
KEYCARD

LISTDEF AUX_TABLES
INCLUDE TABLE schema."blahblahblah" LOB

REORG TABLESPACE LIST AUX_TABLES
SHRLEVEL CHANGE
DEADLINE CURRENT_TIMESTAMP + 3 HOURS
DRAIN_WAIT 1
RETRY 100
RETRY_DELAY 15
MAXRO 1
DRAIN ALL
LONGLOG CONTINUE
UNLDDN SREC
COPYDDN (SCOPY)
SORTDEVT SYSALLDA

RUNSTATS TABLESPACE LIST AUX_TABLES
SHRLEVEL CHANGE
INDEX(ALL)

DIAGNOSE END
OPTIONS OFF
/*
//*
//*------------------------------------------------------------------
//*- - - - - - - - - - - E N D - O F - J O B - - - - - - - - - - -
//*------------------------------------------------------------------

Cheers
Bruce



In Reply to Lizette Koehler:

I forgot to add, this is a V10 system



Lizette





From: Lizette Koehler
Sent: Saturday, July 07, 2018 8:02 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - Help with syntax of doing REORG on LOB and base table for LOB



Sorry, this is a new process for me



I need to run an online Reorg on a LOB table and its base table.



I am not finding any examples of how I do that. Does anyone have a working
REORG example of how to do this?

Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately





-----End Original Message-----



P.S. Want to make a difference to DB2 but don't know how? Join the RFE Community https://www.ibm.com/developerworks/rfe ?

P.P.S. While you're at it why not join the https://www.ibm.com/developerworks/rfe/execute?use_case=groupLanding&GROUP_ID=1283 "All DB2 for z/OS" group and vote on community proposals



-----End Original Message-----