Version Info
   DBI 1.48
   DBD Driver for DB2 UDB: 0.78
   DB2 8.2.3

They finally found some money to get (me) some new hardware fro the
database server. At the same time I'm upgrading from DB2 v8 to v9. Still on
Linux but on a 64 bit machine while the old one ran on 32 bit.
Now I have the problem of copying the databases and all the user

I'm trying to use ADMIN_CMD procedure in my SQL procedure like this:
DROP PROCEDURE IMPORT_DATA#
CREATE PROCEDURE IMPORT_DATA()
SPECIFIC IMPORT_DATA

I have given 'SELECT','INSERT' privileges to a user 'group' for a set of
tables.
But a user gets a prompt that he does not the 'SELECT' privilege on that
particular table. The user does belong to the group which has been granted

We have had a couple situations where DB/2 died due to someone sending
one of the DB/2 processes a kill 9. When this occurs, DB/2 goes down
and I noticed in the db2dump directory some files called
db2eventlog.000 and db2eventlog.000.crash. I renamed one of them to

If I do a
SELECT .... WHERE DTEXT LIKE '%Findit%'
on an iSeries, I won't get records with 'findit' because the LIKE Operator
is case sensitive.

All,
I am experiencing an issue that has confused me, albiet this is not
difficult to do.  Any help anyone could provide would be greatly
appreciated.

Is it possible to have clustered two db2 instances?
Thanks in advance?

I am new to DB2 database.I just have the basic knowledge abt this
database.I in a serious situation of handling 5 large databases.Can
some one help me how to prepare the health check report for the
databases.

Can I get the equivalent information for the following commands
using SYSCAT or SYSIBM tables.
db2 list tablespace containers for 14 show detail
db2 list history backup since 20061018 for dbname

I want to check whether DAS has started using ps command, but I donot
know what is the key.
eg. ps -Aef | grep -i ??? (How to complete the ???)
Thanks a lot.

i have a class file like this  ,
import java.sql.*;
   public class JAVA_UDF  {
       /*

I need to update a fairly wide non-indexed column for a very large
number of rows in several tables. One solution we were tossing around
was to avoid all the problems with performance and log space by
exporting the data to flat files, using an external program to make the

can someone tell me what exactly the value "Direct reads" means (i.e. how is
it calculated), when analysing the bufferpool snapshot?
What I do know is that it shows the number of reads that didn't go through
the bufferpool, but I would like to know why.

I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem connecting
to sample (or any other databases - local or remote), but if I ...