DBD::DB2 and Apache::DBI problem

From: ricardo Guerra Flores (ricardo.guerra_at_es.ibm.com)
Date: 09/22/04 

To: dbi-users@perl.org
Date: Wed, 22 Sep 2004 18:31:19 +0200

Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl

This is the trace when connecting throug Apache:

8750 Apache::DBI PerlChildInitHandler
    -> DBI->connect(dbi:DB2:DATABASE,USER, ****, HASH(0x20283528))
    -> DBI->install_driver(DB2) for aix perl=5.008 pid=65638 ruid=211
euid=211
    -> DBI->connect(DBI:DB2:DATABASE,USER, ****, HASH(0x20a1415c))
    -> DBI->install_driver(DB2) for aix perl=5.008 pid=65638 ruid=211
euid=211
       install_driver: DBD::DB2 version undef loaded from
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBD/DB2.pm
    -> $DBI::errstr (&) FETCH from lasth=none

And this is the trace when i run it as a stand alone program:

8750 Apache::DBI PerlChildInitHandler
    DBI 1.42-ithread default trace level set to Ox2/0 (in pid 58518)
    -> DBI->connect(DBI:DB2:DATABASE, USER, ****)
    -> DBI->install_driver(DB2) for aix perl=5.008 pid=58518 ruid=0 euid=0
       install_driver: DBD::DB2 version 0.76 loaded from
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBD/DB2.pm
    <- install_driver= DBI::dr=HASH(0x2016b5e8)
    -> connect for DBD::DB2::dr (DBI::dr=HASH(0x2016b5e8)~0x20551850
'INFORMES' 'sige' **** HASH(0x20552af8)) thr#20019348
connect 'DATABASE', 'USER', 'pass' <- connect= DBI::db=HASH(0x205518d4)
at DBI.pm line 587
    -> STORE for DBD::DB2::db (DBI::db=HASH(0x20552b28)~INNER 'PrintError'
1) thr#20019348

does someone has any idea on what's happening??

thanks.

Ricardo Guerra

Relevant Pages

  • sp_create_trace throws Errorcode = 12
    ... I'm trying to execute server-side trace with SqlServer 2000 on ... If it helps I added script which I tried to execute: ... declare @TraceID int ...
    (comp.databases.ms-sqlserver)
  • Re: LTT user input
    ... and to that end have taken the existing trace infrastructure ... script for that event (if there's a handler defined for the event ... This gives the script a chance to do whatever Perlish thing it ... syscall totals to individual syscall totals for each pid. ...
    (Linux-Kernel)
  • Re: SQL Profiler Scheduling
    ... Can you create a stored procedure from the script, ... Kalen Delaney, SQL Server MVP ... declare @TraceID int ... -- display trace id for future references ...
    (microsoft.public.sqlserver.tools)
  • Re: Whats more important optimisations or debugging?
    ... the trace interrupt service routine is executed after ... ISR, so you had to check from the processor status word, if the T ... executing even a single instruction or does it execute the next ...
    (comp.arch.embedded)
  • Re: Similar question about Auto Startup Trace
    ... Please take a look at the script created. ... "Harry G" wrote in message ... > If I script the trace like this, when the trace auto ...
    (microsoft.public.sqlserver.tools)