Transient Journal

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.

Transient Journal

Rate Topic

Display Mode

Topic Options

Author

Message

Job_Agent

Posted 5/5/2008 12:45:33 PM

Supreme Being

Group: Forum Members
Last Login: 7/22/2008 10:25:42 AM
Posts: 114, Visits: 61

is there any database parameter which can stop automatic transient journal in version V2R6.2

Post #11363

Posted 5/5/2008 1:41:38 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 1:24:11 PM
Posts: 76, Visits: 144

I believe transient journal is always in effect in order to maintain data integrity during transactions.

-SN

Post #11364

Job_Agent

Posted 5/6/2008 1:56:18 AM

Supreme Being

Group: Forum Members
Last Login: 7/22/2008 10:25:42 AM
Posts: 114, Visits: 61

request your replies

Post #11371

dnoeth

Posted 5/9/2008 7:52:35 AM

Supreme Being

Group: Forum Members
Last Login: 6/25/2008 7:26:06 AM
Posts: 474, Visits: 202

It will not help you, if you repeat your request for replies, the answer is still the same:
You can't switch off the TS on a database level, because of possible rollbacks.

Only Volatile and Global Temporary tables support a "NO LOG" option.

Dieter

Post #11405

« 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 7:29pm