Re: QDBSRV jobs

[Carl Galgano <cgalgano@xxxxxxxxxxxxxxxxx>]

Thanks to all that responded to my post.  After i posted I did some
research and found out exactly what you guys said.  Some files had been
restored and it was building the access paths for those files.
As usual, midrange-L comes through.... THANKS!
Carl

At 09:03 AM 4/23/98 +0300, you wrote:
>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
>+---
>
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
+---