Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 Utility to repair and unload the tablespace

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

New User


Joined: 06 Jun 2005
Posts: 18
Location: mumbai,india

PostPosted: Wed Sep 28, 2005 1:36 pm    Post subject: DB2 Utility to repair and unload the tablespace
Reply with quote

Hi

can anybody tell about the db2 utilites which does the following function.

repair,unload as whole tablespace,load,unload the partition tablespace etc.

where can i get the details?

what is reorgs in DB2?

If anybody know anything please share with me..

Thanks
bnsahoo
Back to top
View user's profile Send private message

die7nadal

Active User


Joined: 23 Mar 2005
Posts: 156

PostPosted: Thu Sep 29, 2005 1:09 am    Post subject:
Reply with quote

U can perform all these functions in utilities like BMCDB2, PLATINUM, DB2L.
Back to top
View user's profile Send private message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Sep 29, 2005 1:09 pm    Post subject: Re: DB2 Utilities
Reply with quote

Hi


Load utility is used to load tables from prod to test.
By using load jcl we can load tables.
For a large table it is better to use load for loading
a table.

If u are using Qmf in ur project , u can use
SAVE DATA AS Command to save datas in a table
and after that by using insert we can load datas frm this table.

Unload utility is used to unload tables either from prod to test or
from test to test. By using Unload jcl we can unload tables.

In both Load and Unload Sysrec and Syspunch are the
important thngs. It vll contain the actual data in a file format.


Corrections are welcome...

Thnks

Karthi G.
Back to top
View user's profile Send private message
bnsahoo

New User


Joined: 06 Jun 2005
Posts: 18
Location: mumbai,india

PostPosted: Sat Oct 01, 2005 2:34 pm    Post subject: Re: DB2 Utilities
Reply with quote

Hi all,

Thanks for your reply,but if you have any documents please share with me.i want to learn from the scratch and i want the details.Otherwise if you know any website URL you can share with me.

Thanks,
bnsahoo
Back to top
View user's profile Send private message
sathish_rathinam

New User


Joined: 22 Aug 2005
Posts: 59
Location: india

PostPosted: Tue Oct 25, 2005 2:35 pm    Post subject:
Reply with quote

HI,
CAN I KNOW ABT PLATINUM AND FOR WHT PURPOSE ITS BEING USED?

REGARDS,
SATHISH
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 NULLFILE on ICEGENER Utility Ashishpanpaliya DFSORT/ICETOOL 5 Wed Nov 08, 2017 10:45 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us