If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Architectural 64gb limit reached

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-20-10, 08:37
compuguruchris compuguruchris is offline
Registered User
 
Join Date: Apr 2010
Posts: 7
Architectural 64gb limit reached

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
Reply With Quote
  #2 (permalink)  
Old 04-20-10, 09:17
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by compuguruchris View Post

Event Monitor Name: EPRC001;
TableName: CONN_EPRC001;
Disable the event monitor, then you can drop the table. Apparently, you don't need it.
Reply With Quote
  #3 (permalink)  
Old 04-20-10, 10:21
compuguruchris compuguruchris is offline
Registered User
 
Join Date: Apr 2010
Posts: 7
I tried to disable the event monitor but because it was too large and monitor crashed I couldn't set the start to off. So, I dropped the event monitor and dropped the table associated.

Thanks for putting me on the right path, was big help
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On