IBM Support

QSYS2.MIRROR_SUSPENDING_JOBS()

News


Abstract

The MIRROR_SUSPENDING_JOBS table function returns a row for each job that prevents Db2 Mirror from resuming active replication. The jobs returned by this table function contain Db2 Mirror database connections that have not completed their processing of a previous Db2 Mirror suspend request. The jobs that prevent Db2 Mirror from resuming can exist on the source node only, on the target node only, or on both nodes.

Content

Db2 Mirror

For complete details, view the IBM Documentation page: MIRROR_SUSPENDING_JOBS table function
 

Enhanced with IBM i 7.5 - [SF99951 Level 5 and SF99950 Level 5] & IBM i 7.4 - [SF99668 Level 23 and SF99704 Level 26]:

  • Enhanced support while Db2 Mirror is attempting to vary off an IASP to include detecting any jobs with Db2 Mirror database connections for the IASP that have not completed their suspend processing.
  • This enhancement requires an active version for the RESUME-INTERNAL-MAINTENANCE version entry of at least 1.2 to fully enable. See RESUME-INTERNAL-MAINTENANCE version entry for more details.

Introduced new service with IBM i 7.5 - [SF99951 Level 3 and SF99950 Level 3] & IBM i 7.4 - [SF99668 Level 21 and SF99704 Level 23]:

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSLLPF","label":"IBM Db2 Mirror for i"},"ARM Category":[{"code":"a8m0z0000001hExAAI","label":"DB2 Mirror"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"},{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001hExAAI","label":"DB2 Mirror"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"}]

Document Information

Modified date:
12 October 2023

UID

ibm16829513

Page Feedback