This might seem like a basic question but I have some doubts, please
humour me.
I have a client-server application using java where each client on
each machine needs to directly communicate directly with the database.

I need to upgrade db2 7.2 workgroup admin client to 8.1 workgroup --
do I need to first unistall the existing version, or can I simply
install the 8.1 over the existing 7.2 without first uninstalling 7.2?
Thank you very much again.

I'm running DB2 8.1.5 on Windows 2000 professional SP4.
When I try to start Control Center, I see the splash
screen for a while, then it closes and nothing else happens.
It happens with "Activity center" (Since I'm running the

How are the following two commands different as far as the 'end
result' of the restores is concerned:
1. db2 RESTORE DB mydb
2. db2 RESTORE DB mydb TABLESPACE

Hi, I have db2 workgroup 7.2 and am planning to upgrade to 8.1
workgroup server edition. Could someone please tell me if the order in
which I do this as listed below is correct?
ON THE SERVER

I have db2 workgroup server 8.1 and I need to download fixpaks -- I
find that there are 2 kinds of fixpaks available, 32 bit and 64 bit.
How do I know which one I need? Is it better to go with the 32 bit?
Also how do I find out how many bits the workgroup server 8.1

I am unable to find the website where I can download the admin and
runtime clients for 8.1 workgroup edition -- help please! Thank you
again!

I have a new Linux RH 9.0 server, on which I'm trying to setup DB2.  I
did the RPM install of IBMJava2-JRE-1.4.1-2.0, which I got from the IBM
site.  All *APPEARED* to have worked fine.  But ... rpm -aq IBMJava2-JRE-
1.4.1-2.0 shows no entry.  A simple rpm -aq shows it as the last ...

Is it possible to specify the sequence of the returned rows?  I have
four incident types('IN', 'UN', 'SU', 'OT').  If I do an order by they
will be returned in that sequence.  However the report calls for
returning them with 'OT' type last.  This is being used in ColdFusion

I am using the latest trial version of DB2 on Windows.
I would like to modify the contents of a table and Control Center allows me
to view the contents by right clicking on the table name selecting "sample
contents". But it seems it give me back a read only view. Is there a way to

I am having problems getting this sql update statement to work in a
db2 sql stored procedure or if I try to execute it as an input script
to db2 command line.  It works fine if I execute it using a SQL editor
on another product we use (dbartisan).  What happens is that the first

What's the difference between using "catalog node" and catalog admin node"?

Which is the best driver for accessing to DB2 (in ab AS/400) from a win2k
via ODBC? is there known problems so far? I mean, memory management bugs,
access degradation, etc.
Thanks,

I need to convert the values of a varchar (..) for bit data column to a
string which can be stored in a normal varchar column (with additional
information).
Is there a function in db2 which supports this?

I have a procedure which returns 2 resultsets. if i call the procedure
with input params, it is showing a windows message box saying that
db2bp.exe error and when checked the db2dial.log file, the entries are
as follows: