I had a question on incremental backup.
We had an incremental backup every weekend. We did full backup every
other week. That is one week incremental + full , the other week is
incremental only. My question is for the first weekend incremental

Is there  a  64K limit to the size of a SQL stored procedure ?
(ver 8.1)
-Thanks

It seems there is a problem with some snapshot table functions, if you try
to divide by some element that is unset or equal to 0. This generates a trap
file with the db2fmp.exe process, that keeps going on, until your disk is
full. I'm on W2K, DB2 UDB 8.1 FP4.

I'm fairly new to DB2. I am having some difficulty converting some
stored procedres from Informix that use default input parameters.
Specifically, the Informix procedures I need to convert use the '*'
character as a default input parameter to be used with the 'MATCHES'

 I'm currently trying to learn DB2.  I have the following version
below installed on my server machine on my little LAN.  However when I
try to connect to it from my client machine, I receive the following
error:

hello to all,
I have some trouble with aliase und dbUnit. The db2-admin has changed
our tables on the db2-db to aliase and now dbUnit throws
"NoSuchTableException". Could anybody tell me if I could configure the

we reached a quite interesting performance-limit while using JDBC type
4 to a DB2 V8.1 database. The DB2 is running on a Intel-based single
CPU-Server with Linux OS.
What we are doing is an OO-loading-service with about 30 single

Anybody know how to enable the new directio option in DB2 FP4(This is
a new feature in FP4) for AIX.  For NT its analog is enabled by the
registry option DB2NTNOCACHE... but I don't see anything like
DB2AIXNOCACHE of DB2AIXDIO... I have looked through all the new

Someone could tel me ho can i do to put a database in Archive log Mod ?
And how can i do to apply redo log on a backup database ?
Thank's

I have downloaded DB2 UDB v8.1 PDE for Windows from the IBM Website.
Now, I am trying to connect to our iSeries OS/400 Server.
But it gives the following error:
[IBM][CLI Driver] SQL8002N Connect processing failed; a valid

I have written a Java UDF for DB2 and registered it using the
following params:
CREATE FUNCTION arsu_bit_value ( varchar(32) for bit data, integer )
RETURNS INTEGER EXTERNAL NAME

Hello NG
I've defined a cursor like the following in my COBOL Programm:
DECLARE testc CURSOR FOR
SELECT ...

We are running DB2 v7.2 on Linux and we had the following error last
night during our online backup, we have been running onlines for quite
some time without any problems
Starting a full database backup.

Is there any way in UDB to 'print' the logs, with details about the
RBAs and Unit of Recovery details? I am looking for something similar to
the DSN1LOGP utility that is available on mainframe DB2.
Also, is there a place in UDB which keeps a mapping between the RBAs

Moin,
wir haben eine neue Version
von DB2 8.1 installiert. Hier wird uns der Datentypen LongVarchar
nicht mehr angezeigt, wenn ich z. B. über die Steuerzentrale eine