Multi-Platform Database Consulting: Database Useage on Mainframe, Mid-Tier and NT Servers

ISBN-13: 9781418468798 / Angielski / Miękka / 2004 / 444 str.

John V. McLean

Opis

Features A look at the Data Warehouse Process, Agents and Threads, Basic Access, Buffer pool Sizes, Catalog the Node, Check Data, Clustering, Communications for DB2 UDB EEE on Windows NT, Compression, Check Data, Clustering, Compression, Configuration Parameters and the path to the Logs, Configuring DB2 Communications, Connection Pooling, Connections Foreword, Constraints On and Off, Copy Incrementally, Core Files, Create an AIX Group and User for DAS Instance Owner, Create Function, Creating a DB2 Instance in EEE, Creating the DAS Instance Manual Option, Data Distribution across Partitions, Data Sharing and Parallel Sysplex, Data Sharing Group - Buffer Pool, Data Warehouse - Overview, Data Warehousing Guide Lines, Data Warehouse Summary, DB2 - Mainframe Utilities, DB2 - Trace Records, DB2 Copy, DB2 Display, DB2 Export, DB2 Import, DB2 Index Copy, DB2 instance, /etc/services db2nodes.cfg file, DB2 Load, DB2 OS/390 Assorted Utilities, DB2 OS/390 Load Utility, DB2 OS/390 Merge Utility, DB2 OS/390 MODIFY Recovery Utility, DB2 OS/390 REBUILD Index, DB2 OS/390 Recover Utility, DB2 OS/390 RECOVER Utility (extended), DB2 OS/390 REORG Utility, DB2 OS/390 RUNSTATS Utility, DB2 OS/390 Unload Utility, DB2 Performance, DB2 PM, DB2 Tools, DB2 UDB AIX / UNIX, DB2 UDB EEE, DB2 UDB ESE Version 8.1 - Detail, DB2 UDB NT Version 7 and Up - Installation, DB2 UDB Tools, DRDA, EEE Selected Functions Overview, Event Monitor, Faster inserts through asynchronous pre-formatting, Faster query execution through FETCH FIRST n ROWS, Faster updates through improved log write, Faster Warehouse queries via UNION in views, Helpful SQL Scripts, How data is partitioned, Introduction to Version 8.1 ESE (a.k.a. EEE), IT Myths and Realities, Log Archiving, Managing Connections to Databases, Partitioned Table Spaces, Partitioning Calculation, Performance Tuning Check List, Questions and Answers, Quick Reference Tuning for DB2 UDB EEE(ESE), Relation Table Scans, REORGS, Rows per Node in a Partitioned Table Space, Runstats, Useful Unix Scripts, Speeding up Performance, Stored Procedures, Table space Examples, The Optimizer, TIMESTAMP SWITCH, Triggers, Tuning, What is a Data Mart?, What is Performance Tuning?, What type of partitioning for most Installations, XML Extender.