Consultor Eletrônico

Status: Verified

GOAL:

What is Client Database-Request Statement Caching?

GOAL:

How to activate Client Database-Request Statement Caching?

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2x

FIX:

Client Database-Request Statement Caching is a new feature added in 10.1C which, when enabled, allows the DBA to determine the ABL program and line number or the SQL statement that has caused or is causing the current database action.

Once activated, the database-request can be viewed via PROMON or a retrieved from a VST.

The database-request statement cache is updated by the individual clients and is refreshed anytime the client performs a database operation. The database-request statement cache can contain the following information:


An ABL program name and line number of the ABL code that is performing a database request
An ABL program stack of up to 32 program names and line numbers beginning with the current program name and line number that is performing a database operation
The most recent SQL statement
When active, the client processes will send extra information to the database.
This will incur a minor penalty for performance on the client but only when Statement Caching is enabled on the database.
This performance penalty is due to an additional operation when performing an interaction with the database regardless of whether the client is a shared memory connection or remote connection. For remote connections the client must send additional packets of information to the database.

There are two ways CDRSC (Client Database-Request Statement Caching) may be enabled: 1) from the promon menus and 2) by VST.

Using promon:
promon <dbname>
R&D
1
18
The following menu will be displayed:
07/30/09 OpenEdge Release 10 Monitor (R&D)
10:21:50 Client Database-Request Statement Caching Menu
1. Activate For Selected Users
2. Activate For All Users
3. Activat