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
 

 

Clarification on RUNSTATS and REORG?

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

New User


Joined: 30 Jan 2006
Posts: 3

PostPosted: Mon Feb 13, 2006 11:57 am    Post subject: Clarification on RUNSTATS and REORG?
Reply with quote

HI,

Can u Explain about RUNSTATS and REORG in DB2?

Thanks in Advance,

Abirami
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Feb 13, 2006 3:03 pm    Post subject:
Reply with quote

What about the fine manual ?

O.
Back to top
View user's profile Send private message
v.amirthalingam

New User


Joined: 13 Feb 2006
Posts: 1
Location: chennai

PostPosted: Mon Feb 13, 2006 3:10 pm    Post subject:
Reply with quote

RUNSTATS
Gathers summary information about the characteristics of the data in table spaces and indexes. This information is recorded in the DB2 catalog, and is used by DB2 to select access paths to data during the bind process. It is available to the database administrator for evaluating database design, and determining when table spaces or indexes should be reorganized

REORG
Reorganized a table space to improve access performance and reclaim fragmented space. In addition, the utility can reorganize a single partition of either a partitioned index ora partitioned table space. If you specify REORG UNLOAD ONLY or REORG UNLOAD PAUSE, the REORG utility unloads data in a format acceptable to the LOAD utility of the same DB2 table space.

Regards,
amir...
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 Need clarification of VSAM FCT and DF... pkmurali CICS 15 Sun Apr 10, 2016 1:06 am
No new posts Question: REORG on LOB tablespaces rakesh1155 DB2 1 Fri Aug 14, 2015 2:14 pm
No new posts Clarification regarding BUFNI & B... thirumalasetty JCL & VSAM 14 Tue Jun 17, 2014 8:22 pm
No new posts Reorg tablespace Dhrubojoty mukherjee DB2 3 Tue Nov 12, 2013 11:26 am
No new posts How to embed RUNSTATS in an applicati... ravindra.vadali DB2 4 Tue Oct 15, 2013 8:33 pm


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