DB2 z/OS REORG & Batch JOB Concurrency

[vgiusto]

Does the reorg of a DB2 database require batch processing be suspended for the duration of the reorg? What about backups? Can a batch JOB read, write, etc... during reorg and/or backup execution?

Maintenance windows for DB2 backups and reorgs are growing and overlapping with system availability windows.

Thanks

 

[CHOT]

For DB2 z/OS maintenance job like reorg,backup,runstat and etc can be run while the batch job is running. Just code in the db2 command shrlevel parameter either none/reference/change.


For worst case scenario, the job will abend if it cannot get the resource it required. Just terminate the utility pending and reset the check pending state for the tablespace that is in process.