Archives of the TeradataForum
Message Posted: Thu, 14 Apr 2005 @ 16:16:06 GMT
| Subj: | | Re: Why UPI on DBC.Acctg? |
| |
| From: | | Dieter Noeth |
Ulrich Arndt wrote:
| | can someone explain why the table DBC.Acctg is showing an UPI on AccountName ,UserName but has to be a NUPI as only VPROC will make it
unique? | |
It's one of the special dbc tables, which are *not* distributed by hash:
dbc.tvm.HashFlag = 'N'
Those tables are AMP-local (similar to a NUSI subtable), so it's unique on each AMP :-)
sel * from dbc.tables
where tablekind = 't'
and databasename = 'dbc'
and protectiontype = 'n'
Acctg
ChangedRowJournal
DataBaseSpace
DataBaseSpace_V2R5
LocalSessionStatusTable
LocalTransactionStatusTable
OrdSysChngTable
RecoveryLockTable
RecoveryPJTable
SavedTransactionStatusTable
SysRcvStatJournal
TransientJournal
UtilityLockJournalTable
| | A create table DBt_poweruser_uarndt.Acctg as DBC.Acctg with data; fails for this reason. | |
;-)
You can't create a non-hashed table, so just add VProc to the PI.
Dieter
| 
