IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Image copy partition unload into different files.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
maruthi143

New User


Joined: 17 Jun 2009
Posts: 7
Location: chennai

PostPosted: Fri Sep 04, 2009 11:08 am
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Sep 04, 2009 11:18 am
Reply with quote

What this has to do with CLIST/REXX is a bit beyond me.
Topic moved to DB2 forum.
Back to top
View user's profile Send private message
maruthi143

New User


Joined: 17 Jun 2009
Posts: 7
Location: chennai

PostPosted: Fri Sep 04, 2009 11:20 am
Reply with quote

I ma not geeting can u pls explain elaborately icon_smile.gif
Back to top
View user's profile Send private message
maruthi143

New User


Joined: 17 Jun 2009
Posts: 7
Location: chennai

PostPosted: Fri Sep 04, 2009 11:22 am
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Sep 04, 2009 4:17 pm
Reply with quote

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
View user's profile Send private message
Kiran Chava

New User


Joined: 07 Jul 2010
Posts: 9
Location: India

PostPosted: Thu Jul 28, 2011 1:49 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Jul 28, 2011 1:55 pm
Reply with quote

apart replying to a 2 years old topic ...
did You test the suggestion before posting ?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts Remote Unload of CLOB Columns DB2 6
Search our Forums:

Back to Top