IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 - Table Space and Index - REORG and questions.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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: 1020
Location: India

PostPosted: Mon Jun 25, 2012 9:29 am
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
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
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: 1020
Location: India

PostPosted: Fri Jun 29, 2012 11:56 am
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
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: 1281
Location: Belgium

PostPosted: Wed Jan 16, 2013 8:38 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 2
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Reorg abended with REASON=X'00E40347' DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top