• Subject: Re: Damaged system cross reference file...
  • From: Rob Berendt <rob@xxxxxxxxx>
  • Date: Thu, 27 Jan 2000 14:58:11 -0500

We run RCLSTG's on all of our 400's every 8 weeks.  Except one.  
It took about 10 hours the last time.  However a RCLSTG(*DBXREF) 
takes only about 20 minutes.




keg@exchange.gasco.com on 01/27/2000 02:33:33 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     midrange-l@midrange.com@Internet
cc:      
Fax to: 
Subject:        Damaged system cross reference file...

 While I  was running a TAATOOL process (CHKDBD) which analyzes physical
files with dependant logical files in different libraries,
 I encountered the following error:

 CPF32BE Escape 40 01/26/00 16:05:44 QDBEXTWU  QSYS   0374  QWHDSDBR QSYS
0145
    Message . :   An error occurred while accessing a system cross reference

                  file.

                  Cause . . . . . :   An attempt was made to retrieve
referential
                  constraint dependent file information for file SYSPARMS in
library
                  QSYS2 for member *N. However, the operation was not done
for reason
                  code 1. See the low level messages previously listed to
locate the
                  cause.  The reason codes are: 1 - While accessing
information from
                  the system cross reference file, an error occurred in the
cross
                  reference file. 2 - The information from the system cross
reference
                  file could not be retrieved. Recovery  . . . :   Do the
following
                  for the specified reason code: 1 - Reclaim storage (RCLSTG
command)
                  to update the system cross reference files, and try the
request 
                  again at a later time. 2 - IPL the machine to correct the
error.

This error is indicating that I need to update the system cross reference
files.... 

I'm assuming I could run RCLSTG SELECT(*DBXREF). I have never run just a
DBXREF reclaim storage before.

I know that a full reclaim can take hours. I don't want to get started down
this road and then have to inform my users that the 
system will be down for hours. Does anyone know how long a DBXREF reclaim
storage might run?

I have a Model 530 4 way with 4GB of memory and around 450GB of disk 70%
full. 


Kenneth

****************************************
Kenneth E. Graap
IBM Certified Specialist
AS/400 Professional
Network Administrator
NW Natural (Gas Services)
keg@nwnatural.com
Phone: 503-226-4211 x5537
FAX:    603-849-0591
****************************************


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

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-2019 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].