For online REORG, create parameter to set RC=4 when DRAIN fails

I am creating a scheduled job to perform regular REORGs of the Db2 Catalog.

I am generating a list of catalog objects and feeding it to LISTDEF and then using ITEMERROR,SKIP

I am using extremely gentle DRAIN settings...DRAIN_WAIT of 2 or 3 seconds. When this job runs, I want it to ATTEMPT to drain the catalog objects as it REORGs them, but if it CANNOT get the DRAIN, I want it to just move on. We would be running the job frequently enough that we would just "get it next time".

ITEMERROR,SKIP does this...but it sets the final RC of the REORG step to an "8".

I don't want the job to set an "8" just because some SPUFI user forgot to COMMIT and sign off after querying the catalog, and have Batch Scheduling calling asking "what's wrong with the job??".

So what I'd like to see...is a command or option for REORG where you can tell it, "IF a SHRLEVEL CHANGE REORG fails solely because it couldn't get a DRAIN, set the RC for that step to '4' instead of '8'".

This would occur ONLY if the job failure is SPECIFICALLY due to inability to complete a DRAIN. All other errors would still set an "8" for the final RC.

This would allow scheduled REORG jobs to REORG whatever they CAN get a DRAIN on, and if they CAN'T get a DRAIN, just skip that object, and those routine jobs could return RC4 instead of RC8, to avoid alerting Scheduling to a problem that isn't really a problem.

Needed By

Not sure -- Just thought it was cool

Post comment

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Please enter your email address

RELATED IDEAS

For online REORG, create parameter to set RC=4 when DRAIN fails