//STEP1 EXEC PGM=DSNUTILB,PARM='DB2V,STEP1.REORGPOL',REGION=4M
//*------------------------------------------------------------------
//STEPLIB DD DSN=VVVVVV,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//*
//SYSUT1 DD UNIT=SYSDA,DISP=(,KEEP),SPACE=(CYL,(900,900))
//SORTOUT DD UNIT=SYSDA,DISP=(,KEEP),SPACE=(CYL,(900,900))
//SYSCPY1 DD UNIT=3590-1,DISP=(,KEEP,DELETE),
// DSN=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
// LABEL=(1,SL,RETPD=3)
REORG TABLESPACE AAAAAAA.VVVVVVV
SHRLEVEL CHANGE
MAPPINGTABLE MAPPING_TABLE
MAXRO 240 LONGLOG DRAIN DELAY 900
STATISTICS TABLE INDEX(ALL)
COPYDDN SYSCPY1
-----Original Message-----
From: JAMES PARK
[mailto:db2udbdba-ezmlmshield-x49812805.[Email address protected]
Sent: Wednesday, November 28, 2007 8:59 AM
To: LazyDBA Discussion
Subject: Online Reorg
Hi, Listers.
V8 on z/OS.
I am trying to set up an Online Reorg JCL to reorg a third party product
tablespace(File-Aid) that has more than one extent.
In the JCL should I have Imagecopy, Alter and Reorg with inline copy in
order?
I can't find a sample Online Reorg sample JCL at my work place. Could
someone provide a sample online reorg JCL?
Thanks,
James Park
Database Specialist II
Annapolis Data Center
410-260-7489
[Email address protected]
------------------------------------------------------------------------
------
This email and any file transmitted with it may be confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you received this email in error, please notify the
Comptroller's System Manager by forwarding this message to [Email
address protected]
========================================================================
======
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail message from State Compensation Insurance Fund and all attachments transmitted with it may be privileged or confidential and protected from disclosure. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, copying, or taking any action based on it is strictly prohibited and may have legal consequences. If you have received this e-mail in error, please notify the sender by reply e-mail and destroy the original message and all copies.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB2 & UDB email list listserv db2-l LazyDBA home page