IBM DB2 Content Manager Version 8 Query Performance Guide

This document describes the IBM® DB2® Content Manager Query Performance Guide.


IBM DB2 Content Manager Version 8 Query Performance Guide - cover page
Brand
IBM
Category
Other software
Document type
Other
Language
English
Pages
20
File format
PDF
File size
171 KB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
54FCA5CE13F30BF905658732B6188254

About this manual

This guide, document version 1.1 dated June 27, 2008, covers performance implications of the DB2 Content Manager Version 8 query component. It is written for customers, partners, application designers and developers, systems and database administrators, and IBM Level 2 and Level 3 technical support representatives who need to increase efficiency and resolve query performance issues.

The document describes the DB2 Content Manager query processing flow, common ways to analyze and address performance problems, database tuning steps such as updating statistics and creating indexes, and ways to narrow down where time is spent. It then lists common rewrites to DB2 Content Manager queries, including handling "child OR" queries, conditions on child component attributes, the IN operator, text search instead of LIKE, wildcards, case-insensitive search, upward traversal queries and folder queries. Later sections cover logging information needed by support teams, XML data model export, and references.

What's inside

  • Introduction
  • Disclaimer
  • Target audience
  • Brief Overview of the DB2 Content Manager Query Processing Flow
  • Common Ways to Analyze and Address Query Performance Issues
  • Database Tuning
  • Narrowing Down Query Performance Problems
  • Common Rewrites to DB2 Content Manager Queries
  • Logging and Other Information Typically Needed for Analysis by DB2 Content Manager Level 2 and Level 3 Support Teams
  • XML Data Model Export

Specifications

Product version coveredDB2 Content Manager Version 8
Document version and date1.1 (June 27, 2008)

Frequently asked questions

How does a DB2 Content Manager query get processed?

The query received by the CM Query API is translated into SQL using information from the Data Model API, then sent to the Search Stored Procedure where ACL conditions are added and the query is executed. The result is a list of IDs called PIDs used to create DDOs.

Which database commands should be run after creating a new index?

After creating a new index, run the reorg, runstats, and rebind commands so that the DB2 UDB optimizer can effectively use the new index.

Why can a wildcard at the beginning of a search term hurt performance?

Using a wildcard at the beginning of the search term may prevent the database system from effectively using the index.

Who is this guide intended for?

It is primarily intended for DB2 Content Manager external and internal users, including customers, partners, application designers and developers, administrators, and IBM L2 and L3 support representatives.

Download PDF (171 KB)

More IBM Manuals


View all IBM manuals →