AS/400 QADBIFLD error Duplicate Record Key?

20 pts.
Tags:
AS/400 error messages
AS/400 errors
Database Cross-Reference 2
Duplicate records
IPL
QADBIFLD
QDBSRVXR2
V5R2
The AS400 job QDBSRVXR2 has system error message Duplicate Record in QADBIFLD. I am aware this is a system cross reference file. (System is doing an automatic reply of C and then tries again) Is this file now corrupt ? Would an IPL help ? Reclaim Storage ? What is causing this error. (System is legacy no development tools and is at V5R2.) HELP

Answer Wiki

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

You can do a RCLSTG SELECT(*DBXREF). What this does is a reclaim of the DB cross reference files only and runs faster than doing a RCLSTG SELECT(*ALL) which touches every library on the system. We had to do this once when the cross reference got hosed up.

As always, the system needs to be in dedicated mode to do this.

Discuss This Question: 1  Reply

 
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
  • Rockgirl
    Thank you very much for this information. As the System needs to be in restricted state to run this command - any idea how long this might take to run the AS400 is a only a model small 170 with less than 100 files at a guess.
    20 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