Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2003
    Posts
    9

    Exclamation Unanswered: Tablespace 3 was mapped to BufferPool 2 which doesnot exist or currently is the wrong

    2003-04-16-08.49.31.523860 Instance:db2inst1 Node:000
    PID:27338(db2agent (COGAIX)) Appid:8E589450.047A.030416064036
    oper_system_services sqloopenp Probe:36 Database:COGAIX

    errno: 0000 001a ....


    2003-04-16-08.55.49.815601 Instance:db2inst1 Node:000
    PID:34488(db2agent (COGAIX)) Appid:8E589450.049F.030416065508
    buffer_pool_services sqlbStartPools Probe:22 Database:COGAIX

    Tablespace 3 was mapped to BufferPool 2 which doesnot exist or currently is the wrong pagesize.
    No bufferpool with pagesize 32768 exists.


    2003-04-16-08.55.49.874627 Instance:db2inst1 Node:000
    PID:34488(db2agent (COGAIX)) Appid:8E589450.049F.030416065508
    buffer_pool_services sqlbCreatePool Probe:920 Database:COGAIX
    DIA9999E An internal error occurred. Report the following error code :
    "FFFFA105".


    Any idea of that problem? I have no clue!


    Thanks,


    Sebastian

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: Tablespace 3 was mapped to BufferPool 2 which doesnot exist or currently is the w

    Hi Sebastian,

    >>
    Tablespace 3 was mapped to BufferPool 2 which doesnot exist or currently is the wrong pagesize.
    No bufferpool with pagesize 32768 exists.

    Anything changed with your database recently? Assigned too large memory chunks to bufferpools or something? System memory exhausted and bufferpools don't get started at first connect to database?

    You can do "select * from syscat.bufferpools" and then consider recreating the bufferpool with BUFFERPOOLID 2.

    Can you still connect to your database?

    Johann

  3. #3
    Join Date
    Apr 2003
    Posts
    9
    yes a connect is successfull but i cannot create tables or do something else. i will try your tip and follow up. Be back in a few minutes.

    Bye

  4. #4
    Join Date
    Apr 2003
    Posts
    9
    after creating a new bufferpool --> System memory exhausted and bufferpools don't get started at first connect to database?

    May that be the problem.

    But I think I will need a new buffer pool /table space with page size of 32 ? or am i wrong?

    What can I do, to solve the problem?


    Thank you for your help.

  5. #5
    Join Date
    Apr 2003
    Posts
    191
    Hi Sebastian,

    you need to first establish what DB2's earliest complaint is after a db2start + db2 connect.

    As instance owner, you could:

    $ db2 deactivate db ...
    $ db2stop # at least make sure everbody logs out from the stricken database
    $ cd ~/sqllib/db2dump
    $ mv db2diag.log db2diag.log-old && touch db2diag.log
    $ db2start

    Check if something is wrong in db2diag.log.

    Then

    $ db2 connect to ...

    Check again if something is wrong in db2diag.log.

    Did you create new tablespaces recently? I wouldn't expect this problem to surface unless there was something extraordinary happening before, like removal of system memore, OS upgrade, or installation of a database backup on a remote and smaller machine.

    Please try to find the root cause of your problems first. Then the rest should be easy.

    Johann

  6. #6
    Join Date
    Apr 2003
    Posts
    9

    Red face

    2003-04-17-11.31.09.565397 Instance:db2inst1 Node:000
    PID:26814(db2star2) Appid:none
    oper_system_services licRequestAccess Probe:2

    SQL8008N The product "DB2 Connect Enterprise Edition" does not have a valid
    license key installed and the evaluation period has expired. Functions
    specific to this product are not enabled.


    2003-04-17-11.31.10.787232 Instance:db2inst1 Node:000
    PID:29124(db2spmrm) Appid:none
    oper_system_services sqloopenp Probe:36

    errno: 0000 0011 ....


    thats all in the diag.log .


    Any idea?

  7. #7
    Join Date
    Apr 2003
    Posts
    191
    Hi Sebastian,

    >>
    SQL8008N The product "DB2 Connect Enterprise Edition" does not have a valid
    license key installed and the evaluation period has expired. Functions
    specific to this product are not enabled.

    What DB2 Connect? Are you operating against a host database?

    Is DB2 Connect the only product installed on your machine? Are you positive you are logged into the right system?

    Possible options are:
    1) If you don't need host access, consider removing DB2 Connect
    2) If you want to test drive DB2 as a database server, get yourself an evaluation edition without DB2 Connect. DB2 Connect is used as a host database gateway only.
    3) If you need DB2 Connect but have no license key, reinstall DB2 Connect and get licenses from IBM.
    4) If you have got DB2 Connect licenses, install them using db2licm.

    Cheers

    Johann

  8. #8
    Join Date
    Apr 2003
    Posts
    9

    Question

    What DB2 Connect? Are you operating against a host database?

    Is DB2 Connect the only product installed on your machine? Are you positive you are logged into the right system?

    I receive this message when i am logged on the aix and starting the db with db2start

    2) If you want to test drive DB2 as a database server, get yourself an evaluation edition without DB2 Connect. DB2 Connect is used as a host database gateway only.

    - So this message should be no problem, or am I wrong?

    To get closer to the problem some explanation from me.

    I tried to use the db2java.zip from the java2 directory under sqllib, but everytime I connecting to the aix my Software dumps and in the jdbc client log the message

    on the server side in the jdbcerr.log the following is written down:

    (Thu Apr 17 12:11:50 2003) pid= 20682 getBufferCount(): Error during recv, einfo= 73 (client IP = 142.88.148.80)
    (Thu Apr 17 12:11:50 2003) pid= 20682 jdbcServiceConnection(): Invalid Request Received., einfo= 0 (client IP = 142.88.148.80)
    (Thu Apr 17 12:11:50 2003) pid= 20682 jdbcSend(): send() error, einfo= 32 (client IP = 142.88.148.80)

    the client I am connecting with logs the following:

    COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0621E Unsupported JDBC Server configuration.

  9. #9
    Join Date
    Apr 2003
    Posts
    191
    Hi Sebastian,

    > I receive this message when i am logged on the aix and starting the db with db2start

    > So this message should be no problem, or am I wrong?

    I believe licensing issues to be the cause of your problem.

    > To get closer to the problem some explanation from me.

    Sorry I can't help with this, I don't usually use Java apps. Also, I believe this is not the point here.

    If the license period has expired recently and you are experiencing trouble just since then, I would expect that you are using DB2 Connect evaluation edition exclusively. And yes, you can use DB2 Connect to build local databases. This would be consistent with what you reported.

    Please solve the license issues first. Remember, you can either install licenses (with db2licm) or try reinstall the software, and get licenses from IBM.

    Johann

  10. #10
    Join Date
    Apr 2003
    Location
    P.R.China
    Posts
    6
    1) If you are not connecting to a DB2 on mainframe, you don't need use DB2 connect Enterprise Edition. CHeck your CDs and select right product when running db2setup
    2) If you need use DB2 connect product and you have the right CDs, you can find the license under db2/license/connect or something like,then use db2licm -a license_filename to install the license
    3) If you need it but have not license, you have to buy DB2 from IBM to get the license

Posting Permissions

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