backup_db This script backs up the database from one location to a different location on disk. blocked_clients This script allows you to determine the cause of a blocked or hung client chk_db_status This script verifies the database is running chk_idle To determine the idle time for all users on the system sorted by idle time (longest idle first) ck_ai To determine how many full ai extents there are per database cp_full_ai This script backs-up all full AI extents to the backup directory and initializes the extents for reuse cpu_hogs To determine the amount of CPU utilization for each user on the system. db.registry A sample registry file db_requests This script gathers database request information and then displays the information to the user. db_status This script acts as a wrapper for the chk_db_status script. Allowing one or all databases to be checked at the same time. disable_ai This script acts as a wrapper for the sub_disable_ai script. Allowing one or all databases to have AI disabled at the same time. enable_ai This script acts as a wrapper for the sub_enable_ai script. Allowing one or all databases to have AI enabled at the same time. get_blank This script finds and displays blank userids. get_locks This script gathers users lock information and displays the information. get_trans This script gathers transaction information and displays the information to standard output. heartbeat This script verifies the database is running kill_users To send a kill signal to all of the _progress processes on the system. lsdb To list all of the databases on the system markempty_ai This script marks all full AI extents as empty Should be run after a full backup is complete monitor_db This script gathers database information and then displays the information to the user. os-gather To gather system activity statistics pmon To monitor one or more databases read-sar To read compressed sar data read_registry This script sets system and database environment variables for use by other scripts. A file (db.registry) is read from to determine if the database is valid and "registered" on the system roll_forward_ai This script backs-up all full AI extents to the backup directory and initializes the extents for reuse sar.p To pull sar information from a file into Progress sar2.p To pull sar information from a file into Progress shut_db To shut the database start_db To start the database and the correct number of page writers for a given database sub_disable_ai This script disables AI for the Database Called by disable_ai sub_enable_ai This script enables AI for the Database Called by enable_ai swai This script acts as a wrapper for the cp_full_ai script. Allowing one or all databases to be swai'ed at the same time. test_registry To test/report the value in the db.registry file truncate_log To truncate the log file for one or more databases user_process A script to find a process for a userid waitfor_backup To wait for one or more "backup_db"s to complete This program will loop until all restores are done on the system. It loops once a second until complete.