Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Query degree and QAQQINI file
50 views
Skip to first unread message
Jonathan Ball
Jul 18, 2012, 12:32:51 PM7/18/12
to
I'm trying to control the degree of parallel processing through the PARALLEL_DEGREE row in the QAQQINI file, and it doesn't seem to be working. When I select the 3000 row from a database monitor output file after changing the value of the PARALLEL_DEGREE row (and specifying the correct library for the QRYOPTLIB parameter of the CHGQRYA command), the degree of parallelism is unaffected. If I use either the DEGREE parameter of the CHGQRYA command or a SET CURRENT DEGREE statement in SQL, the 3000 record reflects the degree of parallelism I specified. I've read all the material I can find on using the QAQQINI file to control queries, and there doesn't seem to be any trick other than specifying the correct library for the QRYOPTLIB parameter on the CHGQRYA command. Am I missing something?
The system is at V6R1, cumulative PTF TC11256, DB2 group PTF 25.
The system is at V6R1, cumulative PTF TC11256, DB2 group PTF 25.
Jonathan Ball
Jul 18, 2012, 3:23:25 PM7/18/12
to
On Wednesday, July 18, 2012 9:32:51 AM UTC-7, Jonathan Ball wrote:
> I'm trying to control the degree of parallel processing through the PARALLEL_DEGREE row in the QAQQINI file, and it doesn't seem to be working. When I select the 3000 row from a database monitor output file after changing the value of the PARALLEL_DEGREE row (and specifying the correct library for the QRYOPTLIB parameter of the CHGQRYA command), the degree of parallelism is unaffected. If I use either the DEGREE parameter of the CHGQRYA command or a SET CURRENT DEGREE statement in SQL, the 3000 record reflects the degree of parallelism I specified. I've read all the material I can find on using the QAQQINI file to control queries, and there doesn't seem to be any trick other than specifying the correct library for the QRYOPTLIB parameter on the CHGQRYA command. Am I missing something?
> I'm trying to control the degree of parallel processing through the PARALLEL_DEGREE row in the QAQQINI file, and it doesn't seem to be working. When I select the 3000 row from a database monitor output file after changing the value of the PARALLEL_DEGREE row (and specifying the correct library for the QRYOPTLIB parameter of the CHGQRYA command), the degree of parallelism is unaffected. If I use either the DEGREE parameter of the CHGQRYA command or a SET CURRENT DEGREE statement in SQL, the 3000 record reflects the degree of parallelism I specified. I've read all the material I can find on using the QAQQINI file to control queries, and there doesn't seem to be any trick other than specifying the correct library for the QRYOPTLIB parameter on the CHGQRYA command. Am I missing something?
>
> The system is at V6R1, cumulative PTF TC11256, DB2 group PTF 25.
<sheepish grin> I figured it out. The IBM i Navigator SQL script window (CWBUNDBS) couldn't get a lock on the QAQQINI table, because another session I used to change the PARALLEL_DEGREE row had a lock on the table. Once I ended the other session, the one I wanted to test was able to obtain the necessary lock on QAQQINI and the degree of parallelism was set correctly.
> The system is at V6R1, cumulative PTF TC11256, DB2 group PTF 25.
0 new messages