How to Find DB Information

General
, , ,
1

How do I find all database information for the DB my application is connected to?

I know the database, table and column that need to be updated, but I require more information, such as schema, in order to inform our DB team how to perform the update.

I’ve tried tools such as the query runner to find more information, but can’t find anything. Looks like a permissions issue:

Query.png
Query.png1920×1080 132 KB

Schema.png
Schema.png1920×1080 107 KB

2

@DevinD16607791

Please try to use Pega API’s to get some additional information about database/class. Attached screenshot for reference.

Pega API.png
Pega API.png1699×734 35 KB

3

@DevinD16607791

Three things are necessary to enable query runner:

  1. Additional datasource (whether it sits in context.xml or prweb.xml is irrelevant) – jndi name can be something like: jdbc/PegaRULESReadOnly

  2. Addition of two new prconfig entries (which can be implemented directly in prconfig.xml, or as Dynamic System Settings, or as jvm runtime settings.
    database/databases/PegaRULES/datasourceReadOnly
    database/databases/PegaDATA/datasourceReadOnly
    (Value of these settings to match the jndi name created in prior step)

  3. For PRPC users to be able to see the Query Runner landing page, need to update their Access Group record to include the role “PegaRULES:DatabaseAdministrator”

4

@DevinD16607791 I had to contact the JBoss engineers in order to obtain the DB information.