Goldstar Software Utilities: BtrvInterceptor
Btrieve Request Capture Tool for Pervasive PSQL Databases
One of the biggest problems in troubleshooting any environment is gaining visibility into Btrieve operations that are hitting your server. If your application is making thousands of function calls, they may run so quickly that you never notice the amount of load that the process puts on your server. Enabling the MKDE tracing functions in the engine itself can cause performance problems and make it difficult to see what is happening when many users are hitting the server at the same time.
In the past, interpretting the Btrieve requests hitting a server required you to install a network analyzer like Wireshark, then dig through the resulting packet data looking for Btrieve requests, then parse them manually. Reading the hex dumps in this way is one sure way to get all cross-eyed. Ugh!
This whole process gets a lot easier with Goldstar Software's BtrvInterceptor utility. This tool is designed to run on either a workstation or server and watch the network for any requests going to the Pervasive PSQL engine (the MKDE). When it sees a request, it can log the important details, such as packet time, length, request type, and more. You can even enable a display of the entire ClientID field, a great aid when troubleshooting multi-threaded applications.
The current release of BtrvInterceptor (v1.30) only supports native IPv4 and IPv6 networks, IPv6 packets coming through a 6to4 gateway, and Cisco 803.1Q tagging at this time. However, we expect this product to quickly become a platform for additional features, including logging to a database file and more. (Watch this space as new features are added.)
Note: BtrvInterceptor uses the open-source library, WinPcap, which must be installed before BtrvInterceptor will work. You can download the latest version of this library from http://www.winpcap.org/.
BtrvInterceptor can be purchased as a single-user license or as a LAN site license, which allows you to run it on any number of workstations in your environment. Order online with the links above or contact us for details!