Re: AS/400 FRONT PANEL KEYS CONFIGURATION

Good stuff Stefan.  Thanks a lot.

Dare

----- Original Message -----
From: <Stefan.Tageson@notes.sema.se>
To: <MIDRANGE-L@midrange.com>
Sent: Monday, April 03, 2000 2:23 PM
Subject: Re: AS/400 FRONT PANEL KEYS CONFIGURATION


>
> According to a AS/400 Support Line Technical Document:
>
> QDBSRVXR - This job maintains each of the system cross-reference files in
> QSYS with the exception of the field cross-reference file. These files
> contain cross-reference information about data base files and SQL
> information across the system. The files all begin with the name of QADB
in
> library QSYS. The primary file that must be maintained is QADBXREF. This
> file is the file cross-reference file. It contains a record for each
> physical and logical file on the system. Create, change, or delete of any
> file will cause the QDBSRVXR job to become active.
>
> QDBSRVXR2 - This job maintains the only system cross-reference file that
is
> not maintained by QDBSRVXR, the field cross-reference file. This file is
> QADBIFLD in library QSYS. This file contains a record for every field of
> every physical and logical file on the system. Create, change, or delete
of
> any file causes the QDBSRVXR job to become active.
>
> QDBSRV01 - This job can be viewed as the database maintenance task
> dispatcher. Typically, it will be the most active immediately following
the
> restore of a library that contains database files. It's function includes:
>
>  o Signalling to the SMAPP (System Managed Access Path Protection) LIC
>    tasks that new access paths have been restored. SMAPP will then
>    determine whether these access paths need to be protected.
>
>  o Sending data queue entries to the QDBSRVXR job of new database files
>    that were restored.
>
>  o Sending data queue entries to the QDBSRVXR2 job of new database file
>    fields that were restored.
>
>  o Preparing the list of access paths that are required to be rebuilt
>    because the access paths were not restored. This is the list that is
>    viewed via the EDTRBDAP command.
>
>
>
> QDBSRV02-03 - These two jobs perform access path maintenance on system
> files. Typically, the jobs are inactive.
>
> QDBSRV04-05 - These two jobs perform access path maintenance on user data
> files. Typically, these jobs are inactive. However, in certain cases,
these
> jobs will be active performing access path rebuilds. The access paths that
> are being maintained can be viewed via the EDTRBDAP command. Some reasons
> why these jobs could be active are:
>
>  o Restore of database files that were not saved with access paths.
>
>  o Restore of logical files that are in the same library as the physical
>    file they are based upon.
>
>  o Cancelling of a RGZPFM command while in process.
>
>  o Invalidation of an index due to damage found upon it.
>
>
>
> QDBSRV06-09 - On systems with additional processors, additional system
jobs
> are started to allow for additional concurrent access path rebuilds. These
> jobs perform the same tasks as QDBSRV04-05.
>
> Regards
> // Stefan
>
>
>
>
>
>                     "oludare"
>                     <oludare@ix.netcom.        To:
<MIDRANGE-L@midrange.com>
>                     com>                       cc:     "Mike Thomas"
<mthomas@bofasecurities.com>
>                     Sent by:                   Subject:     Re: AS/400
FRONT PANEL KEYS CONFIGURATION
>                     owner-midrange-l@mi
>                     drange.com
>
>
>                     2000-04-03 19:37
>                     Please respond to
>                     MIDRANGE-L
>
>
>
>
>
>
> >The access paths are being built file in recovery by these jobs:
> >QDBSRV04
> >QDBSRV05
> >I also notice that there are more of these jobs on the system but they
are
> >not actively doing anything.  These are the list:
> >QDBSRVXR
> >QDBSRVXR2
> >QDBSRV01
> >QDBSRV02
> >QDBSRV03
> >Anyone with knowledge why some are active while the rest are dormant?
>
> >Thanks
>
>
>
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@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
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---