× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: QDBSRVxx Job Hogging the CPU
  • From: "Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>
  • Date: Sat, 31 Jan 98 00:14:07 +1100



Have you considered saving the access paths to reduce the CPU used during the 
restore?
If you save the access paths the indices will generally not need to be rebuilt. 
 There are certain 
situations where the access paths will be rebuilt even if they were saved 
e.g.,the logical has 
MAINT(*REBLD) specified, or when the logical files are in different libraries 
from the based-on 
physical files.  The Backup and Recovery Guide has more information on the 
specifics.

You can also use the EDTRBDAP (Edit Rebuild Access Path) command to manage 
access path builds.

Regards,
Simon Coulter.

//----------------------------------------------------------
// FlyByNight Software
// AS/400 Technical Specialists
// Phone: +61 3 9419 0175
// Fax:   +61 3 9419 0175
// Mob:   +61 3 0411 091 400
// Email: shc@flybynight.com.au
//--- forwarded letter -------------------------------------------------------
> X-Mailer: Internet Mail Service (5.0.1458.49)
> Date: Thu, 29 Jan 98 08:30:27 -0700
> From: "Sannan Solberg" <SSolberg@Washcorp.com>
> To: "'MIDRANGE-L@Midrange.com'" <MIDRANGE-L@Midrange.com>
> Reply-To: MIDRANGE-L@Midrange.com
> Subject: QDBSRVxx Job Hogging the CPU

> 
> 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.
> 
> 
> **************************************************
> Sannan Solberg                               (406)523-1392
> Business/Programmer Analyst        (406)523-1636  fax
> Washington Corporations               ssolberg@washcorp.com
> 
 

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.