Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 15 Sep 2003 @ 18:27:10 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Portnumber
From:   Raj Kollu


Could anyone give me some assitance for my questions i have.

1)I want to know what are the port numbers we connect.

a) Using PM/PC

b) Using SQL

2) When i see the Disk USe% using PMON , it always show 0 percentage only, though i am doing Fastload, and deleting and loading some tables continuosly in BTEQ schdule job..

How i will get the right value, or is there any value i need to look at..

3) In some cases when i shrink my user i see the peakspace is more than maxspace... Is there any way i can get rid of maxpeak space...


i have a user: Testuser1 :
his maxspoolspace is: 200MB
i ran one query it took 190MB spool space.

Later i shrink Testuser1 spool space to 100MB. When i query a Diskspace table it shows

Peakspoolspace : 190MB
Maxspoolspace: 100MB

In any scenario Peakspoolspace should be less than Maxspoolspace. How i have to correct this?



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