SQL QUERY to detect AREO and REORP conditions.

imellis · New User Joined: 29 Jun 2010 Posts: 2 Location: UK

Hi

We have been writing a REXX program to do smart reorgs. It looks at RTS or RUNSTATS and determines from the stats if it thinks that a REORG is necessary and then builds a LISTDEF for a REORG step further along in the JCL.

This is working nicely. But now I want to add some additional functionality to automatically detect AREO and REORP conditions and prioritise those tablespaces for reorg. But after much Googling and rummaging in the manuals I cannot seem to find a method of doing this as part of an SQL query.

So either it's not possible or I'm missing something obvious.

Does anyone have an answer please?

Thank you in advance.

don.leahy · Posted: Thu Nov 08, 2012 12:30 am

I don't think you are missing anything obvious. The only solution I could think of would be to trap the output from the -DIS DATABASE command and use that in your procedure.

imellis · New User Joined: 29 Jun 2010 Posts: 2 Location: UK

I'd already thought of scraping the information out of the -DIS DB command output. It's just that it doesn't integrate well the program I have thus far without making big changes. Finding a more SQL friendly way would be better, if one exists.

Such a feature exists in DB2 LUW, but IBM haven't replicated that functionality in the z/OS edition of their product, which is a shame.

I have figured out a way to go the -DISPLAY command route if I have to, but I didn't want to make any more work for myself than necessary if there was an SQL query that would do the job.

GuyC · Posted: Mon Nov 12, 2012 3:12 pm

DSNACCOX()
querytype = 'RESTRICT'
chklvl = 8

dbzTHEdinosauer · Posted: Thu Nov 15, 2012 1:13 am

as a follow-up to GuyC's post about DSNACCOX
ibmsystemsmag.blogs.com/db2utor/2012/11/db2-performance-stored-procedures.html