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

DB2 Unload from imagecopy files using BMC


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

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Feb 10, 2012 9:36 pm
Reply with quote

sushanth bobby wrote:
Easy thing would be to ask the DBA.

yes, because they have nothing better to do than sit around waiting for dumb questions. icon_evil.gif
Back to top
View user's profile Send private message
M David Hunter

New User


Joined: 30 Jan 2012
Posts: 6
Location: United States

PostPosted: Tue Feb 28, 2012 7:47 pm
Reply with quote

This is a process we use for UNLOAD that my predecessor created. Note I use DSNUTILB

Code:
//steplib EXEC PGM=DSNUTILB,PARM='subsystemID,dbnametsname'
//STEPLIB   DD DSN=DB2.SDSNLOAD,DISP=SHR                         
//SYSPRINT  DD SYSOUT=*                                           
//SYSIN     DD *                                                   
  TEMPLATE UNLDDS                                                 
    UNIT CART                                                     
    DSN 'DB2.&SSID..ULD.&DB..&TS..D&YE(3,2).&MO.&DA..T&TIME(1,4).'
  TEMPLATE CNTLDS                                                 
    UNIT 3390                                                     
    DSN 'DB2.&SSID..ULC.&DB..&TS..D&YE(3,2).&MO.&DA..T&TIME(1,4).'
  UNLOAD                                                           
    TABLESPACE dbname.tsname                                     
    FROMCOPY   ESCDP00.ICF.dbname.tsname.G0588V00                 
    FROMVOLUME CATALOG                                             
    FROM TABLE dbname.tablename                           
    UNLDDN     UNLDDS                                             
    PUNCHDDN   CNTLDS
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 Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top