I would like to seek clarification and guidance regarding the configuration of QBATCH in a DB2 Mirror for i environment, particularly in the context of running and recovering batch jobs during a node switch.
Specifically:
-
How should QBATCH be configured in a DB2 Mirror for i setup to ensure high availability of batch processing?
Is there a recommended approach to ensure job queues like QBATCH are mirrored or made consistently available across both nodes?
-
If a batch job is submitted on one node (e.g., Node A) and a planned or unplanned switch to the other node (e.g., Node B) occurs while the job is still running, how should recovery be handled?
-
Will the job resume automatically on the new active node?
-
Or should the job be designed with restart/recovery logic?
-
Are there best practices or automation mechanisms recommended to detect and re-submit such jobs post-failover?
------------------------------
Mark De Zoysa
Senior Engineering Manager
Commercial Bank
colombo 3
+94 773992594
------------------------------