Learn when you want, where you want with convenient online training courses. Sign up now!
Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
lock_wait_time/nullif(lock_waits,0) as avg_wt_time,
total_sort_time/nullif(total_sorts,0) as avg_sort_time,
sort_overflows/nullif(total_sorts,0) as pct_ovflow_sorts
from table (snapshot_database (' ', -1) ) as snapshot_database;
Open in new window
DB2 Database Error: ERROR  [IBM][DB2/SUN] SQL0443N Routine "SYSPROC.SNAPSHOT_DATABASE" (specific name "SNAPSHOT_DATABASE") has returned an error SQLSTATE with diagnostic text "SNAPSHOT_DATABASE".
substr(table_schema,1,8) as Schema,
substr(table_name,1,30) as Table_Name,
from table (snapshot_table ('sample', -1) ) as snapshot_table;
DB2 Database Error: ERROR  [IBM][DB2/SUN] SQL0443N Routine "*OT_TABLE" (specific name "*OT_TABLE") has returned an error SQLSTATE with diagnostic text "SQL1092 Reason code or token: <username> ".
Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.
Lookup Error - DB2 Database Error: ERROR  [IBM][DB2/SUN] SQL0443N Routine "SYSPROC.SNAPSHOT_APPL" (specific name "SNAPSHOT_APPL") has returned an error SQLSTATE with diagnostic text "SQL1611".
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
SELECT db_path, server_platform
FROM TABLE( HEALTH_DB_INFO( cast (NULL as VARCHAR(1)), -1 ) )
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
SNAPSHOT_TIMESTAMP SYSIBM TIMESTAMP 10 6 Yes
DB_NAME SYSIBM VARCHAR 128 0 Yes
INPUT_DB_ALIAS SYSIBM VARCHAR 128 0 Yes
DB_PATH SYSIBM VARCHAR 1024 0 Yes
DB_LOCATION SYSIBM INTEGER 4 0 Yes
SERVER_PLATFORM SYSIBM INTEGER 4 0 Yes
ROLLED_UP_ALERT_STATE SYSIBM BIGINT 8 0 Yes
ROLLED_UP_ALERT_STATE_DETAIL SYSIBM VARCHAR 20 0 Yes
Changed or additional information
Navigating the DB2 Information Center
Searching the DB2 Information Center
Navigating by keyboard
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.