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

Change query processing defaults

This tip shows you how you can find out how long your queries are taking to run.

Want to know how long your queries are taking to run, or if you want to increase the processing time? Look at the system value that drives the processing of queries.

DSPSYSVAL SYSVAL(QQRYTIMLMT)

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: Tips, tutorials and more.

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

Read this Search400.com Featured Topic: Managing your iSeries.

Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.


Dig Deeper on Performance

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close