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( )

Description

Table 10-60: 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: ‘S,’ ‘W,’ or ‘Q’

CatalogSync

char(1)

In catalog synchronization? ‘T’ or ‘F’

WCatalogID

unsigned bigint

Catalog version on the write server

WVersionID

unsigned bigint

Latest version available on the write server