Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > perl dbi built on DB2 8.2 does not run on 9.1

Reply
Thread Tools

perl dbi built on DB2 8.2 does not run on 9.1

 
 
dcruncher4@aim.com
Guest
Posts: n/a
 
      07-25-2008
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

 
Reply With Quote
 
 
 
 
J. Gleixner
Guest
Posts: n/a
 
      07-25-2008
http://www.velocityreviews.com/forums/(E-Mail Removed) 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.
 
Reply With Quote
 
 
 
 
bwmiller16@gmail.com
Guest
Posts: n/a
 
      07-25-2008
On Jul 25, 10:47*am, (E-Mail Removed) 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
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DB2 under Windows XP - "Missing DB2 Libraries or headers" daf@jaade.com Ruby 0 04-26-2006 03:08 PM
Installing ruby-db2-0.4 for DB2 gives SQLConnect() errors. Dinesh Ruby 0 04-03-2006 04:20 AM
Hibernate 3.1 and db2 connecting using com.ibm.db2.jcc.DB2Driver crawstevenford@gmail.com Java 0 02-19-2006 08:20 PM
Perl DBI and DB2 Stored Procedure Wonderinguy Perl Misc 3 05-10-2004 06:09 AM
connect to db2 database using dbi? Kate Perry Perl 0 07-10-2003 06:44 PM



Advertisments