Welcome
Administering
Learn how to administer the product.
Administering Rational® ClearQuest®
Learn how to administer the Rational® ClearQuest®.
Configuring query limits on result sets
You can configure query limits on the size of result sets to improve system performance, availability, and scalability.
Set the hard limit on result sets
This topic describes how to set the hard limit on result sets for a database set.

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.
- Administering Rational® ClearQuest®
  Learn how to administer the Rational® ClearQuest®.
  - Reconfiguring ClearQuest® to use a different JRE
    When you change the Java Runtime Environment (JRE) for Rational® ClearQuest®, you must reconfigure the product to make it work with the new JRE.
  - Managing databases
    Describes the different types of databases that the administrator can create and manage
  - Managing user accounts
    Use the User Administration tool to set up and administer users and user groups. Rational® ClearQuest® stores information about users and user groups in the user database and schema repository.
  - Configuring query limits on result sets
    You can configure query limits on the size of result sets to improve system performance, availability, and scalability.
    - Guidelines for configuring query limits
      ClearQuest® sets predefined hard and soft limits on the number of rows returned when you run a query. This topic provides guidance for tuning these settings.
    - Set the hard limit on result sets
      This topic describes how to set the hard limit on result sets for a database set.
    - Get the hard limit on result sets
      This topic describes how to get the hard limit on result sets for a database set.
    - Set the soft limit on result sets
      This topic describes how to set the soft limit on result sets for a database set.
    - Get the soft limit on result sets
      This topic describes how to get the soft limit on result sets for a database set.
  - Using LDAP with Rational® ClearQuest®
    Overview of user authentication methods available with Rational® ClearQuest®.
  - Workspace folder permissions overview
    Rational® ClearQuest® uses a role-based access control (RBAC) model for enforcing workspace folder permissions. The workspace folder permissions feature requires that your schema repository and user databases are at feature level 6 or later.
  - Optimistic and pessimistic record locking
    Overview of optimistic and pessimistic locking implementations in Rational® ClearQuest®.
  - Configuring ClearQuest® core logging and tracing
    This section describes how to configure logging and tracing for ClearQuest® core.
- Administering Rational® ClearQuest® Web
  This section discusses how to administer Rational® ClearQuest® Web.
- Administering Rational® ClearQuest® Multisite
  Administering Rational® ClearQuest® Multisite
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.
Tutorials

Set the hard limit on result sets

This topic describes how to set the hard limit on result sets for a database set.

You can set the hard query limit as a master property of a ClearQuest® database set, or by setting a behavior flag in the local environment where the ClearQuest® core resides. Locally defined hard and soft query limits override the master property values set in the database set.

Set the hard limit as a master property of a database set

Use the installutil setmasterproperty subcommand to set the hard limit as a master property of a database set.

installutil setmasterproperty dbset_name cq_login_id cq_password HARD_QUERY_LIMIT new_value

Examples

Set the hard query limit for the database set mydbset to 150,000:

installutil setmasterproperty -dbset mydbset admin secret HARD_QUERY_LIMIT 150000

For the database set mydbset, set the hard query limit to 150,000 for the SAMPL database and 20,000 for the TEST database:
```
installutil setmasterproperty -dbset mydbset admin secret HARD_QUERY_LIMIT SAMPL=150000;TEST=20000
```

Set the hard limit by using a behavior flag in the local environment

To set the query limit behavior flags in the local environment where the ClearQuest® core resides, either modify the Windows™ Registry key HKEY_CURRENT_USER\Software\Rational Software\ClearQuest\Diagnostic, or set the environment variable CQ_DIAG_BEHAVIOR.

Examples

Set the soft limit to 5,000 and the hard limit to 20,000 by modifying the Windows™ Registry.
Use regedit to modify the Registry key HKEY_CURRENT_USER\Software\Rational Software\ClearQuest\Diagnostic:
```
HKEY_CURRENT_USER\Software\Software\Rational Software\ClearQuest\Diagnostic
"Name"=""
"behavior"="SOFT_QUERY_LIMIT=5000;HARD_QUERY_LIMIT=20000"
```
Set the soft limit to 5,000 and the hard limit to 20,000 by setting the environment variable CQ_DIAG_BEHAVIOR.
```
CQ_DIAG_BEHAVIOR="SOFT_QUERY_LIMIT=5000;HARD_QUERY_LIMIT=20000"
```