2.1. SQL Statements, XQuery Statements, and DB2 Commands2.1.1. SQL Statements2.1.2. XQuery Statements2.1.3. DB2 System Commands2.1.4. DB2 Command Line Processor (CLP) Commands2.2. DB2 Tools Overview2.2.1. Command-Line Tools2.2.2. General Administration Tools2.2.3. Information Tools2.2.4. Monitoring Tools2.2.5. Setup Tools2.2.6. Other Tools2.3. The DB2 Environment2.3.1. An Instance(1)2.3.2. The Database Administration Server2.3.3. Configuration Files and the DB2 Profile Registries(2)2.3.3.1. Environment Variables2.3.3.2. The DB2 Profile Registry2.3.3.3. Configuration Parameters2.3.4. Connectivity and DB2 Directories(3)2.3.4.1. System Database Directory2.3.4.2. Local Database Directory2.3.4.3. Node Directory2.3.4.4. Database Connection Services Directory2.3.5. Databases(4)2.3.6. Table Spaces(5)2.3.7. Tables, Indexes, and Large Objects(6)2.3.8. Logs(7)2.3.9. Buffer Pools(8)2.3.10. The Internal Implementation of the DB2 Environment2.4. Federation2.5. Case Study: The DB2 Environment2.6. Database Partitioning Feature2.6.1. Database Partitions2.6.2. The Node Configuration File2.6.3. An Instance in the DPF Environment2.6.4. Partitioning a Database2.6.5. Configuration Files in a DPF Environment2.6.6. Logs in a DPF Environment2.6.7. The Catalog Partition2.6.8. Partition Groups2.6.9. Buffer Pools in a DPF Environment2.6.10. Table Spaces in a Partitioned Database Environment2.6.11. The Coordinator Partition2.6.12. Issuing Commands and SQL Statements in a DPF Environment2.6.12.1. The db2_all command2.6.12.2. Using Database Partition Expressions2.6.13. The DB2NODE Environment Variable2.6.14. Distribution Maps and Distribution Keys2.7. Case Study: DB2 with DPF Environment2.8. IBM Balanced Warehouse2.9. Summary2.10. Review Questions