Related information
You can control which database operations are traced by clicking Designer Studio > System > Performance > Database Trace.
Label |
Operation |
| Prepared Statement Query |
Causes the output to include a line for each query (SQL database read) operation. |
| Prepared Statement Update |
Causes the output to include a line for each update (SQL database insert, update, or delete) operation. |
| Prepared Statement |
Each read, update, or delete operation requested by the Pega 7 Platform server results in a prepared statement query sent to the Pega 7 Platform database. Causes the DB Trace output to include a line for all three types of prepared statements. |
| Get Database Metadata | Causes the DB Trace output to include a line for each check of the rule cache. Checks typically occur before read operations the first time that a table is accessed after startup. |
| Read blob |
Causes the DB Trace output to include a line each time the Storage Stream column (pzPVStream) in a row is read. The size of the entry in the column is also reported. |
| Write blob |
Causes the DB Trace output to include a line each time Storage Stream column (pzPVStream) in a row is written. |
| Commit |
Causes the DB Trace output to include a line each time an internal database commit operation completes. (This is not directly related to the PRPC Commit method.) |
| Rollback |
Causes the DB Trace output to include a line when a PRPC Commit operation is in process but a database rollback operation occurred. |
| Assign Connection to Thread |
Causes the DB Trace output to include a line when a database connection in a pool is reassigned to a new requestor thread. |
| Cache Hit (found) |
Causes the DB Trace output to include a line when a rule cache hit occurred and the requested row was found. |
| Cache Hit (not found) |
Causes the DB Trace output to include a line when a rule cache hit occurred and the requested row did not exist. (For rules, the database cache records both the requests not found and successful requests.) |
| Cache Miss |
Causes the DB Trace output to include a line when a rule cache miss occurred. |
| Run List |
Causes the DB Trace output to include a line when a list rule (Rule-Obj-List rule type) was processed by the Obj-List method in an activity. |
| List Result Count |
Causes the DB Trace output to include a line when a list rule completed and indicates the number of rows returned. |
| Activity Start |
Causes the DB Trace output to include a line when an activity execution starts. |
| Activity End |
Causes the DB Trace output to include a line when an activity execution completes. |
Click OK to apply your settings. The system saves this information in the pyDBTraceSettings page within your requestor page.