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
 

 

How to unload data from db2 table into a dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Rahul Reddy R

New User


Joined: 01 Apr 2008
Posts: 4
Location: Mysore

PostPosted: Fri Jan 30, 2009 12:14 pm    Post subject: How to unload data from db2 table into a dataset
Reply with quote

Hi,

Please help me with a JCL which can be used for unloading data from a db2 table into a dataset(as a backup).

And also a JCL which can be used for loading back the data into the db2 table from the backup created earlier.

Rahul icon_smile.gif
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 Jan 30, 2009 12:16 pm    Post subject:
Reply with quote

The best people to ask is your DB2 people, as they will have the standard JCL along with all of the site specific details.

Also, the DBA's may also have a specific product to perform backup / recovery processing which is faster and better than standard utilities..
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jan 30, 2009 12:17 pm    Post subject:
Reply with quote

Hello,

Suggest you talk with the dbas and have them show you how to perform and imagecopy backup and how to reload from the backup into the table.

Not everyone has the permissions granted to backup/restore. . .
Back to top
View user's profile Send private message
prashanth1

New User


Joined: 27 Sep 2006
Posts: 47
Location: Hyderabad

PostPosted: Fri Jan 30, 2009 12:40 pm    Post subject:
Reply with quote

Rahul,

Use DSNTIUL utility.
Back to top
View user's profile Send private message
Itanium

Active User


Joined: 22 Jan 2006
Posts: 114
Location: India

PostPosted: Fri Jan 30, 2009 1:04 pm    Post subject:
Reply with quote

your DBA's are the right people to contact. There might be standards specific to your shop, they should be having model JCLs.

Thanks,
Itanium
Back to top
View user's profile Send private message
prashanth1

New User


Joined: 27 Sep 2006
Posts: 47
Location: Hyderabad

PostPosted: Fri Jan 30, 2009 2:17 pm    Post subject:
Reply with quote

Rahul,

I can suggest one thing. Search with DSNTIUL against production JCLs and PROCs. Somewhere definately you will find the solution for your problem.

Still If you dont find then I will provide the JCLs to You.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2284
Location: @my desk

PostPosted: Fri Jan 30, 2009 2:21 pm    Post subject:
Reply with quote

Or you can have a look at this related topic.

http://www.ibmmainframes.com/viewtopic.php?t=35857
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 copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Browse dataset cvnlynn CLIST & REXX 4 Tue Jul 18, 2017 3:52 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am


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