Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 05 Aug 2005 @ 19:06:00 GMT


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


Subj:   Re: How to Identify LOCKS using Data Dictionary and Queries.
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, August 05, 2005 14:55 -->

Does sysadmin.fastlog have information on what kind of lock is applied. I don't think so. Does the user have access to this table?

     CREATE SET TABLE sysadmin.fastlog ,FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           TableName CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           DatabaseName CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           StartDate DATE FORMAT 'YY/MM/DD' NOT NULL,
           StartTime FLOAT FORMAT '99:99:99' NOT NULL,
           EndDate DATE FORMAT 'YY/MM/DD',
           EndTime FLOAT FORMAT '99:99:99',
           UserId CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           Status CHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           RowCount INTEGER NOT NULL,
           TotalAMPs SMALLINT NOT NULL,
           UpAMPs SMALLINT NOT NULL,
           DownAMPs SMALLINT NOT NULL,
           Positioning BYTE(500),
           HostMachine CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           WorkStationID CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           AMPArray VARBYTE(24576) NOT NULL)
     UNIQUE PRIMARY INDEX ( TableName ,DatabaseName ,UserId );


     
  <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: 15 Jun 2023