I  am testing a complex J2EE application on WebSphere and UDB V8.2.3.
Because of the compliexity of the application, we have to run it a few
hours to finish all test scenarios.
One of our test objectives is to identify the top 100 most expensive

HELLO ! A VERY GOOD EVENNG TO ALL THE MEMBERS ! I AM VERY NEW TO THIS
GROUP . CURRENTLY I AM PURSUING MY M.S AS A DBA SPECIALIST.I AM
CURRENTLY LOOKING OUT FOR ONLINE PROJECT IN DB...ANY GUIDLINES ...FOR
ME ...HOW TO SEARCH AND WHERE ?..I NEED HELP.

I go in through the Control Center Activity Control Center and
eventually select view locks, I get a popup window "The Activity
Monitor is unable to collect the required snapshot
data because the monitor switch "LOCK" is not turned on at the

I am an Oracle DBA and now trying to get hands-on "DB2" databases. I
have small query...could anyone pls clarify???...
************************
In DB2 I have an instance with 5 databases in it. I now want to

I have run into a performance problem with db2 v9. When the connection
concentrator is turned on then
performance is significantly reduced. I did some simple insert tests,
75 records inserted into a table with 50 Varchar(20) and 4 CLOBs. The

    I need to data from several input fields, and treat them as if
they were all the same field.  I'm not describing this well, so I'll
give an example:
I have a table like this:

I am using DB2 v8.2. I am able to use the Data Movement Utilities
(IMPORT/EXPORT/LOAD)  from the db2 CLP. But now I got a scenario, where
I need to call these utilities from within a stored procedure. I am not
able to. Please help me out....

I am using DB v8.2. when I issuing the following stmt.:
"select DATE('25.12.2006')-DATE('24.12.2006')from sysibm.sysdummy1" :
1
"select DATE('25.12.2006')-DATE('24.11.2006')from sysibm.sysdummy1" :

   I've been struggeling with this for a while now, and I was
wondering if anyone could help me.
   given:
drop table GENCMP.SCRIPTS;

Does db2 have the equivalent of a print statement like SQL server?  I
wanted to debug a stored procedure I wrote and wanted to output some of
the values.  I couldn't find it in documentation...The only thing that
looked close was signal statement.

hello ! to every one of you all ! i am begineeers to db2 . so i need
assistance from you all to follow which documentation to enhanced my
skills .i am currently using 8.2 version ....i need help

I'm having trouble solving the following problem with DB2 UDB 8.2.
I need to create a trigger that performs certain extra constraint
validations (temporal uniqueness). One of the tables has no primary
key.

I'm a relative newbie to DB2.
I need to move a database from a windows server to a linux server.  I
have already identified and resolved an issue with schema names, but I
now have a vexing problem with BLOBs.  The table appears to have come

create table T (
   x integer,
   y integer,
);

DB2 LUW V8 FixPack 13.
create table Table (ID varchar(20), USED char)
I need to find out the total row count per ID, as well as the row count
where USED=Y.