Table of Contents

About DB2 Multisystem for AS/400

  • Who should read DB2 Multisystem

    • Introducing DB2 Multisystem

  • Benefits of using DB2 Multisystem
  • DB2 Multisystem: Basic terms and concepts

    • Introducing node groups with DB2 Multisystem

  • How node groups work with DB2 Multisystem
  • Tasks to complete before using the node group commands with DB2 Multisystem
  • Creating node groups using the CRTNODGRP command with DB2 Multisystem
  • Displaying node groups using the DSPNODGRP command with DB2 Multisystem
  • Changing node groups using the CHGNODGRPA command with DB2 Multisystem
  • Deleting node groups using the DLTNODGRP command with DB2 Multisystem

    • Creating distributed files with DB2 Multisystem

  • Creating a distributed physical file with DB2 Multisystem
  • Restrictions when creating or working with distributed files with DB2 Multisystem
  • Using distributed files with DB2 Multisystem
  • Issuing CL commands against distributed files with DB2 Multisystem
  • Partitioning with DB2 Multisystem
  • Planning for partitioning with DB2 Multisystem
  • Choosing a partitioning key with DB2 Multisystem
  • Customizing the distribution of data with DB2 Multisystem

    • Scalar functions available with DB2 Multisystem

  • PARTITION with DB2 Multisystem
  • Examples of PARTITION with DB2 Multisystem
  • HASH with DB2 Multisystem
  • Example of HASH with DB2 Multisystem
  • NODENAME with DB2 Multisystem
  • Examples of NODENAME with DB2 Multisystem
  • NODENUMBER with DB2 Multisystem
  • Example of NODENUMBER with DB2 Multisystem
  • Special registers with DB2 Multisystem
  • Relative record numbering (RRN) function with DB2 Multisystem

    • Performance and scalability with DB2 Multisystem

  • Why should you use DB2 Multisystem?
  • Performance enhancement tip with DB2 Multisystem
  • How can DB2 Multisystem help you expand your database system?
  • Redistribution issues for adding systems to a network

    • Query design for performance with DB2 Multisystem

  • Optimization overview with DB2 Multisystem
  • Implementation and optimization of a single file query with DB2 Multisystem
  • Implementation and optimization of record ordering with DB2 Multisystem
  • Implementation and optimization of the UNION and DISTINCT clauses with DB2 Multisystem
  • Processing of the DSTDTA and ALWCPYDTA parameters with DB2 Multisystem
  • Implementation and optimization of joins with DB2 Multisystem
  • Co-located join with DB2 Multisystem
  • Directed join with DB2 Multisystem
  • Repartitioned join with DB2 Multisystem
  • Broadcast join with DB2 Multisystem
  • Join optimization with DB2 Multisystem
  • Implementation and optimization of grouping with DB2 Multisystem
  • One-step grouping with DB2 Multisystem
  • Two-step grouping with DB2 Multisystem
  • Grouping and joins with DB2 Multisystem
  • Subquery support with DB2 Multisystem
  • Access plans with DB2 Multisystem
  • Reusable open data paths (ODPs) with DB2 Multisystem
  • Temporary result writer with DB2 Multisystem
  • Temp writer job: Advantages with DB2 Multisystem
  • Temp Writer Job: Disadvantages with DB2 Multisystem
  • Control of the temp writer with DB2 Multisystem
  • Optimizer messages with DB2 Multisystem
  • Changes to the change query attributes (CHGQRYA) command with DB2 Multisystem
  • Asynchronous job usage (ASYNCJ) parameter with DB2 Multisystem
  • Apply remote (APYRMT) parameter
  • Summary of performance considerations

    • Bibliography

    Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]