Installation and Set Up Best Practices › Reorganize Database

Reorganize Database

After you apply maintenance to your product using CA CSM, we recommend that you reorganize your database. Reorganizing your database improves overall access to data the next time you use CA CSM. Use the database reorganization backup and load process to reclaim space and reposition data.

Follow these steps:

1. Stop the SCS Address Space if you have one.
2. Stop the CA CSM application server.
3. Stop the CA Datacom/MSM server (MSMDBSRV) by using the MSMDBSVP JCL member or the MSMDBSRP proclib job.
4. Verify that your CA CSM Multi-User Facility (MSMMUF) is active.
5. Review and edit the CSMBK4K member to reflect your naming standards.
6. Submit the job CSMBK4K.

   The job CSMBK4K creates a current backup of the CA Datacom/MSM database 4000 to a sequential file on the disk.

7. Review and edit the CSMLD4K member.

   Edit the JCL so that it conforms to your site standards, verifying that the input data set matches the output data set created in the previous step.

   Important! You must execute the job CSMLD4K immediately following the job CSMBK4K.

8. Start the CA Datacom/MSM server (MSMDBSRV) by using the MSMDBSVS JCL member or MSMDBSRV proclib member.
9. Start the CA CSM application server.
10. Start the SCS Address Space if you have one.

Business Value:

Using this best practice can help you improve database response time, CPU time, and the number of I/O operations.

Additional Considerations:

A database reorganization (execution of a backup followed immediately by a load) against a database that has little fragmentation (indicated by a low value count in the output display named OVERFLOWS IN AREA of a current CXX report) does not result in a measurable improvement in performance.

More Information:

For more information, see the CA Datacom/DB Database and System Administrator Guide.