Driving and Car Maintenance: Transportation accounts for 66% of U.S.
oil use -mainly in the form of gasoline. Luckily, there are plenty of
ways to improve gas mileage.
Driving Tips:- Idling gets you 0 miles per gallon. The best way to

Do you know that you can find solar cells for less than 1 USD per Watt
on www.ebay.com ?
Regards.

Situation: New x86-64 Red Hat Enterprise Linux 5.4 (64 bit) server with
plenty of RAM (192GB) and DB2 ESE v. 9.7 FP1. The server has one DB2
instance, hosting one 10TB database.
I had tried adjusting some kernel limits according to http://

I fell in love with the net and all the compuiter teahcnology in the very early years and have loved it ever since, I have an IT Degree and Communications degree and will be working on my doctorate for the next five years, in bwetween I design websites, databases, Multimedia ...

Hi, I get this error SQL0101N error for the Select Query. I know that
I am selecting all the colums from 10 tables and passing like 200
values to the IN Clause for a column. But it does work in other
environments(different db2 versions though) but doesnt work in one

For DB2 Version 9.5, does setting swappiness= 0 (/proc/sys/vm/swappiness) on
RHEL 5 sufficiently limit Linux file system caching, or is there some other
way to limit on the percent of memory that can be used for Linux file system
caching.

i have a little performance problem with DB2 UDF:
i've created 2 UDFs:
EAN_128(EanCodeReq VARCHAR(4), Id bigint) returns VARCHAR(32)
and

We'd like to use the auto_del_rec_obj and rec_his_retentn cfg
parameters to delete old backup images and archived log files. This is
working fine, expect in a HADR configuration. Backup images that are
taken on the standby server are stored in that side's history file

Use IQ 20/20 to produce stunning Reports and Dashboards from your DB2
data as well as other data sources.
If you have invested time and money into building your DB2 data then
you probably realized that is only part of the equation.  The next

I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except
the following issue from db2diag.log.
____________________________________________________
2010-02-22-09.48.21.993163-300 I11339579A449      LEVEL: Severe

    I would like to use AUTHENTICATION=DATA_ENCRYPT parameter on my
database for increased security. But I cannot find any in depth
articles about it on the internet. I would like to know about the
following:

I am running DB2 V9.5 on AIX.  We have a fairly small database (2
million records max on main table).  We use COUNT(*) periodically.  We
also schedule runstats and online reorg periodically.  At times
COUNT(*) can be very slow and although a reorg/runstats speeds it up

I am working with WebSphere Federation Server v9.5. for LUW Developer
Edition. What are the limitations of the developer edition? I was not
able to find a list with the limitations.
Specifically, are there any limitations in using asynchronous

How does DB2 choose the victim when a deadlock is detected?
Can it be configured in any way?
Last night a long-running batch transaction was choosen before a one-
account-update Web-application.  I was under the impression that the

Hello, using DB2 version 9.7 I assumed the following would work. In
this example, tableA has a composite key on x,y.
select * from tableA where (x, y) IN ( ( 'x1', y1) )
but, DB2 throws this: