Problem solve Get help with specific problems with your technologies, process and projects.

Queries creating a new temporary access path

I'd like to be able to find out which queries are creating a new temporary access path during any given day. Is there an easy way to do this?

I am not aware of any easy way to do this. The simple way would be to run the queries in question and find the ones that create a temporary access path and log how many times that query is used. That would not preclude a query that does not create a temporary access path from creating one when it cannot use an access path due to system load during high use at any particular time. Some queries will always create one. Some will never create one. Some will only create one if they need it.


The Best Web Links: tips, tutorials and more.

Ask your OS/400 questions--or help out your peers by answering them--in our live OS/400 discussion forums.

Dig Deeper on Past Releases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.