we are using AIX 5.3 and DB2 V8.2 Fixlevel 9.
The attempt to backup a database of 50 GB leads to a message
SQL2059 and a 1 GB-fragment of the backup although there is sufficient
free space in the filesystem.

Running DB2/UDB 8.1 on Linux, 16G RAM, 8 processors. We are currently
converting data from legacy systems and after importing large amounts
of data into multiple tables, I run a script that executes runstats on
all columns with distribution on all columns and detailed indexes for

Sorry,
This should be simple, but brain is hurting...
How do I convert a Current Time to a Decimal 6,0 (HMS)? There must be a
cleaner way then this:

We'are using DB2 UDN 8.2.2 on Linux RHEL3 server. Here we have two databases
under same instance. Can we store all the user tables into the system
tablespace called userspace1 ?
Thanks for answer!

I'm having problems getting any CLI trace info from my Perl script
(which uses DBI and DBD::DB2).  I did:
db2 update cli cfg for section common using trace 1
db2 update cli cfg for section common using traceflush 1

i'd like to know how to implement an automatic failover with HADR.
I've configured 2 databases, one primary and the other standby. Everything
works ok (replciation and takeover).
But if i issue a shutdown force on the primary database, the other database

Is there anyway to delay a trigger from firing for a few seconds?
I have an after insert trigger on table1, which selects information from
table2 and table3. Obviously it cannot fire unless the required rows in
table2 and 3 are filled out first. I can't just put the trigger on

DB2/SUN 8.1.6
Using the client and CREATEing a PROCEDURE with a one-character name
and DECLAREing a CURSOR using WITH RETURN TO CLIENT, does not result in
a RESULT SET being shown.

Running DB2 ESE V8.1.8 on WinXP.
This is Fixpak 8.
Have a structured-type and some methods for that type.
One of my methods needs to do insert / update on tables.

I've been going through the DB2 application development manuals and
have no idea what I'm doing wrong with my UDF.
Basically, I created a C++ library that compares 2 strings and returns
their similarity as a double. I wanted to use this function inside DB2

I have a before insert Trigger and I want to catch if there is a
duplicate Key Error. If the Key already exists I'd like to update else
insert the row.
OK I am at the point I did the updates but if I raise an Error the

Anyone got any ideas as to what could be causing these errors ?
ESE 8.2.2 on Win2k server FP4
2005-08-16-21.46.53.554000-240 I1202H313          LEVEL: Warning
PID     : 2464                 TID  : 1700        PROC : db2syscs.exe

I am trying to verify that I correctly understand something I saw in the DB2
Information Center.
I am running DB2 Personal Edition V8.2.1 on Windows. I came across the
following in the Info Center:

Can anyone please explain in english the difference between blocked and
non-pages in a bufferpool.
What would be a typical ration one would use for say a 100,000 4kb size
BP. 50/50 blocked v unblocked ?

I downloaded the newest 64 bit SDK for IBM and installed it.
I downloaded and installed the C58SBML.tar - Db2 distribution for 64
bit AMD
The install worked and I created and instance however I can't run any