DB2 for LUW - Instance Manager

Toolbar Operations -

Available Operations for all tabs
Refresh : Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Find: Find tool to search the grid of the current tab
Find Next: Find the next instance of the previous find

General Tab - Provides a summary of the DB2 for LUW instance
DB2 Server Component: Name of the DBMS
Value: Version of the DBMS

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

DB2 for LUW Registry Parameters Tab - DB2 for LUW instance parameters

Partition: Indicates whether the parameter can be changed during a session (dynamic)
Parameter: Name of the parameter
Value: Value of the parameter
Aggregate: Shows if there is an aggregate
Aggregate Name: Name of the aggregate
Level: Level of the parameter
 

DB2 for LUW Database Parameters Tab - DB2 for LUW instance parameters

Partition: Indicates whether the parameter can be changed during a session (dynamic)
Parameter: Name of the parameter
Value: Value of the parameter
Value Flags: Current value
Deferred Value: Minimum value of the parameter
Deferred Value Flags: Maximum value of the parameter