View previous topic :: View next topic
|
Author |
Message |
maruthi143
New User
Joined: 17 Jun 2009 Posts: 7 Location: chennai
|
|
|
|
Hi
I created a Image copy with 24 partiton.I need to unload each partiton into different flat files ata atime (I need to run in one jcl).I have the sample JCL look into it but it showing eror and creted only one file and copied all the data into one flat file
//NBKIDED2 JOB (NDB2),'DB2 UNLOAD',
// REGION=0M,MSGCLASS=V,CLASS=G,NOTIFY=&SYSUID
// TIME=(,30) *** IKJEFF10 INSERTS FOR CLASS G
//*
//*+JBS BIND SYS9Z05.PERM
// JCLLIB ORDER=(NBSP.NBS.SYS.PROCLIB)
//DELETE EXEC UCC11
//*----------------------------------------------------------------*
//* IBM UNLOAD - UNLOAD OF S_ASEET_ACCNT
//*----------------------------------------------------------------*
//UNLOAD EXEC DSNUPROC,UID='KTC24.UNLD',UTPROC='',SYSTEM='DZ1T'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
OPTIONS PREVIEW
TEMPLATE UNLDTMPL
DSN ('KTCT.KTC2406D.KTC06009.SCONCN.P&PART.')
DISP (NEW,CATLG,CATLG)
BUFNO (60)
UNIT (SYSDA)
SPACE (1000,1000) CYL
VOLCNT (59)
OPTIONS OFF
UNLOAD TABLESPACE KTC2406D.KTC06009 FROMCOPYDDN SYSCOPY PART 1:24
UNLDDN UNLDTMPL
EBCDIC SHRLEVEL CHANGE ISOLATION UR
FROM TABLE KTC24.S_CONTACT
HEADER NONE
//*
//SYSCOPY DD DSN=KTCT.TST.KTC2406D.KTC06009.TX.SCONTACT,DISP=SHR
//DSNCMD EXEC PGM=IKJEFT1B,
// DYNAMNBR=90,COND=ONLY
//STEPLIB DD DSN=DZ1T.DB2.RUNLIB.LOAD,DISP=SHR
// DD DSN=DZ1T.DB2.DSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSTSIN DD *
Please help it if possible |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
What this has to do with CLIST/REXX is a bit beyond me.
Topic moved to DB2 forum. |
|
Back to top |
|
|
maruthi143
New User
Joined: 17 Jun 2009 Posts: 7 Location: chennai
|
|
|
|
I ma not geeting can u pls explain elaborately |
|
Back to top |
|
|
maruthi143
New User
Joined: 17 Jun 2009 Posts: 7 Location: chennai
|
|
|
|
Pleas efind th eerro msg i get in my SPool
PARTITION PARALLELISM IS NOT ACTIVATED AND THE PARTITION VARIABLE IN THE
TEMPLATE DSN WAS REPLACED BY '00000' FOR TABLESPACE KTC2406D.KTC06009 |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
i'll t ryto tal kyou rlan guage.
straight out of the manual : "You cannot specify multiple output data sets with the FROMCOPY or the FROMCOPYDDN option" |
|
Back to top |
|
|
Kiran Chava
New User
Joined: 07 Jul 2010 Posts: 9 Location: India
|
|
|
|
Try this
TEMPLATE UNLDDS
DSN KTCT.TST.KTC2406D.KTC06009.TX.SCONTACT.P&PART
UNIT SYSDA MAXPRIME 1200 NBRSECND 3 VOLCNT 99
RETPD 30 |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
apart replying to a 2 years old topic ...
did You test the suggestion before posting ? |
|
Back to top |
|
|
|