Activating database-request statement caching for all users

Database Administration

Reference : PROMON Utility : R&D Status Displays : Client Database-Request Statement Cache : 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.