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
 

 

DB2 - Table Space and Index - REORG and questions.

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

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Fri Jun 22, 2012 8:34 pm    Post subject: DB2 - Table Space and Index - REORG and questions.
Reply with quote

I'm at a shop where in first step - they stop TABLESPACE/INDEXSPACE, in second step they will DELETE & DEFINE underlying LDS, the VSAM for TABLE & INDEX(S), in third step they'll start ACCESS(UT) TABLE and INDEXSPACE, in fourth step will load the table using DSNUPROC.

I'm bit confused, why would you do this every day:

1. first, data in-flow for these tables, on daily basis, is not too high.
2. no RUNSTAT, I've observed.
3. These are daily jobs - and do this daily.

The questions which come to mind:

1. Why not first determine if REORG is needed - run a RUNSTAT first.
2. Is IDCAMS delete/define is way better than DB2 REORG. Ofcourse, after every IDCAMS delete/define you've a brand new sapce to work on but at what cost?

When I asked some "senior" around -- "we do it this way", was the answer.

I eagerly look forward to Your thoughts, Thanks.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 22, 2012 8:50 pm    Post subject:
Reply with quote

have no idea if i am right or wrong,
but,
using idcams to delete/define the underlying VSAM LDS,
would preclude any changes to the db2 catalog tables.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Jun 25, 2012 9:29 am    Post subject:
Reply with quote

Hi,

That tablespace/indexspace is using user-managed storage, old style.

These jobs may be designed long time back when DB2 version was less than 7 or 6. I would guess, they have kept it that way because, it works and it haven't failed so far and "Why to fix something, that is not broken", because changing them it would cost. May be its simple and quiet system, that doesn't require lots of tuning.

Some/Most of the shops have CPU and definately storage constraints, in my previous organization we never ran RUNSTATS separately, statistics was collected inline.

Thanks,
Sushanth
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Fri Jun 29, 2012 10:22 am    Post subject:
Reply with quote

I agree with you Dick and that makes me believe if I need to rely on RUNSTATs that would cal for a good change in current infrastructure, no?
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Fri Jun 29, 2012 10:32 am    Post subject:
Reply with quote

You're correct Sushanth - actually, it has its own positive and negative. There are some user-written programs which use these tables and they get abend as the underlying tables are not available when these table space are being deleted/defined. Well, that's a scheduling problem also however, if REORG is a weekly activity it might give some relief.

Having said that, I'd like to know - how it goes on different shops, please share.

Thanks for stopping by.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Jun 29, 2012 11:56 am    Post subject:
Reply with quote

RTS is the way to go.
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Wed Jan 16, 2013 8:15 pm    Post subject:
Reply with quote

I know I'm late on this but was on a different project.

RTS? You meant Run-stats - sushanth?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Wed Jan 16, 2013 8:38 pm    Post subject:
Reply with quote

Real-time Statistics. and running DSNACCOX to determine which tablespace really needs runstats/reorg.

If you really want to review the maintenance jobs of your DB2 : that's the way to go
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Mon Apr 08, 2013 10:42 am    Post subject:
Reply with quote

Thanks GuyC.

One is never too late for a thank you, I believe. icon_redface.gif
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 Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm


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