1.1

APP |PIZZA_ORDER_PIZZAS
APP |PIZZA_ORDER
APP |BASE
APP |PIZZA_TOPPINGS
4 rows selected
For a specific table or set of tables, you can list all of the SQLFire members that host that table's data:
select m.ID from SYS.SYSTABLES t, SYS.MEMBERS m where t.TABLESCHEMANAME='APP'
and t.TABLENAME='PIZZA' and m.HOSTSDATA = 1
and (LENGTH(t.SERVERGROUPS) = 0 or GROUPSINTERSECT(t.SERVERGROUPS,
m.SERVERGROUPS));
ID
-------------------------------------
vmc-ssrc-rh156(23870)<v1>:23802/60824
vmc-ssrc-rh154(26751)<v4>:42054/49195
vmc-ssrc-rh156(23897)<v2>:37163/43747
vmc-ssrc-rh154(26739)<v3>:9287/48842
4 rows selected
Determining Whether a Table Is Replicated or Partitioned
The DATAPOLICY column specifies whether a table is replicated or partitioned, and whether a table is persisted
to a disk store. For example:
select TABLENAME, DATAPOLICY from SYS.SYSTABLES where TABLESCHEMANAME =
'APP';
TABLENAME |DATAPOLICY
--------------------------------------------------
PIZZA |PERSISTENT_REPLICATE
PIZZA_ORDER_PIZZAS |PARTITION
BASE |REPLICATE
TOPPING |REPLICATE
PIZZA_TOPPINGS |PARTITION
PIZZA_ORDER |PERSISTENT_PARTITION
6 rows selected
Determining How Persistent Data Is Stored
For persistent tables, you can also display the disk store that persists the table's data, and whether the table uses
synchronous or asynchronous persistence:
select TABLENAME, DISKATTRS from SYS.SYSTABLES where TABLESCHEMANAME =
'APP';
TABLENAME |DISKATTRS
----------------------------------------------
PIZZA |DiskStore is SQLF-DEFAULT-DISKSTORE; Synchronous
writes to disk
PIZZA_ORDER_PIZZAS |DiskStore is OVERFLOWDISKSTORE;Asynchronous
writes to disk
BASE |NULL
TOPPING |NULL
PIZZA_TOPPINGS |DiskStore is SQLF-DEFAULT-DISKSTORE; Synchronous
writes to disk
PIZZA_ORDER |DiskStore is SQLF-DEFAULT-DISKSTORE; Synchronous
writes to disk
6 rows selected
265
Querying SQLFire System Tables and Indexes