Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: A buffer pool logic error has occurred

    Hi all,

    i am using

    DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL10010"
    with level identifier "0201010E".
    Informational tokens are "DB2 v10.1.0.0", "s120403", "LINUXIA32101", and Fix
    Pack "0".
    Product is installed at "/opt/ibm/db2/V10.1".


    while connecting DB its give error " Bufferpools cant be initialized and db2diag logs the below error about "Logic error in BP". Do anybody experience this earlier and whats the solution.

    2014-07-23-13.06.48.702968+330 I10423422G1277 LEVEL: Error
    PID : 11257 TID : 3036670832 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: db2host.db2domain
    EDUID : 25 EDUNAME: db2pfchr (DBMSTC)
    FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100
    MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"
    DIA8501C A buffer pool logic error has occurred.
    DATA #1 : Codepath, 8 bytes
    7:9:25
    DATA #2 : String, 17 bytes
    preadv() failed !
    DATA #3 : signed integer, 4 bytes
    -1
    DATA #4 : unsigned integer, 4 bytes
    22
    DATA #5 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    File Handle = 119
    File System Block Size = 4096 bytes
    File System Type = ext4
    File Handle Flags :
    Require Sector Align = No
    DIO/CIO Mode = No
    Raw Block Device = No
    Reserved Handle = No
    Flush On Close = No
    Thread-Level Lock = No
    Write-through Mode = Yes
    File Not Tracked = Yes
    DATA #6 : signed integer, 4 bytes
    2
    DATA #7 : signed integer, 4 bytes
    0
    DATA #8 : File Offset, 8 bytes
    28672
    DATA #9 : signed integer, 4 bytes
    12
    DATA #10: signed integer, 4 bytes
    4096
    DATA #11: signed integer, 4 bytes
    0


    thanks and regards
    ssumit
    ssumit

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Better to give the exact error message you get when you start the db2-instance.
    If someone recently changed the bufferpool sizes, then study the docs about the DB2_OVERRIDE_BPF registry variable.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    running base code (GA) is never recommended
    try using latest fp for new installation or try to upgrade to be on current level..
    this is what support center anyhow will direct you to, if PMR is opened
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Thanks db2mor and przytula_guy,

    The version is running confortable from a very long time nor any recent changes has been done except taking a offline full backup, after that , this problem started.

    Exact error is as :
    SQL1478W The defined buffer pools could not be started. Instead, one small
    buffer pool for each page size supported by DB2 has been started.
    SQLSTATE=01626

    Its coming while connecting to db.

    OS memory stats:
    total used free shared buffers cached
    Mem: 1031208 768012 263196 0 117596 397156
    -/+ buffers/cache: 253260 777948
    Swap: 2064376 0 2064376

    db cfg:

    Size of database shared memory (4KB) (DATABASE_MEMORY) = 35000
    Database memory threshold (DB_MEM_THRESH) = 10
    Database heap (4KB) (DBHEAP) = AUTOMATIC(1200)
    Database heap (4KB) (DBHEAP) = AUTOMATIC(1200)
    SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(2048)
    Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256)
    Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(10000)
    Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)
    Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(1)
    Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3)
    Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
    Max number of active applications (MAXAPPLS) = AUTOMATIC(40)
    Average number of active applications (AVG_APPLS) = AUTOMATIC(1)

    dbm cfg:
    Size of instance shared memory (4KB) (INSTANCE_MEMORY) = 100000
    Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(90)
    Instance memory for restart light (%) (RSTRT_LIGHT_MEM) = AUTOMATIC(10)
    Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100)
    Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200)
    Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
    Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS)
    No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(1024)
    No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(512)

    BP details

    BPNAME BUFFERPOOLID DBPGNAME NPAGES PAGESIZE ESTORE NUMBLOCKPAGES BLOCKSIZE NGNAME
    -------------------------------------------------------------------------------------------------------------------------------- ------------ -------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ------ ------------- ----------- --------------------------------------------------------------------------------------------------------------------------------
    IBMDEFAULTBP 1 - 196353 4096 N 0 0 -
    DWHPOOL 2 - 1000 32768 N 0 0 -

    2 record(s) selected.

    I have reduced the size of DWHPOOL but still problem persistes. size reduction of IBMDEFAULTBP is not allowed.

    Any suggestion please.

    ssumit
    ssumit

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as a DB2 dba you should know - to activate a database
    this message is produced because, while executing the first connect - the db will be activated and the BP can NOT be created because of missing memory for this..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Thanks guy ,

    I already understand the fact you have stated, moreover same is clear by the diag message and error thrown while first connect.

    My question is, My DWHPOOL size is 31.25 MB and IBMDEFAULTBP is 767.00MB . IBMDEFAULTBP is too large to initialize at startup, also physical memory is 1G only.

    Is there any way to reduce the size of this pool

    BP details:
    BPNAME BUFFERPOOLID DBPGNAME NPAGES PAGESIZE ESTORE NUMBLOCKPAGES BLOCKSIZE NGNAME
    IBMDEFAULTBP 1 - 196353 4096 N 0 0 -
    DWHPOOL 2 - 1000 32768 N 0 0 -

    Please note root cause of the problem is already known, please suggest solution if any.


    Thanks in advance.
    ssumit

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    looking at alter bufferpool command on this page it should be possible
    IBM Knowledge Center
    all you need : READ TE DOC.....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  8. #8
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ssumit View Post
    please suggest solution if any.
    The solution was given to you by db2mor in the very first response in this thread.
    ---
    "It does not work" is not a valid problem statement.

  9. #9
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    thanks to all, problem resolved by the way which db2mor told. altered the DEFAULTBP SIZE.
    ssumit

Posting Permissions

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