ttGridAttach

Description

Attaches a grid member to a cache grid that has been created. A grid member can be a standalone TimesTen database or a TimesTen active standby pair.

If a member is an active standby pair, both nodes of the pair must attach to the grid. When calling the ttGridAttach built-in procedure from each node of the active standby pair, specify the IP address or host name of both nodes.

This procedure starts the cache agent if it is not already running.

Required privilege

This procedure requires the CACHE_MANAGER privilege.

Syntax

For a standalone TimesTen database:

ttGridAttach(currentNode, 'name1', IPAddr1, port1)

For a node of an active standby pair:

ttGridAttach(currentNode, 'name1', IPAddr1, port1 'name2', IPAddr2, port2)

Parameters

ttGridAttach has the parameters:

Parameter	Type	Description
`currentNode`	TT_INTEGER NOT NULL	Host name of the node where the active master data store resides.
`name1`	TT_VARCAHR (30)	Fully qualified name that uniquely identifies the grid member for the active master data store.
`IPAddr1`	TT_VARCHAR (128) NOT NULL	IP address of the node where the active master data store resides.
`port1`	TT_INTEGER NOT NOLL	Port number for the cache agent process of the active master data store.
`name2`	TT_VARCAHR (30)	Fully qualified name that uniquely identifies the grid member for the standby master data store.
`IPAddr2`	TT_VARCHAR (128) NOT NULL	IP address of the node where the standby master data store resides.
`port2`	TT_INTEGER NOT NOLL	Port number for the cache agent process of the standby master data store.

Result set

ttGridAttach returns no results.

Examples

To attach to a standalone TimesTen data store to a grid:

CALL ttGridAttach (1, 'alone2','sys2',5002);

To attach an active master data store to a grid:

CALL ttGridAttach(1,'cacheact','sys1',5003,'cachestand','sys2',5004);

To attach a standby master data store to a grid:

CALL ttGridAttach(2,'cacheact','sys1',5003,'cachestand','sys2',5004);

Note that the only difference between the calls for attaching the active and the standby master stores is the node number.