UDB v8 fp 6a on AIX 5.1.0.0
Below is a manual incremental recover from compressed backup datasets.
With external compress backup datasets, can it be coded to do an
automatic incremental recover? The manual incremental recover works

In UDB V7 or V8.1 the password for increasing license can be retrieved
by the command : db2licm -l
But now in the Version 8.2 (Linux) no password is displayed by this command,
How can I get this ? Thank you

I am trying to implement some etl feature driven by a java application. I
must work on windows and unixes, possibly without using command scriptings
or shells. I am focussing on windows. I try to have several load operations
executed inside a single connection. I can't succeed in ...

In Oracle, I would handle exceptions like this
EXCEPTION
WHEN OTHERS THEN
--  open up an autonomous transaction

How can one search a value on all fields in a table
is this possible ?
thanks
Peter

Can anyone give same examples on the setting of
logarchmeth1,logarchmeth2,logarchopt1,logarchopt2?
(for DB2 V8.2 on AIX/Windows)
TIA,

Due to a disk crahs I had to reinstall RedHat 3 ws. After installation I
alpplied all updated packages and continued installing db2 8.1 ws.
Before running the db2setup, I also applied fp7a.
When I try ro run db2setup I encounter this error message

Does DB2 provide NLS ( National Language Support) as a configurable
parameter or a system register to get locale specific character/number
representation. For example in Oracle, one may use nls_language to
specify the language in which a particular scalar function may display

Hi,
I am new to DB2 and I am using DB2 UDB 8.1 for Windows. I have a query
which works fine in ORACLE and I am trying to find out equivalent
query in DB2.

salut ;
Nous sommes un groupe d'etudiant de l'INSAT de la Tunisie.Notre
filiere est Génie Logiciel, nous réalisons un Mini projet  concernant
la configuration et l'administration de DB2 (V 8.1)sous Linux suse

I have a problem with a special sql.
My configuration : IBM DB2 V8.1.5 / AIX
Procedure:
CREATE PROCEDURE DB2TARAN.SetSessionAutor()

I'm writing an automatic SQL parser and translator from Informix to
DB2. Now I'm faced with one of the most difficult things to translate,
the "foreach execute procedure" functionality provided by Informix.
This is the problem: the execution of the translated SQL leaves the

I'm running DB2 v8.1 on Win2K
I'm tryng to add a generated column to a quite large table (more than
2,000,000 rows).  I added the column and now would like to generate
values before to run the "set integrity" command.  People on this

Can it be that when I'm running DB2 8.1 on AIX 5.2 I have to create a
new user every time I want to create a new instance?
I tried the standard db2icrt command using a different instance name
and it errors out unless I have a user of the same name on the system.

A tale of woe, and a question . . .
Last week my boss said to me "we've installed DB2 Connect on this
Solaris box.  Make it work."
Now, I've barely seen DB2 Connect on Windows, having fumbled thru one