SAP ABAP Program SAPLSDB2CCMS_ANALYSIS (SAPLSDB2CCMS_ANALYSIS)
Basic Data
Program SAPLSDB2CCMS_ANALYSIS  
Program Type F Function group  
Attributes
Status    
Application S Basis  
Authorization Group  
Logical database D$S Processing without database  
Selection screen  
Editor lock Fixed point arithmetic  
Unicode checks active Start using variant  
Function Group
Include Function Module Short Description Mode
01   DB2_CALL_ANALYSIS_SCREEN   Displays the sceens for the analysis panel    
       
Transaction Code
Transactions reference to this program
# Transaction Code Short Description
1 DB2 DB2 z/OS: Select Database Activities 
2 DB2SYSPARM DB2: System Parameters 
     
Screens
# Screen Short Description
1 0100  Database Analysis: System-Wide Parameters 
2 0115  Database Analysis: Subscreen 
3 0200  Database Analysis: Buffer Pool List 
4 0201  Database Analysis: Buffer Pool Activity 
5 0205  Database Analysis: Buffer Pool (General Information) 
6 0206  Database Analysis: Buffer Pool (Read Operations) 
7 0207  Database Analysis: Buffer Pool (Write Operations) 
8 0208  Database Analysis: Buffer Pool (Query Parallelism) 
9 0209  Database Analysis: Buffer Pool (Sort/Merge Operations) 
10 0210  Database Analysis: Locking Activity 
11 0220  Database Analysis: Logging Activity 
12 0230  Database Analysis: EDM Pool 
13 0235  Database Analysis: Dynamic Statement Cache 
14 0240  Database Analysis: Open/Close Activity 
15 0250  Database Analysis: Subsystem Services 
16 0260  Database Analysis: SQL Activity 
17 0262  Database Analysis: SQL Activity (DML Activity) 
18 0263  Database Analysis: SQL Activity (DCL Activity) 
19 0264  Database Analysis: SQL Activity (DDL Activity) 
20 0265  Database Analysis: SQL Activity (Stored Procedures Activity) 
21 0266  Database Analysis: SQL Activity (Triggers Activity) 
22 0267  Database Analysis: SQL Activity (User-Defined Functions) 
23 0268  Database Analysis: SQL Activity (Row ID Access Activity) 
24 0270  Database Analysis: Locking Conflicts 
25 0280  Database Analysis: RID List Processing 
26 0290  Database Analysis: Star join pool statistics 
27 0300  Database Analysis: Times 
28 0320  Database Analysis: Group Buffer Pool List 
29 0325  Database Analysis: Group Buffer Pool Details 
30 0326  Database Analysis: Group Buffer Pool (General Information) 
31 0327  Database Analysis: Group Buffer Pool (Read) 
32 0328  Database Analysis: Group Buffer Pool (Write) 
33 0329  Database Analysis: Group Buffer Pool (P-lock) 
34 0340  Database Analysis: Data Sharing Locking Activity 
35 0500  Thread Activity: Thread List 
36 0510  Thread Activity: Subscreen 
37 0515  Thread Activity: Subscreen 
38 0540  Thread Activity: Times 
39 0550  Thread Activity: Locking Activity 
40 0560  Thread Activity: SQL Activity 
41 0569  Thread Activity: SQL Activity (Statement Caching) 
42 0570  Thread Activity: SQL Statement 
43 0571  Thread Activity: SQL Activity (Miscellaneous) 
44 0580  Thread Activity: Locks Held 
45 0582  Thread locks: Retry mechanism 
46 0590  Thread Activity: Lock Waits 
47 0600  Thread Activity: Buffer Pool List 
48 0605  Thread Activity: Buffer Pool Activity 
49 0610  Thread Activity: Data Sharing Locking Activity 
50 0620  Thread Activity: Group Buffer Pool List 
51 0666  DBM1 virtual storage monitoring (DB2 IFCID 225) 
52 0700  DBM1 virtual storage monitoring - V10 (DB2 IFCID 225) 
53 0710  subscreen for screen 700 ( DBM1) - Adress Space 
54 0720  subscreen for screen 700 (DBM1) - More Details 
55 0800  DB2 for OS/390: Installation Parameters 
56 0805  DB2 for OS/390: Installation (Miscellaneous) 
57 0810  DB2 for OS/390: Installation (Log Parameters) 
58 0815  DB2 for OS/390: Installation (Locking, IRLM) 
59 0825  DB2 for OS/390: Installation (Data Sharing) 
60 0830  DB2 for OS/390:Installation (Protection and Data Definition) 
61 0835  DB2 for OS/390: Installation (Storage/Connections) 
62 0840  DB2 for OS/390: Installation (Appl. Prog. Defaults) 
63 0845  DB2 for OS/390: Installation (Trace) 
64 0850  DB2 for OS/390: Installation (Summary) 
65 0855  DB2 for OS/390: Installation (Buffer Pools) 
66 0860  DB2 for OS/390: Installation (DDF) 
67 0870  Flashcopy subscreen 
68 0900  DB6: Navigation Frame 
69 1000  Qualification Panel 
70 1100  DB2: Performance: Installation Parameters 
71 1110  subscreen for screen 1100 (Installation Parameters) 
72 1120  subscreen for screen 1100 (Installation Parameters) 
73 1130  subscreen for screen 1100 (Installation Parameters) 
74 1140  subscreen for screen 1100 (Installation Parameters) 
75 1200  DB2: Performance: Bufferpools 
76 1210  subscreen for screen 1200 (Bufferpools) 
77 1220  subscreen for screen 1200 (Bufferpools) 
78 1230  subscreen for screen 1200 (Bufferpools) 
79 1240  DB2: Performance: Bufferpools: Bufferpool Details 
80 1241  subscreen for screen 1240 (Bufferpool Details) 
81 1242  subscreen for screen 1240 (Bufferpool Details) 
82 1243  subscreen for screen 1240 (Bufferpool Details) 
83 1244  subscreen for screen 1240 (Bufferpool Details) 
84 1245  subscreen for screen 1240 (Bufferpool Details) 
85 1300  DB2: Performance: Group Bufferpools 
86 1310  subscreen for screen 1300 (Groupbufferpools) 
87 1320  subscreen for screen 1300 (Groupbufferpools) 
88 1340  DB2: Performance: Groupbufferpools: Details 
89 1341  subscreen for screen 1340 (Groupbufferpool Details) 
90 1342  subscreen for screen 1340 (Groupbufferpool Details) 
91 1343  subscreen for screen 1340 (Groupbufferpool Details) 
92 1344  Database Analysis: Group Buffer Pool (P-lock) 
93 1400  Table Search Window 
94 1500  Database Analysis: Subscreen 
95 1501  Subscreen: Header for statement cache history 
96 1502  Subscreen: Header for statement cache history 
97 1800  DB2: Performance: Global Times 
98 1810  DB2: Performance: Global Times: History 
99 1900  DB2:Performance_ Subsystem Activity: Workfiles 
100 2001  DSC Main Panel w/ ALV Grid 
101 3000  Detail Panel 
102 3100  Subscreen: Statement Text 
103 3200  Subscreen: Explain 
104 3300  Subscreen: Identification and Status 
105 3400  Subscreen: Average Time Distribution per Execution 
106 3500  Subscreen: Total Time Distribution Across All Executions 
107 3600  Subscreen: Average Statistics per Execution 
108 3700  Subscreen: Total Statistics Across All Executions 
109 4000   
110 4050  DSS Subscreen 
111 4060  DSS Second Subscreen 
112 4100  Qualification Panel 
113 4500  DSS Main Panel 
114 4600  DSS Detail Panel 
115 4610  Subscreen: Synchronous I/O 
116 4620  Subscreen: Asynchronous I/O 
117 4630  Subscreen: BP Cached Data 
     
