Partition Assignment Listing | Resource Usage Macros/Tables | Teradata Vantage - Partition Assignment Listing - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

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