- Request a new access token
- Returns public key of Json Web Token
- Sets a new password using dswebToken
- Lists all data load jobs using Db2 load utility technology
- Creates a data load job
- Returns details about a load job including its progress
- Removes load job from history
- Dowloads log file for a data load job
- List disaster recovery enablement information
- Enable disaster recovery
- List disaster recovery remotes pair information
- Perform disaster recovery takeover
- Resync disaster recovery remote pair
- Check current disaster recovery resync status
- Deletes a file in the Db2 temporary cloud object storage
- Download file from Db2 temporary cloud object storage
- Uploads a file to Db2 temporary cloud object storage
- Returns overall status of system components
- Lists active database connections DB ADMIN ONLY
- Terminates a database connection DB ADMIN ONLY
- Returns current storage usage DB ADMIN ONLY
- Returns storage usage history DB ADMIN ONLY
- Storage utilization by schema DB ADMIN ONLY
- Storage utilization of a schema DB ADMIN ONLY
- Return the number of statements for a specified time frame. DB ADMIN ONLY
- Return the histogram of response time for a specified time frame. DB ADMIN ONLY
- Return the average response time for a specified time frame. DB ADMIN ONLY
- Return the list of average response time for a specified time frame. DB ADMIN ONLY
- Return the average number of statements executed every minutes for a specified time frame. DB ADMIN ONLY
- Return numbers of statements executed every minutes for a specified time frame. DB ADMIN ONLY
- Return the average number of rows read(rows/min) for a specified time frame. DB ADMIN ONLY
- Return the numbers of rows read(rows/min) for a specified time frame. DB ADMIN ONLY
- Return the maximum number of concurrent connections for a specified time frame DB ADMIN ONLY
- Return maximum numbers of concurrent connections for a specified time frame. DB ADMIN ONLY
- Return the maximum lockwaits per minute for a specified time frame. DB ADMIN ONLY
- Return the maximum lockwaits per minute for a specified time frame. DB ADMIN ONLY
- Return the maximum usage percentage of logs for a specified time frame. DB ADMIN ONLY
- Return the maximum usage percentages of logs for a specified time frame. DB ADMIN ONLY
- Return the maximum percent of node CPU usage for a specified time frame. DB ADMIN ONLY
- Return the percent of node CPU usage for a specified time frame. DB ADMIN ONLY
- Return the maximum percent of node memory usage for a specified time frame. DB ADMIN ONLY
- Return the percent of node memory usage for a specified time frame. DB ADMIN ONLY
- Return the maximum usage percent of storage for a specified time frame. DB ADMIN ONLY
- Return the usage percent of storage for a specified time frame. DB ADMIN ONLY
- Return the time spent in each operation for a specified time frame. DB ADMIN ONLY
- Return a table storage usage in a time range DB ADMIN ONLY
- Returns a list for tables storage DB ADMIN ONLY
- Returns a table storage DB ADMIN ONLY
- Returns a list for schemas storage DB ADMIN ONLY
- Return a schema used storage in a time range DB ADMIN ONLY
- Returns a schema storage DB ADMIN ONLY
- Runs a tables storage collection DB ADMIN ONLY
- Returns a list of inflight executions
- Returns a list of current inflight executions
- Returns a infight execution detail
- Terminates a statement DB ADMIN ONLY
- Returns a list of connections
- Returns a list of current connections
- Returns a connection detail
- Terminates a database connection DB ADMIN ONLY
- Returns a list of timeseries of a connection
- Returns performance metrics for schemas DB ADMIN ONLY
- Returns performance metrics for schemas DB ADMIN ONLY
- Returns performance metrics for one schema DB ADMIN ONLY
- Returns performance metrics on all members for one schema DB ADMIN ONLY
- Returns performance metrics timeseries for one schema DB ADMIN ONLY
- Returns performance of tables DB ADMIN ONLY
- Returns current performance of tables DB ADMIN ONLY
- Returns performance of one table DB ADMIN ONLY
- Returns performance on all members for one table DB ADMIN ONLY
- Returns performance timeseries for one table DB ADMIN ONLY
- Returns performance of tables and schemas DB ADMIN ONLY
- Returns current performance of tables and schemas DB ADMIN ONLY
- Executes SQL statements
- Fetches partial results of a SQL job execution
- Returns the results of a SQL query to CSV
- Create a scaling request
- Get supported scaling ranges and current allocated resources
- View scaling history
- Query the list of object schemas
- Create schema
- Drops an empty schema
- Get single object privilege
- Privilege list of selected objects
- Grant or revoke privileges
- Create a new table
- Drop table
- Get table definition
- Query table data
- Get column detail properties
- Get the metadata type
- Generate table DDL
- Get distributin keys
- Get data distributin property
- Get partition expressions
- Get data partitions
- Query view detail properties
- Drop views
- Query view data
- Get View definition
- Generate view DDL
- Get the dependencies of the object
- Query bufferpool detail properties
- Query constraint detail properties
- Query index detail properties
- Query trigger detail properties
- Query MQT detail properties
- Query UDF detail properties
- Query tablespace detail properties
- Query procedure detail properties
- Query sequence detail properties
- Query package detail properties
- Query UDT detail properties
- Query alias detail properties
- Get table detail properties
- Create alias
- Drop alias
- Generate Alias DDL
- Query alias data
- Get the SQL statement template for creating MQT table
- Delete mqt tables
- Get the definition of MQT table
- Get the data of specified mqt table
- Get authentications through the authid filter
- Get the privieles of auth id
- Get SQL statement of grant or revoke privileges
- Add new role
- Grant or revoke the privilges of role
- Delete one role
- Get the membership of authid
- Get SQL statement of grant or revoke role
- Get SQL statement for grant or revoke privileges
- Grant or revole privileges for multiple objects and objects type
- Get the SQL statement for grant or revoke multiple roles
- Grant or revoke multiple roles
- Generate workload DDL
- Lists workloads
- Drop sequences
- Drop procedures
- Retrieve parameters for procedure
- Generate create procedure template
- Drop functions
- Retrieve parameters for specific udf
- Generate create function template
- Drop User-defined Types
- Retrieve row definition for User-defined Type object
- Generate Create User-defined Types template