sp_iqmpxversioninfo Procedure

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

Syntax

sp_iqmpxversioninfo

Applies to

Multiplex only.

Privileges

No specific system privilege is required.

Description

sp_iqmpxversioninfo Columns

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