Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people have no idea about how to deal with the state of informix CKPT REQ. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

A database is like this. At that time, the log was full and others saw that the server could not be restarted directly. Now the server has been in CKPT REQ state since it was started.

Prompt that the log needs to be backed up, but I can't back up my onbar.

Modify the cfg file to change / dev/nst0 to / dev/null and use ontape-s-L 0 to back up.

Onparams-a-d llogdbs-s 10000-I does not add a log.

Onmode-ky won't shut down!

Database version: IBM Informix Dynamic Server Version 11.50.FC5

Log hint:

09:54:19 Logical Log Files are Full-Backup is Needed

You can't even switch to single-user backup! Onmode-u didn't respond for a long time!

How to handle it!

Modify the cfg file, change / dev/nst0 to the actual file, for example: / backup/test, and then back up the log with ontape-a!

After reading the above, have you mastered how to handle the state of informix CKPT REQ? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.