home 
 
 
 
enfr
 
Home
Over ABIS
Diensten
Cursussen
Resources
Contact
MyABIS
Alle CursussenbalkjeAlgemeen » Introductie HW & SW » TrajectenOperating Systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transactiesystemen en middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence en data warehouseApplicatieontwikkeling » Methoden en technieken » PRINCE2 » Programmeertalen » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSysteembeheer » ITILbalkjePraktischInschrijven 
Deze pagina is niet beschikbaar in het Nederlands.
Partitioning in DB2 for z/OS: best practices

Intended for

DB2 designers and database administrators who want to learn about new (or not-so-new) data design possibilities of DB2, related to data partitioning.

Background

Sufficient knowledge of DB2 internals (cf. course DB2 for z/OS fundamentals course).

Course leader

Peter Vanroose.

Duration

1 evening (2 hours).

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Objectives

This evening session is one in a series of six where we will bring you up-to-date on some selected topics related to DB2 for z/OS. The individual sessions can be followed independently, or you may sign up for the full series.

DB2 v8 for z/OS introduced several new table/tablespace partitioning possibilities. This session will bring you up-to-date on new concepts like DPSIs, partition rotation, table-based partitioning, and more importantly provide you with some "DO"s and "DONT"s, performance impact, and other consequences of the new partitioning choices.

Main topics

  • Partitioned tablespaces in DB2 v7, DB2 v8, and DB2 9: what changed and what's the same
  • Partition independence for utilities, SQL, DB2 commands, and consequences for locking
  • Table-based partitioning; partitioning indexes; data partitioned indexes (DPSIs); clustering vs partitioning
  • Partitioning best practices: what to choose as clustering sequence / partitioning column(s) / partition size
  • Caveats concerning ADD PARTITION and ROTATE PARTITION; consequences for utilities and -DIS DB
  • Partitioning by range versus partitioning by growth in DB2 9