Error on DSPLOG command.

105 pts.
Tags:
AS/400
QHST
I'll delete same records from QHST* last file (UPDDTA) and now when I run comand DSPLOG and hold 'Page Down' key the commend end with error.

Cancel reply received for message CPF5006.                                File QHST10**** was already closed, never opened or not from this process. Function check. CPF5104 unmonitored by QMHLDISP at statement *N,  instruction X'0289'.                                                   

Help me. 



Software/Hardware used:
AS/400, V4R5
ASKED: March 19, 2010  12:41 PM
UPDATED: March 23, 2010  4:52 PM

Answer Wiki

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

Well, yeah. No records should <i>ever</i> be deleted from system files.

System files should never be opened except by the system, through functions that are provided for those files. For QHST*, a provided function is DSPLOG.

When system files are opened for update, update locks are established that can interfere with the system’s ability to perform its own functions.

If no actual updates were done, then the best action to take is ending your job and starting a fresh session. If that doesn’t clear the problem or if it shows a new problem, the next step that I’d take would be RCLSTG SELECT(*DBXREF).

Even if the DB xref isn’t out of sync, the act of going to restricted state and coming back up might clear the condition. And if that isn’t enough, then an IPL would be next.

It’s possible that that QHST* file is not in a proper state. Rows might not have appropriate values. It might be necessary to generate a new QHST* file to get past the problem.

Tom

Discuss This Question: 7  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
  • YMjK5oDo
    I wont say I have already deleted records.
    105 pointsBadges:
    report
  • WoodEngineer
    We use ASNA for some special applications in our shop. This software generates tons of messages that just record that the job started and ended, It really cluttered up QHST with thousands of messages every day which had no value. We wanted to get rid of those messages. We discovered that as long as we did not delete the first and last record in QHST files everything continued to work just fine.
    6,065 pointsBadges:
    report
  • TomLiotta
    ...as long as we did not delete the first and last record in QHST files... First/last "record"? ...or "message"? Nearly all messages that are converted to the QHST* file formats take four or more records. Did you process the currently active QHST* file or the older ones as they were generated? Were they reorg'd after deletions? (How did you convince auditors that deleting records from the system history log was appropriate?) Any useful info on how this might be safely done could be valuable for others. I've got a couple systems that I might experiment on. Always willing to try things that seem feasible. Tom
    125,585 pointsBadges:
    report
  • YMjK5oDo
    Yes I did. I processed the currently active QHST* file. I am system admin and It was test server. I ran IPL and it opened some new QHST* files, but roll down operation ends by error also till I deleted bad file. Thanks.
    105 pointsBadges:
    report
  • YMjK5oDo
    Where sets size of QHST* files? We have 5000 records on every file.
    105 pointsBadges:
    report
  • WoodEngineer
    Regarding deleting from QHST . . . we only look at inactive QHST* which are *FILE objects. This is why I think of these messages as records.. Never touch the active file. The files are not re-org'ed or modified in any other way than to delete records. The job runs are night. That way we don't delete any records for the current day. Yes, there can be four or more records associated with a given job. My goal was to eliminate the records (msgs) that say the job started and ended. Other records that tell us the job executed remain. Auditors? Few can even spell "IBM i". I've never been asked anything about QHST by any auditors. And, if the were to get really pushy we could just run one of the utility programs which restores deleted records.
    6,065 pointsBadges:
    report
  • WoodEngineer
    Size of QHST* files is controlled by this system value. System is typically delivered with value of 5,000. Display System Value System value . . . . . : QHSTLOGSIZ Description . . . . . : Maximum history log records Number of records . . . . . : 20000 1-10000000, *DAILY
    6,065 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