Hi @ll,
when i want to set the PrefetchSize on my database this setting will not
be set. DB2 shell says that the command is successfull but when i list
my details with.

We have UDB 7.2 running on window 2000 server name SERVERDB2UDB01(example)
Until we move to version 8 we want to move our production on another sever
Steps we want to do
1. install UDB DB2 7.2  on  SERVERDB2UDB07

I'm dealing with internationalization with DB2 here.
Performance-wise, is there any difference between using vargraphic and
varchar.  Say for example, if I choose between using vargraphic(32)
and varchar(64) to support 2-byte foreign characters, is there any

Does the utility db2set permanently sent variables in the Registry or
will it set values only for current session.
Thanks,
Yasaswi

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.
Thanks,
Michael

We have DB2 UDB v8.1 fixpak3 on AIX 5. Production and Development
configuarations (at least for DB2) are identical albeit production is
a 2-way server while development has only one processor. Tables and
indexes have the same schema. In fact, the dev database was taken from

Is there a way to determine the value of JDK_PATH programmatically
without having to grep and awk the output of "get dbm cfg"?  Is there
a way to just access the value of this single parameter?
Thanks!

how can i monitor cpu utilization per database or per instance.
i run snapshot for database and get lots of information which probably can
be used to come up with some
equation. is there anything simpler?

I am writing Java user defined functions running in DB2 8 on Windows XP.
For some reason the Windows system environment CLASSPATH is not being
passed to my Java UDF (i.e. when I println the java.class.path property,
I get a different CLASSPATH). Can anyone please help? How do I set

I would like to play around with BLOB and CLOB's and need the sample
programs compiled by DSNTEJ71, DSNTEJ73 and DSNTEJ75.
The problem is I don't have a C/C++ compiler. Could anyone send me the
object-decks or load-modules of these programs?

I was having an issue inserting data into a table in an I-Series DB2
database. The Insert statement itself is very simple:
Insert into Table1
select * from Table2

On two Aix 5.2 servers I want to implement HACMP. In the IBM's
"Advanced DBA Certification Guide and Reference Book", in page 248,
there are 8 steps to implement HACMP. The 8th step says,
"Failover $HOME to the dbserv2". What does this mean? Does it mean

does a command like,
db2 drop table tabschema.tabname when run from the Aix prompt reclaim
the disk space? Are there any other options? How can we make sure the
disk space is reclaimed?

I am trying to decipher deadlock events in a event monitor. I am
trying to determine what type of lock was held. If I look at the data
elements it shows LOCK MODE 5
LOCK MODE REQUESTED 3

we got new servers with AIX V5.2 and, as i was told,
for the combination DB2 V7.2 and AIX V5.2
   a) the "old" Java versions like 1.1.8 cannot be installed anymore
   b) the "new" Java runtime like 1.3.0/1.3.1 are not supported (and do not