Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
Environment variablesVarious environment variables affect the functionality of your HCL OneDB™ products. You can set environment variables that identify your terminal, specify the location of your software and define other parameters.
Environment variables in HCL OneDB™ productsThe topics that follow discuss (in alphabetic order) environment variables that HCL OneDB™ database server products and their utilities use.
IONEDB_ OPCACHE environment variable

IONEDB_ OPCACHE environment variable

The IONEDB_ OPCACHE environment variable can specify the size of the memory cache for the staging-area blobspace of the client application.

kilobytes: Specifies the value you set for the optical memory cache.

Set the IONEDB_ OPCACHE environment variable by specifying the size of the memory cache in KB. The specified size must be equal to or smaller than the size of the system-wide configuration parameter, OPCACHEMAX.

If you do not set IONEDB_ OPCACHE, the default cache size is 128 kilobytes or the size specified in the configuration parameter OPCACHEMAX. The default for OPCACHEMAX is 0. If you set IONEDB_ OPCACHE to a value of 0, Optical Subsystem does not use the cache.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.