Fallback step 1: Stop Db2 13 activity

Before you can fall back, you must stop Db2 13 activity and ensure that no recovery is required on system databases.

Procedure

To stop Db2 13 work:

  1. Issue the following command:
    Begin general-use programming interface information.
    -DSN1 STOP DB2 MODE(QUIESCE)
    End general-use programming interface information.

    The QUIESCE keyword allows Db2 to complete processing of currently executing programs. This activity might require some processing time.

  2. Issue the following command:
    Begin general-use programming interface information.
    -DSN1 START DB2 ACCESS(MAINT)
    End general-use programming interface information.

    This command allows only the installation-defined system administrators and system operators to access Db2.

    If Db2 does not start properly, it usually abends with a reason code that indicates where the error occurred. To find the error, check the set of definitions for the associated resource. Check to see that you started Db2 with the correct subsystem parameter load module.

  3. Ensure that all work is complete.
    • Ensure that no units of recovery remain. Issue the following command:
      Begin general-use programming interface information.
      -DSN1 DISPLAY THREAD(*) TYPE(*)
      End general-use programming interface information.
      Then use RECOVER INDOUBT for any indoubt threads.
    • Ensure that no utility work remains. Issue the following command:
      Begin general-use programming interface information.
      -DSN1 DISPLAY UTILITY(*)
      End general-use programming interface information.
      Then, either allow utilities to complete before proceeding, or stop all utility processing with the following command: 
      -DSN1 TERM UTILITY(*)
    • Ensure that no table spaces and index spaces in the Db2 directory (DSNDB01) or the Db2 catalog (DSNDB06) have write error ranges or deferred restart states. Issue the following command:
      Begin general-use programming interface information.
      -DSN1 DISPLAY DATABASE(DSNDB01) SPACENAM(*) RESTRICT
-DSN1 DISPLAY DATABASE(DSNDB06) SPACENAM(*) RESTRICT
      End general-use programming interface information.
      A user with installation-defined system administrator or system operator authority also must enter this command.

      Recover any table spaces and index spaces with write error range or deferred restart states.

  4. To stop Db2, issue the following command:
    Begin general-use programming interface information.
    -DSN1 STOP DB2 MODE(QUIESCE)
    End general-use programming interface information.
    A user with SYSADM or SYSOPR authority also must enter this command.
    If IRLM does not stop automatically when Db2 stops, stop IRLM manually. To stop IRLM, issue the following command, where irlmproc is the name you assigned to the IRLM startup procedure: 
    STOP irlmproc