RE: Damaged system cross reference file...

We ran RCLSTG DBXRF on our 50S six months ago. I don't think it took more
than 1/2 an hour (memory is a little foggy on this)




-----Original Message-----
From:   owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]
On Behalf Of Graap, Ken
Sent:   Thursday, January 27, 2000 2:00 PM
To:     'Midrange'
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
+---