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:
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:
|
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.
|
G |