CRMIOS Tables and Journaling

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

CRMIOS Tables and Journaling

Rate Topic

Display Mode

Topic Options

Author

Message

Robby

Posted 4/11/2007 3:46:23 PM

Forum Newbie

Group: Forum Members
Last Login: 6/19/2007 3:04:00 PM
Posts: 3, Visits: 1

The DBA's would like to turn off Fallback and Journaling on tables in the CRMIOS Database. Specifically, IOS_ECAMP*, IOS_SCHD*, IOS_TBL* as well as others.

Since I came into this job when CRM was already up and going, I am assuming that these are system tables and they shipped as-is with Journaling turned on.

Is there a problem with letting the DBAs turnoff the Journaling on the CRM IOS tables?

Post #7093

cgard

Posted 4/12/2007 11:44:21 PM

Forum Newbie

Group: Forum Members
Last Login: 4/12/2007 11:43:00 PM
Posts: 7, Visits: 1

What is your DBA's reasoning for during Fallback and Journaling off?

Post #7106

jrs

Posted 3/25/2008 11:10:11 AM

Forum Newbie

Group: Forum Members
Last Login: 4/17/2008 10:34:12 AM
Posts: 3, Visits: 7

My DBAs asked the same question. After studying the space consumed for the tables that had the default FALLBACK and JOURNAL entries, the number of rows and actual space used was considered to be trivial.

Post #11025

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 6:54pm