UDBV8 fp 6a - AIX 5.1
We have scheduled cron jobs to do backups. Periodically and starting to
occur more frequently, a backup fails with this error:
SQL2072N  Unable to bind the shared library "". Reason code: "".

Trolling before someone else does -)
http://www.eweek.com/article2/0,1759,1776048,00.asp

I'm having strange problem after upgrading my database using db2updv8
utility. The database reside on AIX 5.2 box. I'm using DB2 V8.1 FP 4a.
My developer use DataStage 7.0 to access the database on the AIX box.
Each time when a job is executed at DataStage, it will give the

  I am trying to insert a large number of rows into a table
inside a SPL. But every time, I run the SPL, the table is
locked because of the INSERT. When I tried to issue a COMMIT,
right after the INSERT in the SPL. I got an error stating that

I am a little confused. If i have an SP like:
CREATE PROCEDURE ABC (IN ID Integer,
                                                OUT TEST1 Integer,
                                                OUT TEST2 Integer)

         I am still new to the db2 world so pls help me with the
following :
I have 2 tables A & B in different databases . They can be joined on a
customer_number column. I have to archive all the data from A which is

I'm trying to setup a standby server using log shipping.
The live database has a user exit in place, which archives the closed
logs and ships them to the standby server.
The standby server, checks for new logs, and, if any, simply

Folks -
OpSys: RH Linux, AS3
DB: UDB 8.2.0  (FP7 Stinger)
HW: 2 X-series

  I had posted one topic earlier, but somehow the link
has been broken and I cannot see the topic. So sorry if
this is a duplicate topic for some. Here is the issue
that I'm running into.

I am trying to install DB2 v8.2 Universal Database Express Edition on
my standalone computer using Windows XP Home Version.  Everytime I try
to run the setup I receive an error message that my operating system is
not compatible for this version.

I am running Windows NT and Installing DB2 Connect Personal Edition
Version 8.1 for Windows OS on 32 Bit Systems.
Receiving the following error message:
In order to install the Product "DB2 Connect Personal Edition", the

We are running DB2 PE (AIX) 8.1.5 and have built a SQL stored proc that
uses the SNAPSHOT_APPL_INFO udf to return to the caller info about
current db2 connections.
The SP was created by a user id that belongs to the SYSADM_GROUP and

I've been searching the Internet for a while and I've been trying to
find any resources on return tables using UDF's with Java. I've been
sucessful in returning integers, etc, but I have trouble finding
anything about return tables. Can such a thing be done in Java? If so,

I am writing Java UDFs using DB2 V8.2 (Fixpack 8) on Windows XP.
I would like to create some common code classes that are visible to the UDFs
on my system but I'm not having a lot of luck so far. I'm wondering if I'm
trying to do the impossible or if my technique is just wrong.

1- Does DB2 have Extended Properties for objects like MS SQL has?
Any idea if it exists in Oracle?
2- Oracle has CREATE OR REPLACE PROCEDURE, is there
an equivalent in DB2?