Utility concurrency and compatibility

Some online utilities allow other utilities and SQL statements to run concurrently on the same target object.

To determine whether utilities can be run concurrently, see the compatibility and concurrency information in the following table. Most of these concurrency and compatibility topics include the following information:
  • For each target object, the claim classes that the utility must claim or drain and any restrictive state that the utility sets on the target object.
  • For other online utilities, the compatibility of the utility with the same target object. If two actions are compatible on a target object, they can run simultaneously on that object in separate applications. If compatibility depends on particular options of a utility, that dependency is noted.
Table 1. Utility compatibility and concurrency
Online utility Compatibility and concurrency information
BACKUP SYSTEM Concurrency and compatibility for BACKUP SYSTEM
CATENFM Concurrency and compatibility for CATENFM
CATMAINT Concurrency and compatibility for CATMAINT
CHECK DATA Concurrency and compatibility for CHECK DATA
CHECK INDEX Concurrency and compatibility for CHECK INDEX
CHECK LOB Concurrency and compatibility for CHECK LOB
COPY Concurrency and compatibility for COPY
COPYTOCOPY Concurrency and compatibility for COPYTOCOPY
DIAGNOSE Concurrency and compatibility for DIAGNOSE
EXEC SQL Concurrency and compatibility for EXEC SQL.
LISTDEF Concurrency and compatibility for LISTDEF
LOAD Concurrency and compatibility for LOAD
MERGECOPY Concurrency and compatibility for MERGECOPY
MODIFY RECOVERY Concurrency and compatibility for MODIFY RECOVERY
MODIFY STATISTICS Concurrency and compatibility for MODIFY STATISTICS
OPTIONS Concurrency and compatibility for OPTIONS
QUIESCE Concurrency and compatibility for QUIESCE
REBUILD INDEX Concurrency and compatibility for REBUILD INDEX
RECOVER Concurrency and compatibility for RECOVER
REORG INDEX Concurrency and compatibility for REORG INDEX
REORG TABLESPACE Concurrency and compatibility for REORG TABLESPACE
REPAIR Concurrency and compatibility for REPAIR
REPORT Concurrency and compatibility for REPORT
RESTORE SYSTEM While running RESTORE SYSTEM
RUNSTATS Concurrency and compatibility for RUNSTATS
STOSPACE Concurrency and compatibility for STOSPACE
TEMPLATE Concurrency and compatibility for TEMPLATE
UNLOAD Concurrency and compatibility for UNLOAD

If the utility supports parallelism, it can use additional threads to support the parallel subtasking. Consider increasing the values of subsystem parameters that control threads, such as MAX BATCH CONNECT and MAX USERS.