Client Database-Request Statement Cache

Displays options for Client Database-Request Statement Caching.

                OpenEdge Release 13 Monitor (R&D)
                Client Database-Request Statement Caching Menu

                 1. Activate For Selected Users
                2a. Activate For All Users
                2b. Activate For All Users by User Type
                3a. Activate For All Future Users
                3b. Activate For All Future Users by User Type
                 4. Deactivate For Selected Users
                 5. Deactivate For All Users
                 6. Deactivate For All Future Users
                 7. View Database-Request Statement Cache
                 8. Specify Directory for Statement Cache Files
                 9. Toggle between User and Tenant Options
                10. Database statement cache locks

Choose one of the following options:

• 1–Activate For Selected Users — Activates Client Database-Request Statement Caching for one or more clients. For more information, see Activate database-request statement caching for selected users.
• 2a–Activate For All Users — Activates Client Database-Request Statement Caching for all clients. For backward compatibility, you can enter 2 or 2a to access this option. For more information, see Activate database-request statement caching for all users.
• 2b–Activate For All Users by User Type — Activates Client Database-Request Statement Caching at a specified level for all existing clients of a particular type. For more information, see Activate database-request statement caching for all users by user type.
• 3a–Activate For All Future Users — Activates Client Database-Request Statement Caching for all future client connections to the database. For backward compatibility, you can enter 3 or 3a to access this option. For more information, see Activate database-request statement caching for all future users.
• 3b–Activate For All Future Users by User Type — Activates Client Database-Request Statement Caching at a specified level for all future client connections of a particular type to the database. For more information, see Activate database-request statement caching for all future users by user type.
• 4–Deactivate For Selected Users — Deactivates Client Database-Request Statement Caching for one or more clients. For more information, see Deactivate database-request statement caching for selected users.
• 5–Deactivate For All Users — Deactivates Client Database-Request Statement Caching for all clients.
• 6–Deactivate For All Future Users — Deactivates Client Database-Request Statement Caching for all future client connections to the database.
• 7–View Database-Request Statement Cache — View the Client Database-Request Statement Cache. For more information, see View database-request statement caching.
• 8–Specify Directory for Statement Cache Files — Specify the directory for all temporary database-request statement cache files. For more information, see Specify a directory for database-request statement caching files.
• 9–Toggle between User and Tenant Options — When selected, switches options 1-6 to activate or deactivate based on tenancy not on users.
• 10–Database statement cache locks — When selected, displays a list of locks obtained by users performing database statement caching.