Home > IT Answers > AS/400 > AS/400 QADBIFLD error Duplicate Record Key?
Rockgirl
20 pts.
 AS/400 QADBIFLD error Duplicate Record Key?
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

Software/Hardware used:
ASKED: January 31, 2009  11:56 AM
UPDATED: February 3, 2009  2:39 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  February 2, 2009  5:33 pm  by  WaltZ400   645 pts.
All Answer Wiki Contributors:  WaltZ400   645 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Rockgirl
 20 pts.