1.1

Displaying Eviction Settings
Use the EVICTIONATTRS column to determine if a table uses eviction settings and whether a table is configured
to overflow to disk. For example:
select TABLENAME, EVICTIONATTRS from SYS.SYSTABLES where TABLESCHEMANAME
= 'APP';
TABLENAME |EVICTIONATTRS
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PIZZA |NULL
PIZZA_ORDER_PIZZAS | algorithm=lru-entry-count;
action=overflow-to-disk; maximum=100
BASE |NULL
TOPPING |NULL
PIZZA_TOPPINGS | algorithm=lru-entry-count;
action=overflow-to-disk; maximum=100
PIZZA_ORDER |NULL
6 rows selected
Displaying Indexes
Join SYSTABLES with CONGLOMERATENAME to determine if a table has an index and display the indexed
columns. For example:
select CONGLOMERATENAME from SYS.SYSCONGLOMERATES c, SYS.SYSTABLES t
where c.ISINDEX = 1 and c.TABLEID = t.TABLEID and t.TABLESCHEMANAME
= 'APP'
and t.TABLENAME = 'PIZZA';
CONGLOMERATENAME
----------------
2__PIZZA__ID
6__PIZZA__BASE
2 rows selected
Displaying Installed AsyncEventListeners
If you install AsyncEventListener implementations, you can join the SYSTABLES, MEMBERS, and
ASYNCEVENTLISTENERS tables to display the listener implementations associated with a table as well as
the data store ID on which the listener is installed:
select t.*, m.ID DSID from SYS.SYSTABLES t, SYS.MEMBERS m,
SYS.ASYNCEVENTLISTENERS a
where t.tablename='<table>' and groupsintersect(a.SERVER_GROUP,
m.SERVERGROUPS)
and groupsintersect(t.ASYNCLISTENERS, a.ID);
See SYSTABLES on page 657 and ASYNCEVENTLISTENERS on page 635.
vFabric SQLFire User's Guide266
Managing and Monitoring vFabric SQLFire