Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Can we unload the table to GDG?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
satyender

New User


Joined: 05 Jan 2008
Posts: 40
Location: hyderabad

PostPosted: Thu Aug 07, 2008 9:35 pm    Post subject: Can we unload the table to GDG?
Reply with quote

Hi,
Please excuse me if I am wrong,asking this question.

Can we unload a table using DSNTIAUL or by any other means into GDG?
Back to top
View user's profile Send private message
References
rpuhlman

Active User


Joined: 11 Jun 2007
Posts: 75
Location: Columbus, Ohio

PostPosted: Thu Aug 07, 2008 9:56 pm    Post subject:
Reply with quote

Hi Satyender,

Have you tried it?

Rick
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1003
Location: Virginia, USA

PostPosted: Thu Aug 07, 2008 10:02 pm    Post subject:
Reply with quote

I hope so, I've been doing it for 10 years, if it we can't I'm in big trouble.
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 40
Location: hyderabad

PostPosted: Thu Aug 07, 2008 10:24 pm    Post subject:
Reply with quote

HI rpuhlman,

I am trying, but ending up with errors.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1003
Location: Virginia, USA

PostPosted: Thu Aug 07, 2008 10:27 pm    Post subject:
Reply with quote

satyender wrote:
HI rpuhlman,

I am trying, but ending up with errors.


With more information we may be able to help you.
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 40
Location: hyderabad

PostPosted: Thu Aug 07, 2008 11:05 pm    Post subject:
Reply with quote

Yes, It is working perfectly.

Thanks all for your responses.
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 40
Location: hyderabad

PostPosted: Thu Aug 07, 2008 11:12 pm    Post subject: JCL for UNLOAD ing the table into GDG
Reply with quote

Code:

//STEP1  EXEC DSNUPROC,UID='GDGUNLD',UTPROC='',SYSTEM='DB2E'
//SYSREC00 DD DSN=T0J0AJ7.UNLOAD.TLCS135(+1),
//            DISP=(,CATLG,DELETE),
//            LABEL=EXPDT=99000,UNIT=VTAPE
//SYSPUNCH DD DSN=T0J0AJ7.GDG.SYSPUNCH.TLCS135,
//            DISP=(,CATLG,DELETE),
//            UNIT=DISK,SPACE=(CYL,(100,100),RLSE)
//SYSPRINT DD SYSOUT=*
//SYSIN    DD *
  UNLOAD TABLESPACE tablespace name
    FROM TABLE tablename ;
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1003
Location: Virginia, USA

PostPosted: Thu Aug 07, 2008 11:44 pm    Post subject:
Reply with quote

What error are you getting?
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 40
Location: hyderabad

PostPosted: Fri Aug 08, 2008 1:16 am    Post subject:
Reply with quote

It was a operator error.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1