Table of Contents

Search

  1. Preface
  2. Introduction
  3. Servers
  4. Console Client
  5. Search Clients
  6. Table Loader
  7. Update Synchronizer
  8. Globalization
  9. Siebel Connector
  10. Web Services
  11. ASM Workbench
  12. Cluster Merge Rules
  13. Forced Link and Unlink
  14. System Backup and Restore
  15. Batch Utilities

db_util Utility

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 <Rulebase Name> [Rulebase Number] [-c<Utility Name>] [-s<SQL Script Name>] [-h<Database Host>] [-d<Database Type>]
The db_util utility uses the following parameters:
Rulebase Name
Name of the Rulebase Server or the dictionary alias of the Rulebase name.
Use the following format for a Rulebase name:
<DB Type>:<Number>:<User>/<Password>@<Service>
For example,
-r odb:0:myuid/mypassw@oraserv
Use the following format for the dictionary alias of a Rulebase name:
ids:<Rulebase Alias>
For example,
ids:rb
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.
Database Host
Optional. Host name of the database server.
Database Type
Optional. Type of the database that you use. The type 0 indicates IBM Db2, and the type 1 indicates Microsoft SQL Server.
Use one of the following values:
  • 0. Indicates IBM DB2. For example, the following command indicates that you use IBM DB2 database:
    $SSABIN/db_util $SSA_RBNAME 00 -cdb2 -s/tmp/myscript -hu100lx6 -d0
  • 1. Indicates Microsoft SQL Server. For example, the following command indicates that you use Microsoft SQL Server database:
    $SSABIN/db_util $SSA_RBNAME 00 -csqlcmd -s/tmp/myscript -d1
  • If you do not specify this parameter, it indicates that you use Oracle database. For example, the following command indicates that you use Oracle database:
    $SSABIN/db_util $SSA_RBNAME 00
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

0 COMMENTS

We’d like to hear from you!