15.00 - 3869 A system journal table cannot be accessed via Teradata SQL. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3869 A system journal table cannot be accessed via Teradata SQL.

Explanation:

There are 10 system journal tables: DBC.TransientJournal ChangedRowJournal LocalTransactionStatusTable UtilityLockJournalTable LocalSessionStatusTable SysRcvStatJournal SavedTransactionStatusTable OrdSysChngTable RecoveryLockTable RecoveryPJTable and 1 DBC table: DBC.ALL These system journal tables and DBC.ALL are different from regular tables and they are for internal processing only. They cannot be accessed via Teradata SQL.

Generated By:

RES modules.

For Whom:

The DBA and System Support Representative.

Remedy:

None.