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.


    Jan 06
    2005

    LOAD Partition parallelism in V7

    Ken Michalik
    Dear List:

    I am attempting to run 2 parallel jobs loading different partitions of the
    same table. According to the Utility Guide, it's better to have 2 LOADs
    running rather than 1 LOAD using partition parallelism with when there are
    no NPIs.

    LOAD DATA LOG NO RESUME YES INTO TABLE CREATOR.TBNAME PART xx INDDN DDIN

    All the partitions of the table go into UTUT restrictive state when a load
    is running, and only 1 load can be running simultaneously. The second load
    gets an DSNU180I incompatibility error.This goes against everything I've
    read...the partitions should operate independently.

    Any help you could provide would be appreciated.

    Thanks in advance.

    Ken Michalik
    Kraft Foods

    ---------------------------------------------------------------------------------
    Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
    Chris Tee
    Have you got SHRLEVEL CHANGE?

    -----Original Message-----
    From: Michalik, Ken [mailto:[login to unmask email]
    Sent: Thursday, January 06, 2005 3:50 PM
    To: [login to unmask email]
    Subject: [DB2-L] LOAD Partition parallelism in V7



    Dear List:

    I am attempting to run 2 parallel jobs loading different partitions of the
    same table. According to the Utility Guide, it's better to have 2 LOADs
    running rather than 1 LOAD using partition parallelism with when there are
    no NPIs.

    LOAD DATA LOG NO RESUME YES INTO TABLE CREATOR.TBNAME PART xx INDDN DDIN

    All the partitions of the table go into UTUT restrictive state when a load
    is running, and only 1 load can be running simultaneously. The second load
    gets an DSNU180I incompatibility error.This goes against everything I've
    read...the partitions should operate independently.

    Any help you could provide would be appreciated.

    Thanks in advance.

    Ken Michalik
    Kraft Foods

    ----------------------------------------------------------------------------
    -----
    Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
    page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
    "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
    The IDUG List Admins can be reached at [login to unmask email] Find
    out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


    **********************************************************************************************
    The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only.

    This email and any response may be monitored by Sony United Kingdom Limited.
    (05)
    **********************************************************************************************

    ---------------------------------------------------------------------------------
    Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
    Larry Jardine
    [Aetna]
    Remove the "RESUME YES" -- that is what is putting ALL partitions in UT
    status. Do you want PART xx REPLACE?

    -----Original Message-----
    From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
    Behalf Of Michalik, Ken
    Sent: Thursday, January 06, 2005 10:50 AM
    To: [login to unmask email]
    Subject: [DB2-L] LOAD Partition parallelism in V7

    Dear List:

    I am attempting to run 2 parallel jobs loading different partitions of
    the
    same table. According to the Utility Guide, it's better to have 2 LOADs
    running rather than 1 LOAD using partition parallelism with when there
    are
    no NPIs.

    LOAD DATA LOG NO RESUME YES INTO TABLE CREATOR.TBNAME PART xx INDDN
    DDIN

    All the partitions of the table go into UTUT restrictive state when a
    load
    is running, and only 1 load can be running simultaneously. The second
    load
    gets an DSNU180I incompatibility error.This goes against everything I've
    read...the partitions should operate independently.

    Any help you could provide would be appreciated.

    Thanks in advance.

    Ken Michalik
    Kraft Foods

    ------------------------------------------------------------------------
    ---------
    Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
    home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
    page select "Join or Leave the list". The IDUG DB2-L FAQ is at
    http://www.idugdb2-l.org. The IDUG List Admins can be reached at
    [login to unmask email] Find out the latest on IDUG conferences
    at http://conferences.idug.org/index.cfm

    -----------------------------------------
    This e-mail may contain confidential or privileged information. If you
    think you have received this e-mail in error, please advise the sender by
    reply e-mail and then delete this e-mail immediately. Thank you. Aetna


    ---------------------------------------------------------------------------------
    Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

    All Times America/New_York

    Copyright © 2014 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