RE: [sqr-users] Kicking of Sqr procedures..

["Bob Stone" <bstone@fastenal.com>]

If you're looking to do something parallel you can set it up pretty
easily in SQR - it's just multiple instances of the same SQR as everyone
else says.  But you would break down your sections of program into their
own SQR to do that parallel section.

One thing we've done before to get things to process in parallel is run
a sort of 'preprogram' to set up a run control, and then kick off
multiple of the 'parallel-program' for each of the run controls the
preprogram set up for.  In our case it's batch processing, so we know
the entire list of what needs to be processed.

Lets say that I need a program to do a bunch of things by business unit
in program X, and I have 450 business units to run for.  In the program
I would be looping 1 by 1 through BU, maybe taking 1 minute per BU.  To
use parallel processing to increase throughput, I would add 'business
unit' to a scroll at the run control, such that a 'run for all' would
have 450 rows in a child table to psprcsruncntl.

My preprogram would run, and knowing I want to create 5 parallel
processes it could populate the first run control with the first 100 BUs
in the scroll (insert directly to that child table), the second run
control with the second 100 BUs, ...etc....leaving 50 BUs for the final
run control.

We have an outside program that would actually kick off those 5 parallel
processes at the same time - but you could even have the SQR loop on the
'call system using' with an SQR command to run program X by each newly
created run control.  

The key is to ensure that the data your program touches in the tables is
somehow distinct and not-overlapping.  Otherwise a table in the first
instance will lock out the other 4 instances until it commits, and you
may as well have run it one at a time.  If your section can't run
parallel with other sections, then it wouldn't make sense to split it
up.

bob


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Knapp, Richard
Sent: Thursday, April 12, 2007 4:27 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Kicking of Sqr procedures..


SQR is a 'procedural' language.  Usually this means one step at a time.
As someone has already mentioned you can spawn both processes without
waits.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street  #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Thursday, April 12, 2007 4:17 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Kicking of Sqr procedures..

There is no specific reason for this..Jus wanted to know if its possible
or not.

-----Original Message-----
From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org
[mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org]On
Behalf Of Arun Kumar
Sent: Thursday, April 12, 2007 5:02 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] Kicking of Sqr procedures..


No. Could you explain why you want to do this? Just curious on the
design.



----- Original Message ----
From: "Vaidyanathan, Ramakrishnan (GE, Corporate, consultant)"
<ramakrishnan.vaidyanathan@ge.com>
To: sqr-users@sqrug.org
Sent: Thursday, April 12, 2007 4:27:45 PM
Subject: [sqr-users] Kicking of Sqr procedures..

Hi All,

    I have 2 procedures in a sqr. I want to kick both of the procedures
parallely at the same time. For eg. I have A and B as 2 procedures. I
want to kick off A and B procedures parallely.Once I kick off procedure
A, it shouldn't wait for its completion. I should be able to kick off B
simultaneously. Is it possible to achieve this?

Thanks
Ram

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users







       
________________________________________________________________________
____________
Looking for earth-friendly autos? 
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos.yahoo.com/green_center/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users