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
Start of changeVERSIONIDEnd of change Start of changeVARCHAR(64) NOT NULL WITH DEFAULT ''End of change Start of changeA user-specified character string that specifies the REST service version name. This column is used only if Db2 REST services versioning support is enabled.End of change Start of changeGEnd of change
Start of changeISDEFAULTEnd of change Start of changeCHAR(1) NOT NULL WITH DEFAULT 'Y'End of change Start of changeIndicates 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.End of change		 Start of changeGEnd of change