iSeries Java Technical Discussion Mailing List
http://archive.midrange.com/java400-l
Java programming on and around the IBM iSeries. JDBC to DB2/400, JTOpen, integration between Java and other iSeries languages (RPG, COBOL, CLP, etc).en-usCopyright (c) 1997-2012 midrange.com and David Gibbs as a compilation workdavid@midrange.com (David Gibbs)2012-02-02T09:28:08-06:00This is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site, subject to copyright and fair use.midrange.comhttp://static.midrange.com/images/logo.jpg
http://www.midrange.com
RE: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/F4Rt7vnrViI/msg00008.html
Tomer Sason2012-02-02T09:27:55-06:00If you set the trace level to SERVER_TRACE_DEBUG_SERVER_JOB, for the data source, you should get the debug information that you need. david
<p><a href="http://feedads.g.doubleclick.net/~a/JO7WoLt8I5B8GHqilBj2fJCMn4s/0/da"><img src="http://feedads.g.doubleclick.net/~a/JO7WoLt8I5B8GHqilBj2fJCMn4s/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/JO7WoLt8I5B8GHqilBj2fJCMn4s/1/da"><img src="http://feedads.g.doubleclick.net/~a/JO7WoLt8I5B8GHqilBj2fJCMn4s/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=F4Rt7vnrViI:JSkxQgg_Rus:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=F4Rt7vnrViI:JSkxQgg_Rus:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=F4Rt7vnrViI:JSkxQgg_Rus:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=F4Rt7vnrViI:JSkxQgg_Rus:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=F4Rt7vnrViI:JSkxQgg_Rus:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=F4Rt7vnrViI:JSkxQgg_Rus:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=F4Rt7vnrViI:JSkxQgg_Rus:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=F4Rt7vnrViI:JSkxQgg_Rus:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/F4Rt7vnrViI" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00008.htmlRe: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/-T3r2xG0ATo/msg00007.html
David Gibbs2012-02-02T08:59:00-06:00If you set the trace level to SERVER_TRACE_DEBUG_SERVER_JOB, for the data source, you should get the debug information that you need. david
<p><a href="http://feedads.g.doubleclick.net/~a/57Eud5zfYegn0ATIKAdBuYiCbj4/0/da"><img src="http://feedads.g.doubleclick.net/~a/57Eud5zfYegn0ATIKAdBuYiCbj4/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/57Eud5zfYegn0ATIKAdBuYiCbj4/1/da"><img src="http://feedads.g.doubleclick.net/~a/57Eud5zfYegn0ATIKAdBuYiCbj4/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=-T3r2xG0ATo:SJtMCgMHXxg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=-T3r2xG0ATo:SJtMCgMHXxg:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=-T3r2xG0ATo:SJtMCgMHXxg:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=-T3r2xG0ATo:SJtMCgMHXxg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=-T3r2xG0ATo:SJtMCgMHXxg:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=-T3r2xG0ATo:SJtMCgMHXxg:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=-T3r2xG0ATo:SJtMCgMHXxg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=-T3r2xG0ATo:SJtMCgMHXxg:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/-T3r2xG0ATo" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00007.htmlRE: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/A3jIhG1EIFQ/msg00006.html
Tomer Sason2012-02-02T01:43:48-06:00If you run the query in debug mode (there are properties on the jdbc connection you can set to enable debug), you can see the access path adviser messages ... if you create the recommended access paths, your queries will run faster always. See http://urlq.us/jdbcprops or http://javadoc.midrange.com/jtopen/com/ibm/as400/access/doc-files/JDBCProperties.html for the properties. david
<p><a href="http://feedads.g.doubleclick.net/~a/7IDMcx0jOmeyz_7tVIHh6RqoYDw/0/da"><img src="http://feedads.g.doubleclick.net/~a/7IDMcx0jOmeyz_7tVIHh6RqoYDw/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/7IDMcx0jOmeyz_7tVIHh6RqoYDw/1/da"><img src="http://feedads.g.doubleclick.net/~a/7IDMcx0jOmeyz_7tVIHh6RqoYDw/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=A3jIhG1EIFQ:6nXAA7Li0oA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=A3jIhG1EIFQ:6nXAA7Li0oA:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=A3jIhG1EIFQ:6nXAA7Li0oA:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=A3jIhG1EIFQ:6nXAA7Li0oA:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=A3jIhG1EIFQ:6nXAA7Li0oA:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=A3jIhG1EIFQ:6nXAA7Li0oA:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=A3jIhG1EIFQ:6nXAA7Li0oA:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=A3jIhG1EIFQ:6nXAA7Li0oA:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/A3jIhG1EIFQ" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00006.htmlRE: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/0bTCL_F9veA/msg00005.html
Tomer Sason2012-02-02T01:35:08-06:00-- This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.
<p><a href="http://feedads.g.doubleclick.net/~a/MzBhusAF3iBKXLAOfTTzugZK3tU/0/da"><img src="http://feedads.g.doubleclick.net/~a/MzBhusAF3iBKXLAOfTTzugZK3tU/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/MzBhusAF3iBKXLAOfTTzugZK3tU/1/da"><img src="http://feedads.g.doubleclick.net/~a/MzBhusAF3iBKXLAOfTTzugZK3tU/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=0bTCL_F9veA:lPlBU8mMZjI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=0bTCL_F9veA:lPlBU8mMZjI:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=0bTCL_F9veA:lPlBU8mMZjI:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=0bTCL_F9veA:lPlBU8mMZjI:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=0bTCL_F9veA:lPlBU8mMZjI:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=0bTCL_F9veA:lPlBU8mMZjI:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=0bTCL_F9veA:lPlBU8mMZjI:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=0bTCL_F9veA:lPlBU8mMZjI:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/0bTCL_F9veA" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00005.htmlRe: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/Gk8F55sdTlQ/msg00004.html
David Gibbs2012-02-01T11:15:11-06:00If you run the query in debug mode (there are properties on the jdbc connection you can set to enable debug), you can see the access path adviser messages ... if you create the recommended access paths, your queries will run faster always. See http://urlq.us/jdbcprops or http://javadoc.midrange.com/jtopen/com/ibm/as400/access/doc-files/JDBCProperties.html for the properties. david
<p><a href="http://feedads.g.doubleclick.net/~a/_dO6WnmOtK-OPYg2WJOna4ZlAWg/0/da"><img src="http://feedads.g.doubleclick.net/~a/_dO6WnmOtK-OPYg2WJOna4ZlAWg/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/_dO6WnmOtK-OPYg2WJOna4ZlAWg/1/da"><img src="http://feedads.g.doubleclick.net/~a/_dO6WnmOtK-OPYg2WJOna4ZlAWg/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=Gk8F55sdTlQ:75cor97hJ5g:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Gk8F55sdTlQ:75cor97hJ5g:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Gk8F55sdTlQ:75cor97hJ5g:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Gk8F55sdTlQ:75cor97hJ5g:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=Gk8F55sdTlQ:75cor97hJ5g:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Gk8F55sdTlQ:75cor97hJ5g:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Gk8F55sdTlQ:75cor97hJ5g:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=Gk8F55sdTlQ:75cor97hJ5g:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/Gk8F55sdTlQ" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00004.htmlRE: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/4_meiHoAMoQ/msg00003.html
Dan Kimmel2012-02-01T11:07:49-06:00-- This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.
<p><a href="http://feedads.g.doubleclick.net/~a/PYiu4tzjOdRsa6T5eVXK4Twcuyw/0/da"><img src="http://feedads.g.doubleclick.net/~a/PYiu4tzjOdRsa6T5eVXK4Twcuyw/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/PYiu4tzjOdRsa6T5eVXK4Twcuyw/1/da"><img src="http://feedads.g.doubleclick.net/~a/PYiu4tzjOdRsa6T5eVXK4Twcuyw/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=4_meiHoAMoQ:mdJgFKs1arE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=4_meiHoAMoQ:mdJgFKs1arE:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=4_meiHoAMoQ:mdJgFKs1arE:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=4_meiHoAMoQ:mdJgFKs1arE:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=4_meiHoAMoQ:mdJgFKs1arE:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=4_meiHoAMoQ:mdJgFKs1arE:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=4_meiHoAMoQ:mdJgFKs1arE:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=4_meiHoAMoQ:mdJgFKs1arE:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/4_meiHoAMoQ" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00003.htmlRE: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/Z9yLeXDWbDA/msg00002.html
Tomer Sason2012-02-01T09:54:05-06:00<p><a href="http://feedads.g.doubleclick.net/~a/2UU_3fCrOFHYzc16s6WInWjHgn0/0/da"><img src="http://feedads.g.doubleclick.net/~a/2UU_3fCrOFHYzc16s6WInWjHgn0/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/2UU_3fCrOFHYzc16s6WInWjHgn0/1/da"><img src="http://feedads.g.doubleclick.net/~a/2UU_3fCrOFHYzc16s6WInWjHgn0/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=Z9yLeXDWbDA:E27oN3ybkM4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Z9yLeXDWbDA:E27oN3ybkM4:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Z9yLeXDWbDA:E27oN3ybkM4:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Z9yLeXDWbDA:E27oN3ybkM4:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=Z9yLeXDWbDA:E27oN3ybkM4:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Z9yLeXDWbDA:E27oN3ybkM4:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=Z9yLeXDWbDA:E27oN3ybkM4:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=Z9yLeXDWbDA:E27oN3ybkM4:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/Z9yLeXDWbDA" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00002.htmlRe: AS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/ED6tUFi9xvo/msg00001.html
Jim Oberholtzer2012-02-01T09:19:50-06:00<p><a href="http://feedads.g.doubleclick.net/~a/kCJwLntlVnL1uJwKhB1GTnpJ_Is/0/da"><img src="http://feedads.g.doubleclick.net/~a/kCJwLntlVnL1uJwKhB1GTnpJ_Is/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/kCJwLntlVnL1uJwKhB1GTnpJ_Is/1/da"><img src="http://feedads.g.doubleclick.net/~a/kCJwLntlVnL1uJwKhB1GTnpJ_Is/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=ED6tUFi9xvo:eYpx6wNGFbQ:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=ED6tUFi9xvo:eYpx6wNGFbQ:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=ED6tUFi9xvo:eYpx6wNGFbQ:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=ED6tUFi9xvo:eYpx6wNGFbQ:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=ED6tUFi9xvo:eYpx6wNGFbQ:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=ED6tUFi9xvo:eYpx6wNGFbQ:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=ED6tUFi9xvo:eYpx6wNGFbQ:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=ED6tUFi9xvo:eYpx6wNGFbQ:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/ED6tUFi9xvo" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00001.htmlAS400/DB2 - caching specific query
http://feeds.midrange.com/~r/java400-l/~3/H7PvuQAEcGA/msg00000.html
Tomer Sason2012-02-01T09:03:42-06:00Hello everybody, I am using DB2 on AS400 (V6R1). When I execute a query the first time, It's taking long time (relatively speaking). The next executions time of the same query are significantly shorter. If I do not use this specific query for a while, the next time of execution gets longer again It seems that the query was cached and after a while it was removed from the cache. I assume this is due to caching policy of DB2. I think the caching policy can be set in QAQQINI file (either in QSYS or QUSRSYS), b...
<p><a href="http://feedads.g.doubleclick.net/~a/_4BEml3416mbcYJ4ZuXKmtyUwf4/0/da"><img src="http://feedads.g.doubleclick.net/~a/_4BEml3416mbcYJ4ZuXKmtyUwf4/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/_4BEml3416mbcYJ4ZuXKmtyUwf4/1/da"><img src="http://feedads.g.doubleclick.net/~a/_4BEml3416mbcYJ4ZuXKmtyUwf4/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.midrange.com/~ff/java400-l?a=H7PvuQAEcGA:HLNdj7I_f7I:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=H7PvuQAEcGA:HLNdj7I_f7I:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/java400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=H7PvuQAEcGA:HLNdj7I_f7I:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/java400-l?d=7Q72WNTAKBA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=H7PvuQAEcGA:HLNdj7I_f7I:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/java400-l?i=H7PvuQAEcGA:HLNdj7I_f7I:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=H7PvuQAEcGA:HLNdj7I_f7I:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/java400-l?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/java400-l?a=H7PvuQAEcGA:HLNdj7I_f7I:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/java400-l?i=H7PvuQAEcGA:HLNdj7I_f7I:gIN9vFwOqvQ" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/java400-l/~4/H7PvuQAEcGA" height="1" width="1"/>http://archive.midrange.com/java400-l/201202/msg00000.html