Partition Assignment Listing | Resource Usage Macros/Tables | Teradata Vantage - 17.05 - Partition Assignment Listing - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

The following table lists the Node, AMP, PE, GTW, RSG, and TVS usage of PDE vproc partitions by PDE and Teradata Database.

Partition: Usage in Vprocs of Type
# Name Node AMP PE GTW RSG TVS
0 Kernel PDE daemons pdevproc        
1 System Debugger System Debugger tasks
3 Console PDE console control process (cnscim) --------        
3-6 Interactive 1 through 4 Console interactive partition programs
7 Service Console utilities scpstart --------      
8 Host Utility Procedures -------- utadvtsk --------      
9 Filesys -------- File System processes --------      
10 Gateway --------     Gateway processes --------  
11 AWT -------- AMP Worker Tasks --------      
12 Session --------   Session Control tasks --------    
13 Dispatch --------   Dispatcher/Parser Partition --------    
14 [Unused] --------          
15 Startup -------- Startup tasks --------      
16 [Unused] --------          
17 RSS Startup -------- File System RSS startup --------      
18 Distributed Database File (DDF) Server DDF services --------        
20-29 Interactive Partitions -------- DBCCONS utilities
30 [Unused] --------          
31 Allocator --------         tvsaallocator
32 Node Agent --------         tvsa_agent
33 Clique Coordinator --------         Clique Coordinator services
34-39 [Unused] --------          
40 UDF Debugger server --------        
41 UDF Debugger controller --------        
42 GDO Monitor gdom --------        
43 Parallel Data Collector pdcmaster --------        
44 Dump save slaves csp --------        
45 Dump save or clear csp --------        
46 Dump list csp --------        
47 Replication --------       Replication Gateway rsgdbsmain