This section describes the tools provided with Adabas Fastpath.
The Adabas Fastpath command analysis sampler (AFPLOOK) can be used to determine which database commands have the most potential for Adabas Fastpath optimization.
The following are examples of AFPLOOK output.
The first screen shows the overall potential optimization for database 50:
12:33:10 ***** A D A B A S FASTPATH SERVICES 8.1.1 ***** 2006-05-19
- Afplook - Summary for DB 50 - F16300MA
Afplook Started May 19, 2006 at 12:30 by UKDEV1
----------------------- Potential Optimization Summary -----------------------
Sampled Commands Potential Optimization
Sampled File Commands 57960 (75%) <=== Sequential: 2797 ( 5%)
Direct Access: 30597 (53%)
RCs: 22194 (38%)
Excluded Commands 19115 (25%)
Totals 77075 (100%) 55588 (72%)
------------------------------------------------------------------------------
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Refr File More Menu |
The second screen shows the potential optimization for all files in database 50:
12:31:26 ***** A D A B A S FASTPATH SERVICES 8.1.1 ***** 2006-05-19
Afplook - Files Summary for DB 50 F16200MA
Started: May 19,2006 at: 12:30 by: UKDEV1
C Fnr Total Direct Access RCs Sequential
_ 50 3282 ( 3%) 1641 (50%) 1641 (50%)
_ 52 2428 ( 2%) 1214 (50%) 1214 (50%)
_ 53 3144 ( 3%) 1564 (50%) 1564 (50%)
_ 55 1644 ( 1%) 822 (50%) 822 (50%)
_ 64 821 ( 1%) 821
_ 87 1640 ( 1%) 820 (50%) 820 (50%)
_ 135 12432 (10%) 7102 (57%) 5330 (43%)
X 137 51540 (43%) 28455 (55%) 16876 (33%) 3547 ( 7%)
_ 139 5324 ( 4%) 2662 (50%) 2662 (50%)
_ 143 19514 (16%) 8870 (45%) 7983 (41%) 1774 ( 9%)
_ 144 3551 ( 3%) 1776 (50%) 1775 (50%)
_ 191 3226 ( 3%) 1378 (43%) 908 (28%) 470 (15%)
_ 250 9432 ( 8%) 5623 (60%) 3809 (40%)
Total 122202 (100%)
Mark to Display File Details
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Refr Sumry |
The third screen shows the optimization potential for file 137 in database 50.
12:32:21 ***** A D A B A S FASTPATH SERVICES 8.1.1 ***** 2006-05-19
- Afplook - Details for DB 50 File 137 - F16210MA
Started: May 19,2006 at: 12:30 by: UKDEV1
CC DE Direct Acc RCs Sequential Sequences Non-Qualifying
L3 S5 23902 20508 6752 394 Updates 32
S1 S5 54584 27093 Inserts 0
L3 S1 23670 16889 6781 6781 Deletes 0
L1 -- 6748
L9 TA 13032 13032 Prefetch 0
L9 S5 9326 16478 7896 Excluded 32
Spare 0
No CID 0
Max.CIDs 0
Bad Rsp. 0
Max.Rec.Buff.Len
Total 131262 77522 30011 Direct Acc 69
Total Commands for File 253970 Sequential 63
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Refr Parms File Menu |
For more information, see the section AFPLOOK.
Adabas Fastpath Online Services (SYSAFP) provides a wide variety of online operational and administrative services.
The following services are provided:
| Service | Description |
|---|---|
| System Settings | Maintain Adabas Fastpath configuration file. |
| Parameter Maintenance | Define/maintain Adabas Fastpath parameters. |
| Buffer Statistics | Display Adabas Fastpath buffer information. |
| Buffer History | Display Adabas Fastpath buffer history information. |
| Printing | Print Adabas Fastpath reports. |
| Special Services | Perform miscellaneous actions for the Adabas Fastpath components. |
| Online Sampling (APFLOOK) | Perform optimization sampling. |
| About Adabas Fastpath | Display Adabas Fastpath release information. |
For more information, see section SYSAFP.
The tool AFPCMD provides operating and reporting functions for the Adabas Fastpath buffer. AFPCMD can be invoked online using Adabas Fastpath Online Services or it can be invoked using Natural in batch mode.
For more information, see section AFPCMD.
