GETTING ZPARMS FROM RUNNING DB2 SYSTEM

Mory Bindler

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

Carol L Broyles

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to Steen Rasmussen)
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

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to Mory Bindler)
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

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to Carol L Broyles)
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

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to Tina Hilton)

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

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to Richard Humphris)


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

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to HEPP SHERY C)
_____

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

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to Gerald Hodge)
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

Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM
(in response to Rob --- Sr. Database Administrator --- CFS Crane)
"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