Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.

    Oct 29

    DB2 High Performance Unload

    [login to unmask email]
    Hi folks,

    Got this from a colleague and hadn't seen any mention of it on DB2-L so I
    thought I'd put it out here for anyone who's interested...


    DB2 High Performance Unload, product number 5697-F44,
    was announced for general availability October 22, 1999.
    DB2 High Performance Unload delivers the unload functions
    needed by DB2 installations with outstanding elapsed times
    and with very low CPU consumption.
    o Unloads from both active tablespaces and image copies with
    outstanding performance.
    o Provides key functions to assist in the management and
    control of unload activity.

    Large sequential reads of DB2 tables take long periods of time.
    They make the required large scans that support unload functions
    difficult to schedule in the ever shrinking batch windows of DB2
    installations. Performance becomes critical when several unloads
    read the same tablespace concurrently. The associated DB2 buffer
    pool management can cause multiple programs to compete for the same
    data producing:
    o Conflicts in the use of the DB2 buffer pool
    o Writing over buffers that may be serving several unloads
    o Multiple reads of the same DB2 pages
    o Potential channel conflicts

    DB2 High Performance Unload provides the solution to these
    issues with respect to unload functions by providing a means of
    sequentially reading and sharing a DB2 at lightning speed! It scans
    a tablespace and creates as many output files in the format desired
    based upon the selection criteria specified by the user.

    The output format can be:
    o DSNTIAUL compatible
    o VARIABLE -- quickly create standard variable length records
    o DELIMITED -- quickly create a delimited file that may be exported
    to another platform
    o USER -- support format specification of virtually any type of
    conversion, so output may appear exactly as desired

    As many select statements can be coded as needed for any tables
    belonging to the same tablespace. Different output files can be
    created during the same unload process at almost no additional cost.
    For example, a user may want to unload the list of the customers
    having payments due and birthdays occurring in the next week.

    The list can be created in a single DB2 High Performance
    Unload execution at a fraction of the cost of the dual executions
    required by traditional unload products. This high level of
    performance is achieved while producing multiple outputs by executing
    processes in parallel against a single read of the tablespace.

    DB2 High Performance Unload can be run against image copies.
    This avoids interference with DB2 production databases.

    DB2 High Performance Unload has been demonstrated to peform up
    to ten faster than DSNTIAUL! This DB2 High Performance Unload
    measurement was achieved in a controlled test environment using
    approximately 500,000 rows of DB2 data from a variety of test

    The product will run on any system with DB2 for OS/390 Version 3,
    or later version installed.


    Jay Reavill
    [login to unmask email]
    IBM Global Services
    Tampa, Florida
    Tel: (813) 878-3525, Tie Line 8-427-3525
    Happiness is not around the corner.
    Happiness is the corner.
    - BMW

    All Times America/Chicago

    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact