Operations Guide

10.1 HotFix 1
- 10.5 HotFix 3
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

db_util Utility

The db_util utility unlocks a Rulebase Server after the server shuts down unexpectedly. When you run the db_util utility, the utility internally runs an SQL script that deletes the

IDS_nn_INUSE

table and removes the lock related entry in the

IDS_FDT_META

table.

To run the db_util utility, use the following command format:

db_util ids:rb [Rulebase Number] [-c<Utility Name>] [-s<SQL Script Name>]

The db_util utility uses the following parameters:

Rulebase Number: Optional. Rulebase number for the Rulebase Server that you want to unlock. By default, the utility uses the rulebase number that you specified in the connection string.
Utility Name: Optional. Utility to run the SQL script. Default is sqlplus.
SQL Script Name: Optional. Absolute path and name for the SQL script that the utility internally creates. By default, the utility creates an SQL script named,
myscript.sql
, in the current working directory. Use this parameter when you do not have the write permission to the current working directory.

The following sample command overrides the rulebase number in the connection string and unlocks the Rulebase Server:

$SSABIN/db_util ids:rb 03 -csqlplus -s/tmp/dbscript.sql

Rename Saved Search

Table of Contents

Operations Guide

Operations Guide

db_util Utility

db_util Utility