15.10 - Partition Assignment Listing - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty
dita:id
resource_usage_macros_1099_v15.10

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 --------        
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 --------        
19 Metadata         Metadata Services Gateway rsgmain --------
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