Re: QDBSRV jobs

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Carl,

These are database server system jobs which are responsible for rebuilding 
access paths.  Usually caused by 
doing a restore without having saved the access paths but there are other 
causes.

QDBSRV01 is an event handler and passes the work off to the other QDBSRVxx jobs.

QDBSRV01 runs at priority 9 (because it needs to get the event notification 
quickly), the others run at 
priority 52 to do the rebuild.  Under normal circumstances they shouldn't 
affect your system noticably 
(although they will use CPU) but occasionally the priority 9 job has a problem 
with lot's of events and locks 
and can kill the system.

You will find a small amount of documentation on all the system jobs in the 
Work Management Guide in Chapter 
13.

Regards,
Simon Coulter.

//----------------------------------------------------------
// FlyByNight Software         AS/400 Technical Specialists
// Phone: +61 3 9419 0175      Mobile: +61 3 0411 091 400
// Fax:   +61 3 9419 0175      E-mail: shc@flybynight.com.au
// 
// Windoze should not be open at Warp speed.
 
//--- forwarded letter -------------------------------------------------------
> X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.2 (32)
> Date: Tue, 21 Apr 98 17:40:15 -0400
> From: "Carl Galgano" <cgalgano@ediconsulting.com>
> To: MIDRANGE-L@midrange.com
> Reply-To: MIDRANGE-L@midrange.com
> Subject: QDBSRV jobs

> 
> A client called me today with something I have never seen.
> 
> They had several jobs running on their AS400 called QDBSRVxxxxx (where
> xxxxx is a sequence number).  Each job showed that it was building and
> index (-IDX) and really hogging up the system.  The users reported no
> problems with the system, it has not gone down and I searched the QHST log
> and found nothing unusual before and around the time the jobs started running.
> 
> Any ideas here, what are these jobs and what started them running?
> 
> TIA
> Carl
> 
> Carl J. Galgano
> http://cgalgano.home.mindspring.com
> mailto:cgalgano@ediconsulting.com
> EDI Consulting Services, Inc. 
> 540 Powder Springs Street
> Suite C19
> Marietta, GA 30064
> 770-422-2995

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