Topic
  • 9 replies
  • Latest Post - ‏2011-05-13T21:07:52Z by PGMT_Fernando_Soto
SystemAdmin
SystemAdmin
5837 Posts

Pinned topic Buffer pool logic error

‏2008-02-08T12:38:42Z |
Hi there,
i'm still new in using ibm db2, and right now i'm trying to install IBM DB2 Express-C v9.5 on a laptop with intel 64-bit Gentoo OS.
yes i know that Gentoo is not on the supported OS list, but i've manage to install it on PC also running Gentoo, so i thought i might just give it a try...

the installation using db2_install works fine, i can create and running DAS as well the instance without a problem.
but when i'm trying to create a database, it always gives me "Bad container path" error.
i don't see any problem on the permission rights, i've compared it with DB2 environment on the PC which ran fine there, so i take alook on the db2diag.log and found this "buffer pool logic error".
2008-02-08-19.00.23.332809+420 I111733E480 LEVEL: Event
PID : 21521 TID : 47775215511872PROC : db2sysc
INSTANCE: db2iadm1 NODE : 000
APPHDL : 0-49 APPID: *LOCAL.db2iadm1.080208120023
AUTHID : DB2IADM1
EDUID : 19 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB SAMPLE : "Database_memory" From: "20" <automatic> To: "23776" <automatic>

2008-02-08-19.00.23.420902+420 E112214E1013 LEVEL: Error (OS)
PID : 21521 TID : 47775215511872PROC : db2sysc
INSTANCE: db2iadm1 NODE : 000
APPHDL : 0-49 APPID: *LOCAL.db2iadm1.080208120023
AUTHID : DB2IADM1
EDUID : 19 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.
CALLED : OS, -, open OSERR: EINVAL (22)
DATA #1 : Codepath, 8 bytes
5:6:14:21:22:37
DATA #2 : File name, 61 bytes
/home/db2iadm1/db2iadm1/NODE0000/SAMPLE/T0000000/C0000000.CAT
DATA #3 : Bitmask, 4 bytes
0x00A0003F
DATA #4 : Hex integer, 4 bytes
0x00000180
DATA #5 : signed integer, 4 bytes
0
DATA #6 : signed integer, 4 bytes
16384
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.

2008-02-08-19.00.23.421149+420 I113228E488 LEVEL: Error
PID : 21521 TID : 47775215511872PROC : db2sysc
INSTANCE: db2iadm1 NODE : 000
APPHDL : 0-49 APPID: *LOCAL.db2iadm1.080208120023
AUTHID : DB2IADM1
EDUID : 19 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:820
MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
"Bad container path"

2008-02-08-19.00.23.421221+420 I113717E543 LEVEL: Error
PID : 21521 TID : 47775215511872PROC : db2sysc
INSTANCE: db2iadm1 NODE : 000
APPHDL : 0-49 APPID: *LOCAL.db2iadm1.080208120023
AUTHID : DB2IADM1
EDUID : 19 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:820
DATA #1 : String, 118 bytes
Error acquiring container 0 (/home/db2iadm1/db2iadm1/NODE0000/SAMPLE/T0000000/C0000000.CAT) for tbsp 0. Rc = 8002003C

2008-02-08-19.00.23.421289+420 I114261E613 LEVEL: Error
PID : 21521 TID : 47775215511872PROC : db2sysc
INSTANCE: db2iadm1 NODE : 000
APPHDL : 0-49 APPID: *LOCAL.db2iadm1.080208120023
AUTHID : DB2IADM1
EDUID : 19 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbASSetPoolContsForDMS, probe:70
MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
"Bad container path"
DATA #1 : String, 11 bytes
SYSCATSPACE
DATA #2 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
0
DATA #3 : unsigned integer, 8 bytes
1

can anyone tell me why this happen? and perhsps the solution to my problem here?
i've search on google but still can't find any information bout this error message.

i've tried to reinstall it several times, i've even tried to copy a working DB2 installed environment from the PC to the laptop with no luck (both have same arch).

@};- nightscholar

