Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Ingres Version: All OS: All Q: When I define the same location for checkpoint, journal and dump files Ingres gives a warning message. Is it legal to use the same location for these file types ?

April 26, 2017all q Checkpoint define dump files ingres location OS version

0

Posted

Ingres Version: All OS: All Q: When I define the same location for checkpoint, journal and dump files Ingres gives a warning message. Is it legal to use the same location for these file types ?

1 Answer

0

Posted

You can store the data, checkpoint, journal, dump, and work files for a database in the same locations or in different locations. If the default locations are used when you create the database, these files are all stored in the same area. It is strongly recommended that you store data files on a different disk from those used to store checkpoints, journals, and dumps. Doing so helps to protect your data in the event of disk failure. This will also allow for maximum performance from the disk drives.