Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    7

    Unanswered: 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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •