Administering your database
Monitor your database so that it robustly supports a production-level application. Modify your database to support quick data retrieval and to increase column lengths as your initial requirements change.
- Database tables
Create database table data instances to map classes or class groups to database tables or views. You can use the Database Table form to revise existing class-to-table relationships.
- Viewing general database information
Access the System Database landing page by clicking Configure System Database . The following tabs are available:
- Viewing and modifying schema information
Use Pega Platform tools to view and modify database schema information so that your application can respond to changing circumstances.
- Running SQL queries on Pega Cloud
As a Pega Cloud client, to retrieve data from the internal PegaDATA or PegaRULES databases, you can run SELECT statements using Query Runner.
- Troubleshooting database requests
The Pega Platform database performance is a major factor in overall system performance, affecting response time for interactive, browser-based users, turnaround time for services, and throughput. You can use tools provided by Pega Platform to help you debug, trace, and analyze requests from the server to the Pega Platform database.
- Creating database data instances
Create a database data instance so that Pega Platform can access a database in addition to PegaRULES and PegaDATA. To improve performance, you can create Pega classes and data types in a separate database, or use a separate database for Prediction Studio or for running reports. You can also create a database instance to access an external database.