Configuration 233 Switch Configuration 234 ETL Hosts for Data Loading 235 Tanzu Greenplum Performance Monitoring 236 Estimating Storage Capacity 237 Estimating Storage Capacity 0 Calculating Usable Disk Capacity 316 Resource Queue Memory Management 316 Partitioning 318 Indexes 318 Resource Queues 318 Monitoring and Maintenance 319 ANALYZE 319 Vacuum 320 Loading 320 Security 320 Encryption 321 High Availability Configuring Resource Queues 341 System Monitoring and Maintenance 342 System Monitoring and Maintenance 0 Monitoring 342 gpstate 342 gpcheckperf 343 Monitoring with Operating System Utilities 343 Best

Configuration 240 Switch Configuration 241 ETL Hosts for Data Loading 242 Tanzu Greenplum Performance Monitoring 243 Estimating Storage Capacity 244 Estimating Storage Capacity 0 Calculating Usable Disk Capacity 325 Resource Queue Memory Management 325 Partitioning 327 Indexes 327 Resource Queues 327 Monitoring and Maintenance 328 ANALYZE 328 Vacuum 329 Loading 329 Security 329 Encryption 330 High Availability Configuring Resource Queues 350 System Monitoring and Maintenance 351 System Monitoring and Maintenance 0 Monitoring 351 gpstate 351 gpcheckperf 352 Monitoring with Operating System Utilities 352 Best

Configuration 167 Switch Configuration 168 ETL Hosts for Data Loading 169 Greenplum Performance Monitoring 170 Estimating Storage Capacity 171 Estimating Storage Capacity 0 Calculating Usable Disk Capacity Greenplum v6.17 Documentation VMware, Inc. 10 Partitioning 251 Indexes 251 Resource Queues 251 Monitoring and Maintenance 252 ANALYZE 252 Vacuum 253 Loading 253 Security 253 Encryption 254 High Availability Configuring Resource Queues 276 System Monitoring and Maintenance 277 System Monitoring and Maintenance 0 Monitoring 277 gpstate 278 gpcheckperf 278 Monitoring with Operating System Utilities 279 Best

270 About ETL Hosts for Data Loading 271 About Tanzu Greenplum Performance Monitoring 272 About Management and Monitoring Utilities 273 About Concurrency Control in Greenplum Database 274 Snapshots VMware, Inc 14 Validating the Virtual Machine Template 338 Provisioning the Virtual Machines 338 Monitoring the Greenplum Deployment 340 Setting Up the GPCC Login User 341 Next Steps 341 Option 2: Deploying Playbook - Greenplum Database Installation for CentOS 7 477 Greenplum Database Security Configuration Guide 479 Securing the Database 480 Accessing a Kerberized Hadoop Cluster 480 Platform Hardening 480

278 About ETL Hosts for Data Loading 279 About VMware Greenplum Performance Monitoring 280 About Management and Monitoring Utilities 281 About Concurrency Control in Greenplum Database 282 Snapshots Resources 347 Validating the Virtual Machine Template 348 Provisioning the Virtual Machines 348 Monitoring the Greenplum Deployment 350 Setting Up the GPCC Login User 351 Next Steps 351 Option 2: Deploying Playbook - Greenplum Database Installation for CentOS 7 496 Greenplum Database Security Configuration Guide 498 Securing the Database 499 Accessing a Kerberized Hadoop Cluster 499 Platform Hardening 499

266 About ETL Hosts for Data Loading 267 About Tanzu Greenplum Performance Monitoring 268 About Management and Monitoring Utilities 269 About Concurrency Control in Greenplum Database 270 Snapshots Resources 333 Validating the Virtual Machine Template 334 Provisioning the Virtual Machines 334 Monitoring the Greenplum Deployment 336 Setting Up the GPCC Login User 337 Next Steps 337 Option 2: Deploying Playbook - Greenplum Database Installation for CentOS 7 474 Greenplum Database Security Configuration Guide 477 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 20 Securing the Database 478 Accessing

241 About ETL Hosts for Data Loading 242 About Tanzu Greenplum Performance Monitoring 243 About Management and Monitoring Utilities 244 About Concurrency Control in Greenplum Database 245 Snapshots Resources 301 Validating the Virtual Machine Template 302 Provisioning the Virtual Machines 302 Monitoring the Greenplum Deployment 304 Setting Up the GPCC Login User 304 Next Steps 304 Option 2: Deploying Playbook - Greenplum Database Installation for CentOS 7 402 Greenplum Database Security Configuration Guide 404 Securing the Database 404 Accessing a Kerberized Hadoop Cluster 405 Platform Hardening 405

296 About ETL Hosts for Data Loading 297 About VMware Greenplum Performance Monitoring 298 About Management and Monitoring Utilities 299 About Concurrency Control in Greenplum Database 300 Snapshots Playbook - Greenplum Database Installation for CentOS 7 472 Greenplum Database Security Configuration Guide 474 Securing the Database 475 Accessing a Kerberized Hadoop Cluster 475 Platform Hardening 475 1102 Running gpexpand to Initialize New Segments 1103 To run gpexpand with an input file 1103 Monitoring the Cluster Expansion State 1103 Rolling Back a Failed Expansion Setup 1104 Redistributing Tables

310 About ETL Hosts for Data Loading 311 About VMware Greenplum Performance Monitoring 312 About Management and Monitoring Utilities 313 About Concurrency Control in Greenplum Database 314 VMware Greenplum Playbook - Greenplum Database Installation for CentOS 7 501 Greenplum Database Security Configuration Guide 503 VMware Greenplum 6 Documentation VMware by Broadcom 24 About Endpoint Security Software 504 1134 Running gpexpand to Initialize New Segments 1135 To run gpexpand with an input file 1135 Monitoring the Cluster Expansion State 1135 Rolling Back a Failed Expansion Setup 1136 Redistributing Tables

Configuration 238 Switch Configuration 239 ETL Hosts for Data Loading 240 Tanzu Greenplum Performance Monitoring 241 Estimating Storage Capacity 242 Calculating Usable Disk Capacity 242 Calculating User Data 320 Resource Queue Memory Management 320 Partitioning 322 Indexes 322 Resource Queues 323 Monitoring and Maintenance 323 ANALYZE 323 Vacuum 324 Loading 324 Security 324 Encryption 325 High Availability Greenplum Database 343 Configuring Resource Queues 345 System Monitoring and Maintenance 346 Monitoring 346 gpstate 346 gpcheckperf 347 Monitoring with Operating System Utilities 347 Best Practices 347