DB2 10.5 for Linux, UNIX, and Windows

Administrative routines and ADMIN_CMD procedure

This grouping of routines and views can be used to administer your DB2® databases.

You can use dedicated procedures and functions, or the ADMIN_CMD procedure, which is used by applications to run administrative commands.

ADMIN_CMD procedure - Run administrative commands
The ADMIN_CMD procedure is used by applications to run administrative commands using the SQL CALL statement.
ADMIN_COPY_SCHEMA procedure - Copy a specific schema and its objects
The ADMIN_COPY_SCHEMA procedure is used to copy a specific schema and all objects contained in it.
ADMIN_DROP_SCHEMA procedure - Drop a specific schema and its objects
The ADMIN_DROP_SCHEMA procedure is used to drop a specific schema and all objects contained in it.
ADMIN_EST_INLINE_LENGTH function - Estimate length required to inline data
The ADMIN_EST_INLINE_LENGTH function returns an estimate of the inline length that is required to inline the data stored in an XML column, BLOB column, CLOB column, or DBCLOB column.
ADMIN_GET_ENCRYPTION_INFO table function - Get database encryption settings
The ADMIN_GET_ENCRYPTION_INFO table function returns the current encryption settings for a database.
ADMIN_GET_INDEX_COMPRESS_INFO table function - returns compressed index information
The ADMIN_GET_INDEX_COMPRESS_INFO table function returns the potential index compression savings for uncompressed indexes.
ADMIN_GET_INDEX_INFO table function - returns index information
The ADMIN_GET_INDEX_INFO table function returns index information not available in the catalog views, such as compression information and the logical and physical size of the index.
ADMIN_GET_INTRA_PARALLEL scalar function - Get intrapartition parallelism state
The ADMIN_GET_INTRA_PARALLEL scalar function returns the current state of intrapartition parallelism for the application.
ADMIN_GET_MEM_USAGE table function - Get total memory consumption for instance
The ADMIN_GET_MEM_USAGE table function gets the total memory consumption for a given instance.
ADMIN_GET_MSGS table function - Retrieve messages generated by a data movement utility that is executed through the ADMIN_CMD procedure
The ADMIN_GET_MSGS table function is used to retrieve messages generated by a single execution of a data movement utility command through the ADMIN_CMD procedure.
ADMIN_GET_STORAGE_PATHS table function - retrieve automatic storage path information
The ADMIN_GET_STORAGE_PATHS table function returns a list of automatic storage paths for each database storage group, including file system information for each storage path.
ADMIN_GET_TAB_COMPRESS_INFO table function - estimate compression savings
The ADMIN_GET_TAB_COMPRESS_INFO table function estimates the compression savings that can be gained for the table, assuming a REORG with RESETDICTIONARY option will be performed.
ADMIN_GET_TAB_DICTIONARY_INFO table function - report properties of existing table dictionaries
The ADMIN_GET_TAB_DICTIONARY_INFO table function reports the dictionary information of classic row compression for a specified schema and table when the table dictionary was created.
ADMINTABINFO administrative view and ADMIN_GET_TAB_INFO table function - retrieve table size and state information
The ADMINTABINFO administrative view and the ADMIN_GET_TAB_INFO table function provide methods to retrieve table size and state information that is not currently available in the catalog views.
ADMINTEMPCOLUMNS administrative view and ADMIN_GET_TEMP_COLUMNS table function - Retrieve column information for temporary tables
The ADMINTEMPCOLUMNS administrative view and the ADMIN_GET_TEMP_COLUMNS table function provide methods to retrieve column attribute information for created temporary tables and declared temporary tables.
ADMINTEMPTABLES administrative view and ADMIN_GET_TEMP_TABLES table function - Retrieve information for temporary tables
The ADMINTEMPTABLES administrative view and the ADMIN_GET_TEMP_TABLES table function provide methods to retrieve table attribute and instantiation time information for instances of created temporary tables and declared temporary tables.
ADMIN_IS_INLINED function - Determine if data is inlined
The ADMIN_IS_INLINED function retrieves state information about inline data for an XML column, BLOB column, CLOB column, or DBCLOB column.
ADMIN_MOVE_TABLE procedure - Move tables online
The ADMIN_MOVE_TABLE stored procedure moves the data in an active table into a new table object with the same name, while the data remains online and available for access.
ADMIN_MOVE_TABLE_UTIL procedure - Modify the online move table procedure
The ADMIN_MOVE_TABLE_UTIL procedure works in conjunction with the SYSPROC.ADMIN_MOVE_TABLE stored procedure when moving active table data.
ADMIN_REMOVE_MSGS procedure - Clean up messages generated by a data movement utility that is executed through the ADMIN_CMD procedure
The ADMIN_REMOVE_MSGS procedure is used to clean up messages generated by a single execution of a data movement utility command through the ADMIN_CMD procedure.
ADMIN_REVALIDATE_DB_OBJECTS procedure - Revalidate invalid database objects
The ADMIN_REVALIDATE_DB_OBJECTS procedure revalidates database objects.
ADMIN_SET_INTRA_PARALLEL procedure - Enables or disables intrapartition parallelism
The ADMIN_SET_INTRA_PARALLEL procedure enables or disables intrapartition parallelism for a database application. Although the procedure is called in the current transaction, it takes effect starting with the next transaction.