SQL Administrative Routines

8 8 8

EXEC_DB2_SCRIPT procedure unavailable

8

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 8

GET_DB_CONFIG is a stored procedure

8

GET_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.

8

The schema is SYSPROC.

8

The 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.

8

This procedure requires a user temporary table space that is used to create 8a global temporary table to store the result set.

7 7 7

Column expansion for snapshot UDFs

7

The size of some VARCHAR and CLOB columns in snapshot UDFs have changed 7to match the maximum database object name standards.

7

7 77777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777777
Table 29. Expanded columns for UDFs
UDF
Column name Existing column definition Updated column definition
SYSFUN.SQLCACHE_SNAPSHOT
DB_NAME VARCHAR(8) VARCHAR(128)
STMT_TEXT CLOB(64K) CLOB(16M)
SNAPSHOT_APPL_INFO
APPL_NAME VARCHAR(255) VARCHAR(256)
APPL_ID VARCHAR(32) VARCHAR(128)
AUTH_ID VARCHAR(30) VARCHAR(128)
CLIENT_NNAME VARCHAR(20) VARCHAR(128)
CLIENT_PRDID VARCHAR(20) VARCHAR(128)
INPUT_DB_ALIAS VARCHAR(20) VARCHAR(128)
CLIENT_DB_ALIAS VARCHAR(20) VARCHAR(128)
DB_NAME VARCHAR(8) VARCHAR(128)
DB_PATH VARCHAR(256) VARCHAR(1024)
EXECUTION_ID VARCHAR(20) VARCHAR(128)
CORR_TOKEN VARCHAR(32) VARCHAR(128)
TPMON_CLIENT_USERID VARCHAR(20) VARCHAR(256)
TPMON_CLIENT_WKSTN VARCHAR(20) VARCHAR(256)
TPMON_CLIENT_APP VARCHAR(20) VARCHAR(256)
TPMON_ACC_STR VARCHAR(100) VARCHAR(200)
SNAPSHOT_STATEMENT
CURSOR_NAME VARCHAR(31) VARCHAR(128)
CREATOR VARCHAR(32) VARCHAR(128)
PACKAGE_NAME VARCHAR(20) VARCHAR(128)
STMT_TEXT CLOB(64K) CLOB(16M)
SNAPSHOT_LOCKWAIT
TABLE_NAME VARCHAR(35) VARCHAR(128)
TABLE_SCHEMA VARCHAR(32) VARCHAR(128)
APPL_ID_HOLDING_LK VARCHAR(32) VARCHAR(128)
SNAPSHOT_DATABASE
INPUT_DB_ALIAS VARCHAR(8) VARCHAR(128)
DB_NAME VARCHAR(8) VARCHAR(128)
DB_PATH VARCHAR(256) VARCHAR(1024)
SNAPSHOT_BP
BP_NAME VARCHAR(20) VARCHAR(128)
DB_NAME VARCHAR(8) VARCHAR(128)
INPUT_DB_ALIAS VARCHAR(8) VARCHAR(128)
DB_PATH VARCHAR(256) VARCHAR(1024)
SNAPSHOT_LOCK
TABLE_NAME VARCHAR(35) VARCHAR(128)
TABLE_SCHEMA VARCHAR(32) VARCHAR(128)
SNAPSHOT_TABLE
TABLE_NAME VARCHAR(35) VARCHAR(128)
TABLE_SCHEMA VARCHAR(32) VARCHAR(128)
SNAPSHOT_TBREORG
TABLE_NAME VARCHAR(35) VARCHAR(128)
TABLE_SCHEMA VARCHAR(32) VARCHAR(128)
SNAPSHOT_SUBSECT
STMT_TEXT CLOB(64K) CLOB(16M)
SNAPSHOT_DYN_SQL
STMT_TEXT CLOB(64K) CLOB(16M)
HEALTH_DBM_INFO
SERVER_INSTANCE_NAME VARCHAR(8) VARCHAR(128)
HEALTH_DBM_HI
SERVER_INSTANCE_NAME VARCHAR(8) VARCHAR(128)
HEALTH_DBM_HI_HIS
SERVER_INSTANCE_NAME VARCHAR(8) VARCHAR(128)
HEALTH_DB_INFO
DB_NAME VARCHAR(8) VARCHAR(128)
INPUT_DB_ALIAS VARCHAR(8) VARCHAR(128)
DB_PATH VARCHAR(256) VARCHAR(1024)
HEALTH_DB_HI
DB_NAME VARCHAR(8) VARCHAR(128)
HEALTH_DB_HI_HIS
DB_NAME VARCHAR(8) VARCHAR(128)
HEALTH_DB_HIC
DB_NAME VARCHAR(8) VARCHAR(128)
HEALTH_DB_HIC_HIS
DB_NAME VARCHAR(8) VARCHAR(128)
7 7
Note:
7
The definition of STMT_TEXT for the SNAPSHOT_DYN_SQL, 7SNAPSHOT_STATEMENT, SNAPSHOT_SUBSECT, and SQLCACHE_SNAPSHOT routines has 7expanded to CLOB(16M) to allow for future expansion only. Actual output of 7the statement text data will continue to be truncated at 64K.
[ Top of Page |Previous Page | Next Page | Contents ]