Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : R&D Status Displays : Client Database-Request Statement Cache : Activating database-request statement caching for all users
 
Activating database-request statement caching for all users
When you choose to activate database-request statement caching for all users, the following menu appears:
Enter the type of statement caching to activate (1-Single, 2-Stack, 3-One Time Request, Q-Quit):
Enter the number for the type, or Q to exit:
*1-Single — Only the current ABL program and line number, or a single SQL statement is reported by the ABL client.
*2-Stack — The call stack up to the current ABL program and line number.
*3-One Time Request — The ABL or SQL client report tracing information once. Once reported, database-request statement caching is turned off.
*Q-Quit — Quit this function and return to the Client Database-Request Statement Caching menu.
Once the type of database-request statement caching is selected, tracing is activated for all clients currently connected to the database.
Note: Once activated, database-request statement caching remains activated until deactivated.