In our shop we have a 28,000,000 row insert that gets reloaded every
night. I am not looking to change this process. I would like to know
why in UDB Vs 7.2 we were getting an insert rate of 3300 rows per
second. We migrated to version 8.1 of UDB (non-partitioned) and now

In our shop we have a 28,000,000 row insert that gets reloaded every
night. I am not looking to change this process. I would like to know
why in UDB Vs 7.2 we were getting an insert rate of 3300 rows per
second. We migrated to version 8.1 of UDB (non-partitioned) and now

Running DB2 8.1.1 on AIX 5.1.
I have several userexits on the AIX box. I know about the samples.
However how do I determine which userexit Db2 version 8.1 is using?
Thanks

I'm looking for a way, via C/C++ code, to find the hostname and/or ip
address of the DB2 database server.  I'm given a system name
which, along with user/password allows me to connect to the database
server, but the details are hidden by DB2.

i have db2 udb 8.2 at my development & 8.1.6 on my prod machine. my
concern is if i use get/put routine cross 8.1 & 8.2, will the be any
compatibility problem?

I am trying to create a new database using DB2 UDB 8.1 on AIX.  When I
attempt to use the control center GUI, the error being returned is:
SQL1224N, SQLSTATE 55032.
When I attempt to use the command line, I get: SQL00083.

Trying to create a database - right click -> Create Database Wizard on
the db instance - before I enter the username/password, the Create
Database Wizard takes off doing *something* - the Progress pop-up
showing Elapsed Time sits there for ten minutes or more before telling

 Can anyone tell me how is a multi_byte to single byte and vice versa
conversion done in DB2.
 It would be great even if someone can tell me how Oracle does it?
Oracle already has functions called to_single_byte and to_multi_byte

In one istance I have four different databases. If I use db2stop all
databases will be shutdown. How can I shutdown each database
individually in one instance?
Thanks,

sql = "CALL " + myschema + ".MYSPROC(?,?,?,?,?,?,?,?,?)";
           rs = con.prepareCall(sql);
           rs.setString(1, user);
           rs.setString(2, action);

What is the maximum permissible size of a database? Is there any limitation.
What is the maximum # of tablespace's allowed in a database?
Thanks for your response.

I just upgraded a instance from 8.1 FP5 to 8.2 (FP7). Now when I run
db2advis I get the following:
SQL0805N  Package "NULLID.DB2ADVIO 0X5142316D564F4A55" was not found.
SQLSTATE=51002

I have a situation which I cannot get a good lead on how to resolve.
One of the applications I support uses the Hibernate software to
generate SQL.  The app is JAVA with JDBC.  In testing the users see no
problems and think the app is running okay.  I turned a database

How much time does it take to backup a datbase of size 2 terra byte?
Can you specify the tool you use, technique and registry variables
with values for your system, so that I get an idea?
How many tablespaces, and what are the sizes of those(rough figures

Is Bit & SBCS type same for column .
eg. create table test.tb01 (char (10)) SBCS for data
   create table test.tb01 (char (10)) bit for data    
Thanks