Retrieving status information from the console

You can collect health status information regarding IBM Integrated Synchronization by running a function from the IBM Db2 Analytics Accelerator Console. This includes the information that you also find in DSNX messages in the SYSLOG and in the event viewer of your administration client. In addition, the console function gives you detailed information about open transactions.

Procedure

Log on to the IBM Db2 Analytics Accelerator Console by using telnet or ssh. The preferred method is ssh.
For more information:
- Using telnet to log on to the IBM Db2 Analytics Accelerator Console
- Using ssh to log on to the IBM Db2 Analytics Accelerator Console

Press the Pause key, then Enter to display the following screen:

*****************************************************************************
*         Welcome to the IBM Db2 Analytics Accelerator Console
*****************************************************************************

You have the following options:
 (0) - (Menu) Manage Configuration Console Users                                                
 (1) - (Menu) Run Accelerator Functions
 (2) - (Menu) Manage Incremental Updates 
 (3) - (Menu) Manage Encryption of Data in Motion
 (4) - (Menu) Manage Call Home
                                                                             
 ----------------------------------------------------------------------         
 (x) - Exit the Configuration Console

Type 2 and press Enter to display the submenu:

 main -> 2                                               
 --------------------------------------------------------
 You have the following options:                         
                                                         
(0) - Go back one level
(1) - Enable incremental updates
(2) - Disable incremental updates
(3) - Restart incremental update processes
(4) - Include or exclude tables not enabled for incremental updates in WAITFORDATA queries
(5) - Allow or disallow queries to run if WAITFORDATA timeout is reached
(6) - Change Db2 for z/OS credentials for Integrated Synchronization
(7) - Change IP and secure DDF port of Db2 for z/OS for Integrated Synchronization
(8) - (Menu) Manage Certificates for replication
(9) - Integrated Synchronization status

(Default 0) >

Type 9 and press Enter.
You see a list of the Db2 subsystems that are currently enabled for IBM Integrated Synchronization
Select the Db2 subsystem you are interested in by typing the number in front of it at the prompt. Then press Enter.
If just one Db2 subsystem is enabled, it is selected by default.
The time of the status retrieval is displayed. In addition, you see the following submenu:
```
1. Display status overview
2. Display list of open transactions
3. Refresh status information

Select ('' or '0' to exit):
```
Type the number in front of the option you want to select. Then press Enter.
- 1. Display status overview
  The output will be similar to the following example:
```
Status information retrieved on Fri Feb  4 16:49:28 2022

Latency: 300s
Latest commit RBA / LRSN: 00000000361AC99FE40
Parsed source operations: 1400 insert, 600 update, 2000 delete
Applied target operations: 2000 insert, 2600 delete
Tenured heap usage: 90%
Number of open transactions: 35

Type 'r' to refresh status information or press <return> to go back:
```
  From this panel, you can take one the following actions:
  - Type r to refresh the information.
  - Press Enter to return to the selection submenu.
  For a description of the metrics that are returned, see Health reporting.
- 2. Display list of open transactions
  Selecting this item will display information similar to this example:
```
Status information retrieved on Fri Feb  4 16:49:28 2022

Number of open transactions: 35
Restart position RBA / LRSN: 0000000050738AB417B3  URID: 50738AB45EF8, timestamp: 2021-11-1 10:10:10

Open transactions (showing 1-10 of 35):
-----------------------------------------------------------------------------------------------------------
 # | URID         | Begin RBA / LRSN     | Begin Timestamp    | User ID   | LUWID
-----------------------------------------------------------------------------------------------------------
 1 | 50738AB45EF8 | 0000000050738AB45EF8 | 2021-11-1 10:10:10 | SOMEUSER1 | G91ECBA1.P05E.E19D88FF0A22.0010 
 2 | 50738AB46A12 | 0000000050738AB46A12 | 2021-11-1 10:10:10 | SOMEUSER2 | G91ECBA1.POE4.E19D88FF3334.0010
 3 | 50738AB417B3 | 0000000050738AB417B3 | 2021-11-1 10:10:10 | SOMEUSER3 | G91ECBA1.P086.E19D88FF1579.0010 
 4 | 50738AB48000 | 0000000050738AB48000 | 2021-11-1 10:10:10 | SOMEUSER4 | G91ECBA1.PODC.E19D88FF2FC1.0010 
                                        .
                                        .
                                        .
Type 'n' to view the next 10 transactions,
't' to view transaction tables,
or press <return> to go back to status information for XYZAB10:
```
  Legend:
  
  Restart position RBA / LRSN: X, URID: X, timestamp: X
  
  The RBA or LRSN of the restart position, along with the URID and timestamp. This corresponds to the exact position in the log that IBM Integrated Synchronization rewinds to and resumes processing from after a restart.
  
  #
  
  An ascending sorting number for each record.
  
  URID
  
  Each list item represents a unit of recovery (UR). The URID is the identification number of each such unit
  
  Begin RBA/LRSN
  
  The relative byte address (RBA) or the log record sequence number (LRSN) that marks the beginning of an open transaction
  
  Begin Timestamp
  
  The start time of an open transaction
  
  User ID
  
  The user ID under which an open transaction was started
  
  LUWID
  
  The LUW ID of an open transaction.
  
  Note: Open transactions listed under 1. Display status overview and 2. Display list of open transactions cover only those open transactions that include already processed changes to replicated tables. The SYSLOG, on the other hand, shows all open transactions. Compare Health reporting.
  From this panel, you can take one the following actions:
  - Type n to view the next 10 records in the list.
  - Type p to view the previous 10 records in the list.
  - Type t to view the tables involved in an open transaction. After typing t, you have to type the number of the open transaction you are interested in (the number in the # column of the list). The output will look as follows:
```
Select the transaction # to view its tables: 8

Tables for transaction with URID 000030A3B22E:
 SCHEMA8.TABLETABLE8 ( dbid 705, obid 1 )
Press <return> to go back to the list of transactions.
```
    From the display of tables, you can return to the list of open transactions by pressing Enter.
  - Press Enter to return to the selection submenu.
- 3. Refresh status information
  Selecting this option will collect the very latest status information. Use it if selecting option 1 or 2 did not display the records you are interested in.
Press Enter repeatedly to return to the main menu of the IBM Db2 Analytics Accelerator Console.
Enter x to exit the console.