Env: DB2 ESE/DPF 8.1.6 64 Bit on AIX 5.2.0
we recently had problems with an offline backup of a database with 5
partitions that fails with SQL0956 - Not enough storage in dbheap.
DBHEAP at that time was 5000 Pages per partition. The last backup ran

I have a problem on one of my databases.
I have a Java application that issues SQL statements to that database.
Some of the SQL statements make DB2 go to into a compile state for hours.
I see Compiling if I do "db2 list applications show detail".

I have to setup a 450 GB staging area (database) for the data warehouse.
The System Admin has told me that the space will be made available.
What are all the steps and parameters that need to be considered while
beginning this activity?

           I got a table with three rows like the following
clientid       name         age       location
1                peter
1                                  32

We are on db2 udb v8.2  64 bit,partitioned (5 nodes)
on AIX 5.2 ( intra parllelism is enabled).
I have a question, i am trying to find the memory usage on my
production machine. what is the best tool to find memory usage in

I closed the DB2 system tray icon in Windows XP and now I can't figure
out how to restore it.
It doesn't reappear on reboot!
Suggestions?

Does anybody have a tool to store/retrieve explained sql? We're running
DB2 8.2 on AIX. We would like to be able to compare old saved explains
to the current ones and see if anything changed.
Thanks,

How can i use JDBC driver to load some datas from DB2 DBMS with the load
command
and a specific delimiter ?
Can u give me a sample ?

I'm new with DB2 database, and working on AIX 5.2 with DB2 v8
Just a question regarding the similaneous connection. I'd like to know
how many simultaneous connections that I have in a given time! Do you
know how to get this information?

I had a discussion today regarding the INTRA_PARTITION dbm cfg paramater.  I
believe that this parameter has only an effect on a single SQL statement to
be executed and it does not control whether multiple db2 agents can run in
parallel on multiple physical CPUs.

In some other databases (like Oracle and SQL Server), there is a view
that show all SQL's currently executing, who is executing the SQL, and
what the SQL is waiting on (wait on read, wait on lock, wait while
writing to backup transaction log, etc.).  What, if any, command can do

I have DB2 V8.2 loaded on a Redhat Enterprise Linux version 3 (RHEL 3) box.
RHEL is configured to talk to LDAP for authenticaton besides the local
passwd file.  I can verify this by executing an su to a User Id that exists
in LDAP and not in the local /etc/passwd file.  Also ...

Hi. Below is a simple JDBC program to insert and extract
a numerical value. When ResultSet.getDouble() is called,
the same program produces different output on solaris
than it does on Linux. I would be grateful for any

   I am looking for information how calculate size of table with BLOB
field.
After RUNSTATS command
select fpages * tablespace pagesize - gives me only 16kB (table contain

Dear group,
i am a seasoned DB2-veteran (6 years exp.) on the Windows- and
Linux-Server platform. Once in a while i had a look into DB2 on the
mainframe but mostly only watching other people do the job.