EM: BBjServices > Open Files Stats

Description

In BBj 16.0 and Higher, the File Open Stats viewer in the Enterprise Manager is a powerful tool used to delve deep into how BBj searches the configured PREFIX to resolve file paths when using the OPEN verb. When File Open Statistics enabled ( it is disabled by default), BBj records each file OPEN, including how the PREFIX was resolved if the path was relative, the number of times the OPEN occurred on each path, the total aggregate time required for those OPEN operations, and the average time for each individual OPEN. With this information, the administrator can make informed decisions about the order of paths in the PREFIX and how those adjustments may improve overall application performance. See: Settings.

Note: To minimize processing overhead, File Open Statistics are maintained in memory for the duration of a BBjServices run. Because this data can consume a substantial amount of memory, the feature should not remain enabled for long periods in a production environment.

Location

EM Navigator → File System → File Open Stats

Toolbar

Button	Function
	Checks File Open Stats availability and displays alert when statistics disabled.

Enabling File Open Stats

Before BBj begins collecting File Open Statistics, the feature must be enabled on the Settings page at:

EM Navigator → BBjServices → Settings → Logging Settings : File Open Statistics.

When this setting is enabled, BBj gathers the information about each OPEN call.

Note: It is important to note that SQL operations are not included in this information because they do not use the PREFIX to resolve file paths, which means they always take the fastest possible path to open the data files.

File Open Stats

The File Open Stats pane provides detailed insight into PREFIX resolution, behavior, performance timing, and usage counts across directories and files, enabling administrators to analyze access patterns and optimize BBj application efficiency.

The Clear Stats button clears the server side memory cache of the current information. This can be very useful to gather information from a known starting point.

File Open Stats Settings List

Value	Description
Prefixs/Item	Shows the PREFIX, resolved directory path, and specific file opened across hierarchical table levels.
Original Open	The original OPEN path specified by the application.
Count	The total OPEN counts per level, including PREFIX usage, directory opens, and file opens by Original Open.
Total(ms)	The total time spent performing OPEN operations in milliseconds, corresponding directly to the associated Count values.
Avg(ms)	The average time per OPEN operation, helping estimate individual operation duration within the application.

Optimizing the PREFIX

Administrators analyzing the File Open Stats may determine that the current PREFIX order is not optimized, and in such cases, any modifications should be performed carefully, since changes to the PREFIX order can influence which files are opened by a given call as well as the overall system performance. Because of this impact, all PREFIX adjustments must be thoroughly tested before the updated configuration is deployed to end users, and after any modifications are applied, the File Open Stats information should be cleared before re-evaluating performance to ensure that the displayed average times accurately reflect the new PREFIX configuration.