sp_iqmpxversioninfo procedure

Function

Shows the current version information for this server. Information includes server type (write server, query server, single-node mode) and synchronization status.

Syntax

sp_iqmpxversioninfo( )

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

Table A-6: sp_iqmpxversioninfo columns returned

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