iSeries SQL and identity columns

Hello All,

Have been having some performance issues with web pages hitting our
iSeries. Set up SQL Exit program to be able to capture/log odbc sql
statements. Looking in my log file - the overwhelming log entries have
the following sql statement.

SELECT identity_generation FROM QSYS2/SYSCOLUMNS WHERE identity_generation
is not null AND column_name = ? AND table_name = ? AND table_schema = ?

I have never seen a statement use the identity_generation field. From
what I can tell from IBM's website - this is a col you can add when
creating a sql table and is used to support a type of "auto increment" key
value?

So - a couple of questions? Is there a way (perhaps with Ops Navigator)
to find a list of all tables that have this identity_generation column so
I can backtrack to see what web pages are being called?

Also - is this a system generated statement? I ask because the developers
who have written most of our web pages are telling me they don't recognize
this either???

Know this is not much to go on but it's what I have at the time. Any
thoughts would be greatly appreciated.....

Thanks



Terry Bullard – Applications Programmer Analyst


"Contains Confidential and/or Proprietary Information.
May Not Be Copied or Disseminated Without Express Consent of The Goodyear
Tire & Rubber Company."