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.
- System Database landing page
Access the System Database landing page by clicking Configure System Database . The following tabs are available:
- Configuring connectivity to the Pega Platform database
External database connections through a Java Database Connectivity (JDBC) URL are managed by Pega Platform and use connection pools to handle requestor traffic. You can modify the default connection pools to limit or increase connections and their timeout value that is created for each database user to optimize connectivity for your environment.
- 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.
- 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.