Abstract: A cache manager of a relational database management system (RDBMS) is able to bypass time consuming search operations through the use of a key memory structure and locate generated code segments within an SQL cache within a minimum of time. The SQL cache contains the generated code segments used to execute SQL statements as well as the structures and program logic used for maintaining the cache. The key memory structure is located in an area of memory utilized by the SQL runtime routines in executing applications. The runtime routines provide an interface between the application and the RDBMS.

Abstract: A configuration system and method uses a program device containing configuration software for configuring applications to be executed by a processing system through the use of externally provided values corresponding to environment variables that are used to define an execution environment for all of the applications to be executed by the system. The configuration system is used to establish a plurality of configuration file sources to be used in configuring applications wherein the files define a plurality of different operational levels. Each configuration file stores the values representative of a corresponding number of configurable items defining the environment for executing the applications. The values of each level has a pre-established override capability over the values of other levels.

Abstract: A host system includes a multicache system configured within a host system's memory which has a plurality of local and central cache systems used for storing information being utilized by a plurality of processes running on the system. The central cache system includes an obsolete code management (OCM) component that operates to detect and remove obsolete entries stored within the central cache system. The OCM component operates to remove obsolete code from all the caches when events cause such obsolescence, e.g., data definition language (DDL) statements are executed. In certain situations, by being able to perform such operations during DDL statement processing, the OCM component further enhances overall system operation.

Abstract: A host system includes a multicache system configured within the host system's memory which has a plurality of local and central cache systems used for storing information being utilized by a plurality of processes running on the system. Persistent shared memory is used to store control structure information entries required for operating central cache systems for substantially long periods of time in conjunction with the local caches established for the processes. Such entries includes a descriptor value for identifying a directory control structure and individual sets of descriptors for identifying a group of control structures defining those components required for operating the configured central cache systems. The cache directory structure is used for defining the name of each configured central cache system and for providing an index value identifying the particular set of descriptors associated therewith.