Transcript Features - Treehouse Software

TRIM
A PERFORMANCE MONITOR
FOR ADABAS AND NATURAL
TRIM is a product of Treehouse Software, Inc.
All rights reserved.
1
TRIM Product Overview
• Performance and Tuning for ADABAS and
NATURAL Installations
• Menu-driven Real-time Monitor
• Menu-driven NATURAL Monitor
• Parameter driven control and reporting
features
• Over 300 sites worldwide use TRIM
• Assists:
- DBAs
- Data Analysts
- Application Programmers
2
Features
• Real-Time Monitor
– Current Database Activity
- past 5 minutes, past 5 hours
- by CMD, THD, NAT, UID, JOB, etc.
– Nucleus Session Totals
- by FNR, CMD, CMD within FNR, THD, UID, etc.
- commands of longest Duration
– Tracing ADABAS Calls by UID, NAT, FNR, etc.
3
Features
• Real-Time Monitor (continued)
– Nucleus Parameters and Statistics
– “On-line ADAREP”
– Queue and Table Analysis
- UQ, HQ, CQ, TSC, TSR, IFB
- Extended User Queue (XUQ) lookup by FNR, NAT,
NSA, NSU
- Queue high users, highest activity
4
Features
06-12-31
MFNR
Commands Per Minute By ADABAS File Number
227
14:24:15
FNR
14:24
FNR
14:23
FNR
14:22
FNR
14:21
FNR
14:20
0
3
0
53
0
77
1
34
0
17
1
13
1
50
1
17
4
14
1
23
7
12
8
291
8
434
8
228
4
16
8
51
9
115
9
129
9
126
8
141
9
17
13
248
13
253
10
108
9
32
10
1
50
12
14
13
13
440
13
341
13
44
51
28
31
299
21
351
31
200
31
3
52
8
50
2
77
339
93
6
50
7
53
2
51
12
95
92
51
188
54
2
52
2
52
3
55
2
53
1
53
1
56
4
54
54
54
1
57
2
55
1
55
1
58
14
56
2
56
2
59
2
57
1
57
1
77
6060
58
7
58
7
78
454
59
1
59
1
123
77
77
1891
OTHER=> 4770
OTHER=>
330
********4956
******** 7423
******** 3473
******** 1710
********
868
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12-HELP
END
EXIT
TRIM Real-Time Monitor Commands Per Minute Screen
5
Features
06-12-31
SCWF
Session Totals By CMD within FNR 123
227
14:29:36
TEST-DATABASE
CMD
COUNT
PCT/FILE
----- -------- -------L1/4
12
4.18
L2/5
23
8.01
L3/6
227
79.09
L7/9
2
0.70
S1/4
1
0.35
S2/9
0
0.00
S8
0
0.00
RC
7
2.44
PCT/TOTAL
--------0.9
1.7
16.5
0.2
0.1
0.0
0.0
0.5
CMD
COUNT
PCT/FILE
----- -------- -------A1/4
3
1.05
N1/2
0
0.00
E1/4
0
0.00
ET
7
2.44
BT
2
0.70
OP
1
0.35
CL
0
0.00
MISC
2
0.70
Total Commands - File 123 : 287
Total Commands - Session
PCT/TOTAL
--------0.2
0.0
0.0
0.6
0.2
0.1
0.0
0.1
(20.9% Of Total)
: 1374
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12-HELP
END
EXIT
TRIM Real-Time Monitor Command Totals by File Screen
6
Features
TRIM Provides Control!
"We use TRIM's Real-time Monitor to check performance on our
four databases. It lets us see which programs and which files are
used the most, and which users are accessing the system the
most. With that information, we can then tune our system to run
those programs with maximum efficiency. And, if a program is
updated or accidentally purged, for example, we can use TRIM to
read the ADABAS Protection Logs directly to find out who did it,
when, and from what terminal. We use TRIM daily - it helps to keep
us in control.”
Allen Lamb, Senior Data Base Analyst
Alton Ochsner Medical Foundation
New Orleans, Louisiana
7
Features
• TRIM NATURAL Monitor (TNM)
– Monitors NATURAL activity
– Collects comprehensive user and program
information
– Helps to identify production performance problems
8
Features
06-12-31
11:38:00
TRIM NATURAL MONITOR
Program Percentage Summary
Starting Library/Program:
PAYTEST/
PGM1
USER24
LUMLIB
Page 1
Date: 01-12-31
Reposition Library/Program: ________ / ________
---- Percentage ----Pgm
ADA
--------------- Total -------------Library Program Runtime
Exec Calls
Runtime
Pgm Exec
ADA Calls
-------- -------- ------- ----- -------------- ----------- ----------PAYTEST PGM1
44.8
6.0
52.0
00:00:55.5
7
809
PAYTEST PGM3
0.7
7.7
0.0
00:00:00.9
9
0
PAYTEST PGM4
4.1
3.4
4.1
00:00:05.0
4
64
PAYTEST PGM5
6.5
4.3
3.1
00:00:08.0
5
49
PAYTEST PGM6
0.8
0.9
0.4
00:00:01.0
1
7
PAYTEST PGM7
5.7
2.6
6.4
00:00:07.0
3
99
PAYTEST PGM9
11.4
25.6
9.2
00:00:14.0
30
144
PAYTEST PRO1
0.7
6.8
2.1
00:00:00.8
8
32
PAYTEST PRO3
0.4
4.3
1.3
00:00:00.5
5
20
------------------------------------------------------------------------------Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--HELP PARM END
UP
DOWN
LEFT RIGHT EXIT
---- High Run ----User-ID
Runtime
-------- ---------USER17
00:00:33.0
USER17
00:00:00.1
USER24
00:00:02.0
USER12
00:00:02.0
USER23
00:00:01.0
USER23
00:00:04.0
USER22
00:00:02.0
USER24
00:00:00.1
USER24
00:00:00.1
--- Cataloged --Date
Time
-------- -------01-12-30 17:29:53
01-12-07 17:06:24
01-12-07 17:06:29
01-12-07 17:06:34
01-12-07 17:30:03
01-12-07 17:30:12
01-12-07 17:30:40
01-12-14 11:24:05
01-12-07 17:32:26
TNM Program Percentage Summary Report
9
Features
06-12-31
11:38:00
TRIM NATURAL MONITOR
User Trace Report
User-ID: USER17
Starting Date: 01-12-20
Combine Database Calls: Y
USER24
LUMLIB
Page 1
Starting Time: 14:25:46.8
Event
Time
Elapsed Time Response Time Library Program Line
-------------- ---------- ------------- ------------- -------- -------- ---TERMINAL I/O
14:25:46.8
PAYTEST MAP1
0012
PROGRAM END
14:25:47.2 00:00:01.4963
PAYTEST MAP1
<< 1 ADABAS CALL >>
00:00:00.0283
PAYTEST PGMRUN1 0150
PROGRAM START 14:25:47.2
PAYTEST PGMST5
<<493 ADABAS CALLS >>
00:00:07.0573
PAYTEST PGMST5
0140
<< 1 ADABAS CALL >>
00:00:00.0000
PAYTEST PGMST5
0240
<< 1 ADABAS CALL >>
00:00:00.0000
PAYTEST PGMST5
031
PROGRAM START 14:25:54.5
00:00:07.7330 PAYTEST MAPR7
TERMINAL I/O
14:26:00.5
PAYTEST MAPR7
0220
PROGRAM END
14:26:06.5 00:00:12.0488
PAYTEST MAPR7
PROGRAM END
14:26:07.1 00:00:19.9461
PAYTEST PGMST5
-----------------------------------------------------------------------------Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--HELP PARM END
UP
DOWN
LEFT RIGHT EXIT
ADA
CMD
---
RC
L3
L3
RC
ADABAS
DB/File Date
-------- -------01-12-20
01-12-20
2
0
01-12-20
01-12-20
1
52 01-12-20
2
231 01-12-20
2
231 01-12-20
01-12-20
01-12-20
01-12-20
01-12-20
TNM User Trace Report
10
Features
• Batch Slowdown - Enables the site to slow
down certain batch jobs to improve on-line
response times.
• Performance Control and Security - Dynamic
Control and Security facility
– disallows inefficient commands
– locks out file access
– plugs ADABAS passwords
– performs security checks.
11
Features
• Command and Protection Log Processing batch facilities for processing ADABAS
Command and Protection Logs.
– Flat files or hardcopy output to assist in
performance tuning, chargeback, and capacity
planning.
• Reduction of Command Log Data
– TRIM Dynamic Logging for detailed, selective
logging
– TRIM PRESUM facility condenses Command Log
data by pre-summarizing it in an ADABAS user-exit.
12
Features
TRIM Offers Insight!
"TRIM gives us insight into what's happening in a real-time
mode. And that kind of CONTROL is important because it
lets us react to problems before they're even reported to us!
With TRIM, we can track down problem programs and
monitor response codes on-line, plus the batch reporting
capability is great for review the following day.”
Mark Melichar, Database Administrator
Blood Systems, Inc.
Scottsdale, Arizona
13
Features
• tRelational Support (tRELOG)
– tRelational is TSI's ADABAS-to-RDBMS data analysis
and migration package
– tRELOG provides tRelational with information about
ADABAS data usage
– Monitors activity against specific ADABAS files to
identify:
• Which descriptors were used on each file during
the monitoring period
• How often each descriptor was used
• The volume of update versus retrieval activity for
each file
– Can assist in ADABAS tuning efforts
14
TRIM Utilizes
• User-Exit-B, User-Exit-A: Before and After exits
to ADALINK routines
• User-Exit-1: Before ADABAS processes the
command
• User-Exit-4: After command processing
• Command Log: Formerly one record per
ADABAS command
• Protection Log: Before and After Images of each
updated record
• NATURAL Exits
• SYSRDC
• ADABAS file for TNM
• PRESUM to SMF option
15
Environment Information
ADABAS
•
Dates, important files
•
Addresses of Modules, Queues and Tables
TRIM
•
User-Exit-B combinations, Batch slowdown parameters
•
User-Exit-1 Communication Runs, Parameters, number of
Disallows, Locks, Fails
•
User-Exit-4 Communication Runs, Parameters, Detail and
PRESUM Logging Counts
16
TRIM Summary
•
•
•
•
Mature Product, still growing
Simple to use, but powerful and efficient
Installation in less than one hour
Supports ADABAS 8.2, and the latest
NATURAL versions
• Large, active customer base
• International affiliates
17
18