We're using UDF 8.2.
How does one format a DOUBLE to, for example, 2 decimal digits? Sort of
like sprintf in C where you'd give a format pattern such as 4.2F . I
cannot find any formatting built-in functions. Using CHAR(my_double)

Good morning/afternoon:
What are the recommended ULIMIT settings for the following on a 32-Bit
DB2 instance running on a 64-Bit AIX (5.3)?
time(seconds)

Below the first stored procedure I have written.  It works as intended.
But, being my first one, I wanted to see if there are any obvious (or not so
obvious) flaws in it.  (Yes, there's a reason, perhaps not a good one, why I
have the OUT fields before the INOUT fields.)

CREATE FUNCTION MYSCHEMA.FUNCTION1(SEQNAME VARCHAR(100))
   RETURNS CHAR(100)
   LANGUAGE SQL
   MODIFIES SQL DATA

Folks,
I have questions about using multiple containers in a table space.
Currently we are using JBODS (Just Bunch Of DiskS) for table spaces on the
DB2 server. I have setup table spaces spread across multiple disks for

I am using DB2 V8 fixpack 10 and have the following issue:

single statement as follows:
       -- Get the first update transaction for the mailing event.

I am trying to parameterize a SQL query by re-writing it as a UDF.
However, I find the execution time for my UDF unacceptably long. It
takes 60 times longer than running an equivalent SQL query with
hardcoded parameter values. (e.g. 6 min for UDF Versus 30s for SQL).

DB2 V8 LUW FP12 + Linux.
I have just turned on DB2's connection concentrator feature.
MAX_COORDAGENTS=1100 and MAX_CONNECTIONS=1500.
Two hours after restarting the instance, the db stopped responding.

If I am going to be using multiple tapes to backup a rather large
database , then do I have to initialize ALL the tapes beforehand to the
same blocksize or the backup command will take care of that as more
tapes are added?

I am trying to build a SQL statement dynamically for execution within a
procedure, using PREPARE ... OPEN.
SET v_sql = ' SELECT a,b,c,d,e, .....x,y,z FROM  table1, table2  WHERE
a = v_1...and so on   FOR READ ONLY';

DB2 migration issue from AIX to Linux
I am trying to migrate database from AIX box to Linux box using the
db2move and db2look command. Everything worked fine for the tables with
user defined schema. But I am facing problem with four tables under the

hai everyone.......
can anyone tell me how to insert data into a BLOB coloumn....
regards
Kamal

I'm testing automatic reroute on two instances on the same server. The
client can successfully connect to instance 2 after I stop instance 1.
However I don't know how to let client back to instance 1. I start
instance 1. But client still connect to instance 2. Do I have to stop

A paritioned table ( spead across 7 logical partitions) has around 2
billion rows. I added around 2 million rows newly using db2 load
utility but the the table is in index build phase for the past 3 hours.
Is there is any method available

Thanks
Bill