Version 8.2.1

Adabas System Coordinator online administration

This section describes the administrative functions relating to Adabas Transaction Manager that are found with Adabas System Coordinator.


TM Global Transaction Time Limit

You can use the network discovery function in System Coordinator administration to display/modify the transaction manager global transaction time limit. Use the tasks function against a System Coordinator daemon to see what can be performed as follows…

Display/Modify TM global transaction time limit

Start of instruction setTo display/modify the Transaction Manager global transaction time limit

  1. Use "T" on the row for the System Coordinator daemon where your transaction manager service is running to see the list of tasks allowed.

  2. Select the "Set TM global transaction time limit" task and press PF5.

  3. The following window will appear showing the current time limit:

10:30:49   Set TM Global Transaction Time Limit  2011-03-03 
 Current target: 1650  Type: System Coord                    
                                                             
   Current global transaction time limit: 720_____           
                                                             
                                                             
                                                             
              PF3 Exit    PF5 Set TMGTT                      

Modify the time limit by changing the value and pressing PF5.

Top of page

Stop inactive Adabas sessions

You can use the network discovery function in System Coordinator administration to stop all sessions on a selected database that have been dormant for a specified number of seconds. Use the tasks function against a database to see what can be performed as follows…

Stop inactive sessions

Start of instruction setTo stop inactive sessions

  1. Use "T" on the row for the appropriate database to see the list of tasks allowed.

  2. Mark the "Stop inactive users" task, specify the dormant period and press PF5.

Top of page

Current activity display

Use the System Coordinator current activity display function to see the activities of Adabas jobs and the client sessions within them, including specific detail for Transaction Manager.

Display job statistics

Start of instruction setTo display Adabas Transaction manager job statistics within System Coordinator:

  1. Use PF11 to select Adabas Transaction Manager and the following will appear:

    12:31:24     ***** A D A B A S   SYSTEM COORDINATOR 8.2.1 *****     2011-03-03
                      -  Transaction Manager Session Statistics  -       U1STS0M4  
                                                                                   
     Node ID: LOCAL Session ID: CICSTC43 Hex: C3C9C3E2E3C3F4F3 Job Name: DAEFCI18  
                                                                                   
                       Transactions         Commits    Tran Timeout       Heuristic
                       ------------    ------------    ------------    ------------
       ATM only:                  0               0                                
       External:                  0               0                                
                                                                                   
       Global:                    0               0               0               0
    
    
    
    
    
    
                                                                                   
                                                                                   
     Command ==>                                                                   
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
                      Exit  Refr                          More  Tasks Prods Menu   
    

Display session statistics

Start of instruction setTo display Adabas Transaction manager session statistics within System Coordinator:

  1. Use PF11 to select Adabas Transaction Manager and the following will appear:

    12:31:24     ***** A D A B A S   SYSTEM COORDINATOR 8.2.1 *****     2011-03-03
                      -  Transaction Manager Session Statistics  -       U1STS0M4  
                                                                                   
     Node ID: LOCAL Session ID: CICSTC43 Hex: C3C9C3E2E3C3F4F3 Job Name: DAEFCI18  
                                                                                   
                       Transactions         Commits    Tran Timeout       Heuristic
                       ------------    ------------    ------------    ------------
       ATM only:                  0               0                                
       External:                  0               0                                
                                                                                   
       Global:                    0               0               0               0
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
     Command ==>                                                                   
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
                      Exit  Refr                          More  Tasks Prods Menu   
    

Display session details

Start of instruction setTo display session details:

  1. Press PF9 from the Adabas Transaction Manager session statistics screen and the following will appear:

     12:32:32     ***** A D A B A S   SYSTEM COORDINATOR 8.2.1 *****     2011-03-03
                               -  Session Details  -                     U1TMA0M1  
    
    Job Name: DAEFCI18      Co-ordinator: ATM                 Client Type: 00 - DTP
    Terminal ID: TCR9     E3C3D9F900000000      Net Name: DAEETCR9 C4C1C5C5E3C3D9F9
    Client ID:   TM?q   ? E3D41B9800000005      Status: 0020002002F0  TRN OPEN
    CommID: 000FA10E 20860000 BEAD4038 F1705B42 00000001 C3C9C3E2 E3C3D9F9         
       XID: C1C4C101 00000050 00000002 5033000F A10E2086 0000BEAD 4038F170 5B420000
            0001C3C9 C3E2E3C3 D9F9D7C4 E3C5E2E3 4040C4C1 C5C6C3C9 F1F8BEAD 405F290D
            7C020000 00000000 00000000 00000000 00000000 00000000 00000000 C2D80000
            00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    Adabas calls: 123                                  ASA: 1BC14FE8 GTQE: 1B63EA80
    Last Function Call: 23 - STRT TRN                 Transaction model: DYNAMIC   
     DBNo.   L/R   DTP  ETID    Status           |        Pending Response Codes   
     135      L     N  PDTEST   8067 ET          |           Resp.   Subcode          
     20532    L     Y           0265 CHANGED     |                                 
                                                 |                                 
                                                 |                                 
                                                 |                                 
                                                 |                                 
                                                                                   
                                                                                   
     Command ==>                                                                   
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit  Refr              Top               ErrI        Menu   
    

