Ive just installed DB2 9.1 from scratch on Solaris 10.
I did it first from CLI, but i found the Control Center app was
missing. So i tried to edit the install using db2setup. this informed
me that everything was installed.

Hi all i am using AIX 5.2
Some one has accidentally deleted some files from the server causing
my database server to crash.
We have recovered from the situation but need to find out the guilty

Folks,
 I am running DB2 UDB V8.2 on AIX 5.3.
 I have setup two DB2 instances on a system, they are identical in
 configuration and size. I exported all tables from production and loaded

Hi, guys
I am new to Db2.  Here is my first trivial question.
Let's say I have a simple SELECT statement in a text file called
query1.txt, I want to load the statement from that file and run it in

can any one help me in detecting a deadlock and to clear the deadlock
when it occours?
how to monitor the databases for deadlocks?

I have a table with two columns: number and timestamp.
I would like to do a max function on number and also select the the
corresponding timestamp.
I expected the SQL to be something like this but doesnt work:

I wonder if anyone has compared the db2 universal jdbc driver type 2
and 4 with the legacy db2 driver. Which one is the best to use ? I'm
working in a project where the envm looks like this
Solaris 10

I've run into situations where a table was accidentally dropped. The
related database contained lots of other tables in lots of other schemas
used by many different users. So I couldn't simply recover to a previous
point in time (the other users' changes would be lost and/or there ...

I am looking for the syntax to call a function within the stored
procedure.
For example....
function checkvalue( pv1 )

I have an application that uses the old join syntax instead of the
SQL92 standards join syntax.
I need to justify changing the code to the new standard.
Is there any performance issue related to using the old syntax that

WinXP, db2 v8.2.7
When I use
UPDATE COMMAND OPTION USING <any_switch> ON(or OFF)
it seems that this command has absolutely no effect on these switches

i have a db2-database and a frontend where i create some rows and
insert them into my database.
unfortunately the solution with autoincrement-pk isn't working for me
and a solution with stored procedures isn't wanted either because I

We use the IBM OLE DB Provider for DB2 to connect to a database on AIX
5.2 from SQL Server Integration Service. But there is some codepage
problems. On AIX we use ISO-8859-1, when use DB2 CLP, we should first
set DB2CODEPAGE property to 819(using db2set DB2CODEPAGE=819). Our OLE