Comprehensive support for 'Keep In Memory'

For many years and releases, Db2 for i has had support for in-memory database. 

The tenured service to achieve in memory is the Set Object Access (SETOBJACC) command.

In IBM i 7.1, the Change Physical File (CHGPF) and Change Logical File (CHGLF) commands were enhanced to support the in memory preference.

In IBM i 7.2, the IN MEMORY memory-preference support exists on the following Data Definition Language (DDL) statements:

• ALTER TABLE
• CREATE INDEX
• CREATE TABLE
• DECLARE GLOBAL TEMPORARY TABLE

The QSQGNDDL() API and IBM i Navigator Generate SQL interfaces for generating SQL will return the memory preference.

The KEEP_IN_MEMORY column exists within the following DB2 for i catalogs.  This column can be queried to assess the memory preference setting for existing database objects:

• QSYS2/SYSINDEXSTAT
• QSYS2/SYSPARTITIONINDEXES
• QSYS2/SYSPARTITIONINDEXSTAT
• QSYS2/SYSPARTITIONSTAT
• QSYS2/SYSTABLEINDEXSTAT

The following images illustrate the IBM i Navigator support for memory preference.