Helpful folks,
I am trying to find any doc or research or studies comparing the pros
and cons of architecting a DB2 disk subsystem to physically segragate
index access and data access on separate spindles, as opposed to

No, I am not a headhunter offering jobs :-)
I'd like to ask a question and I'm addressing it especially to those who
hire people to work with DB2 and those who work with those new hires:
What knowledge, skills and techniques would you want a new hire to have if

Folks,
How can I convert date/time/timestamp to an integer?
According to UDB 8.1 docs that I have,
INTEGER('1964-07-20') should return 19640720, but when I run the SQL

Does HADR feature need any add-on product / license  or   is it part
of the base version of DB2 EE software ?
Thanks

I have a couple questions about setting up automatic client reroute.
First, after setting the alternate server for a database, is there a
way to verify the settings later on?  The next thing is I've added
these values for my HADR pair, but I'm not sure I'm testing the basic

  I am getting a message from UDB:
FATAL SQL ERROR
SQL0998N  Error occurred during
transaction or heuristic processing.

i am facing problem in package cache hit ratio its between 47-45%
which is very less:-
here are my configuration related to package cache:-
Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 2500

I was asking questions about the DB2 certification exams a couple of weeks
ago and I realize I forgot to ask two questions. I suspect I know the
answers but it would be very helpful to get confirmation on these points.
1. Are the exams "closed book"? I am assuming they are but if ...

I have some ODBC processes that have been locking tables that I work
with, causing lock issues later at night when we run our billing and
datawarehousing programs.  Since this began about a week ago, I have
found the issue but I continue to double check that I'm not locking

I have some problems with DB2 under Linux.
I'm running IBM DB2 V9.5 on a Debian Testing system. My configuration is as
follows:
--every DB2 component installed on my PC, except the Informix-related

Friends,
Can anyone help me how to use DB2 utilities like IMPORT/LOAD in ASP
scripts ?

I have a query that has 5 predicates, scanning a table of 400+ million
rows and I have built indexes getting help from design advisor and
other tools. The cost of that query is really low. But I federated the
server and created a nickname for that table, and when I give the same

I've been looking at the information on Structured Types in the certifcation
guide and have previously read it in the DB2 manuals. As neat as Structured
Types are, I'm very curious to know if they are being heavily used in the
real world? Or are they just a "nice to have" feature ...

I am trying to do the following w/ SQL for db2 9...
I want to find the top x percent of rows. For example, if i wanted to
find the average sale price of the top 10 most expensive items in a
store, how could I go about doing that, w/o a stored procedure? I've

I have a db2 9 FP3a installation with one instance and one database
installed.
I have 4G of physical RAM and I have enabled the /3G switch in
boot.ini.