We have done some testing with mixed and forgotten results. So I'm
hoping that asking here can clarify some issues for us. Right now we do
one weekly warm backup.  Throughout the week there are multiple
unrecoverable loads.  We are tyring to come up with the best backup

We have seen up to 11 db2fm processes running at the same time, which
was consuming 100% of CPU. We could not run anything else on the
machine because of this. We have only one DB2 instance, so there should
be only one db2fm process. What could be causing so many db2fm

I'm trying to pull data from our corporate DB2 data warehouse via ODBC,
and am trying to optimize a long-running query.
Unfortunately, our company did not install the suite of DB2 tools on my
desktop that would allow me to do anything beyond on ODBC connection.

I have a table in the database that has a BLOB field to store images,
which is usually more than 1MB per record. There are currently near
9000 records in it, which means the table is growing to be huge. Will
this slow the database performance significantly? If so, how to reduce

hai everyone....
                Can anyone tell me how to find the database size......
Regards...
kamal

We're seeing very strange behaviour with db2 under heavy load.
We're running our system in GMT and the timezone never changes for
British Summer Time.
Basically the thing we're doing is (using the udb jdbc driver):

How can I define a null column value for a view?
I need to create a view using UNION ALL, but i need to set some columns
as null.
It's possible? how?

Have DB2 V8.1 fp10 ESE on Red Hat Linux 4. It was created from the
command line. Have tried doing dasdrop and dascrt but no luck. I
believe the original dascrt gave SQL4401C.
Neither message is very helpfull!  Not using the das default user. Any

Hai everyone......
                          i was trying to implement the HADR concept
....... i tried using the following commands ......
On server_1

Is DB2 multi-threaded or single-threaded?

In Ops Nav, it's possible to display the current SQL being executed by
a job. However it's rather slow to find the job as it has to populate a
large list of jobs then sort them. I suspect there is a CL command that
takes a job number parameter that would be much faster.

I have an access violation in DB2SYS.dll at each ending of my
application.
This is a multithreaded application. Threads are created and managed by
Tomcat. One thread connects to DB2 base through ODBC and a C++ DLL.

i have installed a db2 version 8.2 FixPak 4, problem is it is not
showing any of the tool properly.
i.e whenever i try to open CC,DC,SC,RC,CA it is not getting displayed
at all.

hai everyone...
                   i have a scenario here....... i have a database in
a instance......... mistakenly i dropped the instance . i have all the
database files...... can i bring back the database again...... if yes

First, thank you for looking into this posting...
Running UDB V8 FP11.
The question is around the below query branch. I would like to know
what it means and  if there are ways to avoid it.