SQL SYSIXADV STRANGE RESULT (WAS Way to get STRSQL SELECT to run in batch?)

Hi
If it worked, the V5R4 file SYSIXADV would be a very powerful and time
saving function.
I use STRDBMON to get the same info, but I can only do that when the job
is running.
We have BPCS and IIM is the Item Master.

I used the SQL below and IIM came up.
I could not believe my eyes, we are quite diligent and anyway there exits
a LGL with the exact key advised with no other Selects etc etc.

So either SYSIDXADV is broken or something else is not set properly.

Any suggestions


TIMES_ADVISED TABLE_SCHEMA NAME LAST_ADVISED KEY_COLUMNS_ADVISED
56,674,993 LIB IIM 2008-07-31-09.30.19.926679 IPROD




31/07/08 DISPLAY FILE DESCRIPTION
DSPFD COMMAND INPUT
FILE . . . . . . . . . . . . . . . . . . . : FILE IIML02
LIBRARY . . . . . . . . . . . . . . . . . : LIB
TYPE OF INFORMATION . . . . . . . . . . . . : TYPE *ACCPTH
FILE ATTRIBUTES . . . . . . . . . . . . . . : FILEATR *ALL
SYSTEM . . . . . . . . . . . . . . . . . . : SYSTEM *LCL
FILE DESCRIPTION HEADER
FILE . . . . . . . . . . . . . . . . . . . : FILE IIML02
LIBRARY . . . . . . . . . . . . . . . . . . : LIB
TYPE OF FILE . . . . . . . . . . . . . . . : LOGICAL
FILE TYPE . . . . . . . . . . . . . . . . . : FILETYPE *DATA
AUXILIARY STORAGE POOL ID . . . . . . . . . : 00001
ACCESS PATH DESCRIPTION
ACCESS PATH MAINTENANCE . . . . . . . . . . : MAINT *IMMED
UNIQUE KEY VALUES REQUIRED . . . . . . . . : UNIQUE NO
KEY ORDER . . . . . . . . . . . . . . . . . : NOT SPECIFIED

SELECT/OMIT SPECIFIED . . . . . . . . . . . : NO
ACCESS PATH JOURNALED . . . . . . . . . . . : NO
ACCESS PATH . . . . . . . . . . . . . . . . : KEYED
NUMBER OF KEY FIELDS . . . . . . . . . . . : 1
RECORD FORMAT . . . . . . . . . . . . . . . : IPI100IM
KEY FIELD . . . . . . . . . . . . . . . . : IPROD
SEQUENCE . . . . . . . . . . . . . . . : ASCENDING
SIGN SPECIFIED . . . . . . . . . . . . : UNSIGNED
ZONE/DIGIT SPECIFIED . . . . . . . . . : *NONE
ALTERNATIVE COLLATING SEQUENCE . . . . : NO
FILES ACCESSED BY LOGICAL FILE PFILE
FILE LIBRARY LF FORMAT
IIM LIB IPI100IM


Frank Kolmann

----- Message from David FOXWELL <David.FOXWELL@xxxxxxxxx>
on Wed, 30 Jul 2008 09:56:11 +0200 -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: AW: Way to get STRSQL SELECT to run in batch?
I had a quick look.
SELECT * from SYSIXADV where times_advised = (
SELECT max(TIMES_ADVISED) FROM SYSIXADV )

Found a file that has 4 500 000 record and has been advised 2 million

times.

Should I be worried about this?