Monday, July 25, 2016

Enabling System level resource logging in Teradata



This can be done from cnsterm terminal, follow the steps below.

CVS_1-8:~ # cnsterm 6
Attempting to connect to CNS...Completed.
Hello

Input Supervisor Command:
start qrysessn

Started 'qrysessn' in window 1
 at Sat May 11 06:53:04 2013


Input Supervisor Command:
start qrysessn

Started 'qrysessn' in window 2
 at Sat May 11 06:53:04 2013


Input Supervisor Command:
start showlocks

Started 'showlocks' in window 1
 at Sat May 11 06:53:08 2013

Input Supervisor Command:
> get logtable all
get logtable all

spma table's logging is disabled
ipma table's logging is enabled
svpr table's logging is enabled
ivpr table's logging is disabled
scpu table's logging is enabled
sldv table's logging is enabled
spdsk table's logging is enabled
svdsk table's logging is enabled
sawt table's logging is enabled
sps table's logging is enabled
shst table's logging is enabled

Input Supervisor Command:
> set logtable spma on
set logtable spma on


Input Supervisor Command:
> get logtable all
get logtable all

spma table's logging is enabled
ipma table's logging is enabled
svpr table's logging is enabled
ivpr table's logging is disabled
scpu table's logging is enabled
sldv table's logging is enabled
spdsk table's logging is enabled
svdsk table's logging is enabled
sawt table's logging is enabled
sps table's logging is enabled
shst table's logging is enabled

Input Supervisor Command:
> set logtable ivpr on
set logtable ivpr on


Input Supervisor Command:
> get logtable all
get logtable all

spma table's logging is enabled
ipma table's logging is enabled
svpr table's logging is enabled
ivpr table's logging is enabled
scpu table's logging is enabled
sldv table's logging is enabled
spdsk table's logging is enabled
svdsk table's logging is enabled
sawt table's logging is enabled
sps table's logging is enabled
shst table's logging is enabled

Input Supervisor Command:


No comments:

Post a Comment