The documentation currently includes the description of a procedure named 8EXEC_DB2_SCRIPT. Because this procedure is not part of the product, its description 8should be disregarded.
8 8 8GET_DB_CONFIG is a stored procedure, not a table function. The documentation 8for GET_DB_CONFIG incorrectly identifies this procedure as a table function. 8The following text is the correct description.
8The schema is SYSPROC.
8The GET_DB_CONFIG procedure returns database configuration information. 8The procedure does not take any arguments. It returns a single result set 8with two rows containing a column for each parameter. The row with a value 8of 0 in the DBCONFIG_TYPE column contains the values of the database configuration 8parameters that are stored on disk. The row with a value of 1 in the DBCONFIG_TYPE 8column contains the current values of the database configuration parameters 8that are stored in memory.
8This procedure requires a user temporary table space that is used to create 8a global temporary table to store the result set.
7 7 7The size of some VARCHAR and CLOB columns in snapshot UDFs have changed 7to match the maximum database object name standards.
7 7 7UDF | 7||
---|---|---|
Column name | 7Existing column definition | 7Updated column definition | 7
SYSFUN.SQLCACHE_SNAPSHOT | 7||
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
STMT_TEXT | 7CLOB(64K) | 7CLOB(16M) | 7
SNAPSHOT_APPL_INFO | 7||
APPL_NAME | 7VARCHAR(255) | 7VARCHAR(256) | 7
APPL_ID | 7VARCHAR(32) | 7VARCHAR(128) | 7
AUTH_ID | 7VARCHAR(30) | 7VARCHAR(128) | 7
CLIENT_NNAME | 7VARCHAR(20) | 7VARCHAR(128) | 7
CLIENT_PRDID | 7VARCHAR(20) | 7VARCHAR(128) | 7
INPUT_DB_ALIAS | 7VARCHAR(20) | 7VARCHAR(128) | 7
CLIENT_DB_ALIAS | 7VARCHAR(20) | 7VARCHAR(128) | 7
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
DB_PATH | 7VARCHAR(256) | 7VARCHAR(1024) | 7
EXECUTION_ID | 7VARCHAR(20) | 7VARCHAR(128) | 7
CORR_TOKEN | 7VARCHAR(32) | 7VARCHAR(128) | 7
TPMON_CLIENT_USERID | 7VARCHAR(20) | 7VARCHAR(256) | 7
TPMON_CLIENT_WKSTN | 7VARCHAR(20) | 7VARCHAR(256) | 7
TPMON_CLIENT_APP | 7VARCHAR(20) | 7VARCHAR(256) | 7
TPMON_ACC_STR | 7VARCHAR(100) | 7VARCHAR(200) | 7
SNAPSHOT_STATEMENT | 7||
CURSOR_NAME | 7VARCHAR(31) | 7VARCHAR(128) | 7
CREATOR | 7VARCHAR(32) | 7VARCHAR(128) | 7
PACKAGE_NAME | 7VARCHAR(20) | 7VARCHAR(128) | 7
STMT_TEXT | 7CLOB(64K) | 7CLOB(16M) | 7
SNAPSHOT_LOCKWAIT | 7||
TABLE_NAME | 7VARCHAR(35) | 7VARCHAR(128) | 7
TABLE_SCHEMA | 7VARCHAR(32) | 7VARCHAR(128) | 7
APPL_ID_HOLDING_LK | 7VARCHAR(32) | 7VARCHAR(128) | 7
SNAPSHOT_DATABASE | 7||
INPUT_DB_ALIAS | 7VARCHAR(8) | 7VARCHAR(128) | 7
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
DB_PATH | 7VARCHAR(256) | 7VARCHAR(1024) | 7
SNAPSHOT_BP | 7||
BP_NAME | 7VARCHAR(20) | 7VARCHAR(128) | 7
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
INPUT_DB_ALIAS | 7VARCHAR(8) | 7VARCHAR(128) | 7
DB_PATH | 7VARCHAR(256) | 7VARCHAR(1024) | 7
SNAPSHOT_LOCK | 7||
TABLE_NAME | 7VARCHAR(35) | 7VARCHAR(128) | 7
TABLE_SCHEMA | 7VARCHAR(32) | 7VARCHAR(128) | 7
SNAPSHOT_TABLE | 7||
TABLE_NAME | 7VARCHAR(35) | 7VARCHAR(128) | 7
TABLE_SCHEMA | 7VARCHAR(32) | 7VARCHAR(128) | 7
SNAPSHOT_TBREORG | 7||
TABLE_NAME | 7VARCHAR(35) | 7VARCHAR(128) | 7
TABLE_SCHEMA | 7VARCHAR(32) | 7VARCHAR(128) | 7
SNAPSHOT_SUBSECT | 7||
STMT_TEXT | 7CLOB(64K) | 7CLOB(16M) | 7
SNAPSHOT_DYN_SQL | 7||
STMT_TEXT | 7CLOB(64K) | 7CLOB(16M) | 7
HEALTH_DBM_INFO | 7||
SERVER_INSTANCE_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
HEALTH_DBM_HI | 7||
SERVER_INSTANCE_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
HEALTH_DBM_HI_HIS | 7||
SERVER_INSTANCE_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
HEALTH_DB_INFO | 7||
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
INPUT_DB_ALIAS | 7VARCHAR(8) | 7VARCHAR(128) | 7
DB_PATH | 7VARCHAR(256) | 7VARCHAR(1024) | 7
HEALTH_DB_HI | 7||
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
HEALTH_DB_HI_HIS | 7||
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
HEALTH_DB_HIC | 7||
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7
HEALTH_DB_HIC_HIS | 7||
DB_NAME | 7VARCHAR(8) | 7VARCHAR(128) | 7