RE: QDBSRVxx Job Hogging the CPU

I also had this PTF. SF26854 for V3R1M0.  APAR SA47856.

If I recall, they reluctantly came out with this for CISC machines.  I
believe their thinking was (and maybe still is) that the RISC processors
have the horsepower to keep these system wide database cross-reference
files in sync without adversely affecting performance.
Tell that to a development shop that restores libraries several times a
day.   I'd still like to see the ability to disable these jobs, with the
ability to start them later if you chose and have them rebuild.  (Well,
the rebuild ability is already there, but not - as far as I know - the
ability to turn it off).


... Neil Palmer                                     AS/400~~~~~      
... NxTrend Technology - Canada     ____________          ___  ~     
... Thornhill, Ontario,  Canada     |OOOOOOOOOO| ________  o|__||=   
... Phone: (905) 731-9000  x238     |__________|_|______|_|______)   
... Cell.: (416) 565-1682  x238      oo      oo   oo  oo   OOOo=o\   
... Fax:   (905) 731-9202         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
... mailto:NPalmer@NxTrend.com          http://www.NxTrend.com


        -----Original Message-----
        From:   John Earl [SMTP:johnearl@lns400.com]
        Sent:   Thursday, January 29, 1998 5:44 PM
        To:     MIDRANGE-L@Midrange.com
        Subject:        Re: QDBSRVxx Job Hogging the CPU

        Sannon,

        At 08:30 AM 1/29/98 -0700, you wrote:
        >We have the occasion to clear and restore fairly large data
libaries
        >with lots of
        >logical files as well.  We often have to do during the day so
as not to
        >interrupt more important things at night.  Once things restore,
a CPU
        >hogging job
        >kicks off, likely rebuilding indexes and such.  At one time, I
knew a
        >command that
        >allowed you to changed the job running priority from 9 (that it
kicks
        >off at) to 
        >something else, say 50 like batch jobs.  I'm quite sure you
can't do it
        >with the
        >regular CHGSYSJOB command.  Anybody got any ideas?? 
        >We are running mostly model 500's on V3R7 if that matters.


        I remember getting a test PTF from IBM's database group on V3R1
for this
        very problem.  I can't remember the PTF number, but you're
right, it can be
        done.

        jte

        --

        John Earl       Lighthouse Software Inc.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---