cachegroups Command
The cachegroups
command is used to provide detailed
information on cache groups defined in the current database.
The attributes of the root and child tables defined in the cache group are
displayed in addition to the WHERE
clauses associated with the cache group.
The argument to the cachegroups
command is the name of the cache group that
you want to display information for and when no argument is provided, it returns information
of all the cache groups defined by the connected user in the current database.
Command> cachegroups;
Cache Group CACHEUSER.READCACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: Paused
Autorefresh Interval: 5 Seconds
Autorefresh Status: ok
Aging: No aging defined
Root Table: SALES.READTAB
Table Type: Read Only
Cache Group CACHEUSER.WRITECACHE:
Cache Group Type: Asynchronous Writethrough (Dynamic)
Autorefresh: No
Aging: LRU on
Root Table: SALES.WRITETAB
Table Type: Propagate
2 cache groups found.