OVERVIEW TRIM, a robust performance monitor for ADABAS and NATURAL from Treehouse Software, Inc. (TSI), includes a Real-time Monitor that provides hundreds of statistics on-line, in real-time to quickly find and eliminate performance problems.
If you are still wondering if TRIM is the right choice for you, check out the following quotes from TSI customers. The reliable, effective, and efficient performance of TRIM can be seen in these comments even though they date back several years. Today, TRIM monitors ADABAS performance at more than 300 sites worldwide and offers even more user-friendly features.
FIND OUT WHAT OUR CUSTOMERS HAVE TO SAY ABOUT TRIM:
TRIM SOLVES ADABAS CHARGEBACK PROBLEMS!
The following quote appeared in the November 9, 1987 issue of InformationWEEK magazine:
"Following up on our early-summer request for ADABAS DBMS chargeback/usage information, your readers should know we solved our problem by using the product TRIM (from Treehouse Software, Sewickley, PA) to capture the data. We then process the data to calculate the "environment-correction factor," and append the Power/VSE User-Id to the data.With our approach, we are able to create a daily ADABAS-usage dataset in three minutes."John S. Rusnak
Wm. Wrigley Jr. Co.
Chicago, IL
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
TRIM HELPS WITH MAINTENENCE!
"One TRIM feature that's very useful is the user queue. Since we run our system virtually 24 hours a day, we have just one regularly scheduled window per month to perform major maintenance to ADABAS and NATURAL. However, in order to keep our software current, we like to apply maintenance more frequently to our development and test environments. We use TRIM to tell us how many users are signed on and what TP monitor they are using. We can then let them know what we plan to do, and either have them switch to another TP monitor or defer the maintenance. This helps us maintain a positive working relationship with the development staff."Roger Walker
Canadian Utilities Limited
Edmonton, Alberta, Canada
TRIM SOLVES PROBLEMS FASTER!
"TRIM's Trace Facility allows us to investigate and resolve problems faster during application development and quality assurance testing. This helps us guarantee a quality production environment."Brent Knudslien, Systems Programmer
Canadian Utilities Limited
Edmonton, Alberta, Canada
TRIM PAYS FOR ITSELF!
"We bought TRIM in 1984, and amortized the purchase price within just eighteen days! Although we now use TRIM to address many needs, our original purpose in getting it was to simplify our handling of the Command Log for troubleshooting. Whereas we used to log every command, now TRIM lets us select which commands we want to log and takes care of that process automatically, plus we can turn the logging on and off, as needed. We credit TRIM with enabling us to get our dual disk Command Logs down from 200 cylinders to just three, so it has saved us a great deal of disk space."We use TRIM's ADABAS User-Exit-1 to create rules to monitor who can and cannot use each of our databases, and TRIM lets us change those rules on an ad hoc basis. We use it, for instance, to keep test CICS users out of production databases. We can specify that we will accept commands only from this job or that job, which prevents people from running test and maintenance jobs in our production databases when they shouldn't. People are always trying to take shortcuts, so TRIM helps us keep them on the straight and narrow."Keith Newsom, Senior Database Management System Specialist
State of Washington
Department of Information Services
Olympia, Washington
TRIM SAVES WORK!
"Quite often, one of our users will unintentionally bog down our entire system by running a NATURAL program or a batch job that uses too many resources and hits the system too hard. That's when we use TRIM - it helps us to identify the job or the user, and then we can cancel the job if it's batch or terminate the transaction if it's on-line. We simply cannot have one user causing a poor response time for many users, and TRIM helps us to stay on top of that."We also use TRIM's statistical reporting feature quite often. It's fast and flexible, plus it's extremely easy to code new programs. The on-line system is good, too. It's all pre-coded, and there are many different bits of important information available right there on the screen. Without TRIM, we would have to get this information by tracking around to many different places. With TRIM, it's not much work at all."Doug Kirkland, Database Administrator
Public Service Commission of Canada
Ottawa, Ontario, Canada
TRIM IMPROVES RESPONSE TIME!
"For the past several years, we have had a thoroughly saturated CPU - especially during our student registration process, which occurs four times a year. So anything we can do to reduce end-user response time is very important to us. Using TRIM, we are able to identify any abusive applications - not abusive because they were designed that way, but because of oversights in their design - plus TRIM lets us monitor specific applications or terminals on the fly, so to speak. By identifying problem applications, we can then reduce the number of calls to ADABAS, and therefore improve our response time."Randy Franek, Database Administrator
University of North Texas
Denton, Texas
TRIM CUTS UNNECESSARY OVERHEAD!
"Our on-line response time is very important, so any time there's unnecessary overhead, we want to cut it down - and we use TRIM to do that. It lets us look at the guts of ADABAS to see what's going on - such as finding a CICS transaction that's executing in five seconds when it should only be taking one-half second. Finding those savings is very important to us."Using TRIM, I can go into our system and look at actual ADABAS commands that are being executed. Some commands are better to use than others [are], especially on-line, and TRIM lets us monitor them to make sure we are using the proper commands. If, for example, we are using a FIND when we should be using a READ, TRIM makes that easy to determine and to correct."There are lots of TRIM features I like, and that's just one of them. Another is the extra information TRIM adds to the end of our ADABAS reports that shows us the commands by programs, plus much more information that's interesting to review and analyze. We're very impressed with TRIM - we use it every day and have come to take it for granted."Bill Blasingim, Technical Support Analyst
SafeCard Services, Inc.
Fort Lauderdale, Florida
TRIM PROVIDES EASY TO USE FEATURES!
"Using TRIM to look around our system on-line, any bottlenecks are immediately visible. If there are any performance problems during the day, I can use TRIM, for example, to spot a problem with a NATURAL program or to determine if we have too many batch jobs running. And I can use TRIM to run a batch job at night that will tell me which terminals were in use for a specific period of time, what programs were running, what resources were being used, and whether response times were too high."I especially like the way TRIM lets me change the logging criteria dynamically without bringing the database up and down. If we do see something going on, we can log every command or all parts of a command coming from a terminal that we think is causing a problem."There are many features in TRIM, and they are all easy to use and easy to understand."Bill Gohs, Database Administrator
National Education Corporation
Naperville, Illinois
TRIM MEETS PERFORMANCE DEMANDS!
"TRIM helps us to determine if we have applications that are not performing up to our standards. It allows us to pinpoint those problems and resolve them. With 11 copies of ADABAS - including several files between 13 and 15 million records - we have high demands for performance, and TRIM helps to meet those demands."Ted Moore, Database Administrator
Blue Cross/Blue Shield of Oregon
Portland, Oregon
TRIM SAVES TIME AND EFFORT!
"We use TRIM heavily in our daily runs to produce job accounting information, as well as to highlight areas of performance difficulties. Besides getting daily data, we recently used TRIM to gather information on every on-line function and batch job run in our entire system during one particular month. Then we sorted that information according to the amount of time each one used, and then we picked the top five worst jobs - those which used the most time. We looked carefully at each of them to determine why they were using so much time and so many resources. From detailed TRIM reports, we could also review the kinds and numbers of commands issued for each function. With that analysis in hand, we were then able to streamline the applications, and we ultimately produced a savings of 72 hours per month in ADABAS time! Some jobs that were taking two hours now take five minutes. Without TRIM, the job would have been significantly more difficult."Byron Nate, DBA Planning Coordinator
UNOCAL Canada Limited
Calgary, Alberta, Canada
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
