If the ADARUN CFILE parameter has been specified,
the File Level Main Menu appears when you select Caching Facility from the main
menu:
13:59:12 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
- File Level Main Menu - PCF0002
File Level
Code Function
---- -------------------------
D Define File Cache
F Files with Caching
M Maintain File Cache
O Maintain Cache Spaces
P Maintain Cache Parameters
S Cache Session Summary
? Help
. Exit
---- -------------------------
Code .......... _
DataBase ...... 1955 (WIS1955)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
The following functions are available:
| Code | Description |
|---|---|
| D | Define a new cache space for one or more files |
| F | Display detailed cache space statistics for a file |
| M | Enable, disable, or delete caching for one or more files |
| O | Enable, disable, or delete caching for the Work dataset |
| P | Display and modify current settings of ADARUN parameters |
| S | Display summary cache session statistics |
Notes:
CFILE parameter for each, it is not possible to do so
using Adabas Online System functions or operator commands. To define both
Associator and Data Storage caching for a file using Adabas Online System
functions or operator commands, you must use the BOTH option that uses the same
caching parameters for both.
CFILE parameter, Adabas Online System functions,
or operator commands, it is not possible to change the caching parameters
without first deleting the defined cache space and then adding a new cache
space with the different parameters. For example, if you have Data Storage
caching defined for a file and you want to add Associator caching, you must
first delete the Data Storage cache space and redefine caching for the file
using the BOTH option.
Selecting option D from the File Level Main Menu displays a menu of functions used to define a new cache space for one or more files:
13:32:45 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
- Define File Cache - PCFD002
File Level
Code Function
---- --------------------------
A Define Asso Cache
B Define Asso and Data Cache
D Define Data Cache
? Help
. Exit
---- --------------------------
Code .............. _
Memory Type ....... _
File Number ....... 0____ - _____
Class of Service .. _
Database .......... 1955 (WIS1955)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
| Field | Description |
|---|---|
| Code |
One or more files may be defined for Associator (option A), Data Storage (option D), or both (option B). No RABN ranges need to be specified: RABNs are added automatically. The file number may be any file within the database maximum files value. |
| Memory Type |
The memory type may be extended (E), data space (D), hiperspace (H), virtual 64 backed by large pages (L), or virtual 64 (V), depending on the operating system environment. |
| File Number | The file or file range for which caching is to be defined. |
| Class of Service |
The class of service. Possible values are:
|
Selecting option F from the File Level Main Menu displays a list of files that use caching:
13:37:48 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
DBID 1955 - Files with Caching - PCFF002
File Level
Sel File File Name Cache Type State
--- ----- ------------------------ ---------- --------------
0 Unassigned RABNs Asso/Data Not accessed
1 EMPLOYEES Asso/Data Active
2 VEHICLES Asso/Data Active
3 - 5 not loaded
6 EXPANDED Asso/Data Not accessed
7 EXPANDED Asso/Data Not accessed
8 - 9 not loaded
10 TRIGGER-FILE Asso/Data Not accessed
11 - 18 not loaded
19 CHECKPOINT Asso/Data Active
20 - 25 not loaded
Specify 'DI' (Display), EN (Enable) DE (Delete) or DS (Disable) for a file
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Repos Exit Refr -- + Menu |
Entering DI in the
Sel column for a file displays detailed cache
space statistics for that file.
The information displayed on the resulting Statistics screen is the same
as that provided by the CFSTAT
command.
13:41:59 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
DBID 1955 - Statistics - PCFF002
File Level
File 1 EMPLOYEES
Memory type ....... DSP
Cache component ... Data Class 1 (100%)
RABN range ........ DS Blks 271 - 320
Last activity ..... 2001-09-13 09:24:06
Cache status ...... ALLOCATED
Cache writes ...... 12579
Max. Cache used ... 231360 Elapsed time per Cache read request
Cache Size ........ 5118840 Max. ... 0.143685
Cache efficiency .. 99.6 % Min. ... 0.000002
Cache reads ....... 12547 Avg. ... 0.000029
Read EXCPS ........ 49
Total reads ....... 12596 EXCP Time (in microseconds)
RABN's in Cache ... 32 Max. ... 0.049367
RABN's/Cache Space. 1060 Min. ... 0.003509
RABN Index Size ... 216 (bytes) Avg. ... 0.009183
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit + Menu |
Each file may have several screens for each of the following:
| AS | Unassigned Associator |
| AC | Address Converter |
| A2 | Secondary ISNs |
| NI | Normal Index |
| UI | Upper Index |
| DS | Data Storage |
The example screen shown here provides information for one DS extent of file number 1.
Selecting option M from the File Level Main Menu displays a menu of functions used to enable, disable, or delete caching for one or more files:
13:43:56 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
- Maintain File Cache - PCFM002
File Level
Code Function
---- -------------
D Delete Cache
E Enable Cache
S Disable Cache
? Help
. Exit
---- -------------
Code ......... _
File Number .. 0____ - _____
Database ..... 1955 (WIS1955)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12------
Help Exit Menu |
This following functions are available:
| D | Delete all cache spaces for a particular file or range of files |
| E | Enable all cache spaces for a particular file or range of files |
| S | Disable all cache spaces for a particular file or range of files |
Selecting option O from the File Level Main Menu displays the Work cache spaces:
13:45:34 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
DBID 1955 - Maintain Cache Spaces - PCHS002
File Level
Sel No Mem. Cach RABN Range Last Activity Stat Error Status
Type Type From To
-- ----- ---- ---- -------------------- ---------------- ---- ----------------
64001 EXT WRK2 202 211 UNAL
64002 EXT WRK3 222 2392 UNAL
Select DI(Display) EN(Enable) DS(Disable) DE(Delete) MO(Modify)
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
For each RABN range listed on the Maintain Cache Spaces screen, you can display caching parameters, modify the memory type, and maintain the cache space by entering one of the following commands in the Select column:
MO |
Move the selected cache space to the memory type (E for extended; D for data space; H for hiperspace; L for virtual 64 backed by large pages; V for virtual 64) you specify on the Memory Type window that appears. |
DE |
Delete the selected cache space. Once deleted, the space must be redefined using the relevant ADARUN parameters. |
DI |
Display the detailed cache space statistics. The information
provided is the same as that resulting from the
CSTAT operator command.
|
DS |
Disable the selected cache space. |
EN |
Enable the selected cache space. |
The other columns on the Maintain Cache Spaces display contain the following information:
| Column | Description |
|---|---|
| No. | Cache space number (CSN). This is actually a unique RABN Range ID as there is no longer a direct correlation between cache spaces and RABN ranges. |
| Memory Type | Caching location for each cache space: extended storage (EXT), data spaces (DS), hiperspaces (HS), virtual 64 backed by large pages (L64), or virtual 64 storage (V64). |
| Cache Type | Database component being cached in the cache space: Work part 2 (WRK2), or Work part 3 (WRK3). |
| RABN Range | The starting (From...) and ending (To...) RABNs of the RABN range being cached in the cache space. |
| Last Activity | The date and time the cache space was last accessed. |
| Status | The current status of the cache space: disabled (DISA); unallocated (UNAL); or ALLC (allocated). |
| Error Status | If an error condition has occurred, the cause of the error will be displayed in this field. |
Entering DI in the Select column on the
Maintain Cache Spaces screen displays the Cache Statistics screen for an
individual Work cache space:
13:47:03 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
DBID 1955 - Cache Statistics - PCHS002
File Level
Cache Space No ...... 1
Memory Type ....... EXT
Cache Component ... WRK2
RABN-range ........ 202 - 211
Last Activity .....
Cache Status ...... UNALLOCATED
Cache Writes ...... 0
Max. Cache used ... 0 Elapsed Time per Cache Read Request
Cache Size ........ 57344 Max. ... 0.000000
Cache Efficiency .. 0.0 % Min. ... 0.000000
Cache Reads ....... 0 Avg. ... 0.000000
Read EXCPS ........ 0
Total Reads ....... 0 EXCP Time <in microseconds>
RABN's in Cache ... 0 Max. ... 0.000000
RABN's/Cache Space. 10 Min. ... 0.000000
RABN Index Size ... 56 (bytes) Avg. ... 0.000000
Press ENTER to continue |
The information displayed on this screen is the same as that displayed
by the CSTAT
operator command.
Note:
Values for Max. ASSO Cache Size and
Max. DATA Cache Size represent bytes, but may be marked
with a K (1 kilobyte=1024 bytes), M (1 megabyte=1,048,576 bytes), or G (1
gigabyte=1,073,741,824 bytes) indicator when the size of the value requires
it.
Selecting option P from the File Level Main Menu displays the current setting of the Adabas Caching (ADARUN) parameters and allows you to change them:
14:00:14 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
DBID 1955 - Maintain Cache Parameters - PCFP002
Display Cache Space Stats. YES_ (CDISPSTAT)
Minimum Buff. Efficiency . _________0 (CDEMAND)
Elapsed Time (GETMAIN) .. _______900 sec (CRETRY)
Time of Inactivity ....... ______7200 sec (CCTIMEOUT)
Max. No. Permitted ..... 5 (CMAXCSPS)
Max. ASSO Cache Size ..... ___1024000 _ (CASSOMAXS)
Max. DATA Cache Size ..... ___1024000 _ (CDATAMAXS)
WORK Memory Type ......... EXT (CWORKSTORAGE)
Percent WORK2 RABNs ...... 50 % (CWORK2FAC)
Percent WORK3 RABNS ...... 50 % (CWORK3FAC)
Read-ahead Caching
Number of Buffers ...... 0 (CBUFNO)
Command Types Excluded . ________ (CEXCLUDE)
Included . P/L/H/F PHYS/LOGI/HIST/FIND
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Note:
Values for Max. ASSO Cache Size and
Max. DATA Cache Size represent bytes, but may be marked
with a K (1 kilobyte=1024 bytes), M (1 megabyte=1,048,576 bytes), or G (1
gigabyte=1,073,741,824 bytes) indicator when the size of the value requires it.
In the example screen, the value 1,024,000 may also be designated as 1000
K.
For more information about these parameters, see the section Adabas Caching Parameters.
Selecting option S from the File Level Main Menu displays a summary of
information for the Adabas Caching session including cache statistics,
read-ahead statistics, and allocation statistics for active and inactive cache
spaces. This information is the same as that displayed when the
CSUM
command is issued.
14:19:37 ***** A D A B A S CACHING FACILITY ***** 2004-05-11
DBID 1955 - Cache Session Summary - PCF0002
File Level
Cache Allocation Summary Page 1
Current Adabas Buffer Efficiency ....... 473.2
Estimated NON-CACHE Buffer Efficiency .. 10.6
Number of Active Cache Spaces .......... 10
Number of Cache Spaces defined ......... 15
--- ASSO --- --- DATA --- --- WORK ---
Cache Statistics
Cache writes ....... 214 12596 0
Read EXCPS ......... 17 62 0
Cache reads ........ 203 12548 0
Total reads ........ 220 12610 0
Efficiency ......... 92.2 99.5 0.0
Read Ahead Statistics
RABN's read ........ 0 0
EXCPS .............. 0 0
Ave. blks/EXCP ..... 0.0 0.0 next page >> |
Page 2
Cache Size Summary
--- ASSO --- --- DATA --- --- WORK ---
Max Cache Size ..... 5,000 K 5,000 K 5,884 K
EXT Allocated ...... 0 K 0 K 0 K
EXT Highest ........ 0 K 0 K
DSP Allocated ...... 1,000 K 1,000 K 0 K
DSP Highest ........ 1,000 K 1,000 K
HSP Allocated ...... 0 K 0 K 0 K
HSP Highest ........ 0 K 0 K
V64 Allocated ...... 0 0 0 K
V64 Highest ........ 0 0
L64 Allocated 0 0 0 K
L64 Highest 0 0
Allocation Statistics marked as K, M, or G. |
Help screens are available by pressing PF1 from each page of the Cache Session Summary report.