Does DB2 have a setting to turn off lock escalation?  I've just done
several hours of newsgroup googling, and have found only a couple
references to such a setting, for DB2 v4.1 back in the late 90's.
One of our apps is (fairly) regularly grabbing table locks instead of

Is Db2 7.1 certified for Suse Linux 9?

   I am fairly new to linux so bare with me.
   I am trying to install Db2 for Workgroups 7.1 on a Suse Linux 9. I
am logged as root (well, su root) and I am calling db2setup (residing
on the CD) form the "/" directory (the exec command line is

I have recently uninstalled DB2 7 and re-installed it.
I had deleted a database in the past, but now when I go to recreate
it, I'm getting the message
"The database alias ___ already exists in either the local database

Have a question on the Stored procedure method code generated by DB2
development center for Java stored procedures.
Suppose I have a requirement to return the resultset consisting of
FIRSTNME, LASTNAME of all employees belonging to a particular

I have a view which references two different tables at different times
say t_1 on certain days and t_2 on certain other days.
In oracle I have many many ways of doing this without having much
impact.

Hi
Two questions:
1. what is the maximum mirror log that can be set?
2. Say I have a media failure and some or the entire

I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
My previous db2 version was V7.1.
when I issue the db2ckmig for the db, I get the following error.
% db2ckmig sample -l /tmp/db2ckmig.log

I need to access an Oracle DB from DB2.
I'd like to use DB2 Connection relation but I would like to
know...will it work?
Can I do Join between DB2 table and Oracle table?

Are all database configuration parameters included in the database
backup or not ? If I restore the database from the backup are these
restored also ?
What is the best way to backup and restore these parameters ?

I'm installing a new database on a new server in RAID 50 that I've not
used before.  Windows Server 2003 with all XP clients (that I've not
used before).
While I have checklists for what to do administering a db2 database, I

i would like to know whether i can just install fixpack5 without
install the db2 server first, we are using db2 udb v8.1 on windows
64bit.

Can anybody tell me why the select of the following fails ??
--(run'able SQL)
create function f(p_i integer)
returns table (i integer)

I'm looking to order a full paper-based (dead trees)
manual/doc set for DB2 v8 for Linux.  I assume it
is all the books I see listed here:
http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w
/en_main

I am pretty new to DB2 and am facing the huge task of migrating from
SQL server to DB2. Can anyone give me detailed links which will be
useful for a fresher to migrate from sql to db2.