Once database-request statement caching is activated for one or more users, any deactivate menu option will halt database-request statement caching.

Note: To view the database-request statement cache, select View Database-Request Statement Cache from the main Client Database-Request Statement Caching menu. For more information, see Viewing database-request statement caching.

When you choose to deactivate database-request statement caching for selected users, a list of users with database-request statement caching activated is generated, like the following:

                OpenEdge Release 12 Monitor (R&D)
                Deactivate For Selected Users

Usr:Ten Name    Domain   Type       Login time     Serv IPV# Remote Address
  5     User-5      -4   SELF/ABL   04/08/20 13:33    0   
  6     User-6      -4   SELF/ABL   04/08/20 13:34    0   
  7     User-7      -4   SELF/ABL   04/08/20 13:34    0   
  8     User-8      -4   SELF/ABL   04/08/20 13:34    0   

Enter user number, P, T, or X (? for help):

Once the user information is displayed, you can deactivate database-request statement caching for selected users by specifying the corresponding user number. Based on the user number, the following actions are performed:

  • If the user number is valid, and if the user is specified in the list, database-request statement caching is deactivated. If the user is a self-serve or remote client, database-request statement caching is deactivated for that client. If the user number represents a remote database server, database-request statement caching is deactivated for all clients serviced by that database server.
  • 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.