Message was edited by: nightscholar
Updated on 2011-05-13T21:07:52Z at 2011-05-13T21:07:52Z by PGMT_Fernando_Soto
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Buffer pool logic error

    ‏2008-02-08T20:48:19Z  
    Hello,

    It's failing because it's trying to create this file

    /home/db2iadm1/db2iadm1/NODE0000/SAMPLE/T0000000/C0000000.CAT

    Can you check if this is accessible? Can you try manually creating this file and see what happens?

    Terry
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Buffer pool logic error

    ‏2008-02-11T05:42:22Z  
    Hello,

    It's failing because it's trying to create this file

    /home/db2iadm1/db2iadm1/NODE0000/SAMPLE/T0000000/C0000000.CAT

    Can you check if this is accessible? Can you try manually creating this file and see what happens?

    Terry
    sorry for the delay in my response, the laptop that i'm working with, belong to my bos, so i can only have access to it at work.
    about the qustion, i've never tried to create the file manually or even try to edit it, but i can remove it as the instance user name.
    the permission for the file is read and write for the instance username (file owner) and none for others.

    anyway, my bos eventually decide to reformat the partition and (surprisingly) everything finally work, i never thought that partition block settings really matters in installing a database server till now...

    well, time to get to the next level, connecting to remote db2 server.

    thanks for your reply and sorry for my bad english (it's not my native language)
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Buffer pool logic error

    ‏2008-02-11T15:45:09Z  
    sorry for the delay in my response, the laptop that i'm working with, belong to my bos, so i can only have access to it at work.
    about the qustion, i've never tried to create the file manually or even try to edit it, but i can remove it as the instance user name.
    the permission for the file is read and write for the instance username (file owner) and none for others.

    anyway, my bos eventually decide to reformat the partition and (surprisingly) everything finally work, i never thought that partition block settings really matters in installing a database server till now...

    well, time to get to the next level, connecting to remote db2 server.

    thanks for your reply and sorry for my bad english (it's not my native language)
    Ah, so the file already exists there before the create database command started?

    I suspect what happens is there has been previous attempts to create a database but the creation somehow got interrupted that left these files around. So it actually makes sense that the reformat helps.

    Good luck with your testings ;-)
    Terry
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Buffer pool logic error

    ‏2008-02-14T04:14:15Z  
    Ah, so the file already exists there before the create database command started?

    I suspect what happens is there has been previous attempts to create a database but the creation somehow got interrupted that left these files around. So it actually makes sense that the reformat helps.

    Good luck with your testings ;-)
    Terry
    the db2iadm1 directory inside the instance user homedir (which is where the file reside) doesn't exist before i try to create a database, so i can assure you that it was in fact created after my attempt to create a database.
    so the database creating process did successfully create the file, but somehow just can't get access to it? i know that it surely sounds like permission problem, but the instance user is able to delete it, so it does have the apropriate permission to access such file, well, access to delete it anyway.

    i've also tried to removed the user account along with it's home directory and then recreate it (followed with recreation of DAS and instance) in the process to see if it somehow worked out (several times, by the way), but it doesn't solve my problem.
    hmm, it makes me think, maybe it is caused by unclean installation of DB2 product from the previous failure installation, afterall, all i did is just delete the /opt/ibm and /var/db2 directory (and kill all relevant process), well in several attempt, i've also used the db2_deinstall method.

    anyway, do you happen to know a site or two (other than ibm) where i can find a nice tutorial about DB2 for a complete newbie like me? i'm having a problem in understanding some db2 spesific terms, hehehe.

    Message was edited by: nightscholar
    Updated on 2008-02-14T04:14:15Z at 2008-02-14T04:14:15Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Buffer pool logic error

    ‏2008-02-15T15:29:16Z  
    the db2iadm1 directory inside the instance user homedir (which is where the file reside) doesn't exist before i try to create a database, so i can assure you that it was in fact created after my attempt to create a database.
    so the database creating process did successfully create the file, but somehow just can't get access to it? i know that it surely sounds like permission problem, but the instance user is able to delete it, so it does have the apropriate permission to access such file, well, access to delete it anyway.

    i've also tried to removed the user account along with it's home directory and then recreate it (followed with recreation of DAS and instance) in the process to see if it somehow worked out (several times, by the way), but it doesn't solve my problem.
    hmm, it makes me think, maybe it is caused by unclean installation of DB2 product from the previous failure installation, afterall, all i did is just delete the /opt/ibm and /var/db2 directory (and kill all relevant process), well in several attempt, i've also used the db2_deinstall method.

    anyway, do you happen to know a site or two (other than ibm) where i can find a nice tutorial about DB2 for a complete newbie like me? i'm having a problem in understanding some db2 spesific terms, hehehe.

    Message was edited by: nightscholar
    Hm, if this happens again, I suggest opening a PMR to deal with it..

    btw you may find this link useful:

    http://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting+Started+with+DB2+Express-C
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Buffer pool logic error

    ‏2008-02-18T10:05:53Z  
    Hm, if this happens again, I suggest opening a PMR to deal with it..

    btw you may find this link useful:

    http://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting+Started+with+DB2+Express-C
    errm... what's a PMR?

    it's happening again!
    at first, i can't connect to any database i've created previously. So, i decided to reinstall DAS and the instance to see if it fixed.
    reinstallation process works fine, but when i try to create the database... WHAM!! got stuck with the same problem again. :sad:

    it happens after my bos updates all the OS library on his laptop.

    DB2 is a really being picky on me, seeing all the problem, my bos suggest that we return to oracle...
  • igorM
    igorM
    265 Posts

    Re: Buffer pool logic error

    ‏2008-02-18T13:55:14Z  
    errm... what's a PMR?

    it's happening again!
    at first, i can't connect to any database i've created previously. So, i decided to reinstall DAS and the instance to see if it fixed.
    reinstallation process works fine, but when i try to create the database... WHAM!! got stuck with the same problem again. :sad:

    it happens after my bos updates all the OS library on his laptop.

    DB2 is a really being picky on me, seeing all the problem, my bos suggest that we return to oracle...
    Hi,
    first of all I think Gentoo Linux is not supported by DB2. So you are installing on non-supported platform. So problems can accour and no-one will know the answer. I suggest if there is no boder to you to try to install on any other distro. I have installed DB2 on Ubuntu. See more info in my how-to http://www-128.ibm.com/developerworks/forums/thread.jspa?messa geID=14028783&#14028783 At the bottom of page there are also other links to other installs.

    What is PMR? If you have a problem you can request for help from IBM. DB2 Express-C offers free software but you can also buy a support.

    Hope this helps,
    IgorM
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Database creation error

    ‏2008-05-27T12:41:18Z  
    I am having same problem on 64 bit Ubuntu 8.04 Hardy with DB2 express 9.5 64 bit.

    I have installed db2 using db2 ubuntu deb package and also using manual command line installation steps, because server does not run X server.
    I get same error : "SQL0298N Bad container path. SQLSTATE=428B2". I get same problem when creating sample database using db2sampl command. I am sure, I have permission to access
    database files.

    I have tried same version, but 32 bit on 32 bit machine and everything works. Here I have used db2setup graphical installator.

    So either 64 bit DB2 on 64 bit ubuntu does not work or command line installators do something wrong (or forget something) comparing to graphical db2setup install tool.

    I need some tip how to solve this problem.
  • PGMT_Fernando_Soto
    PGMT_Fernando_Soto
    1 Post

    Re: Database creation error

    ‏2011-05-13T21:07:52Z  
    I am having same problem on 64 bit Ubuntu 8.04 Hardy with DB2 express 9.5 64 bit.

    I have installed db2 using db2 ubuntu deb package and also using manual command line installation steps, because server does not run X server.
    I get same error : "SQL0298N Bad container path. SQLSTATE=428B2". I get same problem when creating sample database using db2sampl command. I am sure, I have permission to access
    database files.

    I have tried same version, but 32 bit on 32 bit machine and everything works. Here I have used db2setup graphical installator.

    So either 64 bit DB2 on 64 bit ubuntu does not work or command line installators do something wrong (or forget something) comparing to graphical db2setup install tool.

    I need some tip how to solve this problem.
    Check if your filesystem supports O_DIRECT flag - see open(2) man pages
    ext3 with data=journal, for example, doesn't support it.
    DB2 since version 9.5 uses NO FILESYSTEM CACHING option by default, what would cause the "Bad Container path" error when trying to create a new database on filesystems that don't support O_DIRECT.