Monitoring members in restart light

You can monitor the recovery progress of a member in restart light mode by running the LIST UTILITIES command on any active member. The LIST UTILITIES command can return the global recovery status of all members including members in restart light mode.

 LIST UTILITIES SHOW DETAIL

 ID                               = 1
 Type                             = MEMBER CRASH RECOVERY 
 Database Name                    = SAMPLE
 Partition Number                 = 0
 Description                      = Member Crash Recovery (Light Mode)
 Start Time                       = 11/22/2007 15:20:05.646020
 State                            = Executing
 Invocation Type                  = Automated
 Progress Monitoring:
    Estimated Percentage Complete = 0
    Phase Number [Current]        = 1
       Description                = Forward
       Total Work                 = 4193976 bytes
       Completed Work             = 0 bytes
       Start Time                 = 11/22/2007 15:20:05.646121
    Phase Number                  = 2
       Description                = Backward
       Total Work                 = 4193976 bytes
       Completed Work             = 0 bytes
       Start Time                 = Not Started

There are a number of methods you can use to obtain a point-in-time view of your Db2® pureScale® environment, including the DB2_GET_INSTANCE_INFO table function, the DB2_MEMBER administrative view, the LIST INSTANCE command, and the db2instance command. Using any one of these methods allows you to determine whether any members are in restart light mode, what host they are being recovered on, and what state of their restart light recovery they are currently in.

In this example, the DB2_MEMBER administrative view shows member 2 is being restarted in light mode on host so3.

SELECT ID,  
       varchar(HOME_HOST,10) AS HOME_HOST, 
       varchar(CURRENT_HOST,10) AS CURRENT_HOST, 
       varchar(STATE,21) AS STATE, 
       ALERT 
FROM SYSIBMADM.DB2_MEMBER

ID     HOME_HOST CURRENT_HOST STATE      ALERT
------ --------- ------------ ---------- -----
     1 so1       so1          STARTED    NO
     2 so2       so3          RESTARTING NO
     3 so3       so3          STARTED    NO

     3 record(s) selected.