RDB$Tools - A set of easy tools for Oracle RdB

RDB$Tools - A set of easy tools for Oracle RdB

 

 

RDB$Tools

A set of easy tools for Oracle RdB

Overview

RDB$Tools is a set of three tools, all written in DCL, that help you to perform common tasks on an Oracle RdB database on OpenVMS. They where written for own use and where never meant to be distributed as freeware---which explains the lack of documentation, but they can be found here since they proved to be useful at several sites.

These scripts need no installation or configuration (except RDB$FINDBLOCKER.COM, see below). Just copy them to the location where you want to install them, and execute them like you execute any other DCL script.

These tools come with no warranty, use of this software is at own risk. There is no support on these scripts and they come with no documentation. The scripts can be freely used and modified.

RDB$FindBlocker

version 1.0-2

Released: November 11, 1995

When a database is locked by a transaction, RMU /SHOW LOCKS /MODE=BLOCKING can help you to find the locking transaction. However, on busy databases, especially clusterwide, this might be time consuming. RDB$FindBlocker finds the blocker for you, also when your database runs clusterwide. Just call the script with the database name as the first (and only) parameter.
Depending on the system load, it might several minutes before the output is displayed.

If your database runs clusterwide, set the value if `clusterwide' on line 7 to `1'


RDB$Refresh

version 1.0

Released: August 22, 2001

This script can be used to recreate a databases that's highly fragmented due to too many extents. This is done in the following steps:

  1. Create an SQL file with the metadata
  2. Unload all data
  3. Drop the database (!!!)
  4. Recreate the database with the metadata from step 1
  5. Reload all data with the unload files from step 2
  6. Recreate the indexes with the metadata from step 1
Several options are available to decide which steps should be taken. For more information, type:
$ @RDB$REFRESH HELP

 

This script drops your database! Use with extreme care, and make sure you have a recent backup!

SQL$Format

version 1.1a

Released: April 24, 1998

SQLFormat is an easy-to-use tool for formatting SQL output. It reads an input file, ignores all SQL garbage, and extracts only the relevant information.

Several options can be can be given, either at the command line or using input files, which specify how the output should look like, be printed etc. Online help is available by typing
$ @SQL$FORMAT HELP


Download RDB$Tools

The tools are available in a single ZIP file:
©1995-2001, Oscar van Eijk, Oveas Functionality Provider