Member Table Requirements for Creating Dynamic Cluster Tables

Overview

To create dynamic cluster tables in the server, the tables must have matching table, column, and index attributes. If there are attribute mismatches in table, column, or index attributes, the dynamic cluster table is not created, and the server displays the following error message:

ERROR: Member table not compatible with other cluster members. Compare CONTENTS.

A more detailed error message is written to the server log. The server log lists which attribute is mismatched in the member table.

All of the member table attributes that are described in the following topics must match in order for the server to successfully create a dynamic cluster table.

Table Attributes

The following table attributes must match in all member tables to successfully create a dynamic cluster table:

CONSTRAINT

WHERE constraint

DISKCOMP

compression algorithm

DSORG

table organization

DS_ROLE

table option for ROLE

DSTYPE

SAS data-set type

ENCODING_CEI

encoding CEI for NLS (for compressed tables)

FLAGS

compressed table
encrypted table
backup table
NLS columns in table
MINMAXVARLIST columns in table
SAS encryption password in table

IOBLOCKSIZE

I/O block size

IOBLOCKFACTOR

I/O block factor

LANG

data set language tag

LTYPE

data set language type tag

NINDEXES

number of indexes

NVAR

number of columns

OBSLEN

row length

SASPW

SAS encryption password

SEMTYPE

data set semantic type

Column Attributes

The following column attributes must match in all member tables to successfully create a dynamic cluster table:

NAME

column name

LABEL

column label

NFORM

column format

NIFORM

column informat

NPOS

column offset in row

NVARO

column number in row

NLNG

column length

NPREC

column precision

FLAGS

NLS encoding supported
MINMAXVARLIST column

NFL

format length

NFD

format decimal places

NIFL

informat length

NIFD

informat precision

NSCALE

scale for fixed-point decimal

NTATTR

column type attributes

TYPE

column type

SUBTYPE

column subtype

Index Attributes

The following index attributes must match in all member tables to successfully create a dynamic cluster table:

NAME

index name

KEYFLAGS

unique index
nomiss index

LENGTH

index length

NVAR

number of columns in index

NVAR0

column number in index

Last updated: February 8, 2017