Running DB2 for Linux 8.2.8 (FP15) on IBM PPC.  OS is Red Hat Enterprise
Linux 5 for PPC.
We have a script that does a SET WRITE SUSPEND just prior to split a mirror
on Hitachi SAN and it stopped updates to the tablespaces but not the

I am looking for a function (or hint) how I can count unicode
characters (and not bytes) in DB2 V8.2.
In DB2 9 the length function is extenced with the codeunits32 option -
and this is exactly what I need in DB2 V8.2.

i need to convert the following oracle-based sql to DB2.
SELECT rownum, name, birthday
FROM person
WHERE rownum < 10

I am having the following scenario...
I have a primary key on a column in a table.
I want to create that column a unique key(and not the primary key)
I plan to add another column later, which i'll make as the Primary

DB2 LUW v8 FP15 Linux.
Consider the table T (ID varchar, FIELD_TIME timestamp, Field3
integer). There are approx. 1k different IDs.
Each minute, one application inserts around (avg. 200, max 5k rows)

I have installed the Run Time Client Lite on a WIn XP computer for the
ODBC driver
and it works fine, I get an connection.
When I installed the Client on a Win2000 computer I get this error

Linux RedHat AS4 running DB2 V8 FP15.
I have very large tables (100 Million+ rows), and I only need to keep
6 months of data online/available. The tables have a timestamp field.
I was hoping that DB2 High Performance Unload V3 allow me to 'extract

I need to speed up the inserts through informatica, and I came across
insert buf option with db2 packages for import statements and how we
can use that option to do the same in java programs. Are there any
packages to be bound for informatica powercenter, so that I can rebind

can anybody tell me what the reason code 18 means in combination with
a SQL0902 error?
It would be helpful to know details about the reason code but I could
not find any details about that code.

compatibility features coming along?
Wait 'till you get to this:
CREATE TABLE test (
charcol                     CHAR(2000),

What is the minimum unit of I/O in DB2 9. Is it extendsize or prefetch
size or pagesize ?

SQL:  select talble1.c1
from table1,table2
where table1.c2=table2.c2
so if talbe1 has 1000 records,table2 has 100 records

On a linux Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
box, I've installed DB2 V9 Client at the fixpak3 level.  The install
was successfull but 2 additional log files were produced with messages
that make me wonder if there is a problem. Or are these informational

I have a char column that contains date/time information
(YYYYMMDDTTTTTT) in the following format: 20071002160603
What is the most efficient way to show this information in a query
result as "10/02/2007 16:06:03"?

Hello, all.
DB2 ESE v9.1.3, Windows XP.
I want to change the application name of current connection.
I have wrote such SP using sqleseti api call: