Db2 REST services table (SYSIBM.DSNSERVICE)

REST services tables enable Db2 to be used as a REST service provider.

SYSIBM.DSNSERVICE table

The SYSIBM.DSNSERVICE table contains rows that describe Db2 REST services and their corresponding packages. The following table describes the columns in the SYSIBM.DSNSERVICE table:

Table 1. SYSIBM.DSNSERVICE table column descriptions
Column name Data type Description Use
NAME
VARCHAR(128)
NOT NULL
 Name of the package that contains the service request. G
COLLID
VARCHAR(128)
NOT NULL
 Name of the collection that contains the package. G
CONTOKN
CHAR(8)
NOT NULL
FOR BIT DATA
 Consistency token for the package that is generated when the service is created or altered. G
ENABLED
CHAR(1)
NOT NULL
 Indicates whether the service is enabled:
Y
Service is enabled, which is the default setting.
N
Service is disabled.
 G
CREATEDTS
TIMESTAMP
NOT NULL
 The time when the row is inserted. G
ALTEREDTS
TIMESTAMP
NOT NULL
 The time when the row is last updated. G
DESCRIPTION VARCHAR(250) A user-specified character string. G
VERSIONID VARCHAR(64) NOT NULL WITH DEFAULT '' A user-specified character string that specifies the REST service version name. This column is used only if Db2 REST services versioning support is enabled. G
ISDEFAULT CHAR(1) NOT NULL WITH DEFAULT 'Y' Indicates whether the REST service version that is represented by this row is the default version.
Y
The version in the VERSIONID column is the default version.
N
The version in the VERSIONID column is not the default version.
This column is used only if Db2 REST services versioning support is enabled.		 G