PROFILER for NATURAL PROFILER is a product of

PROFILER for NATURAL PROFILER is a product of Treehouse Software, Inc. All rights reserved. 1

Introducing PROFILER § Quality Assurance and Testing Tool for developing/improving NATURAL objects and applications § Monitors the execution of each statement within a “running” NATURAL object § Comprehensive and flexible reporting § New easy-to-use "tool-like" user interface 2

Introducing PROFILER § Can be run in background with or without the knowledge of the user § Only impacts the user who has started PROFILER § Negligible overhead to NATURAL § Works with NATURAL V 3. 1. x, and V 4. 1. x § ADABAS V 6. x, and V 7. x compatible 3

Uses for PROFILER. . . § Quality Assurance § Identify untested code § Identify the percentage of an application tested § Testing § Find weaknesses in test data and procedures § Debugging § Find which statements are actually being executed, how often, and at what cost 4

Uses for PROFILER. . . § Performance Analysis § Identify expensive database accesses § Identify problem code, inefficient code, and poor application/object design § Evaluation § Assess the impact of application or database changes 5

Uses for PROFILER. . . § Education § Gain insight into NATURAL’s internals § Evaluate NATURAL statement efficiency § Learn how an application works § Application Analysis § Visual aid to verify application and programmatic flow 6

How does PROFILER work? § Runs behind the scenes (invisible) § Monitors each line of NATURAL code as it executes and measures. . . - resource usage (CPU) for each statement - “round-trip” time for each database call - program/instruction iteration § Saves collected statistics to an ADABAS file (either a separate stats file, or FUSER) 7

How does PROFILER work? § Collects statistics (on-line or in batch) for: § A NATURAL library or range of libraries § A NATURAL object or range of objects § One, many, or all NATURAL object types § Many statement types within each NATURAL object (e. g. FOR/REPEAT loops) § Can be started explicitly by a user, or automatically whenever a user enters NATURAL (called ‘background mode’) 8

How does PROFILER work? § Interfaces with NATURAL V 2. 3 or later ‘Review Data Collector’ interface § Provides on-line and batch reports § Allows users to develop their own customized reports to suit their needs 9

How does PROFILER work? . NATURAL PROFILER Standard Reporting Standard Reports PROFILER Statistics DATABASE PROFILER stats file (FUSER) PROFILER Enhanced Reporting Custom Reports Report File 10

The User Interface for PROFILER § Works like a tool; not an application § Easy to use “list/action” style § Minimum number of panels to navigate § Intuitive design § Remembers where you were 11

The User Interface. . . Intuitive design with simple commands makes it a snap to use. 12

The User Interface. . . Defining a new session is as easy as pressing PF 9. 13

The User Interface. . . Activating a Profile Session is this simple. 14

The User Interface. . . Most features are accessed directly from the main menu. 15

Online Reports for PROFILER Simple commands/PF keys to easily change reporting format. 16

Online Reports for PROFILER Format and order easily configured by PF key or command. 17

Online Reports for PROFILER Graphic display of percent of module executed. 18

Online Reports for PROFILER Indicator of statements not executed. 19

Online Reports for PROFILER Highlighting of ADABAS call duration. 20

Online Reports for PROFILER Example of ‘Trace’ Report (and new ‘Text Scan’ feature). 21

Online Reports for PROFILER Detailed analysis of unexecuted objects in an application library. 22

Online Reports for PROFILER Further analyze/divide executed objects by applying threshold criteria. 23

Enhanced Reporting in PROFILER Tag Profile statistics for move to the Enhanced Reporting file. 24

Enhanced Reporting in PROFILER Use PF 5 (E-Rep) to access the Enhanced Reporting facility. 25

Enhanced Reporting in PROFILER Use PF 9 (New-P) to define a new Report Parameter Set. 26

Enhanced Reporting in PROFILER Report Parameters can group Profile statistics for many users. 27

Enhanced Reporting in PROFILER Report Parameters can group Profile statistics for many users. 28

Enhanced Reporting in PROFILER Report Parameters can group Profile statistics for many sessions. 29

Enhanced Reporting in PROFILER Report Parameters can group Profile statistics for many sessions. 30

Enhanced Reporting in PROFILER Simple commands for maintenance and reporting. 31

Enhanced Reporting in PROFILER Use the help menus to invoke an enhanced summary report. 32

Enhanced Reporting in PROFILER Or use a direct command to invoke an enhanced summary report. 33

Enhanced Reporting in PROFILER The Enhanced Summary Report shows grouped statistics. 34

PROFILER in Summary. . . § Quality Assurance and Testing Tool for NATURAL § Assists in: § QA Analysis § Testing § Performance Tuning § Debugging § Education and Evaluation 35

PROFILER in Summary. . . § Only impacts the PROFILER active user § Collects detailed statistics § Comprehensive set of reporting features § Easy to install and use § Operating Environments. . . § z/OS, OS/390 (TSO, Batch, CICS, COM-PLETE, NATURAL 4. 1. x, 3. 1. x, 2. 3. x, 2. 2. 8, ADABAS, VSAM, DB 2) 36

37