Monitoring and displaying RRSAF connections

The Resource Recovery Services attachment facility (RRSAF) allows an application or application monitor to disassociate a Db2 thread from a TCB. Later the thread can be associated with the same or a different TCB within the same address space.

About this task

Begin general-use programming interface information.RRSAF uses the RRS Switch Context (CTXSWCH) service to do this. Only authorized programs can execute CTXSWCH.

Db2 stores information in an RRS CONTEXT about an RRSAF thread so that Db2 can locate the thread later. An application or application monitor can then invoke CTXSWCH to disassociate the CONTEXT from the current TCB and then associate the CONTEXT with the same TCB or a different TCB.

The following command displays information about RRSAF threads, including those that access data at remote locations:

-DISPLAY THREAD(RRSAF)

The command produces output similar to the output in the following figure:

Figure 1. DISPLAY THREAD output showing RRSAF connections
   DSNV401I = DISPLAY THREAD REPORT FOLLOWS -
   DSNV402I = ACTIVE THREADS -
   NAME     ST A   REQ ID           AUTHID   PLAN     ASID TOKEN
 1 RRSAF    T        4 RRSTEST2-111 ADMF001  ?RRSAF   0024    13
 2 RRSAF    T        6 RRSCDBTEST01 USRT001  TESTDBD  0024    63
 3 RRSAF    DI       3 RRSTEST2-100 USRT002  ?RRSAF   001B    99
 4 RRSAF    TR       9 GT01XP05     SYSADM   TESTP05  001B   235
              V444-DB2NET.LUND0.AA8007132465=16 ACCESSING DATA AT
              V446-SAN_JOSE:LUND1
   DISPLAY ACTIVE REPORT COMPLETE
Key
Description
 1 
This is an application that used CREATE THREAD to allocate the special plan that is used by RRSAF (plan name = ?RRSAF).
 2 
This is an application that connected to Db2 and allocated a plan with the name TESTDBD.
 3 
This is an application that is currently not connected to a TCB (shown by status DI).
 4 
This is an active connection that is running plan TESTP05. The thread is accessing data at a remote site.

End general-use programming interface information.