Close

Know your onions when it comes to Db2 indexes

(IJ)

Stream: DB2
Time: 09:30 - 10:30


Presentation

What does a Db2 index look like from the inside?  I will begin with a very short, elementary description of Db2 objects in general, then move on to the various kinds of pages found in a Db2 index.  From there I will explore the contents of the primary pages found in all DB2 indexes and what that content is used for.

Attachments

There is currently no attachment for Know your onions when it comes to Db2 indexes

Speakers


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


  • Randy Bright at BMC Software Ltd
  • Randy is BMC Software’s Solutions Architect for the BMC Db2 Utilities, both Classic (REORG PLUS for DB2, LOAD PLUS for DB2, UNLOAD PLUS for DB2, and CHECK PLUS for DB2) and Next Generation Technology (NGT Reorg, NGT Load, NGT Unload, and NGT Check).  He currently holds six U.S. patents in the Db2 technology area.

     

    Randy started working with IMS in 1979 for a large electric utility company in Texas and Louisiana.  In 1985 he became a Systems Programmer installing and maintaining DB2 Version 1.3 and continued to work in that capacity through DB2 Version 2.3. In 1992 Randy moved to BMC Software in Austin, Texas as a Customer Support Representative for the Db2 Utilities.  Within two years he moved into R&D as a Developer on the Utilities and has worked with BMC’s Db2 Utilities since 1992.


    Feedback

    Click here to give some Feedback so we can make it even better next year!