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.


    Nov 30
    2007

    Segmented tablespace LDS DSN size (Z/OS)

    Sangameswara Panchomarthi
    [JPM CHASE]
    According to my knowledge on DB2, Segmented table
    Dear Experts,

    According to my knowledge on DB2, Segmented table space DSN will grow up to 2GB in size and then another dataset will be created until we reach total of 32 datasets for the table space. Maximum size of segmented table space is 32 x 2GB = 64 GB.

    But recently i have noticed on my DB2 system that segmented table space DSN is growing to 4GB in size. DO they also grow in 4GB chunks up to 16 ?

    Since SEGMENTED table space create syntax does not allow DSSIZE parameter, where the 2GB or 4GB will be decided for the DSN.

    I appreciate your help if you can provide any insight into this.

    Thanks,
    Rao


    -----------------------------------------
    This transmission may contain information that is privileged,
    confidential, legally privileged, and/or exempt from disclosure
    under applicable law. If you are not the intended recipient, you
    are hereby notified that any disclosure, copying, distribution, or
    use of the information contained herein (including any reliance
    thereon) is STRICTLY PROHIBITED. Although this transmission and
    any attachments are believed to be free of any virus or other
    defect that might affect any computer system into which it is
    received and opened, it is the responsibility of the recipient to
    ensure that it is virus free and no responsibility is accepted by
    JPMorgan Chase & Co., its subsidiaries and affiliates, as
    applicable, for any loss or damage arising in any way from its use.
    If you received this transmission in error, please immediately
    contact the sender and destroy the material in its entirety,
    whether in electronic or hard copy format. Thank you.

    IMPORTANT NOTICE:

    IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

    ---------------------------------------------------------------------------------
    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