The following information is provided:

Field Description
Jobname The name of the job under which this client session is running.
Coordinator The transaction coordinator that has control of the session’s transactions.
Possible values are:
  • ATM: the local ATM has control.

  • CLIENT SIDE TC: the session’s client-side transaction coordinator has control.

  • HOST TC: the host system transaction coordinator has control.

Client Type The internal type code for the client session, followed by a summary interpretation.
Possible values are:
  • DTP: a normal DTP-mode client.

  • SER: a client session that is operating in serial ET/BT mode.

  • NTR: a session for which the TM proxy does not invoke transparent transaction processing.

Terminal ID Environment-specific identifier of the client session in character and hexadecimal format.
Net-Name Environment-specific identifier of the client session.
Client ID The Client ID in character and hexadecimal format.
Status The session’s status code in hexadecimal followed by a summary interpretation in character format.
Possible values are:
  • CLT SYNC: syncpoint requested by client-side transaction coordinator.

  • FORCE BT: forced backout in progress.

  • GT: global transaction status.

  • IN BKOUT: an attempt to back out has not yet completed.

  • IN CMIT: an attempt to commit has not yet completed.

  • IN ET/BT: prepare/commit/backout in progress.

  • TM DOWN: TM unavailable.

  • TRN OPEN: transaction in progress.

  • UNKNOWN: transaction status not known.

  • XH ET: in extended hold (ET) status.

  • XH BT: in extended hold (BT) status .

CommID The session’s 28-byte Adabas Communication ID.
XID The Transaction ID of the current transaction. This field contains binary zeros if the session has no transaction is progress.
Adabas Calls The number of Adabas calls issued by the session.
ASA This field contains internal information which might be useful to Software AG’s support staff in problem resolution.
GTQE This field contains internal information which might be useful to Software AG’s support staff in problem resolution.
Last Function Call The type of the most recent internal call sent by the TM proxy to the transaction manager for the session. Included for diagnostic purposes.
Transaction Model The transaction model that is currently in use for the session.

The remainder of the screen displays:

List of Databases

Field Description
DBNo. Database ID.
L/R Indicates whether the database is local to or remote from the client; that is, whether or not the database is executing in the same operating system instance.
DTP Indicates whether distributed transaction processing is enabled for the database; that is, whether it is running with the runtime parameter ADARUN DTP=RM. If this field is blank, the setting of the database's DTP parameter is not currently known.
ETID If the database session has an ETID, it is shown here; otherwise the field is blank.
Status A summary of the current status of the database with respect to the current client session.
Possible summary values are:
  • ET: the client has no pending updates on this database.

  • CHANGED: the client has uncommitted updates on this database.

  • XH: the database is in extended hold status.

  • BT RQD: backout must be performed on this database .

Client TC Display

If the session has an open transaction under the control of the local environment’s client-side transaction coordinator (CLIENT SIDE TC), PF9 at the foot of the screen is labeled "TC". Pressing PF9 invokes the Client TC Display window showing the identifier used by the client-side transaction coordinator for the transaction.

Error Information

Press PF10 to display the contents of the feedback block returned by the local ATM when the TM proxy last sent a command to it on behalf of the session.

The format of the resulting pop-up window is the same as described in section Display Error Information.

Top of page

Stop Adabas sessions

You can use the current activity function in System Coordinator administration to perform tasks against a selected session. First identify the session, and then use the PF10 "tasks" function off the session statistics display to see what tasks can be performed. One such task is the ability for administrators to automatically stop a selected session in all databases where that session is active. This is a large productivity gain because it avoids the administrator having to seek out manually those databases where this session is active.

Start of instruction setTo stop an Adabas session

  1. Use PF10 "Tasks" off the session statistics display to see the list of tasks allowed.

  2. Mark the "Stop Adabas UQEs" task, and press ENTER.

Top of page