Shows the current version information for this server. Information includes server type (write server, query server, single-node mode) and synchronization status.
sp_iqmpxversioninfo( )
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Column |
Data type |
Description |
|---|---|---|
CatalogID |
unsigned bigint |
Catalog version on this server |
VersionID |
unsigned bigint |
Latest version available on this server |
OAVID |
unsigned bigint |
Oldest active version on this server |
ServerType |
char(1) |
Type of server: “C” (Coordinator), “W” (Write Server) or “Q” (Query Server) |
CatalogSync |
char(1) |
Catalog synchronization: “T” (synchronized) or “F” (not synchronized) |
WCatalogID |
unsigned bigint |
Catalog version on the write server |
WVersionID |
unsigned bigint |
Latest version available on the write server |
