Using the ttIsql Utility cachegroups Command

You can obtain information about cache groups in a TimesTen database using the ttIsql utility cachegroups command.

% ttIsql "DSN=cache1;UID=cacheadmin;PwdWallet=/wallets/cacheadminwallet"
Command> cachegroups;

Cache Group CACHEADMIN.RECENT_SHIPPED_ORDERS:

  Cache Group Type: Read Only
  Autorefresh: Yes
  Autorefresh Mode: Incremental
  Autorefresh State: On
  Autorefresh Interval: 1440 Minutes
  Autorefresh Status: ok
  Aging: Timestamp based uses column WHEN_SHIPPED lifetime 30 days cycle 24 hours on

  Root Table: SALES.ORDERS
  Table Type: Read Only


Cache Group CACHEADMIN.SUBSCRIBER_ACCOUNTS:

  Cache Group Type: Asynchronous Writethrough (Dynamic)
  Autorefresh: No
  Aging: LRU on

  Root Table: SALES.SUBSCRIBER
  Table Type: Propagate

Cache Group CACHEADMIN.WESTERN_CUSTOMERS:

  Cache Group Type: User Managed
  Autorefresh: No
  Aging: No aging defined

  Root Table: SALES.ACTIVE_CUSTOMER
  Where Clause: (sales.active_customer.region = 'West')
  Table Type: Propagate

  Child Table: SALES.ORDERTAB
  Table Type: Propagate

  Child Table: SALES.ORDERDETAILS
  Where Clause: (sales.orderdetails.quantity >= 5)
  Table Type: Not Propagate

  Child Table: SALES.CUST_INTERESTS
  Table Type: Read Only

3 cache groups found.

The information displayed by the ttIsql utility's cachegroups command include:

• Cache group type, including whether the cache group is dynamic

• Autorefresh attributes (mode, state, interval) and status, if applicable

• Aging policy, if applicable

• Name of root table and, if applicable, name of child tables

• Cache table WHERE clause, if applicable

• Cache table attributes (read-only, propagate, not propagate)

See ttIsql in Oracle TimesTen In-Memory Database Reference.