Access path for member SYSIXADVIX not built.

1780 pts.
Tags:
AS/400
AS/400 Access Paths
Keep getting this erro. Anyone know what it is and how to fix it? Message ID . . . . . . : CPF3146 Severity . . . . . . . : 40 Message type . . . . . : Information Date sent . . . . . . : 04/15/09 Time sent . . . . . . : 08:33:53 Message . . . . : Access path for member SYSIXADVIX not built. Cause . . . . . : The access path for member SYSIXADVIX file SYSIXADVIX in library QSYS2 was not built for one of the following reasons: -- A failure occurred during the automatic build operation. -- A failure occurred during the build operation when member *N file *N in library *N was being organized (RGZPFM command). -- A failure occurred during the build operation for a copy to member *N file *N in *N. Recovery . . . : Try to open the member. If the open fails, and if the file is a physical file, specify a value of 1 on the FROMRCD parameter on the CPYF command to copy the data to another member. Remove the original member (RMVM command), add the original member again (ADDPFM command), and then

Answer Wiki

Thanks. We'll let you know when a new response is added.

By the way…this is an IBM file so I want to make sure what the problem is before I do anything exciting.
THanks

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Gilly400
    Hi, 1. What are you doing when you get this error? 2. Can you access the physical file? Is it in use by other tasks? 3. Which version of the OS are you using and are you up to date with PTF's? Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • RonKoontz
    I have no idea what its doing with this file. I can access it V5R4.. 3 years behind on PTF's. Should be here soon. This error just started happening this week.
    1,780 pointsBadges:
    report
  • Smurali86
    Hi, when did u get this error? If it is a LF, make sure that theLF and the PF are in the same library.
    25 pointsBadges:
    report
  • RonKoontz
    I got with IBM.. They said to delete it then run this SQL statement... CREATE UNIQUE INDEX QSYS2.SYSIXADVIX ON QSYS2.SYSIXADV (LEADING_COLUMN_KEYS ASC, KEY_COLUMNS_ADVISED ASC, TABLE_NAME ASC, TABLE_SCHEMA ASC, INDEX_TYPE ASC, NLSS_TABLE_NAME ASC, NLSS_TABLE_SCHEMA ASC, PARTITION_NAME ASC) So far it seemed to work. The file got corrupted b/c our power supply went out and system went down hard last friday. Thanks for your help...
    1,780 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following