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.


    Jul 15
    2005

    GETTING ZPARMS FROM RUNNING DB2 SYSTEM

    Mory Bindler
    Hi listers,

    I am a novice DB2 systems person who just subscribed to the list today,
    so I haven't had a chance to look at the archives yet. Forgive me if
    this question has been discussed here before.

    There seems to be differences between the zparms in my current version
    of the ...SDSNSAMP library member DSNTIJUZ and the current parms as
    reported by CA's RC/Query software. Some of the differences may be due
    to how the values are being reported. I don't think anyone has changed
    the parms since DB2 V 7.1 was installed last year. Anyway, I found in
    the manuals that program DSN8ED7 can be used to obtain the parms from an
    active system. Then I discovered that program is written in C and we
    don't have the C compiler installed on our system. Does anyone know of
    another program that can provide this information? Something you wrote?
    Shareware?

    I need to make some parm changes and based on what I see I'm hesitant
    to do so until I have a high confidence level of what we are really
    running. Thanks in advance for any help.

    Mory Bindler
    Technical Services Group
    847-647-5123
    [login to unmask email]

    ---------------------------------------------------------------------------------
    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
    Carol L Broyles
    Mory,

    See a posting in the Archives on a tool for DSNZPARM Analysis by HLS
    Technologies. I've used the tool, and it works. Go to
    www.hlstechnologies.com and select FREEWARE.

    Carol






    Mory Bindler <[login to unmask email]>
    Sent by: DB2 Data Base Discussion List <[login to unmask email]>
    07/15/2005 03:45 PM
    Please respond to
    DB2 Database Discussion list at IDUG <[login to unmask email]>


    To
    [login to unmask email]
    cc

    Subject
    [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM






    Hi listers,

    I am a novice DB2 systems person who just subscribed to the list today, so
    I haven't had a chance to look at the archives yet. Forgive me if this
    question has been discussed here before.

    There seems to be differences between the zparms in my current version of
    the ...SDSNSAMP library member DSNTIJUZ and the current parms as reported
    by CA's RC/Query software. Some of the differences may be due to how the
    values are being reported. I don't think anyone has changed the parms
    since DB2 V 7.1 was installed last year. Anyway, I found in the manuals
    that program DSN8ED7 can be used to obtain the parms from an active
    system. Then I discovered that program is written in C and we don't have
    the C compiler installed on our system. Does anyone know of another
    program that can provide this information? Something you wrote? Shareware?


    I need to make some parm changes and based on what I see I'm hesitant to
    do so until I have a high confidence level of what we are really running.
    Thanks in advance for any help.

    Mory Bindler
    Technical Services Group
    847-647-5123
    [login to unmask email]

    ________________________________________________________________________
    This email has been scanned for all viruses by the MessageLabs SkyScan
    service._______________________________________________________________
    ---------------------------------------------------------------------------------
    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 email has been scanned for all viruses by the MessageLabs SkyScan
    service._______________________________________________________________

    This electronic message contains information from MeadWestvaco
    Corporation or subsidiary companies, which may be confidential,
    privileged or otherwise protected from disclosure. The
    information is intended to be used solely by the recipient(s)
    named. If you are not an intended recipient, be aware that
    any review, disclosure, copying, distribution or use of this
    transmission or its contents is prohibited. If you have
    received this transmission in error, please notify MeadWestvaco
    immediately at [login to unmask email]
    _______________________________________________________________________

    ---------------------------------------------------------------------------------
    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
    Steen Rasmussen
    [CA technologies]
    Hello Mory,

    RC/Query lists ZPARM from the dataset listed on the panel once you get
    the report displayed.
    Since you have access to RC/Query - you also have access to option TT
    from the main menu. This option lists the active ZPARM and also allows
    you to change any parameter within ZPARM. You can even schedule the
    changes you describe to be performed e.g. every day at 8pm. using the
    built-in scheduler.
    If you have further questions - please do not hesitate to contact me off
    the list

    Kind regards
    Steen Rasmussen
    Computer Associates
    Senior Consultant



    _____

    From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
    Behalf Of Mory Bindler
    Sent: 15. juli 2005 14:46
    To: [login to unmask email]
    Subject: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM


    Hi listers,

    I am a novice DB2 systems person who just subscribed to the list today,
    so I haven't had a chance to look at the archives yet. Forgive me if
    this question has been discussed here before.

    There seems to be differences between the zparms in my current version
    of the ...SDSNSAMP library member DSNTIJUZ and the current parms as
    reported by CA's RC/Query software. Some of the differences may be due
    to how the values are being reported. I don't think anyone has changed
    the parms since DB2 V 7.1 was installed last year. Anyway, I found in
    the manuals that program DSN8ED7 can be used to obtain the parms from an
    active system. Then I discovered that program is written in C and we
    don't have the C compiler installed on our system. Does anyone know of
    another program that can provide this information? Something you wrote?
    Shareware?

    I need to make some parm changes and based on what I see I'm hesitant to
    do so until I have a high confidence level of what we are really
    running. Thanks in advance for any help.

    Mory Bindler
    Technical Services Group
    847-647-5123
    [login to unmask email]
    ------------------------------------------------------------------------
    --------- 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

    ---------------------------------------------------------------------------------
    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
    Tina Hilton
    [Random House Bertelsmann Shared Services]
    You can get this infor from Control Center, assuming you have it and DB2
    Connect installed.



    -----Original Message-----
    From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
    Mory Bindler
    Sent: Friday, July 15, 2005 2:46 PM
    To: [login to unmask email]
    Subject: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM



    Hi listers,



    I am a novice DB2 systems person who just subscribed to the list today, so I
    haven't had a chance to look at the archives yet. Forgive me if this question
    has been discussed here before.



    There seems to be differences between the zparms in my current version of the
    ...SDSNSAMP library member DSNTIJUZ and the current parms as reported by CA's
    RC/Query software. Some of the differences may be due to how the values are
    being reported. I don't think anyone has changed the parms since DB2 V 7.1
    was installed last year. Anyway, I found in the manuals that program DSN8ED7
    can be used to obtain the parms from an active system. Then I discovered that
    program is written in C and we don't have the C compiler installed on our
    system. Does anyone know of another program that can provide this
    information? Something you wrote? Shareware?



    I need to make some parm changes and based on what I see I'm hesitant to do
    so until I have a high confidence level of what we are really running.
    Thanks in advance for any help.



    Mory Bindler
    Technical Services Group
    847-647-5123
    [login to unmask email]

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

    ---------------------------------------------------------------------------------
    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
    Richard Humphris
    [CNA]

    Btw, CA's insight/DB2 help is much better than the RC/Query help.

    So if you have Insight, I'd look at the zparms there instead (using
    option path 1.6.3). Nice thing about Insight is you can put the cursor
    on a item and press PF1 and get all kinds of information about what that
    field/number means. Often times, CA uses different label names than IBM
    does; but in Insight they'll tell you the CA name, the IBM name and
    where they derived that number from... very useful information.

    Rich Humphris


    -----Original Message-----
    From: DB2 Data Base Discussion List [mailto:[login to unmask email]
    On Behalf Of Mory Bindler
    Sent: Friday, July 15, 2005 2:46 PM
    To: [login to unmask email]
    Subject: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM


    Hi listers,

    I am a novice DB2 systems person who just subscribed to the list
    today, so I haven't had a chance to look at the archives yet. Forgive me
    if this question has been discussed here before.

    There seems to be differences between the zparms in my current
    version of the ...SDSNSAMP library member DSNTIJUZ and the current parms
    as reported by CA's RC/Query software. Some of the differences may be
    due to how the values are being reported. I don't think anyone has
    changed the parms since DB2 V 7.1 was installed last year. Anyway, I
    found in the manuals that program DSN8ED7 can be used to obtain the
    parms from an active system. Then I discovered that program is written
    in C and we don't have the C compiler installed on our system. Does
    anyone know of another program that can provide this information?
    Something you wrote? Shareware?

    I need to make some parm changes and based on what I see I'm
    hesitant to do so until I have a high confidence level of what we are
    really running. Thanks in advance for any help.

    Mory Bindler
    Technical Services Group
    847-647-5123
    [login to unmask email]

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



    E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the
    addressee(s) and may contain confidential and/or legally privileged information. If you are not the
    intended recipient of this message or if this message has been addressed to you in error, please
    immediately alert the sender by reply e-mail and then delete this message and any attachments. If you
    are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or
    storage of this message or any attachment is strictly prohibited.

    ---------------------------------------------------------------------------------
    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
    HEPP SHERY C


    If you have Visual Explain (it's a free download from IBM) you can
    browse the db2 zparms. You'll need db2 connect though. You should be
    able to find it out on the download screen on the ibm z/0s db2 website





    -----Original Message-----
    From: DB2 Data Base Discussion List [mailto:[login to unmask email]
    On Behalf Of Mory Bindler
    Sent: Friday, July 15, 2005 2:46 PM
    To: [login to unmask email]
    Subject: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM

    Hi listers,



    I am a novice DB2 systems person who just subscribed to the list
    today, so I haven't had a chance to look at the archives yet. Forgive me
    if this question has been discussed here before.



    There seems to be differences between the zparms in my current
    version of the ...SDSNSAMP library member DSNTIJUZ and the current parms
    as reported by CA's RC/Query software. Some of the differences may be
    due to how the values are being reported. I don't think anyone has
    changed the parms since DB2 V 7.1 was installed last year. Anyway, I
    found in the manuals that program DSN8ED7 can be used to obtain the
    parms from an active system. Then I discovered that program is written
    in C and we don't have the C compiler installed on our system. Does
    anyone know of another program that can provide this information?
    Something you wrote? Shareware?



    I need to make some parm changes and based on what I see I'm
    hesitant to do so until I have a high confidence level of what we are
    really running. Thanks in advance for any help.



    Mory Bindler
    Technical Services Group
    847-647-5123
    [login to unmask email]

    E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and
    any attachments are intended solely for the
    addressee(s) and may contain confidential and/or legally privileged
    information. If you are not the
    intended recipient of this message or if this message has been addressed
    to you in error, please
    immediately alert the sender by reply e-mail and then delete this
    message and any attachments. If you
    are not the intended recipient, you are notified that any use,
    dissemination, distribution, copying, or
    storage of this message or any attachment is strictly prohibited.

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

    ---------------------------------------------------------------------------------
    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
    Gerald Hodge
    [HLS Technologies,Inc.]
    _____

    From: Gerald Hodge [mailto:[login to unmask email]
    Sent: Friday, July 15, 2005 8:08 PM
    To: 'DB2 Database Discussion list at IDUG'
    Subject: RE: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM



    Mory:



    There are some differences between what Visual Explain and HLS Describe
    offer. Both are free. Both use DSNWZP, which is a Store Procedure available
    in V8 and V7. Both use DB2 Connect. DSNWZP will return any public field
    from the DSNZPARMs. HLS Describe provides explanations for all the fields
    returned, while Visual Explain does not. HLS Describe provides the JAVA JAR
    file that is the desktop program that connects to DB2, calls DSNWZP and
    returns the values to your desktop. If you are interested in how this works
    then HLS Describe will show you the code.

    This is just one of the free programs available on the web site.

    If you have any questions contact me at 888-494-9019, Monday through Friday
    9 Am to 5 PM CST..



    Gerald Hodge

    HLS Technologies, Inc.



    E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any
    attachments are intended solely for the
    addressee(s) and may contain confidential and/or legally privileged
    information. If you are not the
    intended recipient of this message or if this message has been addressed to
    you in error, please
    immediately alert the sender by reply e-mail and then delete this message
    and any attachments. If you
    are not the intended recipient, you are notified that any use,
    dissemination, distribution, copying, or
    storage of this message or any attachment is strictly prohibited.

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

    ---------------------------------------------------------------------------------
    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
    Rob --- Sr. Database Administrator --- CFS Crane
    Since you seem to have CA products....You can also get zparm info from
    CA's Subsystem Analyzer, under additional options. Are you sure you are
    looking at the correct DSNSAMP library?



    -----Original Message-----
    From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
    Behalf Of Humphris,Richard P.
    Sent: Friday, July 15, 2005 2:48 PM
    To: [login to unmask email]
    Subject: Re: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM



    Btw, CA's insight/DB2 help is much better than the RC/Query help.



    So if you have Insight, I'd look at the zparms there instead (using
    option path 1.6.3). Nice thing about Insight is you can put the cursor
    on a item and press PF1 and get all kinds of information about what that
    field/number means. Often times, CA uses different label names than IBM
    does; but in Insight they'll tell you the CA name, the IBM name and
    where they derived that number from... very useful information.



    Rich Humphris



    -----Original Message-----
    From: DB2 Data Base Discussion List [mailto:[login to unmask email]
    On Behalf Of Mory Bindler
    Sent: Friday, July 15, 2005 2:46 PM
    To: [login to unmask email]
    Subject: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM

    Hi listers,



    I am a novice DB2 systems person who just subscribed to the list
    today, so I haven't had a chance to look at the archives yet. Forgive me
    if this question has been discussed here before.



    There seems to be differences between the zparms in my current
    version of the ...SDSNSAMP library member DSNTIJUZ and the current parms
    as reported by CA's RC/Query software. Some of the differences may be
    due to how the values are being reported. I don't think anyone has
    changed the parms since DB2 V 7.1 was installed last year. Anyway, I
    found in the manuals that program DSN8ED7 can be used to obtain the
    parms from an active system. Then I discovered that program is written
    in C and we don't have the C compiler installed on our system. Does
    anyone know of another program that can provide this information?
    Something you wrote? Shareware?



    I need to make some parm changes and based on what I see I'm
    hesitant to do so until I have a high confidence level of what we are
    really running. Thanks in advance for any help.



    Mory Bindler
    Technical Services Group
    847-647-5123
    [login to unmask email]


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

    E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and
    any attachments are intended solely for the
    addressee(s) and may contain confidential and/or legally privileged
    information. If you are not the
    intended recipient of this message or if this message has been addressed
    to you in error, please
    immediately alert the sender by reply e-mail and then delete this
    message and any attachments. If you
    are not the intended recipient, you are notified that any use,
    dissemination, distribution, copying, or
    storage of this message or any attachment is strictly prohibited.

    ------------------------------------------------------------------------
    --------- 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 message contains information that is confidential
    and proprietary to FedEx Freight or its affiliates.
    It is intended only for the recipient named and for
    the express purpose(s) described therein.
    Any other use is prohibited.
    *******************************************************


    ---------------------------------------------------------------------------------
    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
    Nguyen Duc Tuan
    [euroclear]
    "db2 update" archive has a freeware based only on assembler that can
    regenerate your zparms macro from the current zparm module

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