As many companies expand their use of data, they look for ways to make their processing more efficient. One of the ways to do this is to segment the data in a single table into groups, and to use a concept in CA Datacom/DB called Partitioned Tables.
This article provides a compilation of resources that are available for clients who are considering this functionality.
Table Partitioning is a feature that has been available in CA Datacom since release 11.0, and there have been a number of resources created since that time to help understand the setup and processing.
First, there are a couple webcasts available as part of the CA Datacom Best Practices Series. To review all the videos and webcasts available for CA Datacom, log in to CA Support Online, and then go to the Product Page for CA Datacom. Under the Recommended Reading section, you will see a page for "CA Datacom Video and Recorded Webcast Index".
Under the Previously Recorded Webcasts section are the descriptions of these two webcasts:
Then, since you might be considering partitioning due to the size of your tables, you might want to also consider using Online Reorg to help with tuning. There is a webcast about it, too:
Next, we have written a couple other Knowledge Base articles about partitioning that you might find helpful:
Once you have partitioning in place, here is a Knowledge Base article that addresses a problem you might encounter:
Finally, for the details of configuring and working with partitioned tables, you should refer to one of the following:
These are also available at docops.ca.com for CA Datacom version 15.0 and 15.1:
Since many of the DBUTLTY functions have particular processing for partitioned tables, you should also refer to the various functions as needed in your CA Datacom/DB DBUTLTY Reference Guide.
As always, please contact CA Technologies support for CA Datacom if you have further questions.