APPSTAT
APPSTAT is a Data Collector command that you can issue from the command text area of the Data Collector Command Interface panel (DOMECMDA) or from the system operator console.
APPSTAT is used to display the current status of the intercept, including:
- One or all active Db2s defined to the specified Data Collector
- Status of data collection
- Types of data being collected
- Exception values
- Resource-saving options
Syntax of the APPSTAT command
Parameter | Description |
|---|---|
DCssid | The subsystem ID of the Data Collector for which the status is being reported. Use this parameter only when issuing the command from the console. When the command is issued from the Data Collector Command Interface panel, it applies automatically to the currently selected Data Collector. |
DB2ssid | Specify a Db2 subsystem ID to display statistics for only that Db2 subsystem. When Db2ssid is omitted, the product displays statistics for all active Db2 subsystems defined to the specified Data Collector. |
ENTRIES | Number of statement reduction entries for the current interval |
plan | Plan name |
pgm | Package name |
After APPSTAT is issued, the informational message BMC13120 is displayed in the format:
Calls=<2>, Excptions=<3>, Efficiency Filtered=<4>
Where:
- <1> = Number of statement reduction entries for the current interval
- <2> = Number of monitored calls or extrapolated number of calls if you have selected the Sampling with Extrapolation option
- <3> = Number of exceptions
- <4> = Number of SQL calls that were bypassed for monitoring if you enabled the Efficiency Filtering option
The following figure shows the output of the APPSTAT command for a single Db2 subsystem.
BMC23042 A121 MODE=A BASELINE ENTRIES=N/A COMMIT/ROLLBACK DTL=Y
BMC23035 COLLECTION=ACTIVE ENTRIES= 0 FILTER=!BMCTEST
Next scheduled unload: 2016-08-25-00.00.00
BMC23071 Option and key settings for Pgm=* Plan=* User=* CorrID=*
(Y=Yes, N=No, S=Static, D=Dynamic)
Default Application . . . DEFAULT
Collect/Bypass Options Collection Keys
Monitor SQL . . . . . . Y A. Program name. . . . . . Y
Skip for thread . . . . N B. Plan name . . . . . . . Y
C. User ID . . . . . . . . Y
Collection Options D. Correlation ID . . . . Y
A. Buffer pool data . . Y E. Collection ID . . . . . Y
B. Lock data. . . . . . Y F. Connection ID . . . . . N
C. SQL text data. . . . Y G. Consistency token . . . Y
D. SQL statement counts Y H. Client application. . . N
E. Object data. . . . . Y I. Client user id. . . . . N
J. Client workstation. . . N
Resource-Saving Options K. Client accounting . . . N
F. Ignore dynamic L. Client corr token . . . N
SQL text literals. . Y M. Requesting location . . N
G. Sample data N. Implicit qualifier. . . N
with extrapolation . N O. Connection type . . . . Y
P. Section number. . . . . Y
Q. Statement number. . . . Y
R. Dynamic SQL Detail. . . N
BMC23038 Additional rows Adv, Options Keys
Pgm,Plan,User,CorrID:DfltApp SkipTh ABCDE FG ABCDEFGHIJKLMNOPQR
============================ ====== ===== == ==================
*,DISTSERV,*,*: DISTSERV Y,N YYYYY YN YYYYYNYNNNNNNNYNNN
*,*,*,*: DEFAULT Y,N YYYYY YN YYYYYNYNNNNNNNYYYN
.
BMC23073 Exception settings for Pgm=* Plan=* User=* CorrID=*
Elapsed time. . . 0 msec A. Deadlocks . . . . . . . Y
CPU time. . . . . 0 msec B. Timeouts. . . . . . . . Y
Getpage requests. . 0 C. Show host variables . . Y
Synchronous I/Os. . 0 D. Issue Exception WTOs. . N
Efficient Stmt Count 0 E. Thread Cancels. . . . . N
BMC23069 Additional rows Warning Thresholds/Efficient Stmt
Pgm,Plan,User,CorrID Elapsed CPU GPs SIOs ABCD/Count
============================ ======= ======= ===== ===== ====/=====
*,DISTSERV,*,* 0 0 0 0 YYYN/ 1000
.
BMC23134 Critical/Efficient Thresholds Pgm=* Plan=* User=* CorrID=*
Elapsed time. . . 0 msec / Efficient
CPU time. . . . . 0 msec / CPU time . . . . . 1000 usec
Getpage requests. . 0 / Getpage requests 10
Synchronous I/Os. . 0 / Synchronous I/Os 3
BMC23092 NC1J Additional rows Critical Thresholds/Efficient Stmt
Pgm,Plan,User,CorrID Elapsed CPU GPs SIOs/ CPU GPs SIOs
============================ ======= ======= ===== =====/===== === ====
*,DISTSERV,*,* 0 0 0 0/ 1000 10 3
.
BMC23075 Negative SQL code settings for Pgm=* Plan=* User=* CorrID=*
(Y=Yes, N=No, I=Include codes, E=Exclude codes)
Generate Exception Y
Capture Detail . . Y
Issue WTO. . . . . N
BMC23082 Negative SQL code settings for additional rows
Pgm,Plan,User,Corrid Exception Detail WTO
========================== ============== ============== ==============
*,DISTSERV,*,* Y Y N
.
BMC24321 NC1J Command completed RC=0000 'APPSTAT DLYC'
You can find information about issuing commands from the Data Collector Command Interface panel in online Help (type HELP DOMECMDA).
For an explanation of the output of the APPSTAT command, see online Help for message BMC23018 (type HELP BMC23018).
Related topic