How can I find the list of temporary indexes created by the system of my iSeries AS/400 server?

1480 pts.
Tags:
AS 400
cl 400
iSeries
OS/400
How can I find the list of temporary indexes created on my iSeries server? Can I also find the file name and key fields on which the indexes are created. I have a query running fast on one server which has not been IPLed for quite some time. Same query takes much longer on a server which was recently ipled due to power issue at the site. Both servers are PR and DR server using the same application with data being replicated between the two servers using Mimix replication software. DR drills are done between both server every quarter. A query takes more time on one server, same query runs much longer on other server.  

Software/Hardware used:
cl400,OS400

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try something like this, then query the results..

Remember it will only grab the file information your profile is authorized to use.
DSPFD FILE(MYDTALIB/*ALL) TYPE(*ACCPTH) OUTPUT(*OUTFILE) 
FILEATR(*LF) OUTFILE(QTEMP/KEYS)
If you do truly mean TEMP indexes you will not be able to see them as the file / table is in QTEMP which is only visible to the profile that created it and goes away once the user logs off or removes it manually. 

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: