Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Image copy partition unload into different files.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Image copy partition unload into different files.
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: 8593
Location: Back in jolly old England

PostPosted: Fri Sep 04, 2009 11:18 am    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10257
Location: italy

PostPosted: Thu Jul 28, 2011 1:55 pm    Post subject: Reply to: Image copy partition unload into different files.
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 5 Thu Apr 27, 2017 1:15 am
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us