Neoview Control Query Default (CQD) Reference Guide (R2.5)

1 Introduction
This section provides information on these topics:
• “Overview of CQDs” (page 11)
• “Setting CQDs” (page 12)
Overview of CQDs
This guide describes CQDs that are used to override system-level default settings. This information
is provided for each CQD:
Identifies one of these categories with which the CQD is associated:
• Influencing Query Plans
• Histograms
• Transaction control and locking
• Run time controls
• Schema controls
• File size and placement
• Materialized view controls
• Update Statistics and Reorg
• Operational controls
Category
Describes the purpose of the CQDDescription
Identifies this information:
• Values, in the form of a character string, that specify the applicable attribute values
for the CQD.
• The default attribute value.
• If applicable, the Neoview release in which the attribute values or default changed.
Values
Describes the conditions when the CQD is helpful, and how to detect the conditions.Usage
Identifies when the CQD is not safe to be used as a permanent setting in production.
For example, using services CQDs for diagnosis.
Production usage
Describes any positive and negative implications of using the CQDImpact
Indicates one of these levels at which the CQD should be used:
• Query
• Session
• Service
• Any
NOTE: This level indicates that the CQD can be used at the Query, Session or
Service level as long as the you fully understands the scope of the impact of the
CQD.
Level
Describes CQDs that are in conflict with or can be used in conjunction with the CQD.Conflicts/Synergies
Describes any design or solution that the CQD may be a workaround for and how
you can directly address the real problem.
Real problem addressed
Indicates the Neoview release when the CQD was introduced.Introduced in release
Indicates in what release the CQD was deprecated.Deprecated in release
Overview of CQDs 11