Binary Dump/Load Script Generator
Load a proutil dbanalys output file and use that information to divide tables into multiple Binary dump/load groups or threads. Then create the actual shell scripts that will perform the dump and load.
Dump/Load Verification Utility
Compare proutil dbanalys reports run before and after a dump/load to verify that the number of records dumped equals the number of records loaded. This is crucial in ensuring that a dump/load was performed successfully.
After Image Extent Scanner
Reads and analyzes a text file created by the output of rfutil aimage scan verbose to find transaction information. This can be useful when finding out what transactions would be lost when restoring from an online backup or how far to roll forward in case of a failure. Included is a program to fix the Trid (Transaction Id) bug that is present until V10.1A.
Disconnect Idle Client Sessions
Identify and disconnect 4GL Clients with no database activity for a specified period of time. For example this could be Remote Client that has disconnected abnormally but still has an active session possibly with record locks. The TCP keepalive option may not be able to find these orphaned sessions if the user immediately logged back in to the database. This program will also disconnect users that have been idle (no I/O) for the specified period of time. The program can also be used to disconnect Self-Service Clients that have been idle for too long.
Long Transaction Monitor
Identify and disconnect long running transactions that have the potential to grow a BI file to abnormally large (and potentially dangerous) size.
Safe and Easy Disconnect Utility
This program provides a safe and user-friendly interface to promon/proshut for the purpose of disconnecting a user. When there are dozens of users connected to a database it can be very time consuming to disconnect multiple users because after each individual disconnect you must go back to the top of the user list and start over again. Also it is very easy to accidentally "slip" on the keyboard and shutdown the database instead of disconnecting a process.
Queued Record Lock Monitor
Find all processes that are queued waiting on a record lock as well as the process that is holding the lock.
Database Log File Monitor
Monitor the database log file for selected error messages. This is the "light" version of database log file monitoring program from Dan Foreman's ProMonitor tool.
STGEN - Structure File Generator
Takes the output of proutil dbanalys and generates a properly sized Structure (.st) file for a specified set of Storage Areas. Very useful when converting a database that has no Storage Areas to one that has multiple Storage Areas.
Sample After Imaging Shell Scripts
Unix/Linux shell scripts for monitoring AI extents.
Index Build by Area
Prior to V9.1E it is not easy to build indexes for the tables in a specific Storage Area. This utility produces a text file that can be used as an input file to proutil idxbuild and build all of the indexes in a specific Storage Area.
