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.