DBC.ACCTG

Database

DBC.ACCTG

I have a question on the dbc table 'acctg'.

The 3 Columns found below are from the table DBC.ACCTG.

1) Could anyone explain me the significance and difference of the columns 'CpuTime' & 'CpuTimeNorm'. Also what is the factor used for measure on these 2 columns.Is it a 'Second'?

2) 'DiskIO' - I can understand the use of this.But again how is this measured.

Regards,

Manoj
Tags (1)
1 REPLY

Re: DBC.ACCTG

CpuTimeNorm is the normalized time of the CPU which considers the NNF of the Node of your Teradata system.

CpuTime is approximately equal to CpuTimeNorm / (ResUsage.NodeNormFactor/100)
Units in Teradata performance tables is generally CentiSecs.