After a successful installation of DB2 V9 (GA) on AIX 5.2, I cannot find any
corresponding filesets with lslpp command, any ideas here?!?
BTW, what does "GA" stand for?
The second question, unrelated to DB2: what is the difference between AIX TL

I have 120 tables which mostly dependent to each other. Just did a
db2move for all data. Now causing SQL0668 error when accessing tables
with dependencies.
Now I am running SET INTEGRITY command for each tables one-by-one. :(

I am new to db2 databases.
I use db2 V8.2 on AIX 5 platform.
My database has 6 primary Log files and no secondary log files.
When I try to read these files from the default locationi find that

I have an application, where I do connect, handle a few requests, and
if for some reason, I lose connectivity, I detect that and loop(trying
to reconnect) until I regain connection to the DB. My problem is that
after I do a

I have come across an issue that appears to relate to APAR IY76615:
IY76615   CONNECTION WITH .NET DATA PROVIDER MAY FAIL WHEN UPGRADING TO
DB2 V8         FP10
This is documented as having been fixed in fix pack 11. We upgraded the

Hi people,
How can I reduce the amount of memory required to have the health
monitor running. Presently whenever I start it I get endless out of
memory errors in the db2diag.log when strictly speaking there is over

I am using IBM DB2 JDBC 2.0 Type 2 driver and understandably I am
getting an exception when I call getGeneratedKeys()  (Not supported on
the webspehere java.sql.conenction implementation).
Is there any other to get the keys other than doing another query to

Someone explain the significance of SQL state?

I'm relatively new to DB2 and have noticed a problem with my queries
when doing a like with ucase.
Since queries need to be case insensitive, I have to do a ucase on the
column(s) being searched on.

Hi. I was just wondering if someone could help me understand the
relationship between the recv_hist_retention value and archive logs
(and pruning of history file).
My understanding is that the history file will be automatically pruned

I'm having a problem that I can't seem to find any solution for online.
I'm using a cursor in a cobol program to fetch some data.  I know for a
fact that the select should return 2 rows.  The fetch works as I would
expect it to on the 2 rows, but then when I do my next fetch, the

i've got two structural identical tables (including tablespace and indexes)
with identical data, on which the access path of an SQL is differs. But I
don't see a reason for the different behaviour.
Both tables are allocated in the same database and storage space and use the

I am new to DB2. The version we are using is 8.2.3
I have to query DB2 to find out all backups for a given database and take
following
information

The following is apart of db2diag file.
2006-10-11-19.03.36.005000   Instance:DB2   Node:000
PID:3440(tomcat5.exe)   TID:844   Appid:none
oper system services  sqloSSemClose Probe:20

I'm working on implementing online reorgs(V8 FP11 on AIX), and am
seeing a lot of transaction logging during the reorgs. My problem is
that the archive logs are filling up the active log path before they
can all be archived off to TSM. I don't have unlimited disk space. Is