ttGridNodeStatus

Description

Displays information about all members of the specified cache grid. If no grid name is specified, then it displays information about all members of all cache grids associated with the Oracle database.

Required privilege

This procedure requires the CACHE_MANAGER privilege.

Syntax

ttGridNodeStatus(['gridName'])

Parameters

ttGridNodeStatus has the optional parameter:

Parameter	Type	Description
`gridName`	TT_VARCHAR (30)	If `gridName` is specified, displays information about all members of the named grid. Otherwise, displays information about all grids.

Result Set

ttGridNodeStatus returns the results:

Column	Type	Description
`gridName`	TT_VARCHAR (30)	The name of the grid.
`nodeID`	TT_INTEGER NOT NULL	The ID of the node.
`activeNode`	TT_INTEGER NOT NULL	The number of the node on which the active master data store currently resides.
`node1Attached`	CHAR (1) NOT NULL	Indicates if the active node is attached to the grid: T - the active is attached. F - the active is detached.
`Host1`	TT_VARCHAR (200) NOT NULL	The host name where the active data store is located.
`memberName1`	TT_VARCHAR (200) NOT NULL	Unique fully qualified grid member name for the active master data store.
`IPaddr1`	TT_VARCHAR (128) NOT NULL	The IP address where the active master data store is located.
`port1`	TT_INTEGER NOT NULL	The port number for the cache agent process of the active master data store.
`node2Attached`	CHAR (1)	Indicates if the standby node is attached to the grid: T - the standby is attached. F - the standby is detached.
`host2`	TT_VARCHAR (200)	The host name where the standby master data store is located.
`memberName2`	TT_VARCHAR (200)	Unique fully qualified grid member name for the standby master data store.
`IPaddr2`	TT_VARCHAR (128)	The IP address where the standby master data store is located.
`port2`	TT_INTEGER	The port number for the cache agent process of the standby master data store.

For a grid member that is a standalone database, the number of columns in the result set is fewer than for a member that is an active standby pair.

Example

If ttgrid is the only cache grid in the data store, display information about its members:

Command> call ttGridNodeStatus;

< TTGRID, 1, 1, T, sys1, TTGRID_alone1_1, 140.87.0.201, 5001, <NULL>, <NULL>,<NULL>, <NULL>, <NULL> >
< TTGRID, 2, 1, T, sys2, TTGRID_alone2_2, 140.87.0.202, 5002, <NULL>, <NULL>,<NULL>, <NULL>, <NULL> >
< TTGRID, 3, 1, T, sys3, TTGRID_cacheact_3A, 140.87.0.203, 5003, T, sys4, TTGRID_cachestand_3B, 140.87.0.204, 5004 >