Re: CPF327E restoring SQL file

If you are on V4Rx, you can prompt the RCLSTG command, and enter Y for 
Reorganize
System Cross Reference, and enter N for Reclaim Storage.  If your version of 
OS/400
is below V4, there is a program in QSYS that you can call (dont remember the 
name
off hand), but if you need it, I can find it out.

    Pete Massiello

Jeff Carey wrote:

> While trying to restore a file created as a result of SQL, we got this 
>message:
>
> Message ID . . . . . . :   CPF327E
> Message . . . . :   Alternative name for file PKGLI00005 not allowed.
> Cause . . . . . :   An attempt was made to create, move, or change database
>   file PKGLI00005 with alternative name PKGLIMITEDOPTS into library
>   PKGDFNMTIA.  However, the operation was not done for reason code 3.  The
>   reason codes are:
>   3 - The alternative name could not be verified as a duplicate of other
> file's alternative names in library PKGDFNMTIA because of problems with the
> system cross reference files.
> Recovery  . . . :   Do the following for the specified reason code:
>    3 - Try the operation again.  If the operation fails again with this
>  message and reason code, run reclaim storage (RCLSTG command) to update the
>  system cross reference files.
>
> First, can we rebuild the files without a full blown RCLSTG?
>
> Second, how does the error occur?
>
> +---
> | 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
+---