This section describes the administrative functions relating to Adabas Transaction Manager that are found with Adabas System Coordinator.
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…
To display/modify the Transaction Manager global transaction time limit
Use "T" on the row for the System Coordinator daemon where your transaction manager service is running to see the list of tasks allowed.
Select the "Set TM global transaction time limit" task and press PF5.
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.
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…
To stop inactive sessions
Use "T" on the row for the appropriate database to see the list of tasks allowed.
Mark the "Stop inactive users" task, specify the dormant period and press PF5.
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.
To display Adabas Transaction manager job statistics within System Coordinator:
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 |
To display Adabas Transaction manager session statistics within System Coordinator:
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 |
To display session details:
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:
|
Client Type | The internal type code for the client session,
followed by a summary interpretation. Possible values are:
|
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:
|
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:
a list of databases with which the client is in session; and
a list of up to five pairs of pending Adabas response codes and subcodes in reverse chronological order.
If the list of databases is too long to fit on the display, "More" appears at the foot of the screen. Use PF7 to return to the top of the list and PF8 to scroll down the list.
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:
|
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.
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.
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.
To stop an Adabas session
Use PF10 "Tasks" off the session statistics display to see the list of tasks allowed.
Mark the "Stop Adabas UQEs" task, and press ENTER.