Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2003 @ 09:38:05 GMT


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


Subj:   Re: States
 
From:   Dieter N�th

Anomy Anom wrote:

  Can somebody list the various phases from the physical "switch on" of the NCR machine till the database has come up "ready" state for queries from users?  


  I mean 1st OS coming up, next various states of PDE etc etc...  



The PDE states are listed by

> pdeglobal tpa
..
applstates: 15  initstate: 0  initsubstate: ffffffff
value  sub  message
    0    0     DBS is not running
    1    0     DBS Startup
    1    1   DBS Startup - Initializing DBS Vprocs
    2    1   DBS Startup - Initializing DBS Configuration
    3    1   DBS Startup - Starting AMP Partitions
    4    1   DBS Startup - Starting PE Partitions
    5    1   DBS Startup - Voting for Transaction Recovery
    6    1   DBS Startup - Starting Transaction Recovery
    7    1   DBS Startup - Recovering Down AMPs
    8    1   DBS Startup - Recovering DBS Partitions
    2    0     Logons are disabled - Users are logged on
    3    0     Logons are disabled - The system is quiescent
    4    0     Logons are enabled - Users are logged on
    5    0     Logons are enabled - The system is quiescent
    6    0     RECONFIG is running
    7    0     System is operational without PEs - Sessions are not allowed
    8    0     TABLEINIT is running
    9    0     Config is not operational
    1    9   Config is not op - Unable to select an appropriate control AMP
    2    9   Config is not op - More the one AMP in a cluster is offline/down
    3    9   Config is not op - Could not find a valid DBS configuration map

Dieter



     
  <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