I always assumed that dropping table will drop everything associated
with it like indexes, references etc.
I just noticed that after dropping table A and recreating it and then
creating index on it gave me error

Hi Group,
Getting the below error in AIX server 5.2 and my DB2 ESE is V8.1 and
Fixpack 11.
I'm able to successfully connect to the database and able to run a

On my DB2 UDB 8.2.7 database user User1 has been granted
IMPLICIT_SCHEMA privilege, but when he issues "create schema test",
the error message "SQL0552N, USER1 does not have the previliege to
execute the operation create schema" was thrown. But if he issues

How can I determine the DB instances on a aix box?

Folks,
 Today, I was exporting a table in one database and then importing it in
 another database. The table in destination database was missing one column
 (my mistake while creating the table), but import did not complain about it.

Folks,
I used to be able to access db2 (v8 and prior) from within a cygwin bash
shell after doing some tricks with the DB2CLP variable (see
http://www.cygwin.com/ml/cygwin/2003-02/msg00635.html).

How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third

Hi Group,
Running DB2 V8.2 Fxpack 9 in AIX 5.2, I get the following error
frequently and my instance is stopped...collected some info like: the
signal received is 11 which is SEGMENTATION VIOLATION ERROR...after

I have DB2 v8 server installed in Solaris9. The instance db2inst1 is a
server instance and as a client to connect to the other remote
server.
Today I notice 2 DB2 processes(db2fm) are using 50% CPU resource, how

Who knows how to create multi-location/global views? Could you show me
some examples?
Thanks in advance,
Laurence

root@Server:/opt/ibm/db2/V9.1/bin# ./db2adutl
./db2adutl: error while loading shared libraries: libApiDS.so: cannot
open shared object file: No such file or directory
I just installed db2 9.1 express-c for linux to give it a try since I

I use db2 v8.1 fixpack 3 on AIX 5.2
After I login to my database server if i fire the command db2 it gives
me the following error message:
SQL10007N Message "-1390" could not be retrieved.  Reason code: "1"

v8.2.7
This procedure is not working (SQL20046N):
---
create procedure tst(nm1 varchar(20), nm2 varchar(20))

I m new to DB2, Please bear with me if this is silly question, but i
need to know how to copy(only triggers) 400 triggers from one data
base to another on same server and also onto different server.
we use 8.1 on aix.

I'm try to Unload DB2 data from a table into a record sequential file
on NT. I can an unload on Mainframe, but it doesn't seem to be an
option in NT.
In NT, all I can do is export/import. I can do a Load too, but not an