Hi everybody !!
I am new in DB2 database word, and I am trying to install a DB2
Personal Edition in my notebook to study it, but I have some problems
during the installation.

I have just tried to migrate this stored procedure to another instance.
on the same server.
I have taken the executeable and copied the file to the new database.
Done the binds on the file and created the stored procedure.

       I want to write java store procedure in db2 universal database
by jdbc.
After creating the java class, How can i load this class to the
database by the sqlj.install_jar() command in the windows platform.

When I execute the following statment using the Command Center it
works:
LOAD CLIENT FROM 'Y:\\TheFixedWidthData.txt' OF ASC METHOD L ( 1 1,2
11,12 17) REPLACE INTO S00.TheTargetTable NONRECOVERABLE WITHOUT

just feel puzzled. I can know the nleaf and nlevel value from the
catalog info but how can I get the total space occupied by an index?
thank you~

Hi - I would be grateful for any advice on the following as I have
exhausted all variants within UDB for LUW.
The following concerns an SQL/PL Stored Procedure that has been built
via SPB.

I have a client who is using two BLOB columns in two of their tables
for a new database application.  I have not had much experience working
with LOB data and wanted to 'pick your brains' as to any general advise
you can give to imporove the performance of these two columns.  Max

My client's application is generating an exception of CLI0112 and
SQLSTATE 22005 when accessing a BLOB column.  The condition resolves
itself when I recycle DB2, access if fine for a while, and then the
exception happens again.

Is anyone aware of software - freeware, shareware or commercial - that could
be used to compare two tables and highlight any differences between them?
Ideally, such a tool wouldn't care about operating system or database
version so that I could compare, say, a DB2 V8.2 table from ...

how to create a exact replica of a database.
I have a database . There must be some structure of it.
I want to recreate the same structure of the database on some another
new server .

DB2 UDB 8.2.2, Win32
I'm trying to create GENERATED ALWAYS column with UDF in definition
My code
CREATE FUNCTION ADM.F_AAAA(par_InStr VARCHAR(10))

Just like we move tables from one server to another using db2move
export/import  utility , is their any way out to move the packages.
I have moved my entire data to another server , but only packages are
remaining . Is thir any way to do that.

the install guide of an application which will use our DB2 database
enumerate some DB2 parameters that have to be changed.
db2 => update dbm cfg using udf_mem_sz 6000
But this paramter does not exist in DB 8.2.

I have a (somewhat complicated) query that returns the rows from a table
and its self join in the correct order. I want to call a procedure on
each of the returned rows, in the order returned. Is there any to do
this in straight sql or must I write an sql procedure with a cursor ...

When setting up federation between two databases on the same instance
everything works fine.
When trying to do the same between two databases on different instances
on the same machine I get into trouble.