Reorg requirements for moving from Gen HE to Gen CSE

Products

• Gen
• Gen - Host Encyclopedia

Issue/Introduction

We previously had a Reorg run by a DB2 DBA on the Host Encyclopedia (HE) before moving to a Client Server Encyclopedia (CSE). This was run every time we deleted an existing model or created a new model to ensure space was freed up for any Encyclopedia activity. Is there is a defined process for running a Reorg on the CSE?

Environment

Component: CA Gen Client Server Encyclopedia

Resolution

There is no actual reorg utility/job on the CSE like there is on the HE which invokes the DB2 Reorg utility: Host Encyclopedia Utilities > Reorg

However, running the equivalent reorg for the CSE SQL Server or Oracle database is still important after certain CSE functions which are documented here:
Managing the Client Server Encyclopedia Workload > Specific Encyclopedia Functions in CSE

In general, the CSE database should be treated like any other database in terms of required maintenance to keep the performance optimized and use reorganization tasks etc. as required.
For example, under normal operations Oracle files can be configured to expand automatically, because normally data only grows. Oracle has several tools to help reclaim disk space, so please see the Oracle documentation e.g. Oracle Database Release 19 > 19 Managing Space for Schema Objects. Deciding whether to reorganize (reclaim disk space) totally depends on the amount of growth and shrinkage of the CSE database.  The Oracle DBA should be able to use database parameters to determine the percent free and that should help decide whether to reclaim.  For instance, if there are 20 large models on the CSE and 10 models are deleted, then that may be a reason to reclaim space.

Additional Information

1.  See additional advice for SQL Server and Oracle Routine Procedures under: Client Server Encyclopedia > Client Server Encyclopedia Administration
2.  There is also the CSE cleanup utility which is documented here: Tune the Client Server Encyclopedia > Perform the CSE Cleanup
3.  Q: Before running a DB reorg should all developers need to check-in their subsets? 
    A: When checking in a subset, rows are deleted from the DSUBEX table, the subset expansion table. So, checking in all subsets will give the best scenario/result. However, if the subsets are few and small, then the final
    results may not differ much if they are left checked out.