i want to know if this is better to split a tablespace into several
containers while the database are on san disk.
And how can i configure optimally the values for prefetch and extend ?
thx

Been messing with this for a bit.  I have installed Rational
Application Developer 6 on my workstation and DB2 v9.1 Client.  I have
created DB2 database alias' successfully for my databases.  My issue is
that when I try and create a connection using these alias' from RAD to

I am trying to create a function in db2. The function is getting
created successfully, but when I query the syscat.functions, i dont
find my function.
also when i try to recreate the function, it says similar object

http://www.ibm.com/developerworks/db2/library/long/dm-0610chang/
Enjoy
Serge

If I do IMPORT with ADMIN_CMD procedure and use MESSAGES ON SERVER option
with IMPORT where are those messages stored?
I know ADMIN_CMD returns a result set for IMPORT and an SQL I can get
messages and remove them. Do I have to use the remove part to delete

I'm using DB2 UDB v8.2 on linux.
After minimizing the code in order to isolate the problem, I have a
simple jdbc client that executes the following SQL statement in loop :
SELECT * FROM TABLE (SNAPSHOT_LOCK (CAST (NULL AS CHAR), -1)) AS

I am running a siebel database on Db2 V8.2 32 bit with FP10a. The
system went to production a week back.  After of couple of days we saw
high memory usage and the system ran out of paging space and crashed.
We had to restart the AIX and we can see the memory slowly climbing up.

Is there a way to bring historical data into one field? I have activities
A1, A2, A3 ,etc in a history table.  I need to check for the presence of
that data and bring it back if it exists for a record. I know I can do this
using (not tested):

is it necessary to put jar file or class file inside a
$DB2INSTANCE/sqllib/function  directory .
i appended my own customised path to the existing CLASSPATH variable
but its giving SQL4304N.

v8.2.1
Anybody can try this:
----------
--base table

DB2 UDB v8.2 (FP11) on AIX 5.2.
I'm not an SQL guru, so please be gentle with me.
I have a table that contains a BLOB(312MB) column, and I'd like to
determine, in an efficient way, the row-counts to BLOB size ratio. The

After installation of a new maintenancelevel on aix (5.3, ML 05) db2
administration server doesn't start anymore.
After starting I get the error: SQL1042C An unexpected system error
occurred.

DB2 8.2.3
the task I have is to write a script to restore a database from a
backup on to another machine.
the backup can be as old as seven years. The container layout on the

A few weeks ago I had posed a question about how one my create a cursor for
a query where the predicate condition is dynamic.  Meaning that the query
might want to have one of several possible predicates.  Take the following
queries, for instance:

I would like to query an ORACLE 7.1 database on VMS from DB2 (IBM 390).
Appreciate any help on How to: