Re: recovery of qsys/qadbifld file...

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

Don,

    The best way to fix this is run a RCLSTG.  If you are on V4, all you need to
do is to take the option on RCLSTG to SELECT *DBXREF.

    You see while QADBIFLD has a hugh number of deleted records, it cant be
reorganized, because QDBSRVXR & QDBSRVXR1 jobs have locks on the file.  So the
only way to get around this is to do a ENDSBS *ALL, and then run the RCLSTG as
noted above. If they are on a CISC version, you can also bring the system to a
restricted state and call the program QDBRCLXR.

    If you need more info, call me.

    Pete Massiello

Don wrote:

> Got a call this week from someone that tried to rgzpfm qsys/qadbifld.
> During the process there was a failure that caused them concern that this
> file had been damaged, and indeed there were system log records denoting a
> damaged object.  However, the log of the rgz looks clean.
>
> My questions are:  what is the job QDBSRVXR and how does it relate to
> this file?  And were qadbifld to be totally trashed and there not being a
> current save, what's the best recovery path?
>
> TIA
>
> DR2
>
> +---
> | 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
> +---

--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.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
+---