News
Abstract
Comprehensive support for 'Keep In Memory'
Content
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.
Was this topic helpful?
Document Information
Modified date:
21 January 2020
UID
ibm11171156