15.5.1 Instance Manager

General Tab - Provides a summary of the DB2 for LUW instance

DBMS_NAME: Name of the DBMS
DBMS_VER: Version of the DBMS
DBE_NAME: Unused
OWNER_TERM: Adaptive Server’s term for a table owner (the second part of a three-part name)
TABLE_TERM: Adaptive Server’s term for a table (the third part of a three-part name)
MAX_OWNER_NAME_LENGTH: Maximum length of the name for a table owner (the second part of a three-part name)
IDENTIFIER_CASE: The case sensitivity of user-defined names (table names, column names, and stored procedure names) in the database
        (the case in which these objects are presented in the system catalogs)
COLUMN_LENGTH: The maximum number of characters for a column name
TABLE_LENGTH: The maximum number of characters for a table name
USERID_LENGTH: The maximum number of characters for a user name
TX_ISOLATION: The initial transaction isolation level the server assumes, corresponding to an isolation level defined in SQL92
COLLATION_SEQ: The assumed ordering of the character set for this server
MAX_QUAL_LENGTH: Maximum length of the name for a table qualifier (the first part of a three-part table name)
QUALIFIER_TERM: Adaptive Server’s term for a table qualifier (the first part of a three-part name)
SAVEPOINT_SUPPORT: Does the underlying DBMS support named savepoints?
MULTI_RESULT_SETS: Does the underlying DBMS or the gateway itself support multiple results sets (can multiple statements be sent through
        the gateway, with multiple results sets returned to the client)?
NAMED_TRANSACTIONS: Does the underlying DBMS support named transactions?
SPROC_AS_LANGUAGE: Can stored procedures be executed as language events?
REMOTE_SPROC: Can stored procedures be executed through the remote stored procedure APIs in DB-Library?
ACCESSIBLE_TABLES: In sp_tables, does the gateway return only tables, views, and so on, that are accessible by the current user
        (that is, the user who has at least select privileges for the table)?
ACCESSIBLE_SPROC: In sp_stored_procedures, does the gateway return only stored procedures that are executable by the current user?
MAX_INDEX_COLS: Maximum number of columns in an index for the DBMS
RENAME_TABLE: Can tables be renamed?
RENAME_COLUMN: Can columns be renamed?
DROP_COLUMN: Can columns be dropped?
INCREASE_COLUMN_LENGTH: Can column size be increased?
DDL_IN_TRANSACTION: Can DDL statements appear in transactions?
DESCENDING_INDEXES: Are descending indexes supported?
SP_RENAME: Can a stored procedure be renamed?
SYS_SPROC_VERSION: The version of the catalog stored procedures currently implemented