LOCALSUBTABLES System Table Description
Description
The LOCALSUBTABLES pseudo table show all atoms for partitions that are currently cached on the Transaction Engine (TE) to which the client is connected.
Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
|
Fields
| Field | Type | Description |
|---|---|---|
SCHEMA |
string |
Name of the schema containing the table linked to the partition. |
TABLENAME |
string |
Name of the table linked to the partition. |
OBJECTID |
bigint |
The identifier for the database object. |
CATALOGID |
bigint |
A unique ID identifying the database object. |
TABLECATALOGID |
bigint |
The database catalog ID for the partition. |
CARDINALITY |
bigint |
The number of rows in the partition. |
POPULATED |
boolean |
Internal flag given state of the atom |
OPEN |
boolean |
Internal flag given state of the atom |
COMPLETE |
boolean |
Internal flag given state of the atom |
REFCOUNT |
integer |
Reference count for the atom of the partition |
INCARNATION |
bigint |
The number of versions of this atom that have existed |
CHAIRMAN |
integer |
Node ID of the chairman for this atom. |
REQUESTEDFROM |
integer |
Node ID of the TE from where this atom was serialized. |
DIRTY |
boolean |
True if this atom has data that needs to be written to the backing store, that is, recorded by the SM. |
RECORDSBATCHFACTOR |
integer |
Number of records we attempt to put into each RECORDDATA atom. |
PARENTTABLEOBJECTID |
bigint |
The database catalog ID for the table linked to the partition.. |
PARTITIONID |
bigint |
The ID for this table partition. |