DB2 7.2 on AIX 5.2.
I'm looking to remove redundant indexes.
The GET SNAPSHOT FOR ALL command does not appear to include historic
data for index utilisation. Can anyone give me any tips outside using

trying to use db2rbind to rebind all system procedures after performing
runstats on a few sysibm schema tables.
Getting "Database Manager cannot be started".
What am I doing wrong? Do I need to take the instance down to run db2rbind?

What is the equivalent of "@" (oracle) in db2?
I could use -f option but the basic requirement is to be able to call
file Y from file X.
In Oracle I can have file X as:

I hope this kind of question might be raised earlier in this newsgroup.
I want to design application where i need to call DB2 Admin API from within
Java code
Please suggest possibilities

I have installed DB2 UDB 8.1 on solaris machine. And my system is
win2k system. Is there any DB2 GUI Client software which i can install
in my system and connect to the DB2 UDB in solaris machine? If so,
please give me the URL

I am completely new DB2 UDB. Today i have installed DB2 UDB 8.1 on
Solaris machine. The installation was successfull. I logged into the
machine with db2inst1 user, which default instance user. But, i
couldn't find sqllib directory and DB2INSTANCE variable also not set.

Can anyone help me.
I'm trying to retrieve data from DB2/AIX v8.1 using JDBC connectivity
(Universal Driver - Type 4 - v1.1.67) . I get a recurrent error (after
connection, apparently) :

I have installed db2 7.2 on redhat Linux 7.3 and on another machine
db2 8.1 on redhat linux 8 and both installation prompt for error when
i try to run the control center
they say something like jre not found

I come from Oracle background. In Oracle, when one wants to do a point
in time
recovery, one can specify recover database until timestmap. Oracle's
database maps to a db2 subsystem, i.e., in Oracle database means

Greetings all,
Machine : PENTIUM
Os      :Windows 2000
Product : DB2 UDB EE         Release : 7.2

Everyday I get this error in db2diag.log . What could be the problem?
2003-12-28-09.36.45.141332   Instance:db2vkg   Node:000                
PID:21932(db2agent (VKG))   Appid:*LOCAL.db2vkg.031228053634          
database_monitor      sqm.sqlm_log_ev_err   Probe:1   Database:VKG    ...

I am an MS-SQLServer DBA (and very comfortable with writing SQL) but new to
DB2.
Unfortunately, I am not at the client now, but am hoping that my questions
can be answered before I return there.

Hi there, is it possible to schedule processes on demand, for an external
scheduler, not the one used by datawarehouse center - my company is willing
to use only its official scheduler, that manages all our applications ?
If so, what would be the best implementation for performance ...

I have 1 table which need to store 7 days data in a row, I not sure
which table design will gain better performance in SELECT statement.
Desgin 1. 7 columns (day1, ..., day7) with char(4)
or

do you know how to connect to IBM DB2 running under MS Win 32 with Ado
in Delphi ?
Many thanks