RE: RGZPFM Question

I can say for (almost) sure that changing the system value would have no
effect on the RGZPFM that was running.  It's plausible that the CHGQRYA
command (all of which parameters should have been part of CHGJOB [IMHO])
could have effected it, but the help text gives me no indication.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com



                                                                           
             "Glenn Birnbaum"                                              
             <gbirnba@xxxxxxx>                                             
             Sent by:                                                   To 
             midrange-l-bounce         "Midrange Systems Technical         
             s@xxxxxxxxxxxx            Discussion"                         
                                       <midrange-l@xxxxxxxxxxxx>           
                                                                        cc 
             12/28/2004 07:55                                              
             PM                                                    Subject 
                                       RE: RGZPFM Question                 
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




Mike - did you consider changing the sysval QQRYDEGREE (parallel
processing option) to *NONE.  If the change takes effect immediately
(that's a big IF), then the RQZPFM would only run on one of your 8
processors, but the down side is the reorg would have probably taken
much longer.  Just a thought.....

Glenn Birnbaum
Platform Engineering, REI
253-395-8206
"Get Outside Yourself":  http://www.rei.com


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Sent: Tuesday, December 28, 2004 3:26 PM
To: MIDRANGE-L Listserv
Subject: RGZPFM Question


Folks,



Over the holiday one of our developers deleted 20,000,000 records from a
physical file as they were no longer needed.  This HUGE physical file (
even after 20 M records deleted) has 19 logicals built over it.  On
Sunday morning, a scheduled job ran (which was not planned), that did a
RGZPFM over this mess.  The end result was that it put an 870 8-Way
running SMP on it's
knees for 13 hours.   No matter what I tried, I could not get the
IDX-<access path name> running under QDBSRVxx jobs to ease up.



I did find the following Knowledge Base document (after the fact):



http://www-912.ibm.com/s_dir/slkbase.NSF/ce197905697c4c6086256a4f007978f
7/17
bb5f5d63273150862565c2007ce9e5?OpenDocument



Now for my $64 K questions:  Had I used the EDTRBDAP command, could I
have
put the active access path rebuilds on hold?   Would the active IDX
entries
have to have completed before the *HLD entries would have taken effect?
I
am trying to understand how I could have got this under control in the
least amount of time.



Any and all comment appreciated.  Thanks!



Mike Shaw


--
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.