Archives of the TeradataForum

Message Posted: Fri, 19 Jul 2013 @ 16:21:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Esteemed DBAs,

My company is in the process of migrating from TD 13 to TD 14.

1. Below is the default settings of RSS in the new system. Could you recommend what to turn on?

Version 14 on Linux

     Node Logging Rate=0
     SPMA=Off
     IPMA=Off
     SCPU=Off
     SVPR=Off
     IVPR=Off
     SLDV=Off
     SHST=Off
     SPDSK=Off
     SVDSK=Off
     SAWT=Off
     SPS=Off
     Summarize SPMA=Off
     Summarize IPMA=Off
     Summarize SCPU=Off
     Summarize SVPR=Off
     Summarize IVPR=Off
     Summarize SLDV=Off
     Summarize SHST=Off
     Summarize SPDSK=Off
     Summarize SVDSK=Off
     Summarize SAWT=Off
     Summarize SPS=Off

Below is the current RSS settings. (TD V13 on Windows)

     SPMA=On
     IPMA=Off
     SVPR=On
     IVPR=Off
     SCPU=On
     SLDV=On
     SHST=On
     SVDSK=On
     SPDSK=Off
     SAWT=On
     SPS=On
     Summarize SPMA=Off
     Summarize IPMA=Off
     Summarize SVPR=Off
     Summarize IVPR=Off
     Summarize SCPU=Off
     Summarize SLDV=Off
     Summarize SHST=Off
     Summarize SVDSK=Off
     Summarize SPDSK=Off
     Summarize SAWT=On
     Summarize SPS=Off
     Active SPMA=Off
     Active IPMA=Off
     Active SVPR=Off
     Active IVPR=Off
     Active SCPU=Off
     Active SLDV=Off
     Active SHST=Off
     Active SPDSK=Off
     Active SVDSK=Off
     Active SAWT=Off
     Active SPS=Off

2. V13 has RSS Collection Rate: 60 sec
Node Logging Rate: 600 sec
Vproc Logging Rate: 600 sec

But V14 has Node Logging Rate: 0 sec.

What should be the new rate for Node Logging? What about RSS collection rate and Vproc rate?

Thank you,

James Park
Database Specialist

	<Prev	Next>		<<First	<Prev	Next>	Last>>