Link to home
Start Free TrialLog in
Avatar of Mohammed Atieh
Mohammed Atieh

asked on

DB2 AS/400 7.1.0

Dear
There is any way to find a reason if insert record into database file not successfully inserted in journal

Thanks
Avatar of Member_2_276102
Member_2_276102

A journal captures successful changes to the database. It doesn't track actions that failed to make changes. The joblogs of jobs that encounter errors should show errors if the jobs don't provide any other method of logging them (and they don't suppress error messages).
Avatar of Mohammed Atieh

ASKER

Thanks for your replying, The error message from last 3 month do you think there is any chance to find the errors message from the jobllog if i have qhost file in previous monthly backup
ASKER CERTIFIED SOLUTION
Avatar of Member_2_276102
Member_2_276102

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Do you know the exact INSERT that seems to have failed? If not, how much of it do you know?

If a journal is available, it might be possible to work out what happened.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial