Permanent Journal

Creating Permanent Journal

Create Database Test11 as perm=10e3 DEFAULT JOURNAL TABLE =jtemp111
Modify user Test2 as DEFAULT JOURNAL TABLE =jtemp12

Here JTemp111 is created in the database Test11

Setting Permanent Journals

Permanent Journal can be set at table level or at database level.

a) If a table is created in a database which has a default journal table set, then by default all the journal images of the tables
in the database are maintained in the default journal table of the database.

Create database Test1 as perm=10e3 password= Test1 DEFAULT JOURNAL TABLE =jtemp111

Create table Test1.temp115
, after journal
(
i int,
j int
)

Show table Test1.temp115

CREATE SET TABLE Test1.temp115, NO FALLBACK,
NO BEFORE JOURNAL,
NOT LOCAL AFTER JOURNAL,
WITH JOURNAL TABLE = Test1.jtemp111,
CHECKSUM = DEFAULT
(
i INTEGER,
j INTEGER)
PRIMARY INDEX ( i );


b) When specified explicitly, the journals images can be maintained in a journal table present in different database.


Create table Test1.temp116
, after journal
, with JOURNAL TABLE= Test2. jtemp12
(
i int,
j int
)

Where Test2 database has a permanent journal jtemp12

Dropping Permanent Journal Tables

A journal table can be dropped when no tables point to the journal table.

To stop pointing to journal table

Alter table Test1.temp115, no after journal

When no more tables point to PJ table ,drop it

Modify user Test1 as drop DEFAULT JOURNAL TABLE =jtemp111

All About Teradata Users and passwords

Password Maintenance Commands:


A) To unlock a user

MODIFY USER User1 As RELEASE PASSWORD LOCK;

B) Changing password of a user by a DBA or by user itself:

MODIFY USER Jack1 as Password=Jack1;

c) Assigning a temporary password for a user and prompting the user to enter a new password when logging first time with the password

MODIFY USER Rimmy2 as password=rimmy213 FOR USER;


The password settings of users of Teradata Database system are set in the table in DBC.SyssecDefaults with a single row.

ExpirePassword - After how many days passwords expire
PasswordMinChar - Minimum number of characters that passwords should have
PasswordMaxChar - Maximum number of characters that passwords should have
Password Digits - Are digits allowed in the passwords?
PasswordSpecChar - Are special characters allowed in passwords?
MaxLogonAttempts - Maximum number of times a user is allowed to enter wrong passwords before getting locked
LockedUserExpire - After how many days the locked user will expire
PasswordReuse - After how many days an old password can be reused.