Re: QDBSRV jobs

[ywexler@xxxxxxx]

Carl Galgano wrote:
> 
> 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
> +---

Carl,
Theese jobs are run by the DB server of the AS/400 and usually they
rebuild access paths. There are some events when the system rebuilds
ap's unattended. Example files with access path rebuild or after failure
and keyed files where opened during the failure the system rebuild their
ap's at or after IPL or at the first open of them.
Alsu, using the command: EDTRBDAP you can send to work ap's rebuilding
and this is done by the jobs you mentioned.

Joseph Wechsler,
Bell'arte systems
+---
| 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
+---