troubleshooting Question

AS400, Inserted records lost on unexpected power outage

Avatar of kps_ee
kps_ee asked on
IBM System i
5 Comments1 Solution376 ViewsLast Modified:
AS400. One of my clients experiences a very strange problem. When he has a power outage and the system closes without warning, inserted records  to the database are not there on next system start up. The tables in question are not journaled.
For example he inserts records in the morning and sees them; the system stops due to power loss at night and the next morning some of the inserted records are missing! I guess the new records reside in some temporary space and that is why they are lost. Is there a db command to make the changes permanent or something?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros