Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    14

    Unanswered: Error msg "sqlbSMSDeleteObject" before system down! DB2 v9.1 FP7

    Hello,

    I am experiencing a number of errors in the db2diag.log on different days , for three months .

    This entire period , the environment suffered only two stops abnormal , but I noticed that when he suffered the charts , the messages were the same .

    DB2 v9.1 FP7 32 bits

    Below is the complete sequence of the message before the fall :

    2014-02-12-16.05.07.750000-120 I376911H289 LEVEL: Error
    PID : 2740 TID : 4840 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDeleteObject, probe:830
    MESSAGE : ZRC=0x830004C8=-2097150776

    2014-02-12-16.05.07.750000-120 I377202H327 LEVEL: Error
    PID : 2740 TID : 4840 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDeleteObject, probe:830
    DATA #1 : String, 46 bytes
    Obj={pool:5;obj:14;type:128} State=x37 Cont=0

    2014-02-12-16.05.07.766000-120 I377531H738 LEVEL: Error
    PID : 2740 TID : 4840 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDeleteObject, probe:0
    DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 68 bytes
    Obj: {pool:5;obj:14;type:128} Parent={5;14}
    lifeLSN: 160143019000
    tid: 0 0 0
    extentAnchor: 0
    initEmpPages: 0
    poolPage0: 0
    poolflags: 111
    objectState: 37
    lastSMP: 0
    pageSize: 4096
    extentSize: 16
    bufferPoolID: 1
    partialHash: 2148401157
    bufferPool: 0x085e89f0

    2014-02-12-16.05.07.781000-120 E378271H609 LEVEL: Warning
    PID : 2740 TID : 4840 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbPFPrefetcherEntryPoint, probe:100
    MESSAGE : ADM6022W Asynchronous drop of a temporary table failed. The
    resources associated with this table will not be freed until next
    database startup. You are advised to restart the database for this
    reason. You are also advised to contact IBM support to determine the
    reason for the failure.

    2014-02-12-16.05.07.812000-120 I378882H846 LEVEL: Error
    PID : 2740 TID : 4840 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbPFPrefetcherEntryPoint, probe:105
    MESSAGE : ZRC=0x830004C8=-2097150776
    DATA #1 : String, 31 bytes
    Prefetcher unable to drop temp.
    DATA #2 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 68 bytes
    Obj: {pool:5;obj:14;type:128} Parent={5;14}
    lifeLSN: 160143019000
    tid: 0 0 0
    extentAnchor: 0
    initEmpPages: 0
    poolPage0: 0
    poolflags: 111
    objectState: 27
    lastSMP: 0
    pageSize: 4096
    extentSize: 16
    bufferPoolID: 1
    partialHash: 2148401157
    bufferPool: 0x085e89f0

    Already suspected of disc problem, but not sure yet.
    Anyone have an idea? Any help?

    thank you

  2. #2
    Join Date
    Nov 2008
    Posts
    14
    Ah, I noticed that the error is always occurring in SMS tablespaces + System Temporary Tablespace.

Tags for this Thread

Posting Permissions

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