Hi,
Do you know which queries caused the advice?
If so do you know which query engine executes this queries?
I assume the advice cames from CQE. CQE uses only estimated values for it s
advice.
Also CQE searches the access path from the last one created to the first one
created.
CQE may also get a time out before all indexes are searched.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Frank.Kolmann@xxxxxxxxxx
Gesendet: Thursday, July 31, 2008 01:51
An: midrange-l@xxxxxxxxxxxx
Betreff: SQL SYSIXADV STRANGE RESULT (WAS Way to get STRSQL SELECT to run
inbatch?)
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?
midrange.com
