|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
Hi
I would like to know about Permanent Journals in Teradata.
How to define Permanent Journal tables ? Where are they stored?
How to drop it?
Thanks
Giri
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/12/2009 6:03:17 PM
Posts: 177,
Visits: 64
|
|
The purpose of a permanent journal is to maintain a sequential history of all changes made to the rows of one or more tables. Permanent journals help protect user data when users commit, uncommit or abort transactions. A permanent journal can capture a snapshot of rows before a change, after a change, or both. You use permanent journaling to protect data. Unlike the automatic journal, the contents of a permanent journal remain until you drop them. When you create a new journal table, you can use several options to control the type of information to be captured.
You create permanent journals when you create a user or database. To create permanent journals within an existing user or database, use the MODIFY statement. Users activate permanent journaling by including the JOURNAL option in the CREATE or MODIFY statements for users or databases. You must allocate sufficient permanent space to a database or user that will contain permanent journals. If a database or user that contains a permanent journal runs out of space, all table updates that write to that journal abort.
Use the MODIFY USER or MODIFY DATABASE statement to delete a permanent journal. Before you delete the journal, you must use the ALTER TABLE statement to stop the journaling being done to that journal.
You can find more details in user manuals
Leo Issac "Wants to Learn More!"
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
Thank u,
Leo
Now, I have a clear Idea of Permanent Journals.
Can I use Show Table command to view the Permanent Table ?
Can I define check points from SQL Assistant. Can Multiple Check Points be assigned?
Regards,
Giri.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/12/2009 6:03:17 PM
Posts: 177,
Visits: 64
|
|
giri,
I beleive that Teradata specific command SHOW is used for only Tables/Views/Join Indexes/Hash Indexes/Triggers/Stored Procedure. I hope we cannot show the Journal table definition.Not very sure about it !. I hope there should be someway of doing it. For now, I tried using Teradata Administrator to view the attribute details of Jouranl table. I could get the details successfully.
Regarding the checkpoint, I refered the manuals and I could find the following details. I hope this will be useful
To checkpoint a journal table, you must meet at least one of the following criteria.
• Have CHECKPOINT privilege on the journal table.
• Have CHECKPOINT privilege on the database containing the journal table.
• Be an owner of the database containing the journal table.
• Be an immediate or indirect owner of the journal table.
I thank you for posting these questions. This made me refer few manuals and gather more information on permanent journals.
Leo Issac "Wants to Learn More!"
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717,
Visits: 466
|
|
"I thank you for posting these questions. This made me refer few manuals and gather more information on permanent journals."
Hey, i like that. Sounds so much nicer than "RTFM" ;-)
Dieter
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/12/2009 6:03:17 PM
Posts: 177,
Visits: 64
|
|
Dieter,
Really! Reading The FINE Manual helps. Ofcourse, if one does not have the oppurtunity to refer them, then, I beleive someone else can refer them and share the knowledge.Nothing wrong in that! Dont you think so? ;-)
After all, The very purpose of Forums is knowledge sharing amongst the members . No matter how the members gain /Share the knowledge.
Leo Issac "Wants to Learn More!"
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
Thank U,
I am really having a good time with u. can u share the link or the document for permanent journals.
Giri.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 1/25/2008 3:10:11 PM
Posts: 38,
Visits: 19
|
|
|
I can kind of understand the concept of Journaling for dataBases, but i dont understand Journaling for a user...can someone please explain?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 8:47:37 PM
Posts: 283,
Visits: 989
|
|
Permanent journals provide the ability for the user to execute roll-back or roll-forward operations between user-defined checkpoints.
|
|
|
|