Viewing the status of the updates to nickname statistics
After you request an update to the statistics for a nickname, you can view the status of the update.
About this task
Procedure
To view the status of updates to nickname statistics from the Db2® command line, look in the SYSPROC.FED_STATS table.
The following example shows a describe of the table:
SYSPROC.FED_STATS (The actual length of the columns is reduced to
simplify the example.):
db2 describe table sysproc.fed_stats
Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
SERVER SYSIBM VARCHAR 128 0 Yes
SCHEMA SYSIBM VARCHAR 128 0 Yes
NICKNAME SYSIBM VARCHAR 128 0 Yes
STATS_UPDATE_TIME SYSIBM TIMESTAMP 10 0 No
LOG_FILE_PATH SYSIBM VARCHAR 1000 0 Yes
SQLCODE SYSIBM INTEGER 4 0 Yes
SQLSTATE SYSIBM CHARACTER 5 0 Yes
STATUS SYSIBM VARCHAR 1000 0 Yes
8 record(s) selected.
db2 "select * from sysproc.fed_stats"
SERVER SCHEMA NICKNAME STATS_UPDATE_TIME LOG_FILE_PATH SQLCODE
------ ------- -------- -------------------------- ------------- ----------
ORA8 HAROLDL NICK1 2006-05-02-12.03.24.927112 - 1791 42704
SQLSTATE STATUS
-------- --------------------------------------------------------------------
SQL1791N The specified server definition, schema, or nickname does not exist.
1 record(s) selected.
.