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
 

 

Reorg tablespace

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

New User


Joined: 23 Mar 2010
Posts: 14
Location: kolkata

PostPosted: Tue Nov 12, 2013 11:26 am    Post subject: Reorg tablespace
Reply with quote

How to know that it is required to reorg a table space(Segmented or partitioned tablespace).Is there any process that tells that reorg is needed?
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Nov 12, 2013 12:01 pm    Post subject:
Reply with quote

Dhrubojoty,

Yes.

Take a look at DSNACCOX stored procedure provides recommendations.

DB2 Real-Time-Statistics

Thanks,
Sushanth
Back to top
View user's profile Send private message
Dhrubojoty mukherjee

New User


Joined: 23 Mar 2010
Posts: 14
Location: kolkata

PostPosted: Sun Nov 17, 2013 2:53 pm    Post subject:
Reply with quote

Thanks for ur rply... icon_biggrin.gif
Back to top
View user's profile Send private message
Ruki4db2sys

New User


Joined: 18 Nov 2013
Posts: 1
Location: INDIA

PostPosted: Wed Nov 20, 2013 3:23 pm    Post subject:
Reply with quote

We do reorg under so many factors...

Out of which, if the cluster ratio is low (probably below 90%) then we do reorg. This way we can easily list the tablespace.
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 Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm
No new posts Question: REORG on LOB tablespaces rakesh1155 DB2 1 Fri Aug 14, 2015 2:14 pm


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