perl dbi built on DB2 8.2 does not run on 9.1

Discussion in 'Perl Misc' started by dcruncher4@aim.com, Jul 25, 2008.

  1. Guest

    Our perl DBI is built on DB2 8.2. It runs fine on 8.2

    However it does not run on 9.1. After the connect to the database, at the first
    SQL it gives this error

    "sql0818n A timestamp conflict occurred sqlstate 51003"

    Are we suppose to rebuild perl DBI for db2 in ver 9.1
     
    , Jul 25, 2008
    #1
    1. Advertisements

  2. J. Gleixner Guest

    wrote:
    > Our perl DBI is built on DB2 8.2. It runs fine on 8.2
    >
    > However it does not run on 9.1. After the connect to the database, at the first
    > SQL it gives this error
    >
    > "sql0818n A timestamp conflict occurred sqlstate 51003"
    >
    > Are we suppose to rebuild perl DBI for db2 in ver 9.1
    >


    I don't use DB2, however spending a couple of minutes searching
    the Internet for that error seems to point to a db2stats.bnd
    problem.


    Cause
    The db2stats.bnd package is not bound after fix pack installations.

    And may sites list how to update it.



    It probably wouldn't hurt to rebuild DBD with the new 9.1 libraries.
     
    J. Gleixner, Jul 25, 2008
    #2
    1. Advertisements

  3. Guest

    On Jul 25, 10:47 am, wrote:
    > Our perl DBI is built on DB2 8.2. It runs fine on 8.2
    >
    > However it does not run on 9.1. After the connect to the database, at thefirst
    > SQL it gives this error
    >
    > "sql0818n A timestamp conflict occurred sqlstate 51003"
    >
    > Are we suppose to rebuild perl DBI for db2 in ver 9.1


    This should be fixed after you bind these:

    db2 CONNECT TO MYDB
    db2 BIND $HOME/sqllib/bnd/@db2ubind.lst BLOCKING ALL GRANT PUBLIC
    db2 BIND $HOME/sqllib/bnd/@db2cli.lst BLOCKING ALL GRANT PUBLIC
    db2 BIND $HOME/sqllib/bnd/db2schema.bnd BLOCKING ALL GRANT PUBLIC
    db2rbind MYDB all /l $HOME/MYDB.log
     
    , Jul 25, 2008
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Kate Perry

    connect to db2 database using dbi?

    Kate Perry, Jul 10, 2003, in forum: Perl
    Replies:
    0
    Views:
    3,503
    Kate Perry
    Jul 10, 2003
  2. Carmine

    dbi db2 select

    Carmine, Aug 25, 2003, in forum: Perl
    Replies:
    0
    Views:
    2,073
    Carmine
    Aug 25, 2003
  3. Replies:
    0
    Views:
    7,935
  4. Dinesh
    Replies:
    0
    Views:
    282
    Dinesh
    Apr 3, 2006
  5. Replies:
    0
    Views:
    298
  6. Nicholas Quaine

    DBI:ibm_db connection for IBM DB2 database

    Nicholas Quaine, Apr 25, 2008, in forum: Ruby
    Replies:
    2
    Views:
    325
    Gerardo Santana Gómez Garrido
    Apr 29, 2008
  7. Wonderinguy

    Perl DBI and DB2 Stored Procedure

    Wonderinguy, May 7, 2004, in forum: Perl Misc
    Replies:
    3
    Views:
    648
    Knut Stolze
    May 10, 2004
  8. Dieter Brensteiner

    DBI - DBD-DB2 Problem - Please help

    Dieter Brensteiner, Jun 2, 2005, in forum: Perl Misc
    Replies:
    3
    Views:
    561
    Dieter Brennsteiner
    Jun 3, 2005
Loading...