Timesten - Cache Grid

Member

A grid member is either:

• a standalone TimesTen database
• or an active standby pair that consists of at least two replicated TimesTen databases.

A grid member is composed of one or two nodes.

Grid members can reside on the same system or on different systems. Each system must have the same:

• machine architecture,
• operating system version, platform and bit version.
• TimesTen major release number

A TimesTen database that is or is part of a grid member can contain:

• local and global cache groups
• as well as explicitly loaded and dynamic cache groups.

Node

Each database of a grid member is called a grid node. A node is a single TimesTen database that is either a standalone database, or the active database or standby database of an active standby pair.

Relationship / Association

A cache grid can be associated with only one Oracle database.

A TimesTen database can be a member of only one cache grid.

An Oracle database can be associated with more than one cache grid and each grid can be administered by a different cache administration user.

A cache grid has no association with other cache grids.

Create

You can create a cache grid from:

• any of the standalone databases,
• or from either the active or standby database of the active standby pair.

A cache grid is created only once from any one of the grid members.

-- The procedure ttGridCreate creates a cache grid called "samplegrid".  
call ttGridCreate ('samplegrid');
commit;

You can also manually create a cache grid by running the initCacheGridSchema.sql script.

By default, you must associate a TimesTen database with a cache grid before you can create cache groups in that database. For backward compatibility, you can set the CacheGridEnable connection attribute to 0 so that you do not have to create a cache grid and associate the TimesTen database with the grid before cache groups can be created within that database.

Associate

Regardless of the setting of CacheGridEnable, you must create a cache grid and associate the TimesTen database with the grid before you can create global cache groups within that database.

All standalone databases, and the active and standby databases of the active standby pair must be associated with a cache grid before you can create cache groups within those databases.

-- ttGridNameset associates the current database to "samplegrid". 
call ttGridNameSet ('samplegrid');
COMMIT; -- The commit is normally not needed ...

Get Cache grid info

call ttGridInfo;

GRIDNAME          CACHEADMINID    PLATFORM              MAJOR1  MAJOR2 MAJOR3
----------------  --------------  --------------------  ------  ------ -----
DI_BISAMPLE_GRID  CACHE_TT_ADMIN  Linux x86-64, 64-bit  11      2      2      

Delete

call ttGridInfo;
call ttGridDestroy('samplegrid');
COMMIT;
call ttGridInfo;

Oracle PROCESSES system parameter

If you are planning a grid with ten or more nodes, modify the PROCESSES Oracle system parameter. Use this guideline:

where:

• GridMembers = number of grid members
• DLConnections = number of dynamic load connections. The number of dynamic load connections is determined by how many sessions will have dynamic cache group operations.
• OraBackgroundProcesses = number of Oracle background processes

TT5907: The cache admin user id was not set

call ttGridInfo failed,
TT5907: The cache admin user id was not set before performing the operation.  
Set the cache admin user id and password either through the built-in procedure ttCacheUidPwdSet 
or the utility ttAdmin and try again.

The cache admin user must be set in the timesten database.