Use Client Database-Request Statement Caching user type (-clstmtCacheType) to enable the specified user types to use the client statement caching at the level specified by the - clstmtCacheLevel parameter. If the level is set to 0, statement caching is disabled, even if the user type is set.

Operating system and syntax UNIX / Windows -clstmtCacheType user-type
Use with Maximum value Minimum value Single-user default Multi-user default
Client Connection, Database Server N/A 0 N/A ALL
user-type
Specifies the type of client connection to the database. Set user-type as follows:
  • ALL—This default setting specifies all self-service (local) clients and all remote clients.
  • SELFSERVE—Specifies all local clients.
  • SQLREMC—Specifies all SQL remote clients.
  • ABLREMC—Specifies all ABL remote clients.
  • REMOTECLIENT—Specifies all remote clients, both SQL and ABL.
To change this parameter setting while the database is running, use the following options: