Request a new access token
POST /auth/tokens
Authenticates the user credentials and returns an access token that can be used when invoking the operations.
Request
Request Body
UserCredentials
User credentials
userid
Required *
string
The user's ID
password
Required *
string
The user's password
Response
200 - Authentication token
userid
string
User ID associated with the generated token.
token
string
Token string that can be used in subsequent requests that require authentication.
401 - Invalid credentials
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Returns public key of Json Web Token
GET /auth/token/publickey
Returns public key of Json Web Token.
Request
Response
200 - Token public key and key id.
kty
string
Public key type.
e
string
Exponent of public key.
kid
string
Key ID of public key.
alg
string
Algorithm of public key.
n
string
Modulus of public key.
Sets a new password using dswebToken
PUT /auth/password
Sets a new password using the dswebToken obtained from /auth/reset.
Request
Request Body
UserPasswordReset
New password and dswebToken
password
Required *
string
New password
dswebToken
Required *
string
dswebToken received by email
Response
200 - Password changed
code
string
status code
400 - Invalid or missing new password
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - If dswebToken is missing or invalid
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query the list of object schemas
GET /admin/schemas/obj_type/{obj_type}
Query the list of object schemas.
Request
Path Parameters
obj_type
Required *
string
Object type.
Query Parameters
search_name
string
Object type.
show_systems
string
Whether to show system objects.
rows_return
string
The amount of return records.
Response
200 - Query the list of object schemas.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Create schema
POST /admin/schemas
Creates a new schema. Any user with enough database authority can create schemas using dbapi directly. Regular users can create new schemas indirectly by creating a new table or other database object and specifying the name of the new schema where the object will be placed.
Request
Request Body
CreateSchemaReqBody
name
Required *
string
Schema name.
authorization
string
Authorization ID.
Response
201 - Schema created.
name
string
The schema name
400 - Invalid parameters or schema already exists
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Only administrators can create schemas directly.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Drops multiple schemas
PUT /admin/schemas/delete
Drops multiple schema. An error is returned if the schema contains any objects.
Request
Request Body
DropSchemaReqBody
Response
200 - The schema was dropped successfully.
status
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get single object privilege
GET /admin/privileges
Get single object privilege.
Request
Path Parameters
Query Parameters
obj_type
Required *
string
Object type.
schema
string
Schema name of the object. For table and database, this parameter is not required.
obj_name
string
Name of the object. For database, this parameter is not required.
rows_return
string
The amount of return records.
Response
200 - Get object privilege.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Privilege list of selected objects
POST /admin/privileges
Privilege list of selected objects.
Request
Request Body
privilegsReqBody
obj_type
string
rows_return
integer
filter
array
Response
200 - Privilege list of selected objects
400 - Get error when search authid
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Grant or revoke privileges
PUT /admin/privileges
Grant or revoke privileges
Request
Request Body
privilegesChangeReqBody
stop_on_error
boolean
privileges
array
Response
200 - The status of grant or revoke
status
string
400 - Get error when grant or revoke
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Generate schema DDL
POST /admin/schemas/ddl
Generate schema DDL.
Request
Request Body
GenerateSchemaDDLReqBody
objects
array
Only when the action is more, this parameter is needed.
options
array
The options used to generate DDL. Select 0 or one or several options. Only when the action is more, this parameter is needed. - depobj = Generates the basic DDL statements. - privilege = Generate the authorization DDL statements such as GRANT statements.
stat_terminator
string
Specifies the statement delimiter for SQL statements that are generated. Only when the action is more, this parameter is needed.
Path Parameters
Query Parameters
action
Required *
string
Type of operation.
Response
200 - Generate schema DDL.
commands
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Create a new table
PUT /admin/tables
Create a new table.
Request
Request Body
CreateAlterTableReqBody
schema
Required *
string
Schema name of the object.
table
Required *
string
Unqualified name of the object.
objStorage
string
Use object storage or not.
column_info
Required *
array
Response
201 - The table was created successfully.
status
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Drop multiple tables
PUT /admin/tables/delete
Drop multiple tables.
Request
Request Body
DropTableReqBody
Response
200 - The alias was dropped successfully.
status
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get table definition
GET /admin/schemas/{schema_name}/tables/{table_name}/definition
Get table definition.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
table_name
Required *
string
Table name.
Query Parameters
Response
200 - Get table definition.
schema
string
Table schema.
comments
string
stats
ObjectStatus
columns
array
name
string
Table name.
status
string
Status of the object.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query table data
GET /admin/schemas/{schema_name}/tables/{table_name}/data
Fetches the table data up to a maximum of 100,000 rows. Currently it's not possible to retrieve data from tables that contain CLOB, BLOB or DBCLOB values.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
table_name
Required *
string
Table name.
Query Parameters
rows_return
integer
The amount of return records.
Response
200 - Returned result was successful.
columns
array
Column definitions
rows
array
Table rows
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get column detail properties
GET /admin/schemas/{schema_name}/tables/{table_name}/columns/{column_name}/properties
Get column detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
table_name
Required *
string
Table name.
column_name
Required *
string
Column name.
Query Parameters
Response
200 - Get column detail properties.
column_name
string
Name of the column.
table_name
string
Unqualified name of the table, view, or nickname that contains the column.
table_schema
string
Schema name of the table, view, or nickname that contains the column.
type_name
string
Unqualified name of the data type for the column.
length
string
Maximum length of the data; 0 for distinct types.
scale
string
Scale if the column type is DECIMAL or number of digits of fractional seconds if the column type is TIMESTAMP; 0 otherwise.
nulls
string
Nullability attribute for the column.
default
string
Default value for the column of a table expressed as a constant, special register, or cast-function appropriate for the data type of the column. Can also be the keyword NULL. Values might be converted from what was specified as a default value. For example, date and time constants are shown in ISO format, cast-function names are qualified with schema names, and identifiers are delimited. Null value if a DEFAULT clause was not specified or the column is a view column.
logged
string
Whether the column is logged.
compact
string
Whether the column is compacted.
compress
string
Compress.
identity
string
Identity.
generated
string
Type of generated column.
row_change_timestamp
string
Row change timestamp.
start
string
Start value of the sequence. The null value if the sequence is an alias.
increment
string
Increment value. The null value if the sequence is an alias.
min_value
string
Minimum value of the sequence. The null value if the sequence is an alias.
max_value
string
Maximum value of the sequence. The null value if the sequence is an alias.
cycle
string
Indicates whether or not the sequence can continue to generate values after reaching its maximum or minimum value.
cache
string
Number of sequence values to pre-allocate in memory for faster access. 0 indicates that values of the sequence are not to be preallocated. In a partitioned database, this value applies to each database partition. -1 if the sequence is an alias.
order
string
Indicates whether or not the sequence numbers must be generated in order of request.
inline_length
string
Maximum size in bytes of the internal representation of an instance of an XML document, a structured type, or a LOB data type, that can be stored in the base table; 0 when not applicable.
primary_key
string
Whether it is a primary key.
part_key_seq
string
The column's numerical position within the table's distribution key; 0 or the null value if the column is not in the distribution key. The null value for columns of subtables and hierarchy tables.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the metadata type
GET /admin/tables/meta/datatype
Get the metadata type.
Request
Response
200 - Get the metadata type.
default - Error payload
Generate table DDL
POST /admin/tables/ddl
Generate table DDL.
Request
Request Body
GenerateTableDDLReqBody
schema
Required *
string
Schema name of the object. Only When the action is create or alter, this parameter is needed.
table
Required *
string
Unqualified name of the object. Only When the action is create or alter, this parameter is needed.
objStorage
string
Use object storage or not.
column_info
Required *
array
Only When the action is create or alter, this parameter is needed.
objects
array
Only when the action is more, this parameter is needed.
options
array
The options used to generate DDL. Select 0 or one or several options. Only when the action is more, this parameter is needed. - create = Generates DDL statements with the CREATE OR REPLACE clause. - creatorname:creatorID = Generates DDL statements for objects that were created with the specified creator ID. - depobj = Generates the basic DDL statements - view = Generate the CREATE VIEW DDL statements - privilege = Generate the authorization DDL statements such as GRANT statements.
stat_terminator
string
Specifies the statement delimiter for SQL statements that are generated. Only when the action is more, this parameter is needed.
Path Parameters
Query Parameters
action
Required *
string
Type of operation.
Response
200 - Generate table DDL.
commands
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get distributin keys
GET /admin/schemas/{schema_name}/tables/{table_name}/distribution_keys
Get distributin keys.
Request
Path Parameters
schema_name
Required *
string
Schema name of the table.
table_name
Required *
string
Name of the table.
Query Parameters
Response
200 - Get distributin keys.
partition_mode
string
Indicates how data is distributed among database partitions in a partitioned database system.
keys
array
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get data distributin property
GET /admin/schemas/{schema_name}/tables/{table_name}/distributions/properties
Get data distributin property.
Request
Path Parameters
schema_name
Required *
string
Schema name of the table.
table_name
Required *
string
Name of the table.
Query Parameters
Response
200 - Get data distributin property.
primary_distribution_key
PrimaryDistributionKey
skew_data
SkewData
Table row counts.
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get partition expressions
GET /admin/schemas/{schema_name}/tables/{table_name}/partitions/expressions
Get partition expressions.
Request
Path Parameters
schema_name
Required *
string
Schema name of the table.
table_name
Required *
string
Name of the table.
Query Parameters
Response
200 - Get partition expressions.
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get data partitions
GET /admin/schemas/{schema_name}/tables/{table_name}/partitions
Get data partitions.
Request
Path Parameters
schema_name
Required *
string
Schema name of the table.
table_name
Required *
string
Name of the table.
Query Parameters
Response
200 - Get data partitions.
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Move tables
POST /admin/tables/move_activity
Move tables to another tablespace.
Request
Request Body
Response
200 - Move table started successfully.
status
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Move tables script
POST /admin/tables/move_activity/script
Get script of move tables to another tablespace.
Request
Request Body
Response
200 - Get move table script successfully.
script
array
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Copy tables
POST /admin/tables/copy_activity
Copy tables to another tablespace.
Request
Request Body
Response
200 - Copy table started successfully.
status
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Copy tables script
POST /admin/tables/copy_activity/script
Get script of copy tables to another tablespace.
Request
Request Body
Response
200 - Get copy table script successfully.
script
array
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the latest status after last updated time
POST /admin/tables/tasks/status
Get the latest status after last updated time.
Request
Request Body
GetTasksReqBody
last_updated_time
integer
Last updated time.
Response
200 - Get copy table script successfully.
last_updated_time
integer
Last updated time.
data
array
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query view detail properties
GET /admin/schemas/{schema_name}/views/{view_name}/properties
Query view detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the view.
view_name
Required *
string
Name of the view.
Query Parameters
Response
200 - Query view detail properties.
view_name
string
Unqualified name of the view.
view_schema
string
Schema name of the view.
view_check
string
View check.
read_only
string
Whether it is read-only.
valid
string
Whether it is valid.
optimize_query
string
Whether to optimize the query.
owner
string
Authorization ID of the owner of the view.
owner_type
string
Owner type.
create_time
string
Time at which the object was created.
alter_time
string
Time at which the object was last altered.
stats_time
string
Time at which any change was last made to recorded statistics for this object. The null value if statistics are not collected.
sql
string
Full text of the view CREATE statement, exactly as typed.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Drop multiple views
PUT /admin/views/delete
Drop multiple views.
Request
Request Body
DropViewReqBody
Response
200 - The alias was dropped successfully.
status
string
400 - Run sql exception.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query view data
GET /admin/schemas/{schema_name}/views/{view_name}/data
Query view data.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
view_name
Required *
string
View name.
Query Parameters
rows_return
integer
The amount of return records.
Response
200 - Returned result was successful.
columns
array
rows
array
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get View definition
GET /admin/schemas/{schema_name}/views/{view_name}/definition
Get view definition.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
view_name
Required *
string
View name.
Query Parameters
Response
200 - Get View definition.
schema
string
View schema.
comments
string
stats
ObjectStatus
columns
array
name
string
View name.
status
string
Status of the object.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Generate view DDL
POST /admin/views/ddl
Generate view DDL.
Request
Request Body
GenerateViewDDLReqBody
schema
string
Schema name. Only When the action is create or alter, this parameter is needed.
view
string
View name. This parameter is required to modify the view.
objects
array
Only when the action is more, this parameter is needed.
options
array
The options used to generate DDL. Select 0 or one or several options. Only when the action is more, this parameter is needed. - create = Generates DDL statements with the CREATE OR REPLACE clause. - creatorname:creatorID = Generates DDL statements for objects that were created with the specified creator ID. - depobj = Generates the basic DDL statements - privilege = Generate the authorization DDL statements such as GRANT statements.
stat_terminator
string
Specifies the statement delimiter for SQL statements that are generated. Only when the action is more, this parameter is needed.
Path Parameters
Query Parameters
action
Required *
string
Type of operation.
Response
200 - Generate view DDL.
commands
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the dependencies of the object
GET /admin/schemas/{schema_name}/{obj_type}/{object_name}/dependencies
Get the dependencies of the object.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
obj_type
Required *
string
Type of object.
object_name
Required *
string
Name of the object.
Query Parameters
Response
200 - Get the dependencies of the object.
references
array
dependencies
array
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the dependencies of the tablespace
GET /admin/tablespaces/{tablespace}/dependencies
Get the dependencies of the tablespace.
Request
Path Parameters
tablespace
Required *
string
Tablespace name.
Query Parameters
Response
200 - Get the dependencies of the object.
references
array
dependencies
array
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query bufferpool detail properties
GET /admin/bufferpools/{bufferpool_name}/properties
Query bufferpool detail properties.
Request
Path Parameters
bufferpool_name
Required *
string
Name of the object.
Query Parameters
Response
200 - Returned result was successful.
bufferpool_name
string
Name of the buffer pool.
automatic
string
Whether the buffer pool is automatically managed by DB2.
block_size
string
Number of pages in a block.
npages
string
Default number of pages in this buffer pool on database partitions in this database partition group.
num_block_pages
string
Number of pages of the buffer pool that are to be in a block-based area. A block-based area of the buffer pool is only used by prefetchers doing a sequential prefetch.
page_size
string
Page size for this buffer pool on database partitions in this database partition group.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query constraint detail properties
GET /admin/schemas/{schema_name}/tables/{table_name}/constraints/{constraint_name}/properties
Query constraint detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
table_name
Required *
string
Table name.
constraint_name
Required *
string
Name of the constraint.
Query Parameters
Response
200 - Returned result was successful.
constraint_name
string
Name of the constraint.
table_name
string
Unqualified name of the table to which this constraint applies.
table_schema
string
Schema name of the table to which this constraint applies.
type
string
Indicates the constraint type.
ref_member
string
Referencing key.
ref_table_name
string
Referencing table.
ref_table_schema
string
Referencing schema.
enforced
string
Whether it is a enforce constraint.
member
string
Members.
update_rule
string
Update rule.
delete_rule
string
Delete rule.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query index detail properties
GET /admin/schemas/{schema_name}/tables/{table_name}/indexes/{index_name}/properties
Query index detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
table_name
Required *
string
Table name.
index_name
Required *
string
Name of the index.
Query Parameters
Response
200 - Returned result was successful.
index_name
string
Unqualified name of the index.
index_schema
string
Schema name of the index.
member
string
Name of the column.
table_name
string
Unqualified name of the table or nickname on which the index is defined.
table_schema
string
Schema name of the table or nickname on which the index is defined.
table_space
string
Name of the table space.
index_type
string
Type of index.
unique
string
Whether it is unique.
cluster
string
Whether it is a clustering index
compression
string
Specifies whether index compression is activated
reverse_scans
string
Whether the index supports reverse scanning
percent_free
string
Percentage of each index page to be reserved during the initial building of the index.
level2pctfree
string
Percentage of each index level 2 page to be reserved during initial building of the index.
owner
string
Authorization ID of the owner of the index.
owner_type
string
Owner type.
system_generated
string
Whether it is system generated.
create_time
string
Time when the index was created.
last_used
string
Date when the index was last used by any DML statement to perform a scan, or used to enforce referential integrity constraints. This column is not updated when the index is used on an HADR standby database, nor is it updated when rows are inserted into the table on which the index is defined. The default value is '0001-01-01'. This value is updated asynchronously not more than once within a 24 hour period and might not reflect usage within the last 15 minutes.
stats_time
string
Last time that any change was made to the recorded statistics for this index. The null value if no statistics are available.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query trigger detail properties
GET /admin/schemas/{schema_name}/triggers/{trigger_name}/properties
Query trigger detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
trigger_name
Required *
string
Name of the trigger.
Query Parameters
Response
200 - Returned result was successful.
trigger_name
string
Unqualified name of the trigger.
table_name
string
Unqualified name of the table or view to which this trigger applies.
table_schema
string
Schema name of the table or view to which this trigger applies.
trigger_schema
string
Schema name of the trigger.
trigger_time
string
Time at which triggered actions are applied to the base table, relative to the event that fired the trigger.
trigger_event
string
Event that fires the trigger.
granularity
string
evel of granularity.
valid
string
Whether the trigger is valid.
secure
string
Indicates whether the trigger is secure for row and column access control.
text
string
Full text of the CREATE TRIGGER statement, exactly as typed.
remarks
string
User-provided comments, or the null value.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query MQT detail properties
GET /admin/schemas/{schema_name}/mqts/{mqt_name}/properties
Query MQT detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
mqt_name
Required *
string
Name of the MQT.
Query Parameters
Response
200 - Returned result was successful.
table_name
string
Unqualified name of the materialized query table.
table_schema
string
Schema name of the materialized query table.
tablespace
string
Name of the primary table space for the table.
index_tablespace
string
Name of the table space that holds all indexes created on this table.
long_tablespace
string
Name of the table space that holds all long data (LONG or LOB column types) for this table.
owner
string
Authorization ID of the owner of the materialized query table.
owner_type
string
Owner type.
table_org
string
Table organization.
value_compression
string
Compression mode for the table.
row_compression
string
Row compression mode for the table.
refresh
string
Refresh mode.
pctfree
string
Percentage of each page to be reserved for future inserts.
drop_rule
string
Drop rule.
volatile
string
Volatile.
append_mode
string
For row-organized tables, controls how rows are inserted into pages.
data_capture
string
Data capture.
lock_size
string
Indicates the preferred lock granularity for tables that are accessed by data manipulation language (DML) statements.
not_logged_initially
string
Specifies whether the created temporary table is logged.
refresh_time
string
For REFRESH = 'D' or 'O', time at which the data was last refreshed (REFRESH TABLE statement); null value otherwise.
create_time
string
Time at which the object was created.
alter_time
string
Time at which the object was last altered.
stats_time
string
Time at which any change was last made to recorded statistics for this object. The null value if statistics are not collected.
maintained_by
string
Properties for a table.
sql
string
Full text of the materialized query table CREATE statement, exactly as typed.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query UDF detail properties
GET /admin/schemas/{schema_name}/functions/{specific_name}/properties
Query UDF detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
specific_name
Required *
string
Name of the UDF.
Query Parameters
Response
200 - Returned result was successful.
udf_name
string
Name of the UDF.
udf_schema
string
Schema name of the UDF.
text
string
The full text of the CREATE FUNCTION statement.
specific_name
string
Name of the routine instance (might be system-generated).
language
string
Implementation language for the routine body (or for the source function body, if this function is sourced on another function).
parameter_style
string
Parameter style that was declared when the routine was created.
sql_data_access
string
Indicates what type of SQL statements, if any, the database manager should assume is contained in the routine.
deterministic
string
Whether the result is deterministic.
external_action
string
Whether the function has external side-effects.
commit_on_return
string
Indicates whether the transaction is committed on successful return from this procedure.
parallel
string
Whether the routine can be executed in parallel.
fenced
string
Indicates if there is a fence.
implementation
string
Implementation
owner
string
Authorization ID of the owner.
owner_type
string
Owner type.
create_time
string
Time at which the object was created.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query tablespace detail properties
GET /admin/tablespaces/{table_space}/properties
Query tablespace detail properties.
Request
Path Parameters
table_space
Required *
string
Tablespace name of the object.
Query Parameters
Response
200 - Returned result was successful.
tablespace_name
string
Name of the table space.
db_partition_group
string
Name of the database partition group that is associated with this table space.
buffer_pool_name
string
Name of the buffer pool.
storage_group_name
string
Name of the storage group the table space is using.
tbspace_data_type
string
Type of data that can be stored in this table space.
tablespace_type
string
Type of table space.
reclaimable
string
Indicates if it is reclaimable.
drop_recovery
string
Indicates whether or not tables in this table space can be recovered after a drop table operation.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query procedure detail properties
GET /admin/schemas/{schema_name}/procedures/{specific_name}/properties
Query procedure detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
specific_name
Required *
string
Name of the procedure.
Query Parameters
Response
200 - Returned result was successful.
stored_procedure_name
string
Name of the procedure.
stored_procedure_schema
string
Schema name of the procedure.
text
string
The full text of the CREATE PROCEDURE statement.
specific_name
string
Name of the routine instance (might be system-generated).
language
string
Implementation language for the routine body (or for the source function body, if this function is sourced on another function).
parameter_style
string
Parameter style that was declared when the routine was created.
sql_data_access
string
Indicates what type of SQL statements, if any, the database manager should assume is contained in the routine.
deterministic
string
Whether the result is deterministic.
external_action
string
Whether the function has external side-effects.
commit_on_return
string
Indicates whether the transaction is committed on successful return from this procedure.
parallel
string
Whether the routine can be executed in parallel.
fenced
string
Indicates if there is a fence.
implementation
string
Implementation.
owner
string
Authorization ID of the owner.
owner_type
string
Owner type.
create_time
string
Time at which the object was created.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query sequence detail properties
GET /admin/schemas/{schema_name}/sequences/{sequence_name}/properties
Query sequence detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
sequence_name
Required *
string
Name of the sequence.
Query Parameters
Response
200 - Returned result was successful.
sequence_name
string
Unqualified name of the sequence.
sequence_schema
string
Schema name of the sequence.
type_name
string
Unqualified name of the data type.
precision
string
Precision of the data type of the sequence.
start
string
Start value of the sequence.
increment
string
Increment value.
min_value
string
Maximum value of the sequence.
max_value
string
Minimum value of the sequence.
cycle
string
Indicates whether or not the sequence can continue to generate values after reaching its maximum or minimum value.
cache
string
Number of sequence values to pre-allocate in memory for faster access.
order
string
Indicates whether or not the sequence numbers must be generated in order of request.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query package detail properties
GET /admin/schemas/{schema_name}/packages/{package_name}/properties
Query package detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
package_name
Required *
string
Name of the package.
Query Parameters
Response
200 - Returned result was successful.
package_name
string
Unqualified name of the package.
package_schema
string
Schema name of the package.
default_schema
string
Default schema name used for unqualified names in static SQL statements.
bound_by
string
Authorization ID of the binder and owner of the package.
owner
string
Authorization ID of the binder and owner of the package.
blocking
string
Cursor blocking option.
total_sect
string
Number of sections in the package.
query_opt
string
Optimization class under which this package was bound. Used for rebind operations.
explain_snapshot
string
Value of the EXPLSNAP bind option.
func_path
string
SQL path in effect when the package was bound.
statement
string
Text of the SQL statement.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query UDT detail properties
GET /admin/schemas/{schema_name}/udts/{type_name}/properties
Query UDT detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
type_name
Required *
string
Name of the user-defined type.
Query Parameters
Response
200 - Returned result was successful.
type_name
string
Unqualified name of the data type.
type_schema
string
Schema name of the module to which the data type belongs.
length
string
Maximum length of the type.
scale
string
Scale for distinct types or reference representation types based on the built-in DECIMAL type; the number of digits of fractional seconds for distinct types based on the built-in TIMESTAMP type; 6 for the built-in TIMESTAMP type; 0 for all other types (including DECIMAL itself).
source_name
string
For distinct types or array types, the unqualified name of the source data type. For user-defined structured types, the unqualified built-in type name of the reference representation type. Null for other data types.
source_schema
string
For distinct types or array types, the schema name of the source data type. For user-defined structured types, the schema name of the built-in type of the reference representation type. Null for other data types.
meta_type
string
Meta type.
remarks
string
User-provided comments
instantiable
string
Indicates whether the type can be instantiated.
final
string
Indicates whether the user-defined type can have subtypes.
inline_length
string
Maximum length of a structured type that can be kept with a base table row; 0 otherwise.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query alias detail properties
GET /admin/schemas/{schema_name}/aliases/{alias_name}/properties
Query alias detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
alias_name
Required *
string
Alias name.
Query Parameters
Response
200 - Query alias detail properties.
alias_name
string
Unqualified name of the object.
alias_schema
string
Schema name of the object.
base_obj_name
string
The name of the object referenced by the alias.
base_obj_schema
string
The schema name of the object referenced by the alias.
owner
string
Authorization ID of the owner.
owner_type
string
Owner type.
create_time
string
Time at which the object was created.
alter_time
string
Time at which the object was last altered.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Schema or alias not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get table detail properties
GET /admin/schemas/{schema_name}/tables/{table_name}/properties
Get table detail properties.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
table_name
Required *
string
Table name.
Query Parameters
Response
200 - Get table detail properties.
table_name
string
Unqualified name of the object.
table_schema
string
Schema name of the object.
obj_type
string
Type of object.
tablespace
string
Name of the primary table space for the table.
index_tablespace
string
Name of the table space that holds all indexes created on this table.
long_tablespace
string
Name of the table space that holds all long data (LONG or LOB column types) for this table.
table_org
string
Table organization.
temporal_type
string
Type of temporal table.
drop_rule
string
Drop rule.
volatile
string
Volatile.
value_compression
string
Compression mode for the table.
row_compression
string
Row compression mode for the table.
clustered
string
Clustered.
partition_mode
string
Indicates how data is distributed among database partitions in a partitioned database system.
avg_row_size
string
Average length (in bytes) of both compressed and uncompressed rows in this table; -1 if statistics are not collected.
table_status
string
Status of the object.
append_mode
string
For row-organized tables, controls how rows are inserted into pages.
primary_key
string
Primary key.
row_count
string
Total number of rows in the table; -1 if statistics are not collected.
create_time
string
Time at which the object was created.
last_used
string
Date when the table was last used by any DML statement or the LOAD command.
alter_time
string
Time at which the object was last altered.
stats_time
string
Time at which any change was last made to recorded statistics for this object. The null value if statistics are not collected.
pctfree
string
Percentage of each page to be reserved for future inserts.
data_capture
string
Data capture.
lock_size
string
Indicates the preferred lock granularity for tables that are accessed by data manipulation language (DML) statements.
not_logged_initially
string
Specifies whether the created temporary table is logged.
owner
string
Authorization ID of the owner.
owner_type
string
Owner type.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Object not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Create alias
PUT /admin/aliases
Create alias.
Request
Request Body
AliasObject
base_obj_schema
string
The schema of the object based.
base_obj_name
string
The name of the object based.
alias_name
string
Alias name.
alias_schema
string
Alias schema.
Response
200 - The alias was created successfully.
status
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Drop multiple aliases
PUT /admin/aliases/delete
Drop multiple alias.
Request
Request Body
DropAliasArray
Response
200 - The alias was dropped successfully.
status
string
400 - Invalid parameters or run sql exception.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Generate Alias DDL
POST /admin/aliases/ddl
Generate Alias DDL.
Request
Request Body
GenerateAliasDDLReqBody
base_obj_schema
string
The schema of the object based. Only When the action is create, this parameter is needed.
base_obj_name
string
The name of the object based. Only When the action is create, this parameter is needed.
alias_name
string
Alias name. Only When the action is create, this parameter is needed.
alias_schema
string
Alias schema. Only When the action is create, this parameter is needed.
objects
array
Only when the action is more, this parameter is needed.
options
array
The options used to generate DDL. Select 0 or one or several options. Only when the action is more, this parameter is needed. - create = Generates DDL statements with the CREATE OR REPLACE clause. - creatorname:creatorID = Generates DDL statements for objects that were created with the specified creator ID. - depobj = Generates the basic DDL statements - view = Generate the CREATE VIEW DDL statements - privilege = Generate the authorization DDL statements such as GRANT statements.
stat_terminator
string
Specifies the statement delimiter for SQL statements that are generated. Only when the action is more, this parameter is needed.
Path Parameters
Query Parameters
action
Required *
string
Type of operation.
Response
200 - Generate Alias DDL.
commands
string
400 - Invalid parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Query alias data
GET /admin/schemas/{schema_name}/aliases/{alias_name}/data
Query alias data.
Request
Path Parameters
schema_name
Required *
string
Schema name of the object.
alias_name
Required *
string
Alias name.
Query Parameters
rows_return
integer
The amount of return records.
Response
200 - Returned result was successful.
columns
array
rows
array
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Schema or alias not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the SQL statement template for creating MQT table
POST /admin/mqts/ddl
Get the SQL statement template for creating MQT table.
Request
Request Body
GenerateMQTDDLReqBody
schema
string
Schema name of the object. Only When the action is create, this parameter is needed.
objects
array
Only when the action is more, this parameter is needed.
options
array
The options used to generate DDL. Select 0 or one or several options. Only when the action is more, this parameter is needed. - create = Generates DDL statements with the CREATE OR REPLACE clause. - creatorname:creatorID = Generates DDL statements for objects that were created with the specified creator ID. - depobj = Generates the basic DDL statements - view = Generate the CREATE VIEW DDL statements - privilege = Generate the authorization DDL statements such as GRANT statements.
stat_terminator
string
Specifies the statement delimiter for SQL statements that are generated. Only when the action is more, this parameter is needed.
Path Parameters
Query Parameters
action
Required *
string
Response
200 - The SQL statement of creating MQT table
commands
string
400 - Get error when create MQT table
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Delete multiple mqt tables
PUT /admin/mqts/delete
Delete mutliple mqt tables.
Request
Request Body
deleteMqtReqBody
Response
200 - The status of deleting MQT tables
status
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the definition of MQT table
GET /admin/schemas/{schema_name}/mqts/{mqt_name}/definition
Get the definition of MQT table.
Request
Path Parameters
schema_name
Required *
string
Schema name
mqt_name
Required *
string
mqt name
Query Parameters
Response
200 - Definition of MTQ table
schema
string
comments
string
stats
adminStats
columns
array
name
string
status
string
400 - Error information when get mqt definition
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the data of specified mqt table
GET /admin/schemas/{schema_name}/mqts/{mqt_name}/data
Get the data of specified mqt table.
Request
Path Parameters
schema_name
Required *
string
mqt_name
Required *
string
Query Parameters
rows_return
integer
Response
200 - Get the data of MQT table,include table columns information and data
columns
array
rows
array
400 - Error information when get mqt data
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get authentications through the authid filter
GET /admin/privileges/authentications
Get authentications through the authid filter
Request
Path Parameters
Query Parameters
rows_return
integer
0 means return all query results
authid
Required *
string
Response
200 - The list of authid and authid type
400 - Get error when search authid
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the privieles of auth id
GET /admin/privileges/{authid_type}/{authid}/{obj_type}
Get the privieles of auth id
Request
Path Parameters
authid_type
Required *
string
authid type
authid
Required *
string
Authorization id.
obj_type
Required *
string
Type of object
Query Parameters
rows_return
integer
Response
200 - Returned result was successful.
400 - Get error when get privileges
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get SQL statement of grant or revoke privileges
POST /admin/privileges/dcl
Get SQL statement of grant or revoke privileges
Request
Request Body
privilegesChangeDclReqBody
Response
201 - SQL statement for grant or revoke privileges
commands
string
400 - Get error when get privileges
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Add new role
POST /admin/privileges/roles
Add new role
Request
Request Body
rolesReqBody
authid
string
Response
201 - The status of adding new role
status
string
400 - Get error when add new roles
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Grant or revoke the privilges of role
PUT /admin/privileges/roles
Grant or revoke the privilges of role
Request
Request Body
privilegesChangeRoleReqBody
stop_on_error
boolean
privileges
array
Response
200 - The status of grant or revoke the role's privileges
status
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Delete one role
DELETE /admin/privileges/roles/{role_name}
Delete one role
Request
Path Parameters
role_name
Required *
string
Query Parameters
Response
200 - The status of deleting one role
status
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the membership of authid
GET /admin/privileges/roles/{authid_type}/{authid}
Get the membership of authid
Request
Path Parameters
authid_type
Required *
string
authid type
authid
Required *
string
authid
Query Parameters
rows_return
Required *
integer
Response
200 - The membership of one auth
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get SQL statement of grant or revoke role
POST /admin/privileges/roles/dcl
Get SQL statement of grant or revoke role
Request
Request Body
privilegesChangeRoleDclReqBody
Response
201 - The SQL statement of grant or revoke role
commands
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get SQL statement for grant or revoke privileges
POST /admin/privileges/multiple_objtypes/dcl
Get SQL statement for grant or revoke privileges
Request
Request Body
PrivilegesMultipleObjectTypeChangeDclReqBody
grantee
array
privileges
array
Response
201 - The SQL statement for grant or revoke privileges
commands
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Grant or revole privileges for multiple objects and objects type
PUT /admin/privileges/multiple_objtypes
Grant or revole privileges for multiple objects and objects type
Request
Request Body
PrivilegesMultipleObjectTypeChangeReqBody
grantee
array
privileges
array
stop_on_error
boolean
Response
200 - The status of grant or revoke privileges
status
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the SQL statement for grant or revoke multiple roles
POST /admin/privileges/multiple_roles/dcl
Get the SQL statement for grant or revoke multiple roles
Request
Request Body
privilegesMultipleRolesChangeDclReqBody
Response
201 - The SQL statement for grant or revoke multiple roles
commands
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Grant or revoke multiple roles
PUT /admin/privileges/multiple_roles
Grant or revoke multiple roles
Request
Request Body
privilegesMultipleRolesChangeReqBody
privileges
array
stop_on_error
boolean
Response
200 - The status of grant or revoke roles
status
string
400 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Error payload
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Generate workload DDL
POST /admin/workloads/ddl
Generate workload DDL.
Request
Request Body
CreateWorkloadsReqBody
categorization
string
Type of the connection attribute.
enable_coll_act_data
boolean
Enable collect activity data or not.
Path Parameters
Query Parameters
action
Required *
string
Type of operation.
Response
200 - Return the ddl of creating workloads.
commands
string
400 - Invalid parameters or miss some parameters
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Lists workloads
GET /admin/workloads
Returns the list of workloads.
Request
Path Parameters
Query Parameters
rows_return
string
The amount of return records.
search_name
string
Workload name.
Response
200 - Return the list of workloads
default - Error payload
Drop multiple sequences
PUT /admin/sequences/delete
Drop multiple sequences
Request
Request Body
sequencesDropList
Response
200 - The status of dropping sequences
status
string
400 - Faile to drop sequences
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Drop multiple procedures
PUT /admin/procedures/delete
Drop multiple procedures
Request
Request Body
ProceduresDropReqBody
Response
200 - Delete procedure successfully
status
string
400 - Faile to drop procedures
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Retrieve parameters for procedure
GET /admin/schemas/{schema_name}/procedures/{specific_name}/parameters
Retrieve parameters for procedure.
Request
Path Parameters
schema_name
Required *
string
The schema name of the procedure
specific_name
Required *
string
The specificname of procedure
Query Parameters
Response
200 - Retrieve parameters for procedure.
400 - Error information when get procedure parameters.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Generate create procedure template
POST /admin/procedures/ddl
Request
Request Body
CreateProceduresTemplate
schema
string
The schema name of procedure.
Path Parameters
Query Parameters
action
Required *
string
Response
200 - Generate the template of creating procedure
commands
string
400 - Faile to generate create procedure template
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Drop multiple functions
PUT /admin/functions/delete
Drop multiple functions
Request
Request Body
DropFunctionsReqBody
Response
200 - Delete function successfully
status
string
400 - Faile to drop functions
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Retrieve parameters for specific udf
GET /admin/schemas/{schema_name}/functions/{specific_name}/parameters
Retrieve parameters for specific udf.
Request
Path Parameters
schema_name
Required *
string
The schema name of the function.
specific_name
Required *
string
The specific name of function.
Query Parameters
Response
200 - Retrieve parameters for specific udf.
400 - Error information when get procedure parameters
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Generate create function template
POST /admin/functions/ddl
Request
Request Body
CreateFunctionTemplateReqBody
schema
string
The schema name of function.
Path Parameters
Query Parameters
action
Required *
string
Response
200 - Generate the template of creating function.
commands
string
400 - Faile to generate create function template.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - SQLException
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Drop multiple User-defined Types
PUT /admin/udts/delete
Drop multiple User-defined Types
Request
Request Body
DropUDTArray
Response
200 - The UDTs was dropped successfully.
status
string
400 - Invalid parameters or run sql exception.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Retrieve row definition for User-defined Type object
GET /admin/schemas/{schema_name}/udts/{udt_name}/definition
Retrieve row definition for User-defined Type object
Request
Path Parameters
schema_name
Required *
string
The schema name of User-defined Type.
udt_name
Required *
string
The name of User-defined Type.
Query Parameters
Response
200 - Retrieve row definition for User-defined Type object.
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Schema or alias not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Generate Create User-defined Types template
POST /admin/udts/ddl
Generate Create User-defined Types template.
Request
Request Body
UDTDDLReqBody
schema
string
Schema name of UDT.
Path Parameters
Query Parameters
action
Required *
string
Type of operation.
Response
200 - Generate Create User-defined Types template.
commands
string
403 - Not authorized.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Schema or alias not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Deletes a file in the Db2 temporary cloud object storage
DELETE /home/{path}
Deletes a file in the Db2 temporary cloud object storage.
Request
Path Parameters
path
Required *
string
File path
Query Parameters
Response
200 - File deleted
default - Error payload
Download file from Db2 temporary cloud object storage
GET /home_content/{path}
Download file from Db2 temporary cloud object storage.
Request
Path Parameters
path
Required *
string
File path
Query Parameters
Response
200 - Metadata about a file or folder
location
string
Relative URL path for this file or folder.
size
integer
Size in bytes. The size of a folder is the sum of the files directly under it, excluding subfolders.
contents
array
List of files and folders
404 - File not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Uploads a file to Db2 temporary cloud object storage
POST /home_content/{path}
Uploads a file to Db2 temporary cloud object storage.
Request
Path Parameters
path
Required *
string
Target folder
Query Parameters
Response
201 - Files successfully uploaded
default - Error payload
Lists all data load jobs using Db2 load utility technology
GET /load_jobs
Lists all data load jobs for the user.
Request
Response
200 - Data load jobs
default - Error payload
Creates a data load job
POST /load_jobs
Creates a data load job.
Request
Request Body
DataLoadJobRequest
Data load job details
load_source
Required *
string
Type of data source. It can take the values 'SERVER', 'S3', or 'IBMCloud'.
load_action
string
If set to 'INSERT' data is appended to the existing table data. If set to 'REPLACE' the table data is replaced with the data being loaded.
schema
Required *
string
Schema name where the target table is located
table
Required *
string
Table name where data should be loaded
max_row_count
integer
Maximum number of rows to be loaded. If set to zero or not specified, all rows from the source data are loaded. Not supported in multi-partitioned (MPP) IBM Db2 Warehouse SaaS environments.
max_warning_count
integer
Maximum number of warnings that are tolerated before failing the load operation. A warning is generated for each row that is not loaded correctly.
cloud_source
object
Required when load_type is set to "S3" or "SOFTLAYER". It specifies how to located the data to be loaded from a cloud storage service.
endpoint
Required *
string
URL of the cloud storage endpoint where data is located. Amazon S3 valid endpoints are "s3.amazonaws.com", "s3.us-east-2.amazonaws.com", "s3-us-west-1.amazonaws.com, "s3-us-west-2.amazonaws.com", "s3.ca-central-1.amazonaws.com", "s3.ap-south-1.amazonaws.com", "s3.ap-northeast-2.amazonaws.com", "s3-ap-southeast-1.amazonaws.com", "s3-ap-southeast-2.amazonaws.com", "s3-ap-northeast-1.amazonaws.com", "s3.eu-central-1.amazonaws.com", "s3-eu-west-1.amazonaws.com", "s3.eu-west-2.amazonaws.com", "s3-sa-east-1.amazonaws.com". SoftLayer object storage valid endpoints are "https://ams01.objectstorage.softlayer.net/auth/v1.0", "https://che01.objectstorage.softlayer.net/auth/v1.0", "https://dal05.objectstorage.softlayer.net/auth/v1.0", "https://fra02.objectstorage.softlayer.net/auth/v1.0", "https://hkg02.objectstorage.softlayer.net/auth/v1.0", "https://lon02.objectstorage.softlayer.net/auth/v1.0", "https://mel01.objectstorage.softlayer.net/auth/v1.0", "https://mex01.objectstorage.softlayer.net/auth/v1.0", "https://mil01.objectstorage.softlayer.net/auth/v1.0", "https://mon01.objectstorage.softlayer.net/auth/v1.0", "https://par01.objectstorage.softlayer.net/auth/v1.0", "https://sao01.objectstorage.softlayer.net/auth/v1.0", "https://seo01.objectstorage.softlayer.net/auth/v1.0", "https://sjc01.objectstorage.softlayer.net/auth/v1.0", "https://sng01.objectstorage.softlayer.net/auth/v1.0", "https://syd01.objectstorage.softlayer.net/auth/v1.0", "https://tok02.objectstorage.softlayer.net/auth/v1.0", "https://tor01.objectstorage.softlayer.net/auth/v1.0", "https://wdc.objectstorage.softlayer.net/auth/v1.0".
path
Required *
string
Path used to find and retrieve the data in the cloud storage service
auth_id
Required *
string
Username (SoftLayer) or Access Key (S3).
auth_secret
Required *
string
API Key (SoftLayer) or Secret Key (S3).
server_source
object
Required when load_type is set to "SERVER". It specifies how to source filein the server.
file_path
Required *
string
File path in the server relative to the user's home folder.
file_options
Required *
object
Modifies how the source data should be interpreted
code_page
string
The character encoding of the source file. Valid values are listed in <a target="_blank" href="https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.nls.doc/doc/r0004565.html">Supported territory codes and code pages</a>. Default value is "1208" (corresponds to UTF-8).
has_header_row
string
Specifies whether or not the source file includes column names in a header row. IBM Db2 SaaS does not support this function, so the only acceptable value is NO.
column_delimiter
string
Single character used as column delimiter. Default value is comma (","). The character can also be specified using the format 0xJJ, where JJ is the hexadecimal representation of the character. Valid delimiters can be hexadecimal values from 0x00 to 0x7F, except for binary zero (0x00), line-feed (0x0A), carriage return (0x0D), space (0x20), and decimal point (0x2E).
date_format
string
A valid date format, such as "DD-MM-YY", "YYYY-MMM-DD", "DD/MM/YYY", "M/D/YYYY", "M/DD", "YYYY". For a full list of supported formats, see <a target="_blank" href=" https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008305.html">Valid file type modifiers for the load utility - ASCII file formats (ASC/DEL)</a>, in the LOAD command reference.
time_format
string
A valid time format, such as "HH-MM-SS", "H:MM:SS TT", "HH:MM", "H:MM TT", "H:M", "H:M:S". For a full list of supported formats, see <a target="_blank" href="https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008305.html">Valid file type modifiers for the load utility - ASCII file formats (ASC/DEL)</a>, in the LOAD command reference.
timestamp_format
string
A valid timestamp format, such as "YYYY-MM-DD HH:MM:SS", "DD/MM/YYYY H:MM TT", "MMM DD YYYY HH:MM:SS TT". For a full list of supported formats, see <a target="_blank" href="https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008305.html">Valid file type modifiers for the load utility - ASCII file formats (ASC/DEL)</a>, in the LOAD command reference.
Response
201 - load jobs.
default - Error payload
Returns details about a load job including its progress
GET /load_jobs/{id}
Returns details about a load job including its progress.
Request
Path Parameters
id
Required *
string
Load job ID
Query Parameters
Response
200 - Data load job
id
string
Load job ID
userid
string
User ID of who requested the load
status
DataLoadJobStatus
Execution status of a data load job
request
DataLoadJobRequest
Data load request
metadata
ResourceMetadata
Meta information of an resource. Metadata is ready-only and values are auto-generated by the system.
403 - Not authorized to access load job
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Job not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Removes load job from history
DELETE /load_jobs/{id}
Removes a data load job from history. This operation has no effect on the data already loaded. In-progress jobs cannot be deleted.
Request
Path Parameters
id
Required *
string
Load job ID
Query Parameters
Response
200 - Load job deleted
403 - Not authorized to delete load job
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Job not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Downloads log file for a data load job
GET /load_jobs/{log_path}/log
Downloads log file for a data load job
Request
Path Parameters
log_path
Required *
string
Base64 encode and URL encode with ([deployment id]/[log file name]) the log file name we can get from /load_jobs/{id}
Query Parameters
Response
200 - Log file
403 - Not authorized to access load log
404 - Log not found
default - Error payload
Analyzes CSV data to return a list of value data types
POST /schema_discovery
Schema discovery analyzes data in CSV format and returns a list of suggested data types that can be used when creating a table to store the CSV data.
Request
Request Body
SchemaDiscoveryCSVRequest
Data to analyze
column_separator
Required *
string
Single character can be used as column delimiter. The character can also be specified using the format 0xJJ, where JJ is the hexadecimal representation of the character. Valid delimiters can be hexadecimal values from 0x00 to 0x7F, except for binary zero (0x00), line-feed (0x0A), carriage return (0x0D), space (0x20), and decimal point (0x2E).
includes_header
Required *
string
Accepts values 'yes' and 'no'. The value 'yes' indicates the first row is a header with the column names and should be ignored whe analyzing the data. The value 'no' indicates all rows will be considered for analysis.
data
Required *
string
The CSV data to analyze. It should be in json array string format, such as ['Title, Year, Producer','City of God,2002, Katia Lund','Rain,1292,Christine Jeffs','2001: A Space Odyssey,1969, Stanley Kubrick'].
Response
200 - Suggested table schema
columns
array
dateStyle
string
External table option.
dateDelimiter
string
External table option.
timeStyle
string
External table option.
timeDelimiter
string
External table option.
default - Error payload
Executes SQL statements
POST /sql_jobs
Executes one or more SQL statements as a background job. This endpoint returns a job ID that can be used to retrieve the results.
Request
Request Body
SQLJobCreate
SQL script and execution options
commands
Required *
string
The SQL script to be executed
limit
Required *
integer
Maximum number of rows that will be fetched for each result set.
separator
Required *
string
SQL statement terminator. A character that is used to mark the end of a SQL statement when the provided SQL script contains multiple statements.
stop_on_error
Required *
string
If 'yes', the job stops executing at the first statement that returns an error. If 'no', the job continues executing if one or more statements returns an error.
Response
201 - SQL execution job
id
string
The SQL execution job ID
commands_count
integer
Number of SQL statements to be executed
limit
integer
Maximum number of rows that will be fetched for each result set
default - Error payload
Fetches partial results of a SQL job execution
GET /sql_jobs/{id}
Returns the current status of a SQL job execution along with any results of SQL statements that have already been executed. Clients are supposed to poll this endpoint until the status returned is either 'completed', which indicates all SQL statements have completed executing, or 'failed', which indicates the job failed to execute and therefore is considered terminated. The returned list of results is not cumulative. That means, results that were fetched in a previous call will not be returned again, only new results (i.e. that were not fetched yet) will be included. For example, assuming a job with 10 SQL statements, the first call returns status "running" and 6 results, the second call returns status "running" and an empty list of results, a third call status "completed" and 4 results. Any subsequent calls would return status "completed" and an empty list of results.
Request
Path Parameters
id
Required *
string
ID of the SQL execution job
Query Parameters
Response
200 - Result of a SQL job
id
string
The SQL execution job ID
status
string
Job status
results
array
default - Error payload
Returns the results of a SQL query to CSV
POST /sql_query_export
Executes the specified SQL query and returns the data as a CSV file. The amount of data returned is limited to 100,000 rows.
Request
Request Body
SQLStatement
The SQL query to be executed
command
Required *
string
The SQL statement to execute
Response
200 - CSV file containing query results
default - Error payload
Gets overall status of system components
GET /monitor
Gets overall status of system components.
Request
Path Parameters
Query Parameters
Response
200 - System status
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Lists active database connections DB ADMIN ONLY
GET /monitor/connections
Gets a list of active database connections.
Request
Path Parameters
Query Parameters
Response
200 - Active connections
count
integer
Number of elements
resources
array
List of active connections
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Terminates a database connection DB ADMIN ONLY
DELETE /monitor/connections/{application_handle}
Terminates an active database connection.
Request
Path Parameters
application_handle
Required *
string
Application handle name
Query Parameters
Response
200 - Connection terminated
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets current storage usage DB ADMIN ONLY
GET /monitor/storage
Gets current storage usage.
Request
Path Parameters
Query Parameters
Response
200 - Storage usage
name
string
Describes the storage unit.
capacity_kb
integer
Total capacity, reported in kilobytes.
used_kb
integer
Storage space in use, reported in kilobytes.
available_kb
integer
Storage space available, reported in kilobytes.
collected_at
string
When the metrics were collected.
default - Error payload
Gets storage usage history DB ADMIN ONLY
GET /monitor/storage/history
Gets a list of storage usage daily stats. Currenlty the history of the last seven days is returned.
Request
Path Parameters
Query Parameters
Response
200 - Storage usage history
count
integer
Number of elements
resources
array
List of elements
default - Error payload
Storage utilization by schema DB ADMIN ONLY
GET /monitor/storage/by_schema
Gets a list where each element represents a schema and its corresponding logical and physical sizes. Physical size is the amount of storage in disk allocated to objects in the schema. Logical size is the actual object size, which might be less than the physical size (e.g. in the case of a logical table truncation).
Request
Path Parameters
Query Parameters
Response
200 - Storage usage by schema
count
integer
Number of elements
resources
array
List of schema's storage usage data
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Storage utilization of a schema DB ADMIN ONLY
GET /monitor/storage/by_schema/{schema_name}
Gets logical and physical sizes for one schema. Physical size is the amount of storage in disk allocated to objects in the schema. Logical size is the actual object size, which might be less than the physical size (e.g. in the case of a logical table truncation).
Request
Path Parameters
schema_name
Required *
string
Schema name
Query Parameters
Response
200 - Storage usage for a schema
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Schema does not exist
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get the number of statements. DB ADMIN ONLY
GET /metrics/statements_count
Get the number of statements for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the number of statements for a specified time frame.
app_act_completed_total
integer
Number of statements.
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the histogram of response time. DB ADMIN ONLY
GET /metrics/response_time_histograms
Get the histogram of response time for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the histogram of response time for a specified time frame
count
integer
Counts of matrices data.
histograms
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the average response time. DB ADMIN ONLY
GET /metrics/average_response_time
Get the average response time for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the average response time for a specified time frame.
coord_act_lifetime_avg_ms
integer
Coord act average lifetime.
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the list of average response time. DB ADMIN ONLY
GET /metrics/response_time
Get the list of average response time for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the list of average response time for a specified time frame.
count
integer
Counts of matrices data.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the average number of statements executed every minutes. DB ADMIN ONLY
GET /metrics/average_statements_rate
Get the average number of statements executed every minutes for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the average number of statements executed every minutes for a specified time frame
sqls_per_min
number
SQL rate(sqls/min).
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get numbers of statements executed every minutes. DB ADMIN ONLY
GET /metrics/statements_rate
Get numbers of statements executed every minutes for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return numbers of statements executed every minutes for a specified time frame
count
integer
Counts of matrices data.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the average number of rows read(rows/min). DB ADMIN ONLY
GET /metrics/average_rows_read
Get the average number of rows read(rows/min) for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the average number of rows read(rows/min) for a specified time frame.
rows_read_per_min
number
Rows read(rows/min).
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the numbers of rows read(rows/min). DB ADMIN ONLY
GET /metrics/rows_read
Get the numbers of rows read(rows/min) for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the numbers of rows read(rows/min) for a specified time frame.
count
integer
Counts of matrices data.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum number of concurrent connections DB ADMIN ONLY
GET /metrics/max_connections_count
Get the maximum number of concurrent connections for a specified time frame
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum number of concurrent connections for a specified time frame end
connections
integer
The maximum connections count.
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get maximum numbers of concurrent connections. DB ADMIN ONLY
GET /metrics/connections_count
Get maximum numbers of concurrent connections for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return maximum numbers of concurrent connections for a specified time frame.
count
integer
Counts of matrices data.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum lockwaits per minute. DB ADMIN ONLY
GET /metrics/max_lockwaits_rate
Get the maximum lockwaits per minute for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum lockwaits per minute for a specified time frame
lock_waits_per_min
number
The maximum lockwaits rate(lockwaits/min).
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum lockwaits per minute. DB ADMIN ONLY
GET /metrics/lockwaits_rate
Get the maximum lockwaits per minute for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum lockwaits per minute for a specified time frame.
count
integer
Lockwaits rate(lockwaits/min).
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum usage percentage of logs. DB ADMIN ONLY
GET /metrics/max_log_space
Get the maximum usage percentage of logs for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum usage percentage of logs for a specified time frame.
total_log_used_percent
number
Percentage of used size of log space.
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum usage percentages of logs. DB ADMIN ONLY
GET /metrics/log_space
Get the maximum usage percentages of logs for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum usage percentages of logs in for a specified time frame.
count
integer
Counts of matrices data.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum percent of node CPU usage. DB ADMIN ONLY
GET /metrics/max_cpu
Get the maximum percent of node CPU usage for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum percent of node CPU usage for a specified time frame.
cpu_used_percent
number
The percent of CPU usage.
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the percent of node CPU usage. DB ADMIN ONLY
GET /metrics/cpu_summary
Get the percent of node CPU usage for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the percent of node CPU usage for a specified time frame.
count
integer
Counts of CPU.
issinglenode
boolean
Single node or not.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum percent of node memory usage. DB ADMIN ONLY
GET /metrics/max_memory
Get the maximum percent of node memory usage for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum percent of node memory usage for a specified time frame.
memory_used_percent
integer
The percent of memory usage.
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the percent of node memory usage. DB ADMIN ONLY
GET /metrics/memory_summary
Get the percent of node memory usage for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the percent of memory usage in each node for a specified time frame.
count
integer
Counts of Memory.
issinglenode
boolean
Single node or not.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the maximum usage percent of storage. DB ADMIN ONLY
GET /metrics/max_storage
Get the maximum usage percent of storage for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the maximum usage percent of storage for a specified time frame.
fs_total_size_gb
integer
Total size of storage.
fs_used_size_gb
integer
Used size size of storage.
fs_used_percent
number
Percentage of used size of storage.
403 - Operation is only available to administrators.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the usage percent of storage. DB ADMIN ONLY
GET /metrics/storage
Get the usage percent of storage for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the usage percent of storage for a specified time frame.
count
integer
Counts of matrices data.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get the time spent in each operation. DB ADMIN ONLY
GET /metrics/timespent
Get the time spent in each operation for a specified time frame.
Request
Path Parameters
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Return the time spent in each operation for a specified time frame.
count
integer
Number of time spent.
metadata
TimespentMeta
Timespent meta data.
timeseries
array
404 - Database profile not found.
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload.
Get a table storage usage in a time range DB ADMIN ONLY
GET /metrics/schemas/{tabschema}/tables/{tabname}/storage/timeseries
Get a table storage usage in a time range.
Request
Path Parameters
tabname
Required *
string
Tabname
tabschema
Required *
string
Tabschema
Query Parameters
end
integer
end
start
integer
start
Response
200 - OK
403 - Current user does not have permission to access this database
404 - Database profile not found
default - Error payload
Gets a list for tables storage DB ADMIN ONLY
GET /metrics/tables/storage
Gets a list for tables storage. Only returns the last collected data between start and end.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if includes system tables in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
integer
The amount of return records. Limit and offset should be set together.
offset
integer
The starting position of return records. Limit and offset should be set together
tabschema
string
Used to filter by schema
tabname
string
Used to filter by tabname
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Gets a list for tables storage
count
integer
Number of tables collected
resources
array
A list of tables storage data.
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a table storage DB ADMIN ONLY
GET /metrics/schemas/{tabschema}/tables/{tabname}/storage
Gets a table storage. Only returns the last collected data between start and end.
Request
Path Parameters
tabschema
Required *
string
Used to filter by schema
tabname
Required *
string
Used to filter by tabname
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns the list for tables storage
count
integer
Number of schemas collected
resources
array
A list of schemas storage data.
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a list for schemas storage DB ADMIN ONLY
GET /metrics/storage/schemas
Gets a list for schemas storage. Only returns the last collected data between start and end.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if includes system schemas in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
integer
The amount of return records. Limit and offset should be set together.
offset
integer
The starting position of return records. Limit and offset should be set together
tabschema
string
Used to filter by schema
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns a list for schemas storage
count
integer
Number of schemas collected
resources
array
A list of schemas storage data.
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get a schema used storage in a time range DB ADMIN ONLY
GET /metrics/storage/schemas/{tabschema}/timeseries
Get a schema used storage in a time range.
Request
Path Parameters
tabschema
Required *
string
Used to filter by schema
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - OK
403 - Current user does not have permission to access this database
404 - Database profile not found
default - Error payload
Gets a schema storage DB ADMIN ONLY
GET /metrics/storage/schemas/{tabschema}
Gets a schema storage. Only returns the last collected data between start and end.
Request
Path Parameters
tabschema
Required *
string
Used to filter by schema
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns the list for schema storage
collected
integer
count
integer
isCache
boolean
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Runs a tables storage collection DB ADMIN ONLY
POST /metrics/tables/storage/collector
Runs asynchronously a tables storage collection. Only allow one thread to run at the same time. If there is already a thread running, the new request will not kick off a new one. The returned handle will be the already running one. If there is no thread running, a new handle will be returned.
Request
Path Parameters
Query Parameters
Response
202 - Runs a tables storage collection
handle
string
Tracer of the job handler.
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a list of inflight executions
GET /metrics/statements/inflight_executions
Gets a list of inflight executions.Only returns the same statement once and the last collected one between start and end.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system statements in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
integer
The amount of return records. Limit and offset should be set together.
offset
integer
The starting position of return records. Limit and offset should be set together
client_ipaddr
string
Used to filter by IP address
stmt_text
string
Used to filter by statement text
application_name
string
Used to filter by application_name
session_auth_id
string
Used to filter by session_auth_id
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns a list of inflight executions name
count
integer
Number of statements.
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a list of current inflight executions
GET /metrics/statements/inflight_executions/current/list
Gets a list of current inflight executions
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system statements in the return list
limit
integer
The amount of return records. Limit and offset should be set together.
offset
integer
The starting position of return records. Limit and offset should be set together
client_ipaddr
string
Used to filter by IP address
stmt_text
string
Used to filter by statement text
application_name
string
Used to filter by application_name
session_auth_id
string
Used to filter by session_auth_id
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns a list of current inflight executions
count
integer
Number of statements.
iscache
boolean
from cache or not. If it's slow to get data from target database, then this API will retreve data from cache and get the last one. iscache identifies it is directly returned from db or from cache. true means from cache, false means from target database.
collected
integer
the collected timestamp from target database. This collected value can be used to set start and end for a history retrieval to get the same list later.
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a infight execution detail
GET /metrics/applications/{application_handle}/uow/{uow_id}/inflight_executions/{activity_id}
Gets a infight execution detail. Only returns the last one between start and end
Request
Path Parameters
application_handle
Required *
integer
A system-wide unique ID for the application.
uow_id
Required *
integer
The unit of work identifier.
activity_id
Required *
integer
Counter which uniquely identifies an activity for an application within a given unit of work.
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns a infight execution detail
application_handle
integer
Application handle
uow_id
integer
Unit of work ID
activity_id
integer
Activity ID
coord_member
integer
Coordinator member
entry_time
integer
Entry time
local_start_time
integer
Local start time
total_time_ms
integer
Total time
queue_time_ms
integer
Queue time
idle_time_ms
integer
Idle time
exec_time_ms
integer
Exec time
thresh_violations
integer
Number of threshold violations
wlm_queue_assignments_total
integer
Workload manager total queue assignments
executable_id
string
Executable ID
effective_isolation
string
Effective isolation
effective_query_degree
integer
Effective query degree
query_actual_degree
integer
Actual runtime degree of intrapartition parallelism
adm_bypassed
integer
Reserved for future use
adm_resource_actuals
integer
Reserved for future use
query_cost_estimate_timerons
integer
Query cost estimate
estimated_runtime_ms
integer
Reserved for future use
stmt_text
string
SQL statement text
activity_state
string
Activity state
activity_type
string
Activity type
application_id
string
Application ID
client_ipaddr
string
Client IP address
application_name
string
Application name
system_auth_id
string
System authorization identifier
session_auth_id
string
Session authorization ID
client_applname
string
Client application name
client_wrkstnname
string
Client workstation name
client_acctng
string
Client accounting string
client_userid
string
Client user ID
client_hostname
string
Client hostname
client_pid
integer
Client process ID
client_platform
string
Client platform
client_prdid
string
Client product and version ID
client_port_number
integer
Client port number
workload_name
string
Workload name
appl_id
string
Application ID
service_superclass_name
string
Service superclass name
service_subclass_name
string
Service subclass name
total_cpu_time_ms
integer
Total CPU time
total_routine_invocations
integer
Total routine invocations
fcm_recvs_total
integer
FCM receives total
fcm_sends_total
integer
FCM sends total
complex_operations
integer
Complex operations
all_overflows
integer
All overflows
agents_top
integer
Maximum number of agents that were used
num_agents
integer
Number of concurrent agents
total_sorts
integer
Total Sorts
sort_overflows
integer
Sort overflows
sort_shrheap_allocated_pages
integer
Sort Share Heap Currently Allocated
max_shrheap_allocated_per_part_percent
number
Max Share Heap Allocated Per Part Percent
estimated_sort_shrheap_top_pages
integer
Reserved for future use
max_estimated_shrheap_per_part_percent
number
Max estimated Share Heap Per Part Percent
sort_shrheap_top_pages
integer
Sort share heap high watermark
max_shrheap_peak_per_part_percent
number
Max Share Heap Peak Per Part Percent
hash_join_overflows
integer
Hash Join Overflows
olap_func_overflows
integer
OLAP Function Overflows
hash_grpby_overflows
integer
Hash group by overflows
post_threshold_sorts
integer
Post threshold sorts
post_threshold_hash_joins
integer
Hash Join Threshold
post_threshold_olap_funcs
integer
OLAP function threshold
post_threshold_hash_grpbys
integer
Hash group by threshold
col_vector_consumer_overflows
integer
Columnar vector consumer overflows
post_threshold_col_vector_consumers
integer
Post threshold columnar_vector consumers
rows_read
integer
Rows read
rows_modified
integer
Rows modified
rows_returned
integer
Rows returned
lock_waits
integer
Lock waits
lock_waits_global
integer
Lock waits global
lock_escals
integer
Number of lock escalations
lock_escals_global
integer
Number of global lock escalations
deadlocks
integer
Deadlocks detected
lock_timeouts
integer
Number of lock timeouts
lock_timeouts_global
integer
Lock timeouts global
cf_waits
integer
Number of cluster caching facility waits
log_disk_waits_total
integer
Total log disk waits monitor element
num_log_buffer_full
integer
Number of times full log buffer caused agents to wait
uow_log_space_used_kb
number
Unit of Work Log Space Used
direct_reads
integer
Direct reads from database
direct_writes
integer
Direct writes to database
fcm_volume_kb
number
FCM volume
bp_hit_ratio
number
Buffer pool hit ratio
data_hit_ratio
number
Buffer pool data hit ratio
index_hit_ratio
number
Buffer pool index hit ratio
xda_hit_ratio
number
Buffer pool XDA hit ratio
col_hit_ratio
number
Buffer pool column hit ratio
temp_hit_ratio
number
Buffer pool temp hit ratio
pool_temp_l_reads
number
Buffer pool temp logical reads
pool_temp_p_reads
number
Buffer pool temp physical reads
pool_l_reads
integer
Buffer pool logical reads
pool_p_reads
integer
Buffer pool physical reads
pool_writes
integer
Buffer pool writes
fed_rows_deleted
integer
Rows deleted by a federation system
fed_rows_inserted
integer
Rows inserted by a federation system
fed_rows_updated
integer
Rows updated by a federation system
fed_rows_read
integer
Rows read by a federation system
fed_waits_total
integer
Total number of execution times for a federation server
ext_table_read_volume_kb
number
Total data read by external table readers
ext_table_write_volume_kb
number
Total data written by external table writers
ext_table_send_volume_kb
number
Total data sent to external table writers
ext_table_recv_volume_kb
number
Total data received from external table readers
wlm_queue_time_total_percent
number
Workload manager total queue time
stmt_exec_time_percent
integer
Statement execution time
total_section_proc_time_percent
number
Total section processing time
total_section_sort_proc_time_percent
number
Total section sort processing time
total_col_proc_time_percent
number
Total column-organized processing time
other_section_proc_time_percent
number
Other section processing time
total_routine_user_code_proc_time_percent
number
Total routine user code processing time
total_act_wait_time_percent
number
Total activity wait time
lock_wait_time_global_percent
number
Lock wait time global
lock_wait_time_local_percent
number
Lock wait time local
log_buffer_wait_time_percent
number
Log buffer wait time
log_disk_wait_time_percent
number
Log disk wait time
fcm_wait_time_percent
number
FCM wait time
cf_wait_time_percent
number
cluster caching facility wait time
fed_wait_time_percent
number
Time spent by a federation server
ext_table_wait_time_percent
number
Total agent wait time for external table
total_extended_latch_wait_time_percent
number
Total extended latch wait time
pool_read_time_percent
number
Total buffer pool physical read time
pool_read_time_ms
integer
Total buffer pool physical read time
pool_write_time_percent
number
Total buffer pool physical write time
pool_write_time_ms
integer
Total buffer pool physical write time
direct_read_time_percent
number
Direct Read Time
direct_write_time_percent
number
Direct write time
prefetch_wait_time_percent
number
Time waited for prefetch
prefetch_wait_time_ms
integer
Time waited for prefetch
other_wait_time_percent
number
Other wait time
other_proc_time_percent
number
Other processing time
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Terminates a statement DB ADMIN ONLY
DELETE /metrics/applications/{application_handle}/uow/{uow_id}/inflight_executions/{activity_id}
Terminates a statement
Request
Path Parameters
application_handle
Required *
integer
A system-wide unique ID for the application.
uow_id
Required *
integer
The unit of work identifier.
activity_id
Required *
integer
Counter which uniquely identifies an activity for an application within a given unit of work.
Query Parameters
Response
200 - Connection terminated
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a list of connections
GET /metrics/applications/connections
Gets a list of connections. Each connection represents a row. If there are multiple collections. They'll been aggregated averagely.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system statements in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
integer
The amount of return records. Limit and offset should be set together.
offset
integer
The starting position of return records. Limit and offset should be set together
client_ipaddr
string
Used to filter by IP address
application_name
string
Used to filter by application_name
session_auth_id
string
Used to filter by session_auth_id
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns Connections with the specific profile name
count
integer
counts of connections
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a list of current connections
GET /metrics/applications/connections/current/list
Gets a list of current connections. Only return the last collected connections. The values are calculated based on the last collected and privious collection rows to get rate like values.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system statements in the return list
limit
integer
The amount of return records. Limit and offset should be set together.
offset
integer
The starting position of return records. Limit and offset should be set together
client_ipaddr
string
Used to filter by IP address
application_name
string
Used to filter by application_name
session_auth_id
string
Used to filter by session_auth_id
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns Connections with the specific profile name
count
integer
counts of connections
iscache
boolean
from cache or not. If it's slow to get data from target database, then this API will retreve data from cache and get the last one. iscache identifies it is directly returned from db or from cache. true means from cache, false means from target database.
collected
integer
the collected timestamp from target database. This collected value can be used to set start and end for a history retrieval to get the same list later.
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a connection detail
GET /metrics/applications/connections/{application_handle}
Gets a connection detail
Request
Path Parameters
application_handle
Required *
integer
A system-wide unique ID for the application.
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns connection details with the specific profile name and specific application handle
application_handle
integer
Application handle
coord_member
integer
Coordinating member
connection_start_time
integer
Connection start time
uow_start_time
integer
Unit of work start timestamp
idle_time_ms
integer
Idle time (in milliseconds)
workload_occurrence_state
string
Workload occurrence state
workload_name
string
Workload name
thresh_violations_per_min
integer
Number of threshold violations
wlm_queue_assignments_total_per_min
integer
Workload manager total queue assignments
memory_pool_used_kb
integer
Memory pool used
rejected_rate
number
Rejected rate
application_id
string
Application ID
client_ipaddr
string
Client IP address
application_name
string
Application name
system_auth_id
string
System authorization identifier
session_auth_id
string
Session authorization ID
client_applname
string
Client application name
client_wrkstnname
string
Client workstation name
client_acctng
string
Client accounting string
client_userid
string
Client user ID
client_hostname
string
Client hostname
client_pid
integer
Client process ID
client_platform
string
Client platform
client_prdid
string
Client product and version ID
client_port_number
integer
Client port number
service_superclass_name
string
Service superclass name
total_cpu_time_ms_per_min
integer
Total CPU time
total_routine_invocations_per_min
integer
Total routine invocations
total_compilations_per_min
integer
Total compilations
fcm_recvs_total_per_min
integer
FCM recvs total
fcm_sends_total_per_min
integer
FCM sends total
total_loads_per_min
integer
Total loads
total_reorgs_per_min
integer
Total reorganizations
total_runstats_per_min
integer
Total runtime statistics
complex_operations_per_min
integer
Complex operations
all_overflows_per_min
integer
All overflows
total_sorts_per_min
integer
Total Sorts
sort_overflows_per_min
integer
Sort overflows
sort_shrheap_allocated_pages
integer
Sort Share Heap Currently Allocated
max_shrheap_allocated_per_part_percent
number
Max Share Heap Allocated Per Part Percent
estimated_sort_shrheap_top_pages
integer
Estimated sort Share Heap top
max_estimated_shrheap_per_part_percent
number
Max estimated Share Heap Per Part Percent
sort_shrheap_top_pages
integer
sort_shrheap_top_pages
max_shrheap_peak_per_part_percent
number
max_shrheap_peak_per_part_percent
total_app_commits_per_min
integer
Total application commits
total_app_rollbacks_per_min
integer
Total application rollbacks
act_completed_total_per_min
integer
Total completed activities
act_aborted_total_per_min
integer
Total aborted activities
act_rejected_total_per_min
integer
Total rejected activities
dynamic_sql_stmts_per_min
integer
Dynamic SQL Statements Attempted
static_sql_stmts_per_min
integer
Static SQL Statements Attempted
failed_sql_stmts_per_min
integer
Failed SQL Statements Attempted
select_sql_stmts_per_min
integer
Select SQL Statements Attempted
uid_sql_stmts_per_min
integer
UID SQL Statements Attempted
ddl_sql_stmts_per_min
integer
DDL SQL Statements Attempted
other_stmts_per_min
integer
Other SQL Statements Attempted
rows_read_per_min
integer
Rows read
rows_modified_per_min
integer
Rows modified
rows_returned_per_min
integer
Rows returned
lock_waits_per_min
integer
Lock waits
lock_waits_global_per_min
integer
Lock waits global
lock_escals_per_min
integer
Number of lock escalations
lock_escals_global_per_min
integer
Number of global lock escalations
deadlocks_per_min
integer
Deadlocks detected
lock_timeouts_per_min
integer
Number of lock timeouts
lock_timeouts_global_per_min
integer
Lock timeouts global
num_locks_held
integer
Locks held
cf_waits_per_min
integer
Number of cluster caching facility waits
log_disk_waits_total_per_min
integer
Log disk waits total
num_log_buffer_full_per_min
integer
Number of full log buffers
uow_log_space_used_kb
number
Unit of Work Log Space Used
direct_reads_per_min
integer
Direct reads from database
direct_writes_per_min
integer
Direct writes to database
fcm_volume_kb_per_min
number
FCM volume
bp_hit_ratio
number
Buffer pool hit ratio
data_hit_ratio
number
Buffer pool data hit ratio
index_hit_ratio
number
Buffer pool index hit ratio
xda_hit_ratio
number
Buffer pool XDA hit ratio
col_hit_ratio
number
Buffer pool column hit ratio
temp_hit_ratio
number
Buffer pool temp hit ratio
pool_temp_l_reads_per_min
number
Buffer pool temp logical reads
pool_temp_p_reads_per_min
number
Buffer pool temp physical reads
pool_l_reads_per_min
integer
Buffer pool logical reads
pool_p_reads_per_min
integer
Buffer pool physical reads
pool_writes_per_min
integer
Buffer pool writes
fed_rows_deleted_per_min
integer
Rows deleted by a federation system
fed_rows_inserted_per_min
integer
Rows inserted by a federation system
fed_rows_updated_per_min
integer
Rows updated by a federation system
fed_rows_read_per_min
integer
Rows read by a federation system
fed_waits_total_per_min
integer
Total number of execution times for a federation server
ext_table_read_volume_kb_per_min
number
Total data read by external table readers
ext_table_write_volume_kb_per_min
number
Total data written by external table writers
ext_table_send_volume_kb_per_min
number
Total data sent to external table writers
ext_table_recv_volume_kb_per_min
number
Total data received from external table readers
client_idle_wait_time_percent
number
Client idle wait time
total_rqst_time_percent
number
Total request time
total_compile_proc_time_percent
number
Total compile processing time
total_section_proc_time_percent
number
Total section processing time
total_section_sort_proc_time_percent
number
Total section sort processing time
total_col_proc_time_percent
number
Total column-organized processing time
other_section_proc_time_percent
number
Other section processing time
total_commit_proc_time_percent
number
Total commits processing time
total_rollback_proc_time_percent
number
Total rollback processing time
total_runstats_proc_time_percent
number
Total runtime statistics processing time
total_reorg_proc_time_percent
number
Total reorganization processing time
total_load_proc_time_percent
number
Total load processing time
total_wait_time_percent
number
Total wait time
agent_wait_time_percent
number
Agent wait time
wlm_queue_time_total_percent
number
Workload manager total queue time
lock_wait_time_global_percent
number
Lock wait time global
lock_wait_time_local_percent
number
Lock wait time local
log_buffer_wait_time_percent
number
Log buffer wait time
log_disk_wait_time_percent
number
Log disk wait time
tcpip_wait_time_percent
number
TCP/IP wait time
fcm_wait_time_percent
number
FCM wait time
cf_wait_time_percent
number
cluster caching facility wait time
fed_wait_time_percent
number
Time spent by a federation server
ext_table_wait_time_percent
number
Total agent wait time for external table
total_extended_latch_wait_time_percent
number
Total extended latch wait time
pool_read_time_percent
number
Total buffer pool physical read time
pool_write_time_percent
number
Total buffer pool physical write time
direct_read_time_percent
number
Direct Read Time
direct_write_time_percent
number
Direct write time
prefetch_wait_time_percent
number
Time waited for prefetch
other_wait_time_percent
number
Other wait time
other_proc_time_percent
number
Other processing time
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Terminates a database connection DB ADMIN ONLY
DELETE /metrics/applications/connections/{application_handle}
Terminates an active database connection.
Request
Path Parameters
application_handle
Required *
integer
Application handle name
Query Parameters
Response
200 - Connection terminated
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets a list of timeseries of a connection
GET /metrics/applications/connections/{application_handle}/timeseries
Gets a list of timeseries of a connection. The values are calculated based on the last collected and privious collection rows to get rate like values.
Request
Path Parameters
application_handle
Required *
integer
A system-wide unique ID for the application.
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns connection details of timeseries with the specific profile name and specific application handle
count
integer
counts of connections
timeseries
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance metrics for schemas DB ADMIN ONLY
GET /metrics/schemas
Gets performance metrics for schemas. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system schemas in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
string
Field to set the amount of return records
offset
string
Field to set the starting position of return records.
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - returns performance of schemas
count
integer
counts of statements
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance metrics for schemas DB ADMIN ONLY
GET /metrics/schemas/current/list
Gets current performance metrics for schemas.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system schemas in the return list
limit
string
Field to set the amount of return records
offset
string
Field to set the starting position of return records.
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - returns performance of schemas
count
integer
counts of statements
iscache
boolean
from cache or not. If it's slow to get data from target database, then this API will retreve data from cache and get the last one. iscache identifies it is directly returned from db or from cache. true means from cache, false means from target database.
collected
integer
the collected timestamp from target database. This collected value can be used to set start and end for a history retrieval to get the same list later.
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance metrics for one schema DB ADMIN ONLY
GET /metrics/schemas/{schema_name}
Gets performance metrics for one schema. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
schema_name
Required *
string
Schema name
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns performance metrics for one schema
tabschema
string
Table schema name
table_scans_per_min
integer
Table scans
rows_read_per_min
integer
Rows read
rows_inserted_per_min
integer
Rows inserted
rows_updated_per_min
integer
Rows updated
rows_deleted_per_min
integer
Rows deleted
logical_reads_per_min
integer
Logical reads
physical_reads_per_min
integer
Physical reads
hit_ratio
number
Buffer pool hit ratio
rows_read_versus_accessed_per_min
number
Rows read versus accessed
data_object_l_pages_per_min
integer
Logical data object pages
index_object_l_pages_per_min
integer
Logical index object pages
xda_object_l_pages_per_min
integer
Logical XDA object pages
lob_object_l_pages_per_min
integer
Logical LOB object pages
long_object_l_pages_per_min
integer
Logical Long object pages
accesses_min
integer
Access per minute
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance metrics on all members for one schema DB ADMIN ONLY
GET /metrics/schemas/{schema_name}/members
Gets performance metrics on all members for one schema. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
schema_name
Required *
string
Schema name
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns performance metrics on all members for one schema
count
integer
Schema Perf list
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance metrics timeseries for one schema DB ADMIN ONLY
GET /metrics/schemas/{schema_name}/timeseries
Gets performance metrics timeseries for one schema.
Request
Path Parameters
schema_name
Required *
string
Schema name
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns performance metrics timeseries for one schema
count
integer
Schema Perf list
timeseries
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance of tables DB ADMIN ONLY
GET /metrics/tables
Gets performance of tables. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system tables in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
string
Field to set the amount of return records
offset
string
Field to set the starting position of return records.
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns performance of tables
count
integer
A list of tables
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets current performance of tables DB ADMIN ONLY
GET /metrics/tables/current/list
Gets current performance of tables.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system tables in the return list
limit
string
Field to set the amount of return records
offset
string
Field to set the starting position of return records.
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns performance of tables
count
integer
A list of tables
iscache
boolean
from cache or not. If it's slow to get data from target database, then this API will retreve data from cache and get the last one. iscache identifies it is directly returned from db or from cache. true means from cache, false means from target database.
collected
integer
the collected timestamp from target database. This collected value can be used to set start and end for a history retrieval to get the same list later.
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance of one table DB ADMIN ONLY
GET /metrics/schemas/{schema_name}/tables/{table_name}
Gets performance of one table. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
schema_name
Required *
string
Schema name
table_name
Required *
string
Table name
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns performance of one table
tabschema
string
Table schema name
tabname
string
Table name
tab_type
string
Table type
tbsp_name
string
Tablespace name
table_scans_per_min
integer
Table scans
rows_read_per_min
integer
Rows read
rows_inserted_per_min
integer
Rows inserted
rows_updated_per_min
integer
Rows updated
rows_deleted_per_min
integer
Rows deleted
logical_reads_per_min
integer
Logical reads
physical_reads_per_min
integer
Physical reads
hit_ratio
number
Buffer pool hit ratio
rows_read_versus_accessed_per_min
number
Rows read versus accessed
data_object_l_pages_per_min
integer
Logical data object pages
index_object_l_pages_per_min
integer
Logical index object pages
xda_object_l_pages_per_min
integer
Logical XDA object pages
lob_object_l_pages_per_min
integer
Logical LOB object pages
long_object_l_pages_per_min
integer
Logical Long object pages
accesses_min
integer
Access per minute
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance on all members for one table DB ADMIN ONLY
GET /metrics/schemas/{schema_name}/tables/{table_name}/members
Gets performance on all members for one table. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
schema_name
Required *
string
Schema name
table_name
Required *
string
Table name
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns performance on all members for one table
count
integer
Table performance list
resources
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance timeseries for one table DB ADMIN ONLY
GET /metrics/schemas/{schema_name}/tables/{table_name}/timeseries
Gets performance timeseries for one table.
Request
Path Parameters
schema_name
Required *
string
Schema name
table_name
Required *
string
Table name
Query Parameters
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
Response
200 - Returns performance timeseries for one table
count
integer
Table performance list
timeseries
array
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets performance of tables and schemas DB ADMIN ONLY
GET /metrics/tableperformance
Gets performance of tables and schemas. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system tables in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
string
Field to set the amount of return records
offset
string
Field to set the starting position of return records.
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns performance of tables
schema
schemaPerfList
a list of Sechmas
table
tablePerfList
A list of tables
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Gets current performance of tables and schemas DB ADMIN ONLY
GET /metrics/tableperformance/current/list
Gets current performance of tables and schemas. If there are multiple collections. They’ll been aggregated averagely.
Request
Path Parameters
Query Parameters
include_sys
string
Field to set if include system tables in the return list
start
Required *
integer
Start timestamp.
end
Required *
integer
End timestamp.
limit
string
Field to set the amount of return records
offset
string
Field to set the starting position of return records.
sort
string
Used to sort by the given field. The name of given field can be found from the response. Plus + or - before the given filed to denote by ASC or DESC. By default if not specified it's by ASC. Note: only support one field each time.
Response
200 - Returns performance of tables
schema
currentSchemaPerfList
a list of Sechmas
table
currentTablePerfList
A list of tables
403 - Current user does not have permission to access this database
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - Database profile not found
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Returns the list of users
GET /users
Administrators can retrieve the list of all users in the system. Regular users will receive a list containing only their own user profile.
Request
Response
200 - List of users
count
integer
Number of elements
resources
array
List of users
default - Error payload
POST /users
Creates a new user.
This operation is only available to platform administrators.The token used in authentication has to be IAM token.
Request
Request Body
User
User information
id
Required *
string
The user's ID. It must be between 1 and 128 characters and may only contain letters a-z (lower-case), numbers 0-9, and the special characters '_', '-' or '.'. It can not start with special characters. It may not be "guests", "admins", "users", "local", "idax", "public", "ibm", "dsweb", "sqlj", "root" or "gopher". It cannot begin with "bluadmin", "db2inst1", "nullid", "ibm", "sql" or "sys". Those limits don't apply to IBMid (when "iam" is set to true).
iam
boolean
Indicate if this user is an IBMid User. When set to true, only "id", "ibmid", "role" and "locked" are needed. The default value is false.
ibmid
string
If iam sets to true, ibmid is required. It's the IBMid which will associate with the user id in the Console.
name
string
The user's full name. Not needed for IBMid and will be ignored if set.
password
Required *
string
The user's password. It must have a minimum of 15 characters. It must contain at least one each of upper-case letters, lower-case letters, numbers, and special characters. Do not use common words in password. For IBMid, password should be absent since the credential is managed by IBMid but not the Console.
role
Required *
string
The user's role. Administrators have the `bluadmin` role. Regular users have the `bluuser` role.
string
The user's email address. Not needed for IBMid and will be ignored if set.
locked
string
If set to 'yes', it indicates the user account is locked, which disallows the user from logging into the system
authentication
object
method
Required *
string
The authentication method to be used when the user logs in. Currently only 'internal' is allowed. Not needed for IBMid and will be ignored if set.
policy_id
Required *
string
The authentication policy ID for this user account. Only valid when type is set to 'internal'. Not needed for IBMid and will be ignored if set.
Response
201 - User response
id
string
The user's ID. It must be between 1 and 128 characters and may only contain letters a-z (lower-case), numbers 0-9, and the special characters '_', '-' or '.'. It can not start with special characters. It may not be "guests", "admins", "users", "local", "idax", "public", "ibm", "dsweb", "sqlj", "root" or "gopher". It cannot begin with "bluadmin", "db2inst1", "nullid", "ibm", "sql" or "sys". Those limits don't apply to IBMid (when "iam" is set to true).
iam
boolean
Indicate if this user is an IBMid User. When set to true, only "id", "ibmid", "role" and "locked" are needed. The default value is false.
ibmid
string
If iam sets to true, ibmid is required. It's the IBMid which will associate with the user id in the Console.
name
string
The user's full name. Not needed for IBMid and will be ignored if set.
password
string
The user's password. It must have a minimum of 15 characters. It must contain at least one each of upper-case letters, lower-case letters, numbers, and special characters. Do not use common words in password. For IBMid, password should be absent since the credential is managed by IBMid but not the Console.
role
string
The user's role. Administrators have the `bluadmin` role. Regular users have the `bluuser` role.
string
The user's email address. Not needed for IBMid and will be ignored if set.
locked
string
If set to 'yes', it indicates the user account is locked, which disallows the user from logging into the system
authentication
object
202 - The creating user task has not been finished
message
string
The information about ongoing action
400 - Invalid parameters or user already exists
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
403 - Operation is only available to administrators
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Get a specific user by ID
GET /users/{id}
Get a specific user by ID. Platform administrators may retrieve user information for any user.The token for platform administrator used in authentication has to be IAM token. Regular users may only retrieve themselves.
Request
Path Parameters
id
Required *
string
ID of the user to be fetched
Query Parameters
Response
200 - User response
id
string
The user's ID. It must be between 1 and 128 characters and may only contain letters a-z (lower-case), numbers 0-9, and the special characters '_', '-' or '.'. It can not start with special characters. It may not be "guests", "admins", "users", "local", "idax", "public", "ibm", "dsweb", "sqlj", "root" or "gopher". It cannot begin with "bluadmin", "db2inst1", "nullid", "ibm", "sql" or "sys". Those limits don't apply to IBMid (when "iam" is set to true).
iam
boolean
Indicate if this user is an IBMid User. When set to true, only "id", "ibmid", "role" and "locked" are needed. The default value is false.
ibmid
string
If iam sets to true, ibmid is required. It's the IBMid which will associate with the user id in the Console.
name
string
The user's full name. Not needed for IBMid and will be ignored if set.
password
string
The user's password. It must have a minimum of 15 characters. It must contain at least one each of upper-case letters, lower-case letters, numbers, and special characters. Do not use common words in password. For IBMid, password should be absent since the credential is managed by IBMid but not the Console.
role
string
The user's role. Administrators have the `bluadmin` role. Regular users have the `bluuser` role.
string
The user's email address. Not needed for IBMid and will be ignored if set.
locked
string
If set to 'yes', it indicates the user account is locked, which disallows the user from logging into the system
authentication
object
403 - Access to this user is not allowed
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - The user does not exist
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
PUT /users/{id}
Updates an existing user. Attribute 'iam' can not be updated. That means no conversion between IBMid users and normal users.
Platform administrators may update user information for any user.The token for platform administrator used in authentication has to be IAM token.
Request
Request Body
UserUpdate
User information
id
Required *
string
The user's ID
ibmid
string
ibmid is only valid for IBMid users. It's the IBMid which will associate with the user id in the Console.
name
string
The user's full name
old_password
string
Current password must be provided when user updates his own profile.
new_password
string
New password
role
string
The user's role. Administrators have the `bluadmin` role. Regular users have the `bluuser` role.
string
The user's email address
locked
string
If set to 'yes', it indicates the user account is locked, which disallows the user from logging into the system
authentication
object
method
Required *
string
The authentication method to be used when the user logs in. Currently only 'internal' is allowed. Not needed for IBMid and will be ignored if set.
policy_id
Required *
string
The authentication policy ID for this user account. Only valid when type is set to 'internal'. Not needed for IBMid and will be ignored if set.
Path Parameters
id
Required *
string
ID of the user to be updated
Query Parameters
Response
200 - User response
id
string
The user's ID. It must be between 1 and 128 characters and may only contain letters a-z (lower-case), numbers 0-9, and the special characters '_', '-' or '.'. It can not start with special characters. It may not be "guests", "admins", "users", "local", "idax", "public", "ibm", "dsweb", "sqlj", "root" or "gopher". It cannot begin with "bluadmin", "db2inst1", "nullid", "ibm", "sql" or "sys". Those limits don't apply to IBMid (when "iam" is set to true).
iam
boolean
Indicate if this user is an IBMid User. When set to true, only "id", "ibmid", "role" and "locked" are needed. The default value is false.
ibmid
string
If iam sets to true, ibmid is required. It's the IBMid which will associate with the user id in the Console.
name
string
The user's full name. Not needed for IBMid and will be ignored if set.
password
string
The user's password. It must have a minimum of 15 characters. It must contain at least one each of upper-case letters, lower-case letters, numbers, and special characters. Do not use common words in password. For IBMid, password should be absent since the credential is managed by IBMid but not the Console.
role
string
The user's role. Administrators have the `bluadmin` role. Regular users have the `bluuser` role.
string
The user's email address. Not needed for IBMid and will be ignored if set.
locked
string
If set to 'yes', it indicates the user account is locked, which disallows the user from logging into the system
authentication
object
202 - The updating user task has not been finished
message
string
The information about ongoing action
403 - Access to this user is not allowed
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - The user does not exist
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
DELETE /users/{id}
Deletes an existing user.
Only administratos can delete users.The token for platform administrator used in authentication has to be IAM token.
Request
Path Parameters
id
Required *
string
ID of the user to be deleted.
Query Parameters
Response
202 - The deleting user task has not been finished
message
string
The information about ongoing action
204 - No content, User deleted
403 - Removal of this user is not allowed
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - The user does not exist
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Locks a user account indefinitely. PLATFORM ADMIN ONLY
PUT /users/{id}/lock
Platform admin users can unlock users' accounts which have been locked out following repeated failed authentication attempts.The token for platform administrator used in authentication has to be IAM token.
Request
Path Parameters
id
Required *
string
ID of the user who will be locked
Query Parameters
Response
200 - User response
id
string
The user's ID. It must be between 1 and 128 characters and may only contain letters a-z (lower-case), numbers 0-9, and the special characters '_', '-' or '.'. It can not start with special characters. It may not be "guests", "admins", "users", "local", "idax", "public", "ibm", "dsweb", "sqlj", "root" or "gopher". It cannot begin with "bluadmin", "db2inst1", "nullid", "ibm", "sql" or "sys". Those limits don't apply to IBMid (when "iam" is set to true).
iam
boolean
Indicate if this user is an IBMid User. When set to true, only "id", "ibmid", "role" and "locked" are needed. The default value is false.
ibmid
string
If iam sets to true, ibmid is required. It's the IBMid which will associate with the user id in the Console.
name
string
The user's full name. Not needed for IBMid and will be ignored if set.
password
string
The user's password. It must have a minimum of 15 characters. It must contain at least one each of upper-case letters, lower-case letters, numbers, and special characters. Do not use common words in password. For IBMid, password should be absent since the credential is managed by IBMid but not the Console.
role
string
The user's role. Administrators have the `bluadmin` role. Regular users have the `bluuser` role.
string
The user's email address. Not needed for IBMid and will be ignored if set.
locked
string
If set to 'yes', it indicates the user account is locked, which disallows the user from logging into the system
authentication
object
202 - The locking user task has not been finished
message
string
The information about ongoing action
403 - Cannot edit this user
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - The user does not exist
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Unlocks a user account PLATFORM ADMIN ONLY
PUT /users/{id}/unlock
Platform admin users can unlock users' accounts which have been locked out following repeated failed authentication attempts.The token for platform administrator used in authentication has to be IAM token.
Request
Path Parameters
id
Required *
string
ID of the user who will be unlocked
Query Parameters
Response
200 - User response
id
string
The user's ID. It must be between 1 and 128 characters and may only contain letters a-z (lower-case), numbers 0-9, and the special characters '_', '-' or '.'. It can not start with special characters. It may not be "guests", "admins", "users", "local", "idax", "public", "ibm", "dsweb", "sqlj", "root" or "gopher". It cannot begin with "bluadmin", "db2inst1", "nullid", "ibm", "sql" or "sys". Those limits don't apply to IBMid (when "iam" is set to true).
iam
boolean
Indicate if this user is an IBMid User. When set to true, only "id", "ibmid", "role" and "locked" are needed. The default value is false.
ibmid
string
If iam sets to true, ibmid is required. It's the IBMid which will associate with the user id in the Console.
name
string
The user's full name. Not needed for IBMid and will be ignored if set.
password
string
The user's password. It must have a minimum of 15 characters. It must contain at least one each of upper-case letters, lower-case letters, numbers, and special characters. Do not use common words in password. For IBMid, password should be absent since the credential is managed by IBMid but not the Console.
role
string
The user's role. Administrators have the `bluadmin` role. Regular users have the `bluuser` role.
string
The user's email address. Not needed for IBMid and will be ignored if set.
locked
string
If set to 'yes', it indicates the user account is locked, which disallows the user from logging into the system
authentication
object
202 - The unlocking user task has not been finished
message
string
The information about ongoing action
403 - Cannot edit this user
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
404 - The user does not exist
trace
string
Unique ID assigned by the server that identifies the request that generated the error
errors
array
List of errors
default - Error payload
Create a scaling request
POST /scaling/request
Scale the amount of storage and cpu cores for your instance.
Request
Request Body
The number of cores and the amount of storage to scale.
total_cores
Required *
integer
The number of cores to scale
total_storage
Required *
integer
The amount of storage to scale in MB
Response
200 - The scaling request was successful. Returns the task ID used to scale the deployment.
scaling_id
string
the task ID for scaling operation
400 - Bad request
401 - Unauthorized
500 - Internal server error
message
string
error message
code
integer
error status code
Get supported scaling ranges and current allocated resources
GET /scaling/resources/info
View the allocated storage and cpu size at the time of the request. This request will also return the supported scaling ranges for this Db2 on Cloud service.
Request
Response
200 - Details for supported scaling ranges and current allocated resources.
plan
string
groupID
string
storage
object
current allocated storage and supported storage ranges for scaling
compute
object
current allocated cpu and supported cpu ranges for scaling
400 - Bad request
401 - Unauthorized
500 - Unexpected error
message
string
error message
code
integer
error status code
View scaling history
GET /scaling/history
View scaling historical data.
Request
Path Parameters
Query Parameters
start
integer
end
integer
search
string
sort_column
string
sort_order
string
activity_type
string
Response
200 - View scaling history
list
array
List of scaling history
400 - Bad request
401 - Unauthorized
500 - Internal server error
message
string
error message
code
integer
error status code
Get a list of backups
GET /backups
Get a list of backups from current instance.
Request
Response
200 - The list of backups
backups
array
400 - Bad request
401 - Unauthorized
500 - Internal server error
message
string
error message
code
integer
error status code
Restore
POST /backups/restore
Restore to a particular backup or perform a point-in-time restore.
Request
Request Body
ts
string
Timestamp, used when doing point-in-time restore
backup_id
string
backup ID, used when restoring to a particular backup
Response
200 - Task detail of the restore job
task
object
400 - Bad request
401 - Unauthorized
500 - Unauthorized
message
string
error message
code
integer
error status code
Create a backup
POST /backups/backup
Create a backup
Request
Response
200 - OK
task
object
400 - Bad request
401 - Unauthorized
500 - Unexpected error
message
string
error message
code
integer
error status code
Get backup setting
GET /backups/setting
Get backup setting for scheduled time and retention policy
Request
Response
200 - OK
setting
object
500 - Unexpected error
message
string
error message
code
integer
error status code
Update backup setting
POST /backups/setting
update backup setting for scheduled backup time
Request
Request Body
backup_time
string
Response
200 - OK
setting
object
400 - Bad request
401 - Unauthorized
500 - Unexpected error
message
string
error message
code
integer
error status code
Get tasks status
GET /tasks/status
Request
Response
200 - contain tasks status for scaling ,restore etc.
tasks
array
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Checks for any available database update
GET /db_update
Request
Response
200 - Returns the available Db2 database update.
needs_update
boolean
whether there is a new db2 version
latest_version
string
the latest db2 version
update_deadline
string
deadline for updating to the latest db2 version
400 - Bad request
500 - Error
message
string
error message
code
integer
error status code
Trigger database update
POST /db_update
Request
Request Body
scheduled_timestamp
string
leave it as empty
target_version
Required *
string
db2 version
Response
200 - Db2 database update was triggered successfully.
task
object
400 - Bad request
500 - Error
message
string
error message
code
integer
error status code
Copy database to a new provision database
POST /manage/copy_db
Provision new database by copy from current database
Request
Request Body
CopyDatabaseRequest
name
Required *
string
name of the new cloned system
target
Required *
string
region of the new cloned system
resource_plan_id
Required *
string
resource plan id
high_availability
Required *
boolean
whether it's HA
resource_group
Required *
string
resource group
backup_id
string
backup id
key_protect_key
Required *
string
key protect key
members_disk_allocation_mb
integer
storage allocated to the new cloned system
tags
array
tags for the new cloned system
Response
201 - Copy db successfully
id
string
task ID of the copy request
crn
string
CRN of the new cloned system
state
string
status of the copy request
created_at
string
creation time of the copy request
service_name
string
name of the new cloned instance
target_region
string
region of the new cloned instance
400 - Bad request
500 - Error
message
string
error message
code
integer
error status code
Get Db2 connection information
GET /connectioninfo/{DEPLOYMENT_ID}
Request
Path Parameters
DEPLOYMENT_ID
Required *
string
Encoded deployment id
Query Parameters
Response
200 - Get connection info
public
object
default - Error payload
List disaster recovery enablement information
GET /manage/dr
List available regions that can be used for disaster recovery.
Request
Response
200 - List disaster recovery enablement information successfully.
regions
object
plan
object
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Enable disaster recovery
POST /manage/dr
Enable disaster recovery.
Request
Request Body
EnableDRRequest
name
Required *
string
The name of disaster recovery node
region
Required *
string
The region where this disaster recovery node will be deployed. The complete region list can be retrieved from `/manage/dr`.
Response
200 - Disaster recovery enabled successfully.
id
string
crn
string
state
string
created_at
string
service_name
string
target_region
string
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
List disaster recovery remotes pair information
GET /manage/dr/remotes/status
List disaster recovery remotes pair information
Request
Response
200 - Disaster recovery remotes status was returned successfully.
current
object
primary
object
dr
object
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Perform disaster recovery takeover
POST /manage/dr/takeover
Perform take over on current instance to switch from standby node to primary node. This API requires current instance is standby.
Request
Request Body
TakeOverDRRequest
force
Required *
boolean
If set to 'true' specifies that the database is not to wait for confirmation that the primary database has been shut down and it will close the connection between primary and standby node.
Response
200 - Takeover has ran successfully on current instance.
id
string
deployment_id
string
state
string
created_at
string
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Resync disaster recovery remote pair
POST /manage/dr/resync
Reconnect a broken or disconnected standby node
Request
Response
200 - Disaster recovery resync request completed successfully.
id
string
status
string
created_at
string
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Check current disaster recovery resync status
GET /manage/dr/resync/status
Check if there is an ongoing resync request
Request
Response
200 - Check disaster recovery resync status successfully.
id
string
status
string
created_at
string
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Get system information
GET /about
Request
Response
200 - Get system information
last_updated
string
name
string
dr_configured
string
description
string
region
string
configuration_type
string
oracle_compat
string
version
string
plan_id
string
protected_key_id
string
default - Error payload
Get the endpoint information
GET /dbsettings/endpoints
Request
Path Parameters
Query Parameters
Response
200 - Get the endpoint information
enable_public_endpoint
string
Indicates if the public endpoint is enabled ("true" or "false")
updating
string
Indicates if the endpoint is currently updating ("yes" or "no")
enable_private_endpoint
string
Indicates if the private endpoint is enabled ("true" or "false")
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Get all the whitelist IPs
GET /dbsettings/whitelistips
Request
Path Parameters
Query Parameters
Response
200 - List of whitelist IPs
ip_addresses
array
List of whitelist IPs
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Add whitelist IPs
POST /dbsettings/whitelistips
Request
Request Body
Path Parameters
Query Parameters
Response
200 - Success
status
string
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code
Delete whitelist IPs
DELETE /dbsettings/whitelistips
Request
Request Body
Path Parameters
Query Parameters
Response
200 - Success
status
string
400 - Bad request
401 - Unauthorized
500 - Error
message
string
error message
code
integer
error status code