I am trying this query here because I got no useful reply on
alt.php.sql. If you can recommend a better venue for this question, I'd
be glad to hear it.
When I have an Sql statement of the form:

  Test code:
 $dbconn = odbc_connect($dbname, $username, $password);
 $path = "C:\Temp\myJar.jar";
 $statement = "CALL SQLJ.INSTALL_JAR('file://$path', 'myJarId')";

uname -a
Linux XXXX 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686 i686
i386 GNU/Linux
db2level

I have 2 related questions.
DB2 UDB ESE v8.x (8.1 till 8.2 FP2 - all fixpaks included) on AIX 5.4.x
_____________________________________________________________________________
(QUESTION 1)

A select count (*) from table shows
SQL1224N  A database agent could not be started to service a request, or
was terminated as a result of a database system shutdown or a force
command.  SQLSTATE=55032

Is there a possibility to concert a string, which is in a column
defined as 'FOR BIT DATA',  in a normal string, so that i can use the
normal string functions?
I'm using DB2 V7.2 on z/OS.

We have done a script for migration from SQL server to DB2 UDB. Its an
end to end migration. Actually the script has been done by some other
team. My team has given a job of assessment for this script.
I just want to know a checklist that we should be considering while

we have a performance problem with UDB 8.x.
When I start the cotrol center and I select the database and then I
select Table, I became the login Window, I write UID and PWD, finaly
the system run and run and run ...

All,
New to DB2 environment. Can someone share a script that can be used to
a create a DB2 UDB database manually. I am trying to create a database
on Linux, single partition.

Is it possible to define an external stored procedure to be executed
not with the executing user privileges, but instead with the user who
created the stored procedure privileges in db2 version 8.1 on
linux/unix ?

Im trying to install DB2 Connect from a central installation point.
and the program installs as it should, on the target machine,
Is there a way to implement the databases into the installation file?
Best regards

As a newbie to DB2 I have a strange problem on a zSeries linux box I
hope someone can answer.
I have created a linux user,
user=mytest

  Folks,
  I have a PHP script that does:
 $statement = 'SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2';
 $result = odbc_prepare($dbconn, $statement);

I am in a very strange situation, and am looking for suggestions to
tackle it.
I have a 10 gig database on 64-bit windows 2003 running platform. The
database has about 5 gigs of bufferpool. It's a DB2 UDB 8.2 FP9a

I've checked the supported environments list from IBM website
(http://www-306.ibm.com/software/data/db2/linux/validate/), there does
not mention about DB2 UDB V8.1 on RHEL 4.
I know that I can install the latest fixpak for DB2 UDB V8.1 and then