APPSTAT
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 DB2ssid ENTRIES is issued, the informational message BMC23120 is displayed in the format:
Dynamic=<2>, Ineligible=<3>, Static=<4>
Monitored=<5>, Bypassed=<6>, Rate=<7>
Where:
- <1> = Number of statement reduction entries for the current interval
- <2> = Number of dynamic statement executions
- <3> = Number of static statement executions of a statement type not eligible for Efficient
Statement processing. These include fetches, commits and rollbacks - <4> = Number of static statement executions eligible for Efficient Statement processing.
- <5> = Number of static statement executions eligible for Efficient Statement processing,
and were fully monitored - <6> = Number of static statement executions where monitoring was bypassed due to
Efficient Statement processing - <7> = The percentage of static statement executions eligible for Efficient Statement
processing that were fully monitored.
The following figure shows the output of the APPSTAT command for a single Db2 subsystem.
BMC23042 D02A MODE=A BASELINE ENTRIES=N/A COMMIT/ROLLBACK DTL=Y
BMC23035 ADVANCED COLLECTION=ACTIVE ENTRIES= 0 FILTER=!BMCTEST
Next scheduled unload: 2022-09-27-11.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
Advanced Metrics. . . . 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 Collect Options Keys
Pgm,Plan,User,CorrID:DfltApp SkipTh ABCDE FG ABCDEFGHIJKLMNOPQR
============================ ====== ===== == ==================
*,DISTSERV,*,*: DISTSERV Y,N YYYYY YN YYYYYNYNNNNNNNYNNN
.
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 1000 E. Thread Cancels. . . . . N
Excp limit per stmt. 0 F. Multi excp per exec . . Y
G. CPU time type . . . . . A
BMC23069 Additional rows Warning Thresholds/Efficient Stmt
Pgm,Plan,User,CorrID Lim Elapsed CPU GPs SIOs ABCDEFG/Count
========================= ==== ======= ======= ===== ===== =======/=====
*,DISTSERV,*,* 0 0 0 0 0 YYYNNYA/ 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 D02A 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 SQL error settings for Pgm=* Plan=* User=* CorrID=*
(Y=Yes, N=No, -=Negative only, I=Include codes, E=Exclude codes
Include + codes N
Fetch +100 . . . . N
Report Details . . Y
Report Limit . . . 17
WTO reported errs. N
Generate Exception Y
BMC23082 SQL error settings for additional rows
Pgm,Plan,User,Corrid Incl>0 F Report Lim WTO Exception
========================= ========= = ========= === ========= =========
*,DISTSERV,*,* N N Y 17 N Y
.
BMC24321 D02A Command completed RC=0000 "APPSTAT DMC2"
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).