Welcome
Reference
Review reference information for the product.
Rational® ClearQuest® command reference
binddb2pkg
Binds IBM® DB2® databases with the DataDirect drivers used by Rational® ClearQuest®. You must run this command once for each physical DB2 database before Rational ClearQuest clients connect to the database. You should also run this command if you are upgrading an existing user database to a version of Rational ClearQuest that includes an updated version of the DataDirect driver.

IBM ClearQuest 10.0.9
Overview
Learn general information about the product.
Installing
Learn how to install the product.
Upgrading and migrating
Learn how to upgrade and migrate data for the product.
Administering
Learn how to administer the product.
Reporting
Learn how to generate reports for the product.
Developing
Learn how to develop schemas by using the Rational® ClearQuest® Designer.
Managing change and releases
Learn how to manage change and release in the product.
Integrating
You can integrate Rational® ClearQuest® with other software by adding packages to existing schema.
Extending product function
Learn how to extend the product.
Reference
Review reference information for the product.
- API Reference
- Index
- Rational® ClearQuest® command reference
  - binddb2pkg
    Binds IBM® DB2® databases with the DataDirect drivers used by Rational® ClearQuest®. You must run this command once for each physical DB2 database before Rational ClearQuest clients connect to the database. You should also run this command if you are upgrading an existing user database to a version of Rational ClearQuest that includes an updated version of the DataDirect driver.
  - bkt_tool
    Exports, imports, updates, and deletes the contents of a Public Queries folder in a Rational® ClearQuest® user database.
  - bkt_tool delete
    Saves the workspace contents of the Public Queries folder in a Rational® ClearQuest® user database and then deletes the workspace from the database.
  - bkt_tool export
    Exports all the workspace objects in the Public folders of a Rational® ClearQuest® database into one or more files. This allows the workspace objects to be reused.
  - bkt_tool import
    Imports all the workspace objects from the Public Queries folders of another Rational® ClearQuest® user database into the current database.
  - bkt_tool update
    Updates the workspace contents of a Rational® ClearQuest® user database.
  - clm_server_rename.pl
    This tool updates Jazz Team Server public URI artifact links for the Rational® ClearQuest® solution for Collaborative Lifecycle Management (CLM). Specifically, the tool updates the URIs that are stored in Rational ClearQuest Web server configuration files. The tool also updates the URIs that are stored in OSLCLink records in the Rational ClearQuest user database.
  - codepageutil analyze_tables
    Counts and identifies all the characters in a schema repository that are not in a specified code page.
  - codepageutil test_codepage
    Determines whether the database can handle all of the characters in a specified character set.
  - cpheader
    Adds and removes data code page header information to and from exported workspace items (queries, charts, reports, report formats) and form files created by using the original Rational® ClearQuest® Designer.
  - cqload
    Copies an entire Rational® ClearQuest® schema into a schema repository, or copies a partial schema into another schema.
  - cqload exportintegration
    Export schema revisions to create a partial schema file for integrating into another schema.
  - cqload exportschema
    Exports an entire Rational® ClearQuest® schema to a text file.
  - cqload importintegration
    Imports schema modifications to an existing schema from a schema file created with the cqload exportintegration subcommand.
  - cqload importschema
    Imports an entire schema from a text file and adds it to your schema repository.
  - cqreg
    Manages database set and database connection information in the Rational® ClearQuest® registry on the UNIX™ system and Linux™
  - cqtsadmin.pl
    cqtsadmin.pl automates the steps to set up, configure, and administer Rational® ClearQuest® full-text search.
  - cqtsadmin-dbset-userdb.xml
    cqtsadmin-dbset-userdb.xml is a full-text search administrator configuration file that the cqtsadmin.pl Perl script generates and uses. The file contains data about your deployment, which you can further customize.
  - findrecordlocks.pl
    Use the findrecordlocks.pl Perl script from the command line to find record locks and set timeout locks.
  - FIPSreport.pl
    Use the FIPSreport.pl Perl script from the command line to audit the configuration of a ClearQuest® database at feature level 7 to report users who are not using FIPS 140-2 approved algorithms.
  - importutil
    Imports or exports a dynamic list from text files.
  - importutil exportlist
    Exports a dynamic list to a text file.
  - importutil importlist
    Imports a dynamic list to a user database.
  - installutil
    Configures or modifies databases. Although you can use installutil with a variety of subcommands, the syntax that is described in this reference page is specific to subcommands used to configure LDAP user authentication. The installutil command line utility is available on Windows™ only.
  - installutil convertschemarepo
    Copies a schema repository to migrate a database for testing the upgrade process. This subcommand updates the new database with the correct location information.
  - installutil convertuserdb
    Copies and relocates a user database.
  - installutil copyschemarepo
    Copies a schema repository.
  - installutil copyuserdb
    Copies a user database.
  - installutil getauthenticationalgorithm
    Use the installutil getauthenticationalgorithm subcommand to display the algorithm specified by the installutil setauthenticationalgorithm subcommand.
  - installutil getcqldapmap
    Use the installutil getcqldapmap subcommand to display the string specified by the installutil setcqldapmap subcommand.
  - installutil getldapinit
    Use the installutil getldapinit subcommand to display the ldapsearch string specified by the installutil setldapinit subcommand.
  - installutil getldapsearch
    Use the installutil getldapsearch subcommand to display the string specified by the installutil setldapsearch subcommand.
  - installutil getmasterproperty
    Use the installutil getmasterproperty subcommand to retrieve the master properties values for a database set.
  - installutil getmasterpropertytofile
    Use the installutil getmasterpropertytofile subcommand to retrieve the master properties values for a database set and save these values to a file.
  - installutil getrecordlimits
    Obtains the database record ID allocator limit.
  - installutil lscodepage
    Displays the data code page of the Rational® ClearQuest® schema repository and the associated user databases.
  - installutil licensecheck
    The installutil licensecheck command allows Rational® ClearQuest® administrators to check the license configuration by checking out one or more licenses.
  - installutil setauthenticationalgorithm
    The installutil setauthenticationalgorithm subcommand controls whether Rational® ClearQuest® supports both Rational ClearQuest and LDAP authentication or only Rational ClearQuest authentication for the specified database set.
  - installutil setcqldapmap
    The installutil setcqldapmap subcommand identifies the Rational® ClearQuest® user profile field and the LDAP user attribute that Rational ClearQuest uses to map a user account in the database set to a user account in the LDAP directory.
  - installutil setdbcodepage
    Sets the value of the Rational® ClearQuest® data code page to a supported Windows™ code page.
  - installutil sethighrecordlimit
    Increases the database record ID allocator limit.
  - installutil setldapinit
    Use the setldapinit subcommand to set the parameter string that is required to connect a Rational® ClearQuest® database set to the LDAP directory used for authentication.
  - installutil setldapsearch
    Use the setldapsearch subcommand to specify the LDAP search criteria to use to find an LDAP user account to authenticate against.
  - installutil setmasterproperty
    Use the installutil setmasterproperty subcommand to set the master properties values for a database set.
  - installutil setmasterpropertyfromfile
    Use the installutil setmasterpropertyfromfile subcommand to set the master properties values for a database set by using the values that are stored in a file.
  - installutil showfeaturelevels
    Displays the feature levels for the installed version of Rational® ClearQuest®.
  - installutil unlockschemarepo
    Unlocks a schema repository.
  - installutil unlockuserdb
    Unlocks a user database.
  - installutil validateldap
    Use the installutil validateldap subcommand to confirm that an LDAP configuration is working correctly.
  - oslc-mappings.xml
    The oslc-mappings.xml configuration file controls how Rational® ClearQuest® prefills new OSLC 2.0-linked records.
  - setupCQLDAP.pl
    Use the setupCQLDAP.pl Perl script from the command line to set a user's authentication mode.
