Database maintenance for the Pega Cloud 2.1 database
Pega Cloud provides the back-end database that supports your Pega 7 Platform application. Each customer environment is provisioned with dedicated databases inside the customer virtual private cloud.
Building a new application on the Pega 7 Platform or extending a Pega application by using the Pega 7 Platform Designer Studio often involves changing and optimizing the underlying database structures. Proactively managing and maintaining the Pega 7 Platform database and your changes are critical to having a healthy, well-performing application.
Some database maintenance functions are self-service enabled directly in the Pega 7 Platform Designer Studio, while other database management functions require working with the Pega Cloud Support desk. Understanding the different methods for managing these tasks will help you to keep your application and the underlying database running efficiently.
Self-service enabled tasks
The following table lists database maintenance tasks that are enabled within the Pega 7 Platform Designer Studio. The table includes links to Pega 7 Platform help topics that explain how to accomplish the tasks by using the Schema Tools, Query Inspector, and Query Runner landing pages. These landing pages are secure and should only be accessed by your database administrator or someone who is familiar with daily database maintenance tasks.
Your user account must have the PegaRULES:DatabaseAdministator role assigned to it to use these landing pages.
- Access the Schema Tools landing page by clicking .
- Access the Query Inspector landing page by clicking .
- Access the Query Runner landing page by clicking
For a summary of these two landing pages, see Schema Tools and Query Inspector for Pega Cloud 2.1.
|Database task||Frequency||Help topic|
|Defragment tables||Daily or weekly||Defragmenting tables|
|Collect table statistics||Daily or weekly||Updating statistics|
|Extend VARCHAR column length||Based on your requirements||Increasing column lengths|
|Examine the size of a BLOB field||Based on your requirements||Viewing column BLOB size|
|Create indexes (single column, composite, or function-based)||Based on database performance and analysis needs||Adding and deleting indexes|
|Analyze SQL queries||Based on database performance and analysis needs||Generating an explain plan|
|Run ad hoc SQL queries (with limited result set)||Based on analysis needs||Testing SQL queries|
Database tasks that require working with Pega Cloud Support
The following table lists database maintenance tasks performed by Pega Cloud Support and the frequency with which they should be performed. You can request that these tasks be performed by submitting a support ticket. For more information about the change management process, see Change Management in Pega Cloud.
|Rename columns||Based on requirements|
|Change column data types||Based on requirements|
|Partition tables||Ongoing based on requirements|
|Create custom tables||Ongoing based on requirements|