i am trying on my Windows XP Prof. Maschine connect a DB2 Server with version 7,
which is installed remote on a Solaris Machine.
On my local machine is a DB2 V8 installed.
I can connect to a another DB2 with version 8 without any problems, but

I have a DB2 V7.1 running on RedHat 7.1. It is very stable. The DB2 is
an installation from Internet download 2 years ago. We have little use
of the system for this year.
Recently, I find that it can no longer startup with error message of

I am a newbie at this level of DBA.
Due to flakiness by my ISP, apparently I have left lots of hanging
transactions in the log file( SQL0964C, 57011). They are worthless but
stopping my later transaction, so how do I get rid of these logged but

Folks,
Ive been trying to clean up a lot of old code that I have inherited
and make it more efficient. In the process I have been spending hours
with my nose buried in the sql reference manuals and here in the

I have defined a daily backup of my DB2 7.2 database. The backup is not
incremental, and every night Tivoli is configured to backup the disk on
which the DB2 backup is placed.
So my question is: Can I define a backup that overwrites the backup from the

I have the backup command
BACKUP DATABASE NEST TO C:\\databases WITH 2 BUFFERS BUFFER 1024 $
How do I force all the user to disconnect? before running the above command

Hello people,
Thanks to Serge, PM, Knut and a host of others I have now successfully
completed my very first SQL Stored Procedure. Takes some 13mins or so
to run, but that was expected as it does a fairly significant number

hi, i try to user db2dart tool remotely, that means i would like to do
the analysis over a remote database, but how to do that ? please help.

All-
I am having a problem where my DB2 administrator account on Windows
(db2admin) is losing its local Administrator privledges.  This happens
randomly throughout the day with no ryhme or reason.

I tried to integrate the db2java.zip as a jdbc driver into eclipse.
On win2k, db2 8.2., eclipse 2.1. Other jdbc drivers are working properly.
eclipse recognizes the driver at COM.ibm.db2.jdbc.app.DB2Driver
the URL is jdbc:db2//localhost:6789/SAMPLE with the SAMPLE DB up and

When creating a table with a CLOB column, I can (should?) specify the
maximum length of the CLOB.  What purpose does this serve apart from
restring the length of data that can be inserted.   Are there any
advantages in specifying a smaller max length than a larger one?

Suppose I have a table like this:
CREATE TABLE (
  ITEMA     CHAR(10) NOT NULL,
  ITEMB     VARCHAR(4000),

I'm using DB2 UDB V8 on Win2k system. Around 8 people will connect to
the db. But, frequently they'll will get Communication Protocol Error
and more over the db2 itself will stop. Again, i have to say db2start
in-order to start. Can anyone tell me why is this happening? Any

I use DB2 8.1 with FixPack 5. In command line for sql I get all DATE
columns only in MM-DD-YYYY format. Of course, DATE('20-12-2003') gives
me an error
SQL0181N  The string representation of a datetime value is out of

People,
I've inherited a lot of SP embedded SQL code that makes substantial
use of FOR cursors rather than DECLARED, and I am wondering whether
there is a significant difference in the performance of either.