My Oracle Support Banner

How Can REORG Be Used for Database Maintenance with Siebel and DB2? (Doc ID 477378.1)

Last updated on MAY 07, 2018

Applies to:

Siebel CRM - Version 7.8.1.1 SIA [19044] and later
Siebel System Software - Version 7.8.1.1 SIA [19044] and later
Information in this document applies to any platform.
Area(s):System Administration
Release(s):V8 (Enterprise)
Database(s):DB2
App Server OS(s):All Supported Platforms
Latest release tested against:V8 (Enterprise)
Keywords:DB2, REORG, REORGCHK, Performance, cluster, index, cluster ratio, cluster factor

This document was previously published as Siebel FAQ 2072.


Goal

How Can REORG Be Used for Database Maintenance with Siebel and DB2?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 What is new in Siebel  for DB2 Table Maintenance?
 What is Table Reorganization?
 What is a Clustering Index?
 Why is it necessary to use the REORG Utility on Tables?
 How will the DBA know when the Table Requires Reorganization?
 Reorganizing Fragmented Tables and Indexes
 Reorganization Options
 Role of RUNSTATS in Table Reorganization

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.