I have the following problem:
In a view I obtain three rows and I have to group them together making
some particular operation to add dinamic column.
The query without the group by give me these results :

I wrote a sqc program. Its hanging in the middle
I want to know how can it be debugged.
One way is to attach to fmp process where I can debug the C program
which is being generated.

How can I tell if a backup image was created using the include logs
option?

This is my first email message about DB2 Universal database so don't
mind if it looks like confusion. Recently I have installed DB2 UDB
(Try and by Version) on my OS. It is, as follows
Windows XP SP2 512MB RAM 80GB HDD, x64.

The DB2 runs on Redhat, and when I entered following command,
$ db2 call GET_DBSIZE_INFO(?,?,?,0)
I got error like this:
-bash: syntax error near unexpected token `('

shoes on
AIR Jordan 1  (paypal payment)(www.king-trade.cn )
AIR Jordan 2
AIR Jordan 3

My trigger looks like this:
CREATE TRIGGER REVIZIJA.T_1_AU AFTER UPDATE ON TABLE1
REFERENCING OLD O
           NEW N

1.I have db2 V9 installed in a DPF environment for OLAP application .i
am trying to install db2 query patroller V9 on top of db2 V9.1.4a but
it throws an error saying lower down your db2 image . i need help
regarding this as i cant find out which version of qp should i install

I have an existing table with 2 million rows which I'm tasked to
improve performance.  I am thinking of creating a two-column MDC, on
column A and B.  The total cells will be card(A) * card(B) =~ 12,000.
Although on average each cell will have about 90 rows, 25% of the

What is the query for selecting non duplicate elements
for eg:
no   name age
1     siva    28

I'm running db2 9 on windows.
I'm looking for a query to find dependencies between stored
procedures.
For instance if I have a procedure P that calls p1 and p2, I'd like to

Is there a way to get the last day of the previous business quarter
from DB2?
For 10/21/2008 the day would be 9/30/2008.
Thanks.

Testing the above without TSA or HA, just plain HADR performing manual
db2 TAKEOVER HADR ......................... etc.
I am testing without the PEER_WINDOW i.e. set to 0  and HADR_SYNCMODE
= SYNC.

We have 2 environments one is test which is one BCU with 8 partitions
+ admin/catalog node server ( smaller BCU ) and other prod is 3 BCU
with 24 partitions + admin/catalog node server ( smaller BCU ) .
I have sql which shows higher cost in test but run faster and does not

I'm new here, so at the beginning I'd like to say hello for everybody.
First I'll describe my problem.
There is db2 database :) with about 0.5 mln people. Every person has
three features. These features have allowable values and also are stored