Hi expert,
I installed DB2 v8.2 server on Solaris 9 box. When I connect to DB2
using control centre or other applications(except command line),
around 12 db2sysc processes pop up and each one consumes more than 2G

I have a condition in which I have to ignore an error while SELECTING.
The error is lock timeout (Db2 error code -911). When fetchrow_arrayref
fetches the locked row, I do get -911 which I trap in my code. When I
move on to the next row doing another fetchrow_arrayref, I get error ...

Have you seen any significant performance issues mixing single
partition and multi partition databases in the same instance.  If so
could you please share your experience on this.
Thanks,

Is there a way to make use of RDA 6.1 with DB2 9 and not being obliged to
switch to RDA 7 ? For example, Data sources refer only to 8.1 or 8.2. I
believe there are other limitations to work with DB2 9.
Thanks,

When I found that a SMS tablespace used 30GB file system, I checked
each containers in that tablespace and located it (/db2inst3/NODE0000/
SQL00001/SQLT0002.0/SQL00164.DAT). How to find which tables resided in
this container?

I want to test using structured UDT, so I was wondering if there is
some sample that give me quick understanding of what is possible for
generating structured using the method specification with java..
Note, I have used structured UDTs and have generated java UDFs.

I'm using DB2 v9 Express-C - I have problem when selecting XML
columns.
I have 2 columns in patients table:
- id_patient

I am running a standalone PC (DELL 1,73MHz with 504 MB of RAM) using
Windows XPP Service Pack 2 and BD2 version 8.1 (the freeware
version!).
Right after start of the PC the process db2dasrrm.exe takes all CPU

I have two tables, T1 and T2 defined as follows:
create table T1(c1 integer not null,
        primary key (c1));
create table T2(c1 integer not null,

Does anyone have any suggestions for securing against this
vulnerability:
http://nvd.nist.gov/nvd.cfm?cvename=CVE-2007-1027
Fixes are not yet available from IBM.  They will be in FP2 for V9 and

I have the following warning message in my db2diag file:
2007-02-22-10.59.20.426000-300 I624712H529        LEVEL: Warning
PID     : 1012                 TID  : 4332        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : FLINT

Does a revoke post an entry in the DB2 catalog that would allow an
query of the number of revokes by someone? Or does the revoke just
delete the grant and leave no record in the catlalog? I am on DB2 V8
for Z/OS.

I used to load the Db2 database in mainframe using the following
commands
LOAD DATA LOG NO REPLACE NOCOPYPEND ENFORCE CONSTRAINTS DISCARDS 1
INDDN SYSREC00 INTO TABLE

Integers are stored in tables using only 4 bytes.  Is there a way in
SQL to retrieve the value as it is actually stored, not converted back
into the displayed number?
For example, if I have 2030906, it gets stored in 4 bytes.  Can a

Can anyone share their recommendation for a basic book on SQL syntax
in DB2?  I'm a Teradata/ Oracle/ MSSQL Server/ MS Access user with no
DB2 experience.  Most of my work problems have to do with date and
string manipulation queries, exporting data to another platform.