Hello, this is my db2icrt.log.xxxxx:
------------------------------------------------------
    Program name = db2idbm
Instance home dir = /home/db2inst1,   Sysadm group = db2iadm1

I have a problem registering Stored Procedures.
I tried diferent stored procedure and non of them work.
Not even an empty stored procedure like the following:
    CREATE PROCEDURE DB2INST1.PRUEBA ()

We have a bunch of components registered under COM+ with 'transaction
required' option.
On the client we are using iSeries Access 5.2.0, with all possible
fixes applied (Service level SI16136, iSeries ODBC driver version

Hi, I have some problem in using SQL3  recursive queries on DB2
database system (8.1 and 8.2 UDB).
I need to compute the transitive closure of a (possibly) ciclic graph
using SQL3 on DB2.

Who knows how to convert a field with picture
decimal (8) to a db2 date?
--
Met vriendelijke groet

   What is correct syntax to do declare unique constraint on two fields in
table (UDB 8.2, Win)?
Statement:
CREATE TABLE mytest(

   Could anyone tell how can I drop table conditionally (UDB 8.2 Win) ?
I have a script file
create table_1@
create table_2@

I have a DB2 8.2 client installed and I have created multiple database
aliases using ODBC wizard.  I am now trying to figure out how to remove
these aliases.  I tried removing data source, however alias does not
get removed.  I don't have any gui tools for db2 installed - only db2

Folks,
 How many tcp ports does DB2 server use?
 I installed UDB 8.2 on a AIX system and created several instances.
 I used consecutive ports for each instance, but when I look at

I am trying to use DB2 Control Centre (version 8.2) to load one flat
file into multiple tables. However, I don't see the options in Control
Centre that allows that.
Anyone knows how to do this?

I'm new to DB2, so apologies in advance for any stupid comments I
might make on this replication problem.
Using Information integrator and DB2 8.2 I managed to create a
nickname that references a table sitting on an Oracle 10g Database on

If you do a SELECT * FROM TAB WHERE DATE=?, the explain plan might pick up a
TBSCAN and you'll see in db2exfmt PREFETCH=SEQUENTIAL.
Now, TAB is a MDC, and DATE is a dimension. The explain plan will pick up
the block index and db2exfmt indicates PREFETCH=NONE. However, monitoring

I want to send out emails like the task center sends.  I have found
several post about creating your own stored procedures in Java or C
that will do it.
The Task center is already using an api to send email.  Is there any

I'm trying to restore a database backup taken from a server
running DB2 8.1 FP6a on Windows 2000 Server on to a new machine
running Windows Server 2003 (also 8.1 FP6a), but I'm getting the
following error:

Hi,
My company uses Informix as corporative database.  
As experienced DBA of the company, I have that to make a study comparing
Oracle, Informix and DB2 databases and suggesting new alternatives.