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

Cover of Multi-Platform Database Consulting Database Useage on Mainframe, Mid-Tier and NT Servers by John V. McLean
Publisher: AuthorHouse
Year: 2004
Language: en
Pages: 444
ISBN-13: 9781418468798
Dimensions:
Height: 11 Inches
Length: 8.25 Inches
Weight: 2.18919026166 Pounds
Width: 0.9 Inches
Editorial overview Touché

Multi-Platform Database Consulting Database Usage on Mainframe, Mid-Tier and NT Servers by John V. McLean is a comprehensive resource published by AuthorHouse in November 2004. This edition spans 444 pages and is presented in English. The book offers an in-depth examination of various aspects of database management, focusing on the Data Warehouse Process, configuration parameters, and performance tuning for DB2 across different platforms.

Readers will find detailed discussions on topics such as data distribution, connection pooling, and the creation of DB2 instances. The content covers essential utilities and tools for DB2, including performance tuning checklists and helpful SQL scripts. Additionally, the book addresses IT myths and realities, providing insights into effective database management practices. This resource is particularly relevant for those interested in technology and engineering, offering practical guidance for optimizing database performance across mainframe, mid-tier, and NT server environments.


Official synopsis Publisher

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.

Explore more

Publisher

Topics

FAQ
What is “Multi-Platform Database Consulting Database Useage on Mainframe, Mid-Tier and NT Servers” about?
This page includes the available description and bibliographic details for “Multi-Platform Database Consulting Database Useage on Mainframe, Mid-Tier and NT Servers” by John V. McLean. Synopsis preview: 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, Cluster…
Who is the author of “Multi-Platform Database Consulting Database Useage on Mainframe, Mid-Tier and NT Servers”?
“Multi-Platform Database Consulting Database Useage on Mainframe, Mid-Tier and NT Servers” is credited to John V. McLean.
When was “Multi-Platform Database Consulting Database Useage on Mainframe, Mid-Tier and NT Servers” published?
Publisher: AuthorHouse. Year: 2004.
What is the ISBN for “Multi-Platform Database Consulting Database Useage on Mainframe, Mid-Tier and NT Servers”?
ISBN-13: 9781418468798.
What are the book details (language, pages, edition)?
Language: en. Pages: 444.

Related Books by Topic