- Accessibility features for Rational® ClearQuest®
  Accessibility features help users who have a physical disability, such as restricted mobility or limited vision, to use information technology products successfully.
Tutorials

binddb2pkg

Binds IBM® DB2® databases with the DataDirect drivers used by Rational® ClearQuest®. You must run this command once for each physical DB2® database before Rational® ClearQuest® clients connect to the database. You should also run this command if you are upgrading an existing user database to a version of Rational® ClearQuest® that includes an updated version of the DataDirect driver.

Synopsis

: binddb2pkg server database DB2_admin password [port ]

Description

The DataDirect driver that is used by Rational® ClearQuest® to connect to DB2® databases requires that a number of DB2® packages be created and bound to the database before you use them. The first Rational® ClearQuest® connection to a DB2® database binds these packages. However, unless all DB2® users who connect to the database have database administrator privileges, the automatic binding does not work. If all of Rational® ClearQuest® users of DB2® do not have database administrator privileges, you must run the command before connecting to the database from Rational® ClearQuest®. This command must be run for every DB2® database that Rational® ClearQuest® uses.

Options and Arguments

server: The machine name of the database server for the schema repository or user database.

database: The database name.

DB2_admin: The user name that has the Database Administrator authority for the DB2® database.

password: The password for the user name.

port: If the database is in a DB2® instance that is not using default port value 50000, the port value must be specified.

Examples

Binds the DB2® package to the database user_db.mdb on the server Jupiter using port, 60000.

binddb2pkg Jupiter user_db admin "" 60000