× 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.




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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.