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: I have hundreds of tables in my production database. How can I tell which ones are journalled without having to run help table on each of them?

April 26, 2017all q database hundreds ingres OS production tables version

0

Posted

Ingres Version: All OS: All Q: I have hundreds of tables in my production database. How can I tell which ones are journalled without having to run help table on each of them?

1 Answer

0

Posted

Check the ‘is_journalled’ column of iitables. For each table, is_journalled will have one of three values – ‘Y’ if it’s journalled, ‘N’ if it is not, and ‘C’ if it will be journalled on the next checkpoint.