Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 22 Mar 2015 @ 11:16:09 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: How to determine freequently accessed tables
From:   Sravan.Bodla

Bhonagiri Satyendra Kumar wrote:

  To turn on usecount for all users you can run this..  

HI Guys,

We face some or other issues by enabling OUC [Object Use Count] in TD 14.10

Recently, At our site, one fast load job was running for 8hrs, when aborted it continued to be in aborted state for more than 5 hrs.

Later aborted using GTWGLOBAL, but, the session still continued to be in aborting for another 3hrs.

Finally engaged GSC and they advised the session is hanging on the node and needs a TPARESET and as a workaround suggested to disable OUC.

Refer to DR 176227 for more info. And also, there are quite a few open NTA's/DR's as well on OUC

Waiting for the above DR to be addressed, so that we continue with STATS MANAGER and other features.



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