Given a loop like this:
for (int ix=0; ix<myArray.length; ix++) {
   System.out.println(ix);
}

One of our demonstration systems has just started to produce the
following error during startup.  We can't interpret this ourselves, can
anyone give us a clue what we've broken?
2005-02-23-11.49.12.340000+060 I178174598H381     LEVEL: Severe

does anybody know whether IBM Websphere Information Integrator
supports distributed transactions, that is - can you update multiple
heterogenous databases in one update, or at least in one
transaction...?

(UDB 8.1 FP8, Win)
In my simple test database, I have two tables
CREATE TABLE "DB2ADMIN"."AAA" (
   "F1" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,

 I want to assign SYSADM privileges to user say XYZ. I know that this
privileges can't be assigned directly using grant command. But can be
acheived by assigning the privileges to group and then inturn assign
the user to the group? Does this group mean OS level group or something

I understand that there are various lock modes in DB2. In SNAPSHOT_LOCK
function there is a field known as lock_mode. It has values varying
from 1 to 9. Can anyone tell me the meaning of these values? (I mean
lock_mode = 1 stands for which lock?)

In the ISPF editor I am using, for a particullar PO Dataset I am
getting the result of FIND  statement narrowed down to the colums
48-56. i.e. if I give "FIND 'TO' ALL", the result I am getting as
"CHARS 'TO' - found 239 times within columns 48 to 56".

Problem:
=========
Unknown column appearing in federated tables.
Description:

I have two identical schema tables (one in a production library and
another in a development library) and I need to be able to easily
compare the data in them for errors and omissions.  With another
relational database (can you guess which?) I was able to do the

Bloomington IL -- Technical Analyst / Security (Oblix)
Mail your resumes to : godwin@simplexinfo.com; carmelc@gmail.com
Bill rate : best .
Experience: 5+ years Total IT experience

We have a table in db2 that has about 40 million rows added to it daily and
want to keep a rolling period of 180 days worth of data on the table.  We
want to remove either one day or a few days worth of data in batch, but it
must not cause significant locking on the table.

As do all such projects, my latest venture into DB design has grown as
the user becomes more educated to his needs, the design process and the
capabilities of those involved. I am looking for a tool which I can
point to a db2 dub schema and get a pictorial representation of the

I want to create a very simple db2 package and bind it .
The test is to bind multiple versions of a package.
So I want to first create a package ,bind it and then modify it to
create another version .

we are using db2 udb v8.2 on windows. All our tables are created with
"not logged initially" parameter. Our application with auto commit on.
I would like to do an online backup and rolling forward recovery, is
this allowed? because in the document, i read these: You cannot recover

I am writting a stored procedure to purge one of our transaction
tables. I would like to run this SP periodically, say everyday at 4 am.
I am wondering how can I achieve this without writting a OS cron job. I
know Oracle has the feature DBMS_JOB, but wondering whether is there