Re: RPG SQL and multi-threading

[darren@xxxxxxxxx]

Is the PARALLEL_DEGREE parameter in file QAQQINI sufficient to control this
problem?  This setting may refer to system value QQRYDEGREE depending on
how its set.



                                                                           
             "Steve R."                                                    
             <sriedmue@xxxxxxx                                             
             om>                                                        To 
             Sent by:                  midrange-l@xxxxxxxxxxxx             
             midrange-l-bounce                                          cc 
             s@xxxxxxxxxxxx                                                
                                                                   Subject 
                                       RPG SQL and multi-threading         
             03/28/2008 11:58                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




Greetings all.  I have recently discovered that executing an RPG/SQL
program
causes a job to become multi-threaded.  Even when the SQL has finished, the

additional thread(s) remain in the job.  This is going to cause us a
problem
with Lansa jobs which cannot be allowed to become multi-threaded, or chaos
death and destruction will ensue.

Does anyone know if the additional thread(s) can be cleaned up?  Or any
other way to avoid this problem?  We are reluctant to use a SBMJOB to
execute the RPG/SQL outside of the running job.

Thanks in advance for any assistance.  See you at COMMON. :)

Steve


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.