Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What are the VLDB utilities

Database Engine

What are the VLDB utilities

by  davidmichel  Posted    (Edited  )
UTILITIES

There are five database repair utilities, which are collectively called the dbrepair toolkit. This toolkit can be used to diagnose and repair the server database. With the dbrepair toolkit, you can check database consistency (dbcheck utility), repair a corrupted database (dbfix), rebuild key files (keybuild), compress fragmented databases (dbdefrag), and rebuild delete chains (dchain). All utilities use a command-line interface. You can display the command syntax for most Velocis utilities by entering the name of the utility, followed by the -? or -h option.


Dbcheck - Database consistency check utility

usage: dbcheck [-?] [-a] [-q] [-r [r1[;r2]...]] [-s [s1[;s2]...]] [-k [k1[;k2]...]] [-b
[b1[;b2]...]] [-i #] [-m #] [-p #] [-f optfile] [-L server;user;password] dbname

-? = Display this usage information
-a = Same as -r -s -k -b
-q = Perform only a partial (quick) consistency check on sets
-r = Perform consistency check for record types with names r1, r2, ...
-s = Perform consistency check for sets with names s1, s2, ...
-k = Perform consistency check for keys with names k1, k2, ...
-b = Perform consistency check for blobs with names b1, b2, ...
-i = Set period for report polling to # seconds (default is 10)
-m = User and system report type (# can be from 1 to 4, default is 4)
-p = Set number of pages in the dbrepair server cache to # (between 8 and
1000, default is 64)
-f = Read -r, -s, -k, and -b options from 'optfile' (in place of command
line flags)
-L = Use values server;user;password to login to a server (if not specified,
will attempt to use contents of RDSLOGIN env. variable and, failing
that, will prompt on the command line)

NOTE: multiple -r, -s, -k, and -b flags can be specified

Description - This utility examines the consistency of the files in the physical
database specified by dbname.



dbdefrag - Data file compression utility


usage: dbdefrag [-? | -h] [-a] [-b ["bname[;bname]..."]] [-f file] [-i secs] [-L
"serverID;userID;password"] [-m type] [-n] [-p pages] [-q] [-r
["rname[;rname]..."]] dbname

-? = -h Displays the usage information for the utility.
-a = Compresses all database data and BLOB files. This option is equivalent to
the combination of -r -b.
-b = ["bname[;bname]..."] Compresses the BLOB files containing BLOBs with the
names in the specified list. If no list is present, the utility compresses all
BLOB files.
-f = file Specifies the file containing the specifications for additional compressed
database elements. When you create such a file, each line must be in the
form of "k kname" or "b bname". These names are added to those specified
in the options.
-i = secs Determines the accumulation period, in seconds, before report
messages are flushed into the console (standard output). The default is 10.
-L = "serverID;userID;password" Specifies the user login information. If this
option is omitted, the utility looks for the information in the RDSLOGIN
environment variable. Then, if the variable is undefined, the utility prompts
you for the login information.
-m = type Specifies the user and system report types and reports as follows:
1 = Summary user and system reports
2 = Detailed system report and summary user report
3 = Detailed user report and summary system report
4 = Detailed user and system reports (default)
-n = Produces a report of all modifications, without actually changing the
database.
-p = pages Defines the number of pages in the dbrepair server cache. Use a
value between 8 and 1000. The default is 64.
-q = Specifies quick mode, in which the utility does not attempt to adjust user-
defined fields of type DB_ADDR. Adjustment may be necessary when those
fields refer to records in other databases.
-r = ["rname[;rname]..."] Compresses the data files containing records with the
names in the specified list. If no list is present, the utility compresses all data
files.
Dbname = Specifies the name of the database.

Description - This utility compresses files in the dbname database.


Dbfix - Database repair utility

usage: dbfix [-?] [-a] [-n] [-r [r1[;r2]...]] [-s [s1[;s2]...]] [-k [k1[;k2]...]] [-b [b1[;b2]...]]
[-i #] [-m #] [-p #] [-f optfile] [-d dumpfile] [-L server;user;password]
dbname

-? = Display this usage information
-a = Same as -r -s -k -b
-n = Do not actually perform repair operations (simulation mode)
-r = Perform repair operations for record types with names r1, r2, ...
-s = Perform repair operations for sets with names s1, s2, ...
-k = Perform repair operations for keys with names k1, k2, ...
-b = Perform repair operations for blobs with names b1, b2, ...
-i = Set period for report polling to # seconds (default is 10)
-m = User and system report type (# can be from 1 to 4, default is 4)
-p = Set number of pages in the dbrepair server cache to # (between 8 and
1000, default is 64)
-f = Read -r, -s, -k, and -b options from 'optfile' (in place of command
line flags)
-d = Specify the dump file name
-L = Use values server;user;password to login to a server (if not specified,
will attempt to use contents of RDSLOGIN env. variable and, failing
that, will prompt on the command line)

NOTE: multiple -r, -s, -k, and -b flags can be specified

Description - This utility performs the consistency check of the dbname database and repairs the database if corruption is detected.



Dchain - Delete chain repair utility

usage: dchain [-?] [-a] [-n] [-r [r1[;r2]...]] [-k [k1[;k2]...]] [-b [b1[;b2]...]] [-i #] [-m #]
[-p #] [-f optfile] [-L server;user;password] dbname

-? = Display this usage information
-a = Same as -r -k -b
-n = Do not actually perform delete chain modifications (simulation mode)
-r = Rebuild delete chain in files containing record types with names r1,
r2, ...
-k = Rebuild delete chain in files containing keys with names k1, k2, ...
-b = Rebuild delete chain in files containing blobs with names b1, b2, ...
-i = Set period for report polling to # seconds (default is 10)
-m = User and system report type (# can be from 1 to 4, default is 4)
-p = Set number of pages in the dbrepair server cache to # (default is 64)
-f = Read -r, -k, and -b options from 'optfile' (in place of command line
flags)
-L = Use values server;user;password to login to a server (if not specified,
will attempt to use contents of RDSLOGIN env. variable and, failing
that, will prompt on the command line)

NOTE: multiple -r, -k, and -b flags can be specified

Description - This utility rebuilds delete chains in the dbname database.



Keybuild - Key file rebuild utility

usage: keybuild [-?] [-k [k1[;k2]...]] [-i #] [-m #] [-p #] [-f optfile] [-L
server;user;password] dbname

-? = Display this usage information
-k = Rebuilds key files containing keys with names k1, k2, ...
-i = Set period for report polling to # seconds (default is 10)
-m = User and system report type (# can be from 1 to 4, default is 4)
-p = Set number of pages in the dbrepair server cache to # (between 8 and
1000, default is 64)
-f = Read -k options from 'optfile' (in place of command line flags)
-L = Use values server;user;password to login to a server (if not specified,
will attempt to use contents of RDSLOGIN env. variable and, failing
that, will prompt on the command line)

NOTE: multiple -k flags can be specified

Description - This utility rebuilds indexes in the dbname database.

Dbfix can be run to repair corruption, however running dchain and then keybuild on a database will do a much better job and is almost always successful in repairing any corruption.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top