I have a table that has reached its limit. I am unsure if this table belongs to part of the system or the database it resides?
If I drop the object, I'm unsure of what it will do.
It looks like statistics for connections. It is below as well. Does this look familiar
Thanks,
Chris
2010-04-20-08.18.16.952696-240 E2744676E446 LEVEL: Error
PID : 13311 TID : 182957707712PROC : db2event (EPRC001)
INSTANCE: db2inst1 NODE : 000 DB : DPPRC001
APPHDL : 0-11 APPID: *LOCAL.DB2.100420121359
FUNCTION: DB2 UDB, data management, sqldExtendTable, probe:1
MESSAGE : ADM5511E The object "0" of table "DBPRC001.CONN_EPRC001" has reached
the maximum possible size.
2010-04-20-08.18.16.953330-240 I2745123E456 LEVEL: Severe
PID : 13311 TID : 182957707712PROC : db2event (EPRC001)
INSTANCE: db2inst1 NODE : 000 DB : DPPRC001
APPHDL : 0-11 APPID: *LOCAL.DB2.100420121359
FUNCTION: DB2 UDB, database monitor, sqm_ttarget::write_data, probe:119
DATA #1 : String, 88 bytes
Event Monitor Name: EPRC001;
TableName: CONN_EPRC001;
Insertion failed while inserting !
2010-04-20-08.18.16.953455-240 I2745580E494 LEVEL: Severe
PID : 13311 TID : 182957707712PROC : db2event (EPRC001)
INSTANCE: db2inst1 NODE : 000 DB : DPPRC001
APPHDL : 0-11 APPID: *LOCAL.DB2.100420121359
FUNCTION: DB2 UDB, database monitor, sqm_ttarget::write_data, probe:150
RETCODE : ZRC=0x8404000A=-2080112630=SQLD_RC_MAX_OBJ_SIZE
"ARCHITECTURAL 64GB LIMIT REACHED"
DIA8710E Maximum table size was reached.
Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
ACC_CURS_BLK SYSIBM BIGINT 8 0 No
AGENT_ID SYSIBM BIGINT 8 0 No
APPL_ID SYSIBM CHARACTER 32 0 No
APPL_PRIORITY SYSIBM BIGINT 8 0 No
APPL_PRIORITY_TYPE SYSIBM BIGINT 8 0 No
APPL_SECTION_INSERTS SYSIBM BIGINT 8 0 No
APPL_SECTION_LOOKUPS SYSIBM BIGINT 8 0 No
APPL_STATUS SYSIBM BIGINT 8 0 No
AUTHORITY_LVL SYSIBM BIGINT 8 0 No
BINDS_PRECOMPILES SYSIBM BIGINT 8 0 No
CAT_CACHE_HEAP_FULL SYSIBM BIGINT 8 0 No
CAT_CACHE_INSERTS SYSIBM BIGINT 8 0 No
CAT_CACHE_LOOKUPS SYSIBM BIGINT 8 0 No
CAT_CACHE_OVERFLOWS SYSIBM BIGINT 8 0 No
CAT_CACHE_SIZE_TOP SYSIBM BIGINT 8 0 No
COMMIT_SQL_STMTS SYSIBM BIGINT 8 0 No
COORD_NODE SYSIBM BIGINT 8 0 No
DDL_SQL_STMTS SYSIBM BIGINT 8 0 No
DEADLOCKS SYSIBM BIGINT 8 0 No
DIRECT_READ_REQS SYSIBM BIGINT 8 0 No
DIRECT_READ_TIME SYSIBM BIGINT 8 0 No
DIRECT_READS SYSIBM BIGINT 8 0 No
DIRECT_WRITE_REQS SYSIBM BIGINT 8 0 No
DIRECT_WRITE_TIME SYSIBM BIGINT 8 0 No
DIRECT_WRITES SYSIBM BIGINT 8 0 No
DISCONN_TIME SYSIBM TIMESTAMP 10 0 No
DYNAMIC_SQL_STMTS SYSIBM BIGINT 8 0 No
ELAPSED_EXEC_TIME SYSIBM BIGINT 8 0 No
EVMON_FLUSHES SYSIBM BIGINT 8 0 No
FAILED_SQL_STMTS SYSIBM BIGINT 8 0 No
HASH_JOIN_OVERFLOWS SYSIBM BIGINT 8 0 No
HASH_JOIN_SMALL_OVERFLOWS SYSIBM BIGINT 8 0 No
INT_AUTO_REBINDS SYSIBM BIGINT 8 0 No
INT_COMMITS SYSIBM BIGINT 8 0 No
INT_DEADLOCK_ROLLBACKS SYSIBM BIGINT 8 0 No
INT_ROLLBACKS SYSIBM BIGINT 8 0 No
INT_ROWS_DELETED SYSIBM BIGINT 8 0 No
INT_ROWS_INSERTED SYSIBM BIGINT 8 0 No
INT_ROWS_UPDATED SYSIBM BIGINT 8 0 No
LOCK_ESCALS SYSIBM BIGINT 8 0 No
LOCK_TIMEOUTS SYSIBM BIGINT 8 0 No
LOCK_WAIT_TIME SYSIBM BIGINT 8 0 No
LOCK_WAITS SYSIBM BIGINT 8 0 No
PARTIAL_RECORD SYSIBM SMALLINT 2 0 No
PKG_CACHE_INSERTS SYSIBM BIGINT 8 0 No
PKG_CACHE_LOOKUPS SYSIBM BIGINT 8 0 No
POOL_DATA_FROM_ESTORE SYSIBM BIGINT 8 0 No
POOL_DATA_L_READS SYSIBM BIGINT 8 0 No
POOL_DATA_P_READS SYSIBM BIGINT 8 0 No
POOL_DATA_TO_ESTORE SYSIBM BIGINT 8 0 No
POOL_DATA_WRITES SYSIBM BIGINT 8 0 No
POOL_INDEX_FROM_ESTORE SYSIBM BIGINT 8 0 No
POOL_INDEX_L_READS SYSIBM BIGINT 8 0 No
POOL_INDEX_P_READS SYSIBM BIGINT 8 0 No
POOL_INDEX_TO_ESTORE SYSIBM BIGINT 8 0 No
POOL_INDEX_WRITES SYSIBM BIGINT 8 0 No
POOL_READ_TIME SYSIBM BIGINT 8 0 No
POOL_TEMP_DATA_L_READS SYSIBM BIGINT 8 0 No
POOL_TEMP_DATA_P_READS SYSIBM BIGINT 8 0 No
POOL_TEMP_INDEX_L_READS SYSIBM BIGINT 8 0 No
POOL_TEMP_INDEX_P_READS SYSIBM BIGINT 8 0 No
POOL_WRITE_TIME SYSIBM BIGINT 8 0 No
PREFETCH_WAIT_TIME SYSIBM BIGINT 8 0 No
PRIV_WORKSPACE_NUM_OVERFLOWS SYSIBM BIGINT 8 0 No
PRIV_WORKSPACE_SECTION_INSERTS SYSIBM BIGINT 8 0 No
PRIV_WORKSPACE_SECTION_LOOKUPS SYSIBM BIGINT 8 0 No
PRIV_WORKSPACE_SIZE_TOP SYSIBM BIGINT 8 0 No
REJ_CURS_BLK SYSIBM BIGINT 8 0 No
ROLLBACK_SQL_STMTS SYSIBM BIGINT 8 0 No
ROWS_DELETED SYSIBM BIGINT 8 0 No
ROWS_INSERTED SYSIBM BIGINT 8 0 No
ROWS_READ SYSIBM BIGINT 8 0 No
ROWS_SELECTED SYSIBM BIGINT 8 0 No
ROWS_UPDATED SYSIBM BIGINT 8 0 No
ROWS_WRITTEN SYSIBM BIGINT 8 0 No
SELECT_SQL_STMTS SYSIBM BIGINT 8 0 No
SEQUENCE_NO SYSIBM CHARACTER 4 0 No
SHR_WORKSPACE_NUM_OVERFLOWS SYSIBM BIGINT 8 0 No
SHR_WORKSPACE_SECTION_INSERTS SYSIBM BIGINT 8 0 No
SHR_WORKSPACE_SECTION_LOOKUPS SYSIBM BIGINT 8 0 No
SHR_WORKSPACE_SIZE_TOP SYSIBM BIGINT 8 0 No
SORT_OVERFLOWS SYSIBM BIGINT 8 0 No
STATIC_SQL_STMTS SYSIBM BIGINT 8 0 No
SYSTEM_CPU_TIME SYSIBM BIGINT 8 0 No
TOTAL_HASH_JOINS SYSIBM BIGINT 8 0 No
TOTAL_HASH_LOOPS SYSIBM BIGINT 8 0 No
TOTAL_SORT_TIME SYSIBM BIGINT 8 0 No
TOTAL_SORTS SYSIBM BIGINT 8 0 No
UID_SQL_STMTS SYSIBM BIGINT 8 0 No
UNREAD_PREFETCH_PAGES SYSIBM BIGINT 8 0 No
USER_CPU_TIME SYSIBM BIGINT 8 0 No
X_LOCK_ESCALS SYSIBM BIGINT 8 0 No