If a file server has been installed, the file server statistics part of the Natural Tools for Db2 is used to display statistics on the use of the file server.
To invoke the File Server Statistics function
On the Natural Tools for Db2 Main Menu, enter function code
F and press ENTER
The File Server - Generation Statistics screen is displayed:
16:53:20 ***** NATURAL TOOLS FOR DB2 ***** 2009-10-30
- File Server - Generation Statistics -
File Server Dataset Name ......: SAG.N2122.FSERV
Enqueue Resource Name .........: FSERVV609
Total Number of File Server Blocks ..........: 1000
File Server Block Size ......................: 4080
Number of Space Map Blocks ..................: 2
Number of Global Directory Blocks ...........: 1
Entries ..........: 203
User Space Allocation Quantities Primary ....: 50
Secondary ..: 10
Total Number of Blocks permitted per User ...: 200
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Dire Next Canc |
This screen provides information on parameters that must be specified when generating the file server.
If the file server storage medium is the Software AG Editor buffer pool, the File Server - Generation Statistics screen looks as follows:
16:53:20 ***** NATURAL TOOLS FOR DB2 ***** 2009-10-30
- File Server - Generation Statistics -
File Server Dataset Name ......: STORAGE MEDIUM IS EDITOR BUFFER POOL
Enqueue Resource Name .........:
Total Number of File Server Blocks ..........: 0
File Server Block Size ......................: 4088
Number of Space Map Blocks ..................: 0
Number of Global Directory Blocks ...........: 0
Entries ..........: 0
User Space Allocation Quantities Primary ....: 20
Secondary ..: 10
Total Number of Blocks permitted per User ...: 100
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Next Canc |
If you press PF11 (Next), a second screen is displayed, the File Server - User Statistics screen, showing statistics that have been kept since the file server was installed - Statistics since Generation -, and statistics about the current Natural session - Current Session Statistics.
16:53:20 ***** NATURAL TOOLS FOR DB2 ***** 2009-10-30
- File Server - User Statistics -
Statistics since Generation:
Active Users - Maximum Number: 3 Current Number: 1
Maximum Number of used Blocks for single User ..........: 200
for all Users ............: 200
Number of Block Allocations PRIMARY ....................: 13
SECONDARY ..................: 17
Number of free Blocks ..................................: 997
Number of INIT SESSION Calls ...........................: 65
Current Session Statistics:
Total Number of Blocks .................. ...: 0
Free Blocks .................: 0
Secondary Allocations ......: 0
VSAM I/O Buffer inside DB2AREA ........... ..: YES (Yes/No)
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Dire Prev Canc |
If you press PF10 (Prev), you are returned to the File Server - Generation Statistics screen.
Statistics are updated, each time you press ENTER, PF10, or PF11.
If the file server storage medium is the Software AG Editor buffer pool, the File Server - User Statistics screen looks as follows:
16:53:20 ***** NATURAL TOOLS FOR DB2 ***** 2009-10-30
- File Server - User Statistics -
Statistics since Generation:
Active Users - Maximum Number: 3 Current Number: 0
Maximum Number of used Blocks for single User ..........: 0
for all Users ............: 0
Number of Block Allocations PRIMARY ....................: 0
SECONDARY ..................: 0
Number of free Blocks ..................................: 0
Number of INIT SESSION Calls ...........................: 0
Current Session Statistics:
Total Number of Blocks .................. ...: 20
Free Blocks .................: 20
Secondary Allocations ......: 0
VSAM I/O Buffer inside DB2AREA ........... ..: YES (Yes/No)
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Prev Canc |
Note that the section Statistics since Generation could not be provided by this display.
For file server VSAM files, Natural for Db2 also provides file server directory display and maintenance.
If you press PF9 (Dire), the active directory entries are listed showing the session identifiers and their allocated file server blocks. The display looks like the following:
12:47:40 ***** NATURAL TOOLS FOR DB2 ***** 2009-11-03 User XYZ - File Server - Directory Entries - TID TCD4 C No Tpsessid Birth 1st Block Last Block Blocks Comment ------------------------------------------------------------------------------ _ 0 Free Chn 826 964 597 Checked _ 1 TCKK pre NDB43 902 951 50 Checked _ 2 TCLB pre NDB43 50 99 50 Checked _ 3 TCR0 pre NDB43 301 250 50 Checked _ 4 TCR7 pre NDB43 251 350 50 Checked _ 5 TCDW pre NDB43 604 503 50 Checked _ 6 TCEX pre NDB43 504 653 50 Checked _ 7 TCBW 2009-09-25 957 374 50 Checked _ 8 TC42 2009-10-15 357 993 50 Checked _ 9 - free - 0 0 0 Empty Chain _ 10 - free - 0 0 0 Empty Chain Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Cont Help Exit List Pos -- - + ++ Delet Fresh Canc |
Birth denotes a rough creation date of the file server session,
if it was created by Natural for Db2 Version 4.3. If the file server session was
created by an earlier version of Natural for Db2, the birthday of the file server
session appears as pre NDB43.
The Directory Entries screen provides the functionality to scroll through the directory entries and to position a particular entry to the top of the screen.
In addition, Directory Entries allows you to list all file
server block numbers of a directory entry (PF4, line command
L) or to delete a directory entry from the file server
(PF10, line command D). You should only delete
directory entries, if you are sure the associated Natural session is no longer alive,
otherwise the deletion could destroy the file server structure.
Directory Entries reflects the file server sessions at one particular point in time. By pressing PF11, the display will be refreshed from the file at another (actual) point in time.