Re: db2 - persistent connection

2006-09-05 Thread Darin McBride
On Monday 04 September 2006 22:28, Jack Faley ( The Tao of Jack ) wrote: Thank you for your reply. If their was any way to mitigate the small exits I would do it but I'm modifying an app that was never meant to be extensible. So, you are correct, Im moving the load to a daemon in the middle

Re: db2 - persistent connection

2006-09-04 Thread Darin McBride
On Saturday 02 September 2006 00:21, Jack Faley ( The Tao of Jack ) wrote: I have several ( 100 - 200 ) small exits c oming from an app that update db2 tables. This works fine but the dba's don't like that many open connection overheads. This isn't cgi/apache. These are all seperate

Re: compilation requirements for DBD-DB2

2004-10-13 Thread Darin McBride
On October 12, 2004 1:27 pm, Edward Peschko wrote: hey all, I'm missing a piece, I guess, in the install of DB2.. I have the libraries, etc. installed in /opt/IBM/db2/V8.1. Did you install the application development tools with DB2? If you have the Application Development Client installed,

Re: Perl / DB2 administrative API

2004-08-07 Thread Darin McBride
On August 6, 2004 6:54 am, [EMAIL PROTECTED] wrote: [ Not really DBI related, but Tim suggested I post here ] We're starting to write our own administration functions for DB2, and are currently developing a perl module that provides access (through XS code) to the DB2 administrative API.

Re: Help with DB2 DBI Connection

2004-08-02 Thread Darin McBride
On July 29, 2004 9:53 am, Jay harris wrote: I am onsite at a client, and they use AIX/DB2-UDB V8. They have an automated scheduling package that starts jobs using su super user, and then passes the account like a nohup would do. My problem is that the dbi connect seems to require a password,

Re: db2 with apache2 cgi

2004-06-01 Thread Darin McBride
On June 1, 2004 1:47 pm, Alec Brecher wrote: kind of an apache2 crossover problem: when perl cgi scripts using dbi:db2 are called I get the total enviroment failure error. I can run scripts using dbi:db2 from the shell without a problem. Can anyone offer some hints? Set $ENV{DB2INSTANCE}

Re: Antwort: Re: Access into MVS DB2 using DBI or ???

2004-04-05 Thread Darin McBride
On April 5, 2004 5:00 pm, Wagner, David --- Senior Programmer Analyst --- WGO wrote: [EMAIL PROTECTED] wrote: Hi, as I already mentioned this morning, you don't need anything special in perl to access a DB2 on a mainframe nor on any other operating system. All You need is dbi and

make test problems

2004-03-26 Thread Darin McBride
As I was testing another module that used DBI, I found some interesting behaviour while trying to trace/debug my DBI interactions. Rather than posting a bunch of code, I managed to find that I could reproduce this with the DBI 1.42 distribution directly. The problem is that turning on trace

Re: make DBI-1.35 Fails on HP-UX 11i and Perl 5.8.0

2003-04-04 Thread Darin McBride
On April 4, 2003 01:41 pm, [EMAIL PROTECTED] wrote: That is why the DBI build fails. Work with your systems folks to make sure you have a good GCC on this box. How could you have possibly built perl with gcc on this box? Read the README.hpux that comes with DBD-Oralce. Lincoln

quote vs placeholders (was Re: Huge performance difference between command line and DBI interfaces Solved)

2003-03-31 Thread Darin McBride
On March 31, 2003 10:41 am, Ronald J Kimball wrote: On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote: I have discovered that it is the placement of single quotes around the key value in the query: my $rth = $dbh-prepare(SELECT * FROM demographics_1 WHERE

Re: DBD::DB2 Do I need to compile on each box or can I copy the installed version to another box? (AIX)

2003-02-08 Thread Darin McBride
On February 5, 2003 10:29 am, [EMAIL PROTECTED] wrote: Hello, My environment is as follows: AIX 4.3.3.0 running perl 5.005_03 Installed DBI 1.32 Installed DB2 vsn 7.2 I'm requiring install of the DBD::DB2 driver onto a number of AIX RS6000 machines. The install originally failed

Re: use DBD::Oracle qw(:ora_types); - from cron

2002-11-06 Thread Darin McBride
Michael Fox -Original Message- From: Darin McBride [mailto:darin;naboo.to.org] Sent: Wednesday, November 06, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: Re: use DBD::Oracle qw(:ora_types); - from cron On November 5, 2002 04:41 pm, you wrote: When I need to have a use DBD::Oracle qw

Re: use DBD::Oracle qw(:ora_types); - from cron

2002-11-05 Thread Darin McBride
On November 5, 2002 04:41 pm, you wrote: When I need to have a use DBD::Oracle qw(:ora_types); in my program, and I am running from cron, I get a message like: Can't load 'long path/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:' at the use DBD::Oracle line. Other programs that just

Re: Problem with set DB2_HOME environment variable during install DBD:DB2

2002-10-24 Thread Darin McBride
On October 24, 2002 07:20 pm, Limei Zhang wrote: Hi, there, I am using DB2 Runtime client (V7.2) on linux redhat 7.3. I am try to install DBD:DB2 (0.76)that I can run perl program to remote access database in the DB2 server. You need to use the Application Development Client to compile the