ttCacheDbCgStatus
Required Privilege
This procedure requires no privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in both TimesTen Classic and TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttCacheDbCgStatus([cgOwner], [cgName])
Parameters
ttCacheDbCgStatus
has these optional parameters:
Parameter | Type | Description |
---|---|---|
|
|
Specifies the user name of the cache group owner. |
|
|
Specifies the cache group name. |
Result Set
ttCacheDbCgStatus
returns the result:
Column | Type | Value |
---|---|---|
|
|
Specifies the autorefresh status of all the cache groups in the database. The status is one of:
|
|
|
Specifies the autorefresh status of the specified cache group. The status is one of:
|
Examples
This example shows that the automatic refresh status of the database is alive
. The automatic refresh status of the cache group is ok
.
CALL ttCacheDbCgStatus ('terry', 'cgemployees'); < alive, ok > 1 row found.
To determine the automatic refresh status of the database, call ttCacheDbCgStatus
with no parameters:
CALL ttCacheDbCgStatus; < dead, <NULL> > 1 row found.
This procedure is available only for cache operations.