How Can REORG Be Used for Database Maintenance with Siebel and DB2?
(Doc ID 477378.1)
Last updated on OCTOBER 02, 2023
Applies to:
Siebel CRM - Version 7.8.1.1 SIA [19044] and laterSiebel 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 |