ttDataStoreStatus

Description

Returns the list of processes connected to a data store. If the dataStore parameter is specified as NULL, then the status of all active data stores is returned.

The result set is similar to the printed output of the ttStatus utility.

Required privilege

This procedure requires no privilege.

Syntax

ttDataStoreStatus('dataStore')

Parameters

ttDataStoreStatus has the parameter:

Parameter	Type	Description
`dataStore`	TT_VARCHAR (256)	Full path name of desired data store or NULL for all data stores.

Result set

ttDataStoreStatus returns the result set:

Column	Type	Description
`dataStore`	TT_VARCHAR (256) NOT NULL	Full path name of data store.
`PID`	TT_INTEGER NOT NULL	Process ID.
`Context`	BINARY(8) NOT NULL	Context value of connection.
`conType`	TT_CHAR (16) NOT NULL	Type of process connected. The result can be one of the following: application - an ordinary application is connected. replication - a replication agent is connected. subdaemon - a subdaemon is connected. oracleagent - an cache agent is connected.
`ShmID`	TT_VARCHAR (260) NOT NULL	A printable version of the shared memory ID that the data store occupies.
`connection_Name`	TT_CHAR (30) NOT NULL	The symbolic name of the data store connection.
`connID`	TT_INTEGER NOT NULL	The numeric ID of the data store connection

Example

CALL ttDataStoreStatus('/data/Purchasing');