Hi Gurus,
Questions for you.
1. Is it possible to assign a DB2 DBA for UNIX into a DB2 DBA for
Mainframe (OS390)?

Have installed DB2 v8.1 on a SUN 450, with an UltraSPARC-II processor
running at 248 MHz, 256 MB RAM, using Solaris 8.
Instance creation was smooth, but when trying to create a database I get
the error

I want to know if I can detect exactly what row table is locked.
My application is locked and I get valuable information (table, application,
lock mode...) with "get snapshot for locks..." command,  but I need to know
what is the row table (the values in the row or PK row value) ...

Does anyone have experience with running the DB2 Design Advisor on huge
workloads? I have a workload for a single day for some 132'000
statements in a file. Will the advisor handle this or should I take a
sample?

Don't install Windows XP SP2 if you use db2cctr.exe and have DB2
V7.1.0.6.0 installed.  After I installed XP SP2, db2cctr.exe would not
initialize.  After I uninstalled SP2, db2cctr.exe worked fine.
KC

I know this isn't strictlt a DB2 problem, but I hope someone can help me.
I running DB2 v5 on XP and have just installed SP2. Now DB2CC fails to load
with "The application failed to initialize (0xc0000005)".
Any ideas, apart from upgrade or backout SP2?! Does anyone know what the

Db2UDB version 8.2
Is possible difrent way  than this
DECLARE TT
as select * from session.TT

Do any one have idea how to obtain the exactly number of seconds in a month
with given month and year using DB2 given functions?
The formula is as simple as "No_of_days_for_a_month" * 60 * 60 * 24 .. but
It is a headache for me to find the No_of_days_for_a_month... in DB2

Anyone have a one liner of code to getting the right side of a string after
the last occurence of a given character?
Thanks, Bill
ie '*abc*def*ghi' would yield  '*ghi' (or 'ghi' would be acceptable)

I am one of the authors of MyGeneration, I'm working on enhancing our
DB2 support, which datatype do I want to use from SYSCOLUMNS when it
comes to creating parameters to stored procedures or datatypes for a
CREATE TABLE statemment?

doing some investigations with the EXPLAIN statement
I wonder about the quality from the plan_table.
for different kind of selects I expected that
an index with two columns is used in a join.

Is it correct that "INSERT INTO new SELECT * FROM old" does not copy
BLOB columns? Or is there something I failed to configure properly?
Thank you,
Peter Arrenbrecht

I cannot get a 'continue' handler to work within a 'before insert'
trigger....The line
set nnn.name='Bill';
never gets executed. If I do an insert on the table, I get the 99001 error

I installed DB2 8.1.1 FP 7 on an AIX system running AIX 5.2 in 32 bit
mode. The DB2 control center started up fine until I changed the
server to boot in 64 bit mode. Now db2cc fails. I have been told by
one of our Java experts that the error messages mean that java is not

I needed to log all statements executed during a period of time
and now i need ordering the long varchar column in the statements monitor table
(STMT_TEXT)
Is there any flag to set to release the DB2 255 char wide ordering limit ?