How to unload data from db2 table into a dataset

Rahul Reddy R · New User Joined: 01 Apr 2008 Posts: 4 Location: Mysore

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

expat · Posted: Fri Jan 30, 2009 12:16 pm

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..

dick scherrer · Posted: Fri Jan 30, 2009 12:17 pm

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. . .

prashanth1 · New User Joined: 27 Sep 2006 Posts: 47 Location: Hyderabad

Rahul,

Use DSNTIUL utility.

Itanium · Active User Joined: 22 Jan 2006 Posts: 114 Location: India

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

prashanth1 · New User Joined: 27 Sep 2006 Posts: 47 Location: Hyderabad

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.

Arun Raj · Posted: Fri Jan 30, 2009 2:21 pm

Or you can have a look at this related topic.

www.ibmmainframes.com/viewtopic.php?t=35857