GUI Status
# GUI Status Short Description
1 0270  System-wide lock waits 
2 0300  Times: Global 
3 0700  Virtual and Real Storage 
4 0701  IFI Data Collector trace 
5 0800  Installation Parameters 
6 0900  DB2/390 and OS/390 Commands: Command List 
7 0950  OS/390 Console: Time Period 
8 0960  OS/390 System Log 
9 0975  DBSL Trace 
10 0999  SAP Collector Settings 
11 1100  Installations Parameter 
12 1200  Bufferpools 
13 1300  GroupBufferpools 
14 1800  Global Times 
15 1810  Global Times History 
16 1900  Workfiles 
17 DETAILPANEL  Detail Panel 
18 FILTER  Filter for statement cache 
19 MAINPANEL  Main Panel 
20 MAINPANEL_DSS  DSS Main Panel 
21 QUALIFICATION_DSS  Filtering the Data Set Statistics 
22 RETRY  Thread locks held retry mechanism 
23 RETRY_STMT  Retry data 
24 SUSY  Database Activity - Detail Analysis 
25 THDL  Thread Activity: Thread List 
26 THRD  Thread Activity: Detail Analysis 
     
GUI Title
# GUI Title Short Description
1 050  DB2 for z/OS: Database Activity 
2 0700  Virtual and Real Storage 
3 100  DB2 for z/OS: Subsystem Activity 
4 1100  DB2 System Parameters 
5 1200  Bufferpools 
6 1300  Groupbufferpools 
7 1800  Global Times 
8 1810  Global Times - History 
9 1900  Workfiles 
10 200  DB2 for z/OS: Subsystem Act./ Buffer Pool List 
11 201  DB2 for z/OS: Subsystem Act./ Buffer Pool Activity(Detail) 
12 205  DB2 for z/OS: Subsystem Act./ Buffer Pool(General Infor.) 
13 206  DB2 for z/OS: Subsystem Act./ Buffer Pool(Read Operations) 
14 207  DB2 for z/OS: Subsystem Act./ Buffer Pool(Write Operations) 
15 208  DB2 for z/OS :Subsystem Act./ Buffer Pool(Query Parallelism) 
16 209  DB2 for z/OS: Subsystem Act./ Buffer Pool(Sort/Merge Opera.) 
17 210  DB2 for z/OS: Subsystem Act./ Locking Activity 
18 220  DB2 for z/OS: Subsystem Act./ Logging Activity 
19 230  DB2 for z/OS: Subsystem Act./ EDM Pools (packages, DSC, DBD) 
20 235  DB2 for z/OS: Subsystem Act./ Dynamic Statement Cache 
21 240  DB2 for z/OS: Subsystem Act./ Open/Close Activity 
22 250  DB2 for z/OS: Subsystem Act./ Subsystem Services 
23 260  DB2 for z/OS: Subsystem Act./ SQL Activity 
24 270  DB2 for z/OS: Subsystem Act./ Locking Conflicts 
25 280  DB2 for z/OS: Subsystem Act./ RID List Processing 
26 290  DB2 for z/OS: Subsystem Act./ Misc. Statistics 
27 300  DB2 for z/OS: Global Times 
28 320  DB2 for z/OS: Subsystem Act./ Group Buffer Pool 
29 325  DB2 for z/OS: Subsystem Act./ Group Buffer Pool (Detail) 
30 340  DB2 for z/OS: Subsystem Act./ Data Sharing Locking 
31 500  DB2 for z/OS: Thread Activity 
32 540  DB2 for z/OS: Thread Activity / Times 
33 550  DB2 for z/OS: Thread Activity / Locking Activity 
34 560  DB2 for z/OS: Thread Activity / SQL Activity 
35 570  DB2 for z/OS: Thread Activity / SQL Statement 
36 580  DB2 for z/OS: Thread Activity / Locked Resources 
37 582  DB2 for z/OS: Records to be fetched 
38 590  DB2 for z/OS: Thread Activity / Lock Waits 
39 600  DB2 for z/OS: Thread Activity / Buffer Pool Activity 
40 605  DB2 for z/OS: Thread Activity/ Buffer Pool Activity (Detail) 
41 610  DB2 for z/OS: Thread Activity/ Data Sharing Locking Activity 
42 620  DB2 for z/OS: Thread Activity / Group Buffer Pool 
43 666  DB2 for z/OS: Subsystem Act./DBM1 Virtual Storage Monitoring 
44 667  Virtual/Real Storage Monitoring for DBM1/DIST Address Spaces 
45 688  DB2 for z/OS: Data Set Statistics 
46 701  DB2 for z/OS: IFI DB Trace 
47 800  DB2 for z/OS: Installation Parameters 
48 900  DB2 for z/OS: Commands / Command List 
49 910  DB2 for z/OS: Commands / Change Command 
50 920  DB2 for z/OS: Commands / Display Command 
51 930  DB2 for z/OS: Commands / New Command 
52 950  DB2 for z/OS: z/OS System Log / Time Period 
53 960  DB2 for z/OS: z/OS System Log 
54 970  DB2 for z/OS: ICLI Diagnostics 
55 971  DB2 for z/OS: DB2 Connect Diagnostics 
56 972  DB2 for z/OS: DB2 Connect Network Statistics 
57 975  DB2 for z/OS: DBSL SQL Trace 
58 999  DB2 for z/OS: SAP Collector Settings 
59 DE1  DB2 for z/OS: Statement Cache Statistics / Details 1 
60 DE2  DB2 for z/OS: Statement Cache Statistics / Details 2 
61 DE3  DB2 for z/OS: Statement Cache Statistics / Details 3 
62 DE4  DB2 for z/OS: Statement Cache Statistics / Details 4 
63 DETAILPANEL  DB2 for z/OS: Statement Cache Statistics / Details 
64 DETAILPANEL_DSS  DB2 for z/OS: Data Set Statistics: Detail 
65 FIL  DB2 for z/OS: Filtering SQL Statements 
66 FIL_STAT  DB2 for z/OS: Filtering by Statistics Fields 
67 FIL_THR  DB2 for z/OS: Filtering by Statistics Fields with Threshold 
68 MAINPANEL  DB2 for z/OS: Statement Cache Statistics: Overview 
69 MAINPANEL_DSS  DB2 for z/OS: Data Set Statistics 
70 QUALIFICATION_DSS  DB2 for z/OS: Data Set Statistics/ Enter Filtering Criteria 
71 SCL  DB2 for z/OS: Statement Cache Statistics/ SQL Statement 
72 SPEC_FILTER  DB2 for z/OS: Cached Statements Statistics/ Specify a Filter 
73 STR_RETRY  DB2 for z/OS: Mount of retry data 
74 STR_SEARCH  DB2 for z/OS: Specify Strings to Search for 
     
History
Last changed by/on SAP  20070813 
SAP Release Created in