how to know about how many tables i created in that database.if the
database is connected to many users.
i want the query in this way that i want creater,number of
tables,time,updates .

Does anyone have any idea what the following entries in the DB2 diag
could indicate?  Here are the details...
Second night in a row that DB2 has hung.  All DB2 commands related to
databases hang.  Platform is AIX 5.3 and DB2 8.2 ESE.  Here are the

I' m sending query to DB2 7.2 (installed on Win 2000) using JDBC driver
COM.ibm.db2.jdbc.net.DB2Driver like this:
String query = "SELECT dercert from vacert "
    + "WHERE vrijediod=(select max(vrijediod) from vacert where

I am trying to find a way to determine the DB2 version level through
c++.  I only found one way through IBM's website and i would have to
connect to a db first.  I will have to check versions on systems that
do not yet have a database.  My applications will be used for creating

One of our tablespaces is in an offline state:
Tablespace ID                        = 9
Name                                 = xxx_xxxx
Type                                 = Database managed space

I am new to DB2. I could connect to DB2 database on AS/400, but cannot
see any DBM or DB configuration. Is database or database manager
configuration available for DB2 on Z/OS, OS/390 or AS/400? If
available, what is the way to obtain it?

I want to run this query.  The query runs fine but it always inserts
blanks into the temp database.  Any suggestions would be appreciated.
DECLARE GLOBAL TEMPORARY TABLE temp_date (v_date timestamp) in VDATE;
INSERT INTO SESSION.temp_date values(SELECT current timestamp FROM

db2 version 8.2.2
Windows
I have installed the database and created Sample db. Now when I am giving
db2stop ,it says

I have a Linux box (RH 4 Update 2 / kernel 2.6) running DB2 V8 FP 10.
My application is continuosly inserting data to a table. The statement
is a simple "insert into table values (a,b), ... (c,d)". 50 rows are
inserted per transaction, and a Commit is issued after the insert.

I'm attempting to get Instead Of triggers working.  My platform in
Solaris, DB2 verison 8.1.x (not sure which).
If I create two simple tables with 1 row each:
create table test_cc_1 (col1 char(2), col2 integer);

When attempting to use the native iSeries JDBC driver to access the
local iSeries DB2 db, I get the following SQLException:
"The Username and/or password supplied is incorrect." (SQL1403N)
The JDBC Driver used is: com.ibm.db2.jdbc.app.DB2Driver

Problem: getting SQL0181N for queries on nicknames to remote
Union-All-View.
Can't see what I'm doing wrong yet, maybe someone has seen this before.
Environment: UDB ESE 8.1 + FIXPAK 9A, on Solaris 8.1, with 64-bit

On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure
use two-phase-commit with nicknames and if DB2 provides the
Transaction-manager?
i.e. in the same transaction, can an SQL/PL procedure

I want to create a temp table called
DECLARE LOCAL TEMPORARY TABLE tempdate(test integer) in VDATE;
but I always get an error.  I read that I have to create a Table space
so I did.  

Hi. If I have an index (or primary key) on 3 columns, will a subset of
these columns automatically be indexed also?
For example:
CREATE INDEX idx ON tbl(cola, colb, colc);