I have installed a new Db2 V9.5 fp1 Linux 64 bit  with a partioned database.
When I connect  to the database using  DB2Visualizer on Windows, that uses db2jcc, it works OK.
Connecting from DB2 Control Center takes 4-5 minutes, but it connects. Opening a table can take 4-5 minutes ...

We have created triggers to log modifications to tables in our application.
The triggers work fine, just on one of the tables in our database the
triggers fail with the error message <SQL0437W Performance of this complex
query may be sub-optimal.  Reason code: "1".  SQLSTATE=01602>. ...

Hello, I need to communicate with a db2 database from a  java program
and this java program needs to check which "user tables" there are. I
came up with the following query which I tried in Control Center:
select tabname, tabschema from syscat.tables where tabschema !=

DB2 LUW 8.1 fixpak 14
Red Hat EL AS 4.4
I'm trying to diagnose some nocturnal CPU pressure, and am trying to
understand the dynamic statement cache as it applies to LUW.  The only

i set up php+db2+zend+apache2 on my linux server (debian/etch amd) and
have great problems with the performance of queries. I currently have
50 empty tables and 2 filled ones (one with 11 rows, the other with 60)
if i issue a simple "select * from table1" (11 results), its takes up ...

DB2 LUW v8 FP15
I am running a simple 'runstats on table session.temp_MID_1 and
indexes all' and it fails with
[04/29/2008 13:25:49.902600] SQLAllocStmt( phStmt=4:2 )

Can anyone tell me where i can download the DB2 UDB EE v8.2 base
release? It seems i need to have passport advantage account to be able
to download it from IBM website.
Thanks,

Syntax Error-Help!!
My error "SQL0180N The syntax of the string representation of a
datetime value is incorrect. SQLSTATE=22007" .
I'm using yyyy-mm-dd. I can see the dates in a column on another

Db2 v8 FP15 LUW .
create table T (ID varchar (24), ABC timestamp)
There is an index for (ID, ABC), allowing reverse Scans.
My application needs to determine MIN and MAX(ABC) for a given ID. We

hi   I am using DB2 V9.5   but there is a  IMPORT transaction that will
never be able to commit itself.
Its status is forever "Commit Active", and is taking 12% CPU, and not
waiting on any lock.

I'm doing some cross-platform development, under LUW 8.2 (Windows) for
z/OS 8.
I have some fairly complex queries which address some rather large
tables.

I am running DB2 UDB Workgroups V8.2 on Linux.  I don't believe I
installed the Data Warehouing capability when I installed.  Is it
difficult to enable that capability post installation?, and a second
question is "Are the data warehousing capabilities available with my

I'm trying to set up a database instance on a prime Linux server,
using db2 V9.5 with fixpack 1 applied.
I issued db2set DB2RSHCMD=/usr/bin/ssh
After adding 2 partitions, when issuing db2stop (as instance owner),

hi I have a   "import from flatfile into table" command which takes 100
seconds to
finish by itself.
However, when I run this import under UR  concurrence mode, this import

I am attempting to implement, what I believe to be, an unusual
scenario, and am hoping to find someone that has experience with
something similar.  I currently have a series of physical and logical
files on an iSeries (AS/400, System i5, or whatever IBM calls it