I am going thru the documentation of IBM DB2 9.5. It seems it is
now a truly multi-threaded architecture like informix. db2sysc
is the only process seen via ps -ef (like oninit) and other EDUs
are shown as threads within that process.

Using 8.2 FP16 on AIX 5.3.3
I created a UDF to convert a 26-byte character string into a CHAR(13)
FOR BIT DATA item. During testing, a flaw was discovered (a known DB2
issue with CHR(0) = x'20' instead of x'00'), so I created a workaround

I am aware in DB2 v8 there is a limit on tablespace size depending on
pagesize; for e.g 4 K pages grow a maximum of 64 G. Does such a limit
exist for SMS tablespaces or is addressing of rows managed by the
Operating System and hence the limit is the maximum filesize on the

is there a way to tell the current tablespace for tables i create without IN
clause?
i know i can do that by create a table and select its tablespaceid from
syscat

I have an PC application using MS Access 97 running on NT4.
Now, there is an upgrade to use internet technology.
I have to convert the MS Access 97 mdb file to become DB2 tables in
AIX.

I have got the problem to import large XML files (greater 2GB) as LOBs
into a DB V9.x. The specs specify the maximum size of LOB as 2 GB. I
am not quite sure how well Oracle does, but my information states that
their maximum size is 4 GB.

Just wondering is that OK to create index online ( without down the
application servers)..
it's OLTP 24*7 production environment..
Is that OK to create index on one table online ? the table size is

I have a table called employee. Any time anything is added or updated
on this table there is trigger that fires off and send copies of the
data to another table called Emp_audit with the current timestamp. I
want to create a query of the employee's name, date, and time from

  Is there a way to calculate the maximum total memory  ever used by
the instance?
 Is db2mtrk the answer ... especially the high watermark option.....
 If I add up all the values......Will  it be the total memory used ?

I have a pretty complicated query containing several columns generted
via olap windowing expressions. This query without any 'filtering'
where clauses would run in about 3-4 minutes. However the moment I add
a simple filtering clause like column_a = 20, the query would finish

The following SQL results in some (not all) records being doubled in
the SUM()'d column.  This occurs when I add in the LEFT OUTER JOIN'd
table.  I can't for the life of me figure out why.  Am I missing
something obvious?

Hi friends
What is the best way to keep track of number of users logged into
database everyday.
Where does db2 store user connection information ? does it keep a log

with the following java exception. any idea ?
NULL
------------------------------------------------------------------------
0SECTION       TITLE subcomponent dump routine

I am a mainframe Cobol programmer (yes - Cobol programmers are still
around, mostly in caves) and I am writing a java code to access DB2.
In a Cobol world after each SQL command we are checking for return
conditions like success (sqlcode=0), not found (sqlcode = +100),

we have 3 instances where a table space (good old SMS) lives in the
wrong directory.
Normally I simply would create a new one and do a INSERT ... SELECT
for all tables (or a load ... from cursor). But we have different