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 > termina

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 installe

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 passwo

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{DB2INSTANC

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 nee

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 seems

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 > > 21

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 faile

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

2002-11-06 Thread Darin McBride
f directly. ;-) > So I will perservere with re-organising my program so option 1 will work > > 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

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 '/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:' > at the use DBD::Oracle line. > > Other programs that just have

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 t