Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 25 Aug 2002 @ 00:50:35 GMT


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


Subj:   Re: PI and statistics
 
From:   John Hall

There is another way of getting the same information without having to use TSET. Instead, you can use the DIAGNOSTIC USESTATS command. The description given in Doug's post applies to this method.

- Start a telnet session to a Node and logon as 'root'.

- Start terminal logging for the telnet session. The output can be voluminous and a portion of it will likely be lost if not logging to disk.

- Enter the following command:

cnsterm 5

This will open a window to the Supervisor I/O screen (Also known as Screen #5):

- Start a new telnet session and logon to the Node.

- If desired, start terminal logging for this telnet session.

- Start BTEQ on this new session and logon to the Teradata.

- Enter the following command:

diagnostic usestats on for session;

This will stay in effect until the user logs-off.

- Then enter the following command:

help statistics database.tablename;

- While the normal 'help statistics' information is displayed on the BTEQ telnet session, the detailed statistics information will be displayed on the Supervisor I/O screen. The detailed information will contain all of the columns and indices for which statistics have been collected. See below for a sample of the output.

The BTEQ screen will look something like this:

     diagnostic usestats on for session;

     *** Null statement accepted.
     *** Total elapsed time was 1 second.

     help statistics jjhall.test03;

     *** Help information returned. 3 rows.
     *** Total elapsed time was 56 seconds.

     Date      Time      Unique Values   Column Names
     --------  --------  -------------   ------------
     02/08/19  07:26:29          1,001   col_1
     02/08/19  07:26:28          1,001   col_2
     02/08/19  07:26:29          1,010   col_1,col_2

The Supervisor I/O screen will look something like this:

     test_12:/ [ 230 ] cnsterm 5
     Attempting to connect to CNS...completed.

     Column Names: col_1
     StatTime    : 02/08/19 07:26:29
     Version     : 1
     NumNulls    : 0
     NumIntervals: 100
     Numeric     : TRUE
     Min. Value  : 0
     Mode Value  : 1
     Mode Freq   : 2
     Total Values: 1001
     Total Rows  : 1010
     Interval[1]
       Max. Value: 4
       Mode Value: 1
       Mode Freq : 2
       Values    : 4
       Rows      : 7
     Interval[2]
       Max. Value: 9
       Mode Value: 6
       Mode Freq : 2
       Values    : 4
       Rows      : 8
         .
         .   NOTE: Intervals [3] thru [98] have been deleted
         .
     Interval[99]
       Max. Value: 989
       Mode Value: 986
       Mode Freq : 1
       Values    : 10
       Rows      : 10
     Interval[100]
       Max. Value: 1000
       Mode Value: 997
       Mode Freq : 1
       Values    : 10
       Rows      : 10


     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016