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 selected users
 
Activating database-request statement caching for selected users
When you choose to activate database-request statement caching for an individual user, 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.
*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.
After selecting the type, chose a user by number from a menu like the following:
Enter the type of statement caching to activate (1-Single, 2-Stack, 3-One Time Request, Q-Quit): 2

04/08/15        OpenEdge Release 11 Monitor (R&D)
12:23:14        Activate For Selected Users

Usr:Ten Name Domain Type Login time Serv IPV# Remote Address
5 User-5 -4 SELF/ABL 04/08/15 12:23    0
6 User-6 -4 SELF/ABL 04/08/15 12:23 0
7 User-7 -4 SELF/ABL 04/08/15 12:23 0
8 User-8 -4 SELF/ABL 04/08/15 12:23 0

Enter user number, P, T, or X (? for help):
Based on your entry, the following actions are performed:
*If the user number is valid, or if the user is specified in the list, database-request statement caching is activated. If the user is a self-serve or remote client, database-request statement caching is activated for that client. If the user number represents a remote database server, database-request statement caching is activated for all clients serviced by that database server.
Note: Once activated, database-request statement caching can not be canceled. You must deactivate for selected users, all users, or all future users.
*You can continue entering additional valid user numbers.
*The user number entry is terminated when you press ENTER without specifying a valid numeric character, or when you press ENTER after entering a non-numeric character.