Roberto,
You have to use the db2profile that is in the [$DB2HOME]/sqllib directory.
It contains all the environment variables that are needed for your web
server to run your scripts. It sets up your DB2DIR, DB2INSTANCE, INSTHOME,
PATH, the java path, LD_LIBRARY_PATH and runs the UDB Extender
initialization.
Try that, this problem is just an environment not completly setup to run
DB2.
Good Luck.
-----Original Message-----
From: roberto l [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 12:39 PM
Cc: [EMAIL PROTECTED]
Subject: Re: Total Environment allocation failure!
Well, I've placed the .profile into the home of the nobody user, my original
post included the script with the setup of all the variables, and still the
same
error! Another suggestion?
"Warden, Ronald MCF:EX" wrote:
> This is simply a problem of permissions and environment variables. If you
> shell is a csh you have source'd the {DB2HOME}/sqllib/db2cshrc file that
> set's up all of environment variables and path's. You can cheat and just
> copy those things into the web server's shell or have the shell that
invokes
> the db2cshrc before starting the web services. If you don't want to do
that
> you just have to go through what the db2cshrc is setting up and add those
to
> the environment.
>
> Either way is easy to do.
>
> Cheers
>
> -----Original Message-----
> From: roberto l [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 8:41 AM
> Cc: [EMAIL PROTECTED]
> Subject: Re: Total Environment allocation failure!
>
> The scripts run perfect at the shell prompt. I can execute with no
problem,
> and query the database perfectly. Current cgi directory is /cgi-bin, the
> user
> running the webserver is nobody
>
> >
> > Have you tried to set the variables in the shell
> > and run this script from there (and not as CGI)?
> >
> > As an off-topic, I always wonder why don't people
> > spend a minute to make their code more readable:
> >
> > $ENV{THREADS_FLAG} = q|native|;
> > $ENV{JAVA_HOME} = q|/usr/java|;
> > $ENV{LANG} = q|en_US|;
> >
> > And why do you use "." and ".." here:
> >
> > > $ENV{CLASSPATH}=qq|.:..:/opt/WebSphere/CommerceSuite/AdvSvr/lib:/opt/
> >
> > What is the current directory for a CGI-scipt?
>
> --
> De duobus malis, minus est semper eligendum
--
De duobus malis, minus est semper eligendum
