Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : @SESSIONCOUNTS

@SESSIONCOUNTS
Obtains information on events occurring within the Execution Environment during a session. (TBL)
Table Definition
Parameters
This table requires a numeric value to be specified as a parameter. The value can be any valid number between 0 and 999999999.
Fields
Fields in the @SESSIONCOUNTS table include:
This value is obtained from the z/OS ASCB structure, and is generally reliable within a range of plus/minus 3 percent.
This value is obtained from the z/OS ASCB structure and is generally reliable within a range of plus/minus 3 percent.
Increment in SYSTEMSECONDS time since the last access to @SESSIONCOUNTS.
CPUSECONDS & CPUDELTA represent address space time information and should not be referenced in a shared space environment such as z/OS CICS.
Usage Notes
To view data in @SESSIONCOUNTS use the Table Browser, or to process data in @SESSIONCOUNTS, do a GET from a rule and use the fields accordingly.
Example
Fields whose names end in DELTA are the difference between the value of the correspondingly named field now, and its value the last time the table was read.
Suppose a user is interested in how many table accesses are done in the course of creating a new employee record. The transaction they would normally run would start by calling CREATE_EMPLOYEE from a menu. To determine our count, the user could write the following rule:

 
CHECK_#ACCESSES;
------------------------------------------------
--------------------------------------------+---
GET @SESSIONCOUNTS(0);                     | 1
CALL CREATE_EMPLOYEE('111'); | 2
GET @SESSIONCOUNTS(0);                     | 3
TABLECALLS = @SESSIONCOUNTS.TABLECALLDELTA;| 4

 
This obtains the count of table calls done between the GETs on @SESSIONCOUNTS. Since CREATE_EMPLOYEE is the only process called in between, this gives the count.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved