Value
|
Description
|
AE
|
ALTER EXTERNAL PROCEDURE
|
AF
|
ALTER FUNCTION
|
AP
|
ALTER PROCEDURE
|
AR
|
OVERRIDE RESTORE
|
AS
|
ABORT SESSION
|
CA
|
CREATE AUTHORIZATION
|
CD
|
CREATE DATABASE
|
CE
|
CREATE EXTERNAL PROCEDURE
|
CF
|
CREATE FUNCTION
|
CG
|
CREATE TRIGGER
|
CM
|
CREATE MACRO
|
CO
|
CREATE PROFILE
|
CP
|
CHECKPOINT
|
CR
|
CREATE ROLE
|
CT
|
CREATE TABLE
|
CU
|
CREATE USER
|
CV
|
CREATE VIEW
|
D
|
DELETE
|
DA
|
DROP AUTHORIZATION
|
DD
|
DROP DATABASE
|
DF
|
DROP FUNCTION
|
DG
|
DROP TRIGGER
|
DM
|
DROP MACRO
|
DO
|
DROP PROFILE
|
DP
|
DUMP
|
DR
|
DROP ROLE
|
DT
|
DROP TABLE
|
DU
|
DROP USER
|
DV
|
DROP VIEW
|
E
|
EXECUTE (MACRO)
|
EF
|
EXECUTE FUNCTION
|
GC
|
CREATE GLOP
|
GD
|
DROP GLOP
|
GM
|
GLOP MEMBER
|
I
|
INSERT
|
IX
|
INDEX
|
MR
|
MONTIOR RESOURCE
|
MS
|
MONITOR SESSION
|
NT
|
NONTEMPORAL
|
OA
|
OVERRIDE DUMP
|
OD
|
OVERRIDE DELETE POLICY
|
OI
|
OVERRIDE INSERT POLICY
|
OP
|
CREATE OWNER PROCEDURE
|
OS
|
OVERRIDE SELECT POLICY
|
OU
|
OVERRIDE UPDATE POLICY
|
PC
|
CREATE PROCEDURE
|
PD
|
DROP PROCEDURE
|
PE
|
EXECUTE PROCEDURE
|
R
|
RETRIEVE/SELECT
|
RF
|
REFERENCE
|
RO
|
REPLCONTROL
|
RS
|
RESTORE
|
SA
|
SECURITY CONSTRAINT ASSIGNMENT (system wide)
|
SD
|
SECURITY CONSTRAINT DEFINITION (system wide)
|
SH
|
SHOW
|
SR
|
SET RESOURCE RATE
|
SS
|
SET SESSION RATE
|
ST
|
STATISTICS
|
TH
|
CTCONTROL
|
U
|
UPDATE
|
UM
|
UDT METHOD
|
UT
|
UDT TYPE
|
UU
|
UDT USAGE
|
Wednesday, April 2, 2014
AccessRight Column
DBC.logonoff : Event column
Account Name Column
The AccountName column is the current unexpanded account name for the session.
Possible Values for Event Column
•Logon
•Logoff
•Logon failed
This value means a logon failed for reasons other than “Bad User,” “Bad Account,” or “Bad Password.” Currently, those other reasons are a failure to conform to Logon Rules or an attempt to log on without a password, where the TDP logon exit does not approve the logon.
•Bad user
•Bad account
This value means the user provided an account string during logon time, but that string does not match any of the account names specified for the user in the SQL CREATE USER or MODIFY USER statement.
•Bad password
•Bad profile
The external profile associated with the logon request does not exist. External profiles are stored in the directory server.
•Forced off
This value indicates that the user session was terminated from the Teradata Database console or the PM/API.
•IP restriction
This value indicates the user is not permitted to log on from the IP address used.
•Authentication failed
•Bad authentication
This value may indicate other authentication errors: bad authentication field, deprecated logons, decryption failure, and so forth.
UserName Column
The UserName column returns “Non-existent User” when a user tries to log on with a bad username.
Saturday, March 22, 2014
SET RSS
SAM8_1-8:~ # cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
start rcvmanager
Started 'rcvmanager' in window 1
at Sat Feb 23 16:12:55 2013
Input Supervisor Command:
> SET RESOURCE LOGGING 600
SET RESOURCE LOGGING 600
Input Supervisor Command:
>
SAM8_1-8:~ # ctl
> sc rss
(0) Node Logging Rate : 600 sec
RSS Table Logging Enable
(1) SPMA : On (2) IPMA : On (3) SCPU: On
(4) SVPR : On (5) IVPR : On (6) SLDV: On (7) SHST: On
(8) SPDSK: On (9) SVDSK: On (A) SAWT: On (B) SPS : On
RSS Summary Mode Enable
Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off (K) Summarize SPS : Off
> set resource vproc logging 600
set resource vproc logging 600
^
<input>:2 syntax error
> get resource
get resource
^
<input>:3 syntax error
>
SAM8_1-8:~ # cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
start rcvmanager
Started 'rcvmanager' in window 1
at Sat Feb 23 16:12:55 2013
Input Supervisor Command:
SET RESOURCE LOGGING 600
Input Supervisor Command:
> get resource
get resource
RSS Rate Information:
RSS Collection Rate = 60
Node Logging Rate = 600
Input Supervisor Command:
> SET LOGTABLE ALL ON
SET LOGTABLE ALL ON
Input Supervisor Command:
> SET VPROC LOGGING 600
SET VPROC LOGGING 600
SET VPROC LOGGING 600
^
5: syntax error
Input Supervisor Command:
> GET ACTIVELOGTABLE ALL
GET ACTIVELOGTABLE ALL
spma table's active row filtering mode is disabled
ipma table's active row filtering mode is disabled
svpr table's active row filtering mode is disabled
ivpr table's active row filtering mode is disabled
scpu table's active row filtering mode is disabled
sldv table's active row filtering mode is disabled
spdsk table's active row filtering mode is enabled
svdsk table's active row filtering mode is enabled
sawt table's active row filtering mode is enabled
sps table's active row filtering mode is enabled
shst table's active row filtering mode is disabled
Input Supervisor Command:
>
SAM8_1-8:~ # ctl
> sc rss
(0) Node Logging Rate : 600 sec
RSS Table Logging Enable
(1) SPMA : On (2) IPMA : On (3) SCPU: On
(4) SVPR : On (5) IVPR : On (6) SLDV: On (7) SHST: On
(8) SPDSK: On (9) SVDSK: On (A) SAWT: On (B) SPS : On
RSS Summary Mode Enable
Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off (K) Summarize SPS : Off
>
SAM8_1-8:~ # cnsterm 6
Attempting to connect to CNS...Completed.
Hello
SET VPROC LOGGING 600
^
5: syntax error
Input Supervisor Command:
GET ACTIVELOGTABLE ALL
spma table's active row filtering mode is disabled
ipma table's active row filtering mode is disabled
svpr table's active row filtering mode is disabled
ivpr table's active row filtering mode is disabled
scpu table's active row filtering mode is disabled
sldv table's active row filtering mode is disabled
spdsk table's active row filtering mode is enabled
svdsk table's active row filtering mode is enabled
sawt table's active row filtering mode is enabled
sps table's active row filtering mode is enabled
shst table's active row filtering mode is disabled
Input Supervisor Command:
> Get Resource
Get Resource
RSS Rate Information:
RSS Collection Rate = 60
Node Logging Rate = 600
Input Supervisor Command:
> set resource vproc log 600
set resource vproc log 600
Input Supervisor Command:
> Get Resource
Get Resource
RSS Rate Information:
RSS Collection Rate = 60
Node Logging Rate = 600
Input Supervisor Command:
>
SAM8_1-8:~ # ctl
> sc rss
(0) Node Logging Rate : 600 sec
RSS Table Logging Enable
(1) SPMA : On (2) IPMA : On (3) SCPU: On
(4) SVPR : On (5) IVPR : On (6) SLDV: On (7) SHST: On
(8) SPDSK: On (9) SVDSK: On (A) SAWT: On (B) SPS : On
RSS Summary Mode Enable
Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off (K) Summarize SPS : Off
>
SAM8_1-8:~ # get resource
-bash: get: command not found
SAM8_1-8:~ #
SAM8_1-8:~ #
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
start rcvmanager
Started 'rcvmanager' in window 1
at Sat Feb 23 16:12:55 2013
Input Supervisor Command:
> SET RESOURCE LOGGING 600
SET RESOURCE LOGGING 600
Input Supervisor Command:
>
SAM8_1-8:~ # ctl
> sc rss
(0) Node Logging Rate : 600 sec
RSS Table Logging Enable
(1) SPMA : On (2) IPMA : On (3) SCPU: On
(4) SVPR : On (5) IVPR : On (6) SLDV: On (7) SHST: On
(8) SPDSK: On (9) SVDSK: On (A) SAWT: On (B) SPS : On
RSS Summary Mode Enable
Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off (K) Summarize SPS : Off
> set resource vproc logging 600
set resource vproc logging 600
^
<input>:2 syntax error
> get resource
get resource
^
<input>:3 syntax error
>
SAM8_1-8:~ # cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
start rcvmanager
Started 'rcvmanager' in window 1
at Sat Feb 23 16:12:55 2013
Input Supervisor Command:
SET RESOURCE LOGGING 600
Input Supervisor Command:
> get resource
get resource
RSS Rate Information:
RSS Collection Rate = 60
Node Logging Rate = 600
Input Supervisor Command:
> SET LOGTABLE ALL ON
SET LOGTABLE ALL ON
Input Supervisor Command:
> SET VPROC LOGGING 600
SET VPROC LOGGING 600
SET VPROC LOGGING 600
^
5: syntax error
Input Supervisor Command:
> GET ACTIVELOGTABLE ALL
GET ACTIVELOGTABLE ALL
spma table's active row filtering mode is disabled
ipma table's active row filtering mode is disabled
svpr table's active row filtering mode is disabled
ivpr table's active row filtering mode is disabled
scpu table's active row filtering mode is disabled
sldv table's active row filtering mode is disabled
spdsk table's active row filtering mode is enabled
svdsk table's active row filtering mode is enabled
sawt table's active row filtering mode is enabled
sps table's active row filtering mode is enabled
shst table's active row filtering mode is disabled
Input Supervisor Command:
>
SAM8_1-8:~ # ctl
> sc rss
(0) Node Logging Rate : 600 sec
RSS Table Logging Enable
(1) SPMA : On (2) IPMA : On (3) SCPU: On
(4) SVPR : On (5) IVPR : On (6) SLDV: On (7) SHST: On
(8) SPDSK: On (9) SVDSK: On (A) SAWT: On (B) SPS : On
RSS Summary Mode Enable
Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off (K) Summarize SPS : Off
>
SAM8_1-8:~ # cnsterm 6
Attempting to connect to CNS...Completed.
Hello
SET VPROC LOGGING 600
^
5: syntax error
Input Supervisor Command:
GET ACTIVELOGTABLE ALL
spma table's active row filtering mode is disabled
ipma table's active row filtering mode is disabled
svpr table's active row filtering mode is disabled
ivpr table's active row filtering mode is disabled
scpu table's active row filtering mode is disabled
sldv table's active row filtering mode is disabled
spdsk table's active row filtering mode is enabled
svdsk table's active row filtering mode is enabled
sawt table's active row filtering mode is enabled
sps table's active row filtering mode is enabled
shst table's active row filtering mode is disabled
Input Supervisor Command:
> Get Resource
Get Resource
RSS Rate Information:
RSS Collection Rate = 60
Node Logging Rate = 600
Input Supervisor Command:
> set resource vproc log 600
set resource vproc log 600
Input Supervisor Command:
> Get Resource
Get Resource
RSS Rate Information:
RSS Collection Rate = 60
Node Logging Rate = 600
Input Supervisor Command:
>
SAM8_1-8:~ # ctl
> sc rss
(0) Node Logging Rate : 600 sec
RSS Table Logging Enable
(1) SPMA : On (2) IPMA : On (3) SCPU: On
(4) SVPR : On (5) IVPR : On (6) SLDV: On (7) SHST: On
(8) SPDSK: On (9) SVDSK: On (A) SAWT: On (B) SPS : On
RSS Summary Mode Enable
Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off (K) Summarize SPS : Off
>
SAM8_1-8:~ # get resource
-bash: get: command not found
SAM8_1-8:~ #
SAM8_1-8:~ #
Checktable / Scandisk Log
You need to be root and be on SMP001-8 (cop1) on each server to run these.
Checktable level two on DBC
Command line syntax: /opt/teradata/gsctools/bin/cnsremote checktable check dbc at level two with no error limit skiplocks priority=m error only;
Checktable level one on user tables
Command line syntax: /opt/teradata/gsctools/bin/cnsremote checktable check all tables exclude dbc at level one with no error limit skiplocks priority=m error only;
Checktable output from both of these will be in this file. Each file will be differentiated by the time. So they will not overwrite each other.
/var/opt/teradata/gsctools/cnsremote/checktable.mmddyytime
Scandisk
Command line syntax: /opt/teradata/gsctools/bin/cnsremote scandisk
Scandisk output will be in this file:
/var/opt/teradata/gsctools/cnsremote/scandisk.mmddyy
below FAQ
1. Is every cnsterm command’s output storead at /var/opt/teradata/gsctools/cnsremote/ ?
1A. Yes, if you run it from the command line, yes all the output goes there. Each run of each tool will go to a unquie file so you don’t need to worry about overwriting another log file.
2. If yes, then what is retention period .
2A. No retention period. Usually, until we clean it up.
3. By anyhow, Is this data stored in Dictionary table(s)?
3A. No
Checktable level two on DBC
Command line syntax: /opt/teradata/gsctools/bin/cnsremote checktable check dbc at level two with no error limit skiplocks priority=m error only;
Checktable level one on user tables
Command line syntax: /opt/teradata/gsctools/bin/cnsremote checktable check all tables exclude dbc at level one with no error limit skiplocks priority=m error only;
Checktable output from both of these will be in this file. Each file will be differentiated by the time. So they will not overwrite each other.
/var/opt/teradata/gsctools/cnsremote/checktable.mmddyytime
Scandisk
Command line syntax: /opt/teradata/gsctools/bin/cnsremote scandisk
Scandisk output will be in this file:
/var/opt/teradata/gsctools/cnsremote/scandisk.mmddyy
below FAQ
1. Is every cnsterm command’s output storead at /var/opt/teradata/gsctools/cnsremote/ ?
1A. Yes, if you run it from the command line, yes all the output goes there. Each run of each tool will go to a unquie file so you don’t need to worry about overwriting another log file.
2. If yes, then what is retention period .
2A. No retention period. Usually, until we clean it up.
3. By anyhow, Is this data stored in Dictionary table(s)?
3A. No
Wednesday, March 19, 2014
gtwglobal Command
SAM4_1-9:/ # tdatcmd
PDE running version is 13.00.01.21
SAM4_1-9:/ # gtwglobal
_______
| | |
| ___ __ ____ | ____ __|__ ____
| / |/ \ ____| ____| ____| | ____|
| --- | / | / | / | | / |
| \___ | \____| \____| \____| |__ \____|
Enter gateway command or enter h for Help:
sel host 1
Host 1 has been selected.
Enter gateway command or enter h for Help:
1>di se 107657245
Session 107657245 connected to GTW 8196 is assigned to PE 16316
of host 1
User Name IP Addr Port
------------------------------ --------------- ----------
CSERVICES 173.37.93.41 49166
State Event Action
----------------------------- ------------------------ ------------------------
CS_CLIENTWAITNOTRAN CE_CONTINUEMSGRSPOK CA_SENDDBSRSP
Partition Authentication
---------------- --------------
DBC/SQL DATABASE
Enter gateway command or enter h for Help:
1>di se 107918327
Session 107918327 connected to GTW 8238 is assigned to PE 16367
of host 1
User Name IP Addr Port
------------------------------ --------------- ----------
R_FIN_FBI_BO_M3 10.21.88.128 59900
State Event Action
----------------------------- ------------------------ ------------------------
CS_CLIENTWAITNOTRAN CE_CONTINUEMSGRSPOK CA_SENDDBSRSP
Partition Authentication
---------------- --------------
DBC/SQL DATABASE
Enter gateway command or enter h for Help:
1>di se 107938037
Session 107938037 connected to GTW 8225 is assigned to PE 16340
of host 1
User Name IP Addr Port
------------------------------ --------------- ----------
R_ATHENA_QLIKVIEW_M 173.36.136.18 62207
State Event Action
----------------------------- ------------------------ ------------------------
CS_CLIENTWAITNOTRAN CE_CONTINUEMSGRSPOK CA_SENDDBSRSP
Partition Authentication
---------------- --------------
DBC/SQL DATABASE
Enter gateway command or enter h for Help:
1>di se 108113754
Session 108113754 connected to GTW 8209 is assigned to PE 16360
of host 1
User Name IP Addr Port
------------------------------ --------------- ----------
GG_NRTREP_01 72.163.43.141 10328
State Event Action
----------------------------- ------------------------ ------------------------
CS_WAITSTARTRSP CE_STARTMSGOK CA_SENDSTART
Partition Authentication
---------------- --------------
DBC/SQL DATABASE
Subscribe to:
Posts (Atom)