IBM Support

How to run the ClearCase dbcheck utility

Question & Answer


Question

How do you run the IBM Rational ClearCase dbcheck utility to check for possible database corruption and key file inconsistencies on Microsoft Windows, Linux, and UNIX?

Answer

Review technote 1122499 for a complete list of data to collect for VOB database issues.





Note: The dbcheck utility is run against a single VOB. All references to VOB in the instructions below refer to the VOB you wish to run dbcheck against.

  1. Log on to the VOB server as VOB owner, Administrator (on Windows) or root (on Linux/UNIX)

  2. Lock the VOB

    Note: You can reduce the time the VOB needs to be locked by locking the VOB, making a copy of the db directory, unlocking the VOB, and running dbcheck on the copy of the database.

    IMPORTANT: If there are errors locking the VOB, copy the database to another location and run the dbcheck. Be sure you inform Rational Client Support that the dbcheck was run on an unlocked VOB.

  3. Open a command prompt and cd to the db sub-directory in the storage location of the VOB

    Example: E:\ClearCase_Storage\VOBs\test.vbs\db

  4. Run dbcheck (from within the db directory of the VOB).

    On Windows:

    <CCHOME>\etc\utils\dbcheck -r1 -a -k -p
    32767 vob_db > c:\tmp\dbcheck.txt 2>&1

    On UNIX and Linux:

    Option #1
    <CCHOME>/etc/utils/dbcheck -r1 -a -k -p32767 vob_db > /tmp/dbcheck.txt 2>&1

    Option #2 in csh (c shell)
    <CCHOME>/etc/utils/dbcheck -r1 -a -k -p32767 vob_db >& /tmp/dbcheck.txt

    Note: The string vob_db is not an abbreviation, and should be entered literally. Make sure the dbcheck.txt output file indicates processing of each of the 7 database files.

    UNIX/Linux Note: Be sure to run the correct version of dbcheck if running the utility from a Link-Only installation as there are different versions for different database schemas. View technote 1122278 for more information.

    Note: If *** db_VISTA database error -4 - invalid database appears in the dbcheck output, the command was not run correctly. Review technote 1148556 for more information.

    Refer to technote 1121988 for more details on what the maximum value can be set for dbcheck's "-p" argument.

  5. Unlock the VOB

The output you want to see is 0 errors were encountered in 0 records/nodes
Anything else should be reported to Support.



Example Output:


db_VISTA Version 3.20
Database Consistency Check Utility
Copyright (C) 1985-1990 Raima Corporation, All Rights Reserved



------------------------------------------------------------------------

Processing key file: vob_db.k01(1), total of 3 nodes


Processing delete chain:  0 nodes on delete chain.
Processing nodes:
++100%


------------------------------------------------------------------------

Processing key file: vob_db.k02(2), total of 3 nodes


Processing delete chain:  0 nodes on delete chain.
Processing nodes:
++100%


------------------------------------------------------------------------

Processing key file: vob_db.k03(5), total of 1 node


Processing delete chain:  0 nodes on delete chain.
Processing nodes:
100%


------------------------------------------------------------------------

Processing key file: vob_db.k04(6), total of 1 node


Processing delete chain:  0 nodes on delete chain.
Processing nodes:
100%


------------------------------------------------------------------------

Processing data file: vob_db.d01(0), total of 153 records


Processing delete chain:  0 records on delete chain.
Processing records:
+++++++++10%+++++++++20%+++++++++30%+++++++++40%+++++++++50%+++++++++
60%+++++++++70%+++++++++80%+++++++++90%+++++++++100%



------------------------------------------------------------------------

Processing data file: vob_db.d02(3), total of 133 records


Processing delete chain:  0 records on delete chain.
Processing records:
+++++++++10%+++++++++20%+++++++++30%+++++++++40%+++++++++50%+++++++++
60%+++++++++70%+++++++++80%+++++++++90%+++++++++100%



------------------------------------------------------------------------

Processing data file: vob_db.d03(4), total of 1 record


Processing delete chain:  0 records on delete chain.
Processing records:
100%


Database consistency check completed

0 errors were encountered in 0 records/nodes

[{"Product":{"code":"SSSH27","label":"Rational ClearCase"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Utilities and Tools","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.0;7.0.1;7.1;7.1.1;7.1.2;8.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
29 September 2018

UID

swg21122748