DSNZPARM basic doubt ....

Raquel Rodriguez

DSNZPARM basic doubt ....
Our sysprog is on a long leave so I need to perform a
change in the DSNZPARM. Had a basic doubt regarding
this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above
ZPARM.

To change the value of this parameter, I am planning
to Run DSNTINST Clist with Install Type UPDATE,
navigate to the appropriate panel and change the value
of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new
DSNZPARM.

Now my question is: How do we ensure in this process
that some of the values that might have been changed
(by the systems DBA) are not overwritten by my
changes….in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of
various parameters (and not some default values or any
other values). How does DSNTINST pick up the values
corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

---------------------------------------------------------------------------------
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: DSNZPARM basic doubt ....
(in response to Raquel Rodriguez)
Have you looked at your HLQ.SDSNSAMP(DSNTIJUZ) member to see what changes are reflected? Many sysprogs don't go back to the panels once they have JCL they can manipulate. You might be able to use that approach, go to the most recently changed DSNTIJUZ member, make your changes, compile and then -SET SYSPARM LOAD(yourzparm) or cycle DB2 depending on the change you are making(if it is not an online change). Back up the DSNTIJUZ member before you change it, etc.

This is assuming your shop is not using a 3rd vendor tool to manipulate the zparms.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Raquel Rodriguez
Sent: Monday, November 29, 2004 10:57 AM
To: [login to unmask email]
Subject: DSNZPARM basic doubt ....

Our sysprog is on a long leave so I need to perform a
change in the DSNZPARM. Had a basic doubt regarding
this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above
ZPARM.

To change the value of this parameter, I am planning
to Run DSNTINST Clist with Install Type UPDATE,
navigate to the appropriate panel and change the value
of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new
DSNZPARM.

Now my question is: How do we ensure in this process
that some of the values that might have been changed
(by the systems DBA) are not overwritten by my
changes....in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of
various parameters (and not some default values or any
other values). How does DSNTINST pick up the values
corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

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

Cathy Taddei

Re: DSNZPARM basic doubt ....
(in response to Rob --- Sr. Database Administrator --- CFS Crane)
My answer pertains to DB2 for OS390/zOS, version 7 and prior. When you
first install DB2, you typically supply DSNTIDXA for Input Member Name
on panel DSNTIPA1, which contains the default values. Besides a new
DSNTIJUZ member, the Clist also creates a new DSNTIDxx member, whatever
name you supplied for the Output Member Name on panel DSNTIPA1. It
places this member in the source SDSNSAMP instead of the edited JCL
dataset where it places DSNTIJUZ. Upon subsequent runs of the clist,
you supply the updated member name for Input Member Name, and supply
either that same name or yet another new name for Output Member Name.

To make sure nothing has unintentionally changed, back up both the old
DSNTIDxx member and the old DSNTIJUZ, and then compare them after you
run the clist. Alternatively, you can manually update the old DSNTIJUZ
member and run it, without going through the clist, and leave a message
for your sysprog so they can run the clist or manually update DSNTIDxx.
It would also be polite to put comments in your DSNTIJUZ describing
which approach you took and what was updated.

Regards,
Cathy

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Raquel Rodriguez
Sent: Monday, November 29, 2004 9:57 AM
To: [login to unmask email]
Subject: DSNZPARM basic doubt ....

Our sysprog is on a long leave so I need to perform a
change in the DSNZPARM. Had a basic doubt regarding
this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above
ZPARM.

To change the value of this parameter, I am planning
to Run DSNTINST Clist with Install Type UPDATE,
navigate to the appropriate panel and change the value
of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new
DSNZPARM.

Now my question is: How do we ensure in this process
that some of the values that might have been changed
(by the systems DBA) are not overwritten by my
changes....in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of
various parameters (and not some default values or any
other values). How does DSNTINST pick up the values
corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

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

Jeff Frazier

Re: DSNZPARM basic doubt ....
(in response to Avram Friedman)
Raquel, first of all check and see if there is an already customized ZPARM
called dsntijuz within an install lib. also some of the parms are dynamic
by using the db2 command -set sysparm once you have assembled and linked
dsnzparm. I'm assuming you are V7 by the way. the list of updatable parms
are in Command Reference Appendix A. We very rarely use the install clist
once we are migrated to update zparm. i keep a customized zparm member
within an install library for each subsystem and when i make a change to a
parm i document it within the JCL as to the parm, from value, to value ,
date, etc.




Raquel Rodriguez <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
11/29/2004 12:57 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: DSNZPARM basic doubt ....


Our sysprog is on a long leave so I need to perform a
change in the DSNZPARM. Had a basic doubt regarding
this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above
ZPARM.

To change the value of this parameter, I am planning
to Run DSNTINST Clist with Install Type UPDATE,
navigate to the appropriate panel and change the value
of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new
DSNZPARM.

Now my question is: How do we ensure in this process
that some of the values that might have been changed
(by the systems DBA) are not overwritten by my
changes?.in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of
various parameters (and not some default values or any
other values). How does DSNTINST pick up the values
corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

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

Avram Friedman

Re: DSNZPARM basic doubt ....
(in response to Cathy Taddei)
I would suggest starting by reviewing two things
1. Look at the latest (or only) *.NEW.SDSNSAMP
Is there one member or many members
If many, and there have been frequent ZPARM updates your shop
probally does not use the install CLIST for updates.
2. Look at *.SDSNSAMP
Are there any updater footprints on the member list?
The issue here is the install CLIST stores the CLIST variables
as a member in SDSNSAMP (not NEW.SDSNSAMP)

If you use the install CLIST for doing updates the old list of saved
CLIST variables is entered on
Line 7 of the main pannel and the new member is entered on line 8.

IBM provides a sample stored procedure for listing the actual current
ZPARM values
DSNWZP
If you are concerned about starting with the correct values install and
run DSNWZP and compare it to the output of the install CLIST.


A bit off the subject,
A.) How long is your DB2 Systems Programmer going to be away?
B.) Why can't your change wait?
C.) What is the change?

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Raquel Rodriguez
Sent: Monday, November 29, 2004 12:57 PM
To: [login to unmask email]
Subject: DSNZPARM basic doubt ....

Our sysprog is on a long leave so I need to perform a change in the
DSNZPARM. Had a basic doubt regarding this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above ZPARM.

To change the value of this parameter, I am planning to Run DSNTINST
Clist with Install Type UPDATE, navigate to the appropriate panel and
change the value of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new DSNZPARM.

Now my question is: How do we ensure in this process that some of the
values that might have been changed (by the systems DBA) are not
overwritten by my changes....in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of various parameters
(and not some default values or any other values). How does DSNTINST
pick up the values corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

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

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and 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

Venkatesh Mokshagundam

Re: DSNZPARM basic doubt ....
(in response to Jeff Frazier)

Raquel, you're right, the CLIST generates DSNTIJUZ.

The way I do it, I rename the current one to DSNTIJUB and run the install
CLIST. I know I have added some parms (SMSDCFL, SMSDCIX, TSQTY, IXQTY,
UTLRSTRT etc) which are not available thru the CLIST. So, after I generate
the new Job DSNTIJUZ with the CLIST, I compare the old and the two members
(just a simple ISPF compare using 3.13) and make sure I have retro-fitted
all the parms.

Other way is to make the change while your SYSPROG is to directly update the
DSNTIJUZ member and make sure you let him know what you changed when he's
back so he can update the CLIST.

You can also use the original as the input and a different member name for
the output in the install CLIST in UPDATE mode. This way, you'll not
overwrite the input (I think this is generally the defauly, but, I could be
wrong). You also have to make sure you let your sysprog know to make your
changes in their input member so they don't lose your latest changes.

I'm sure there are many other ways to do this, but, hope this will give you
a start....

Venkatesh

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Raquel Rodriguez
Sent: Monday, November 29, 2004 11:57 AM
To: [login to unmask email]
Subject: DSNZPARM basic doubt ....


Our sysprog is on a long leave so I need to perform a
change in the DSNZPARM. Had a basic doubt regarding
this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above
ZPARM.

To change the value of this parameter, I am planning
to Run DSNTINST Clist with Install Type UPDATE,
navigate to the appropriate panel and change the value
of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new
DSNZPARM.

Now my question is: How do we ensure in this process
that some of the values that might have been changed
(by the systems DBA) are not overwritten by my
changes....in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of
various parameters (and not some default values or any
other values). How does DSNTINST pick up the values
corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

----------------------------------------------------------------------------
-----
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 communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.

Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.

---------------------------------------------------------------------------------
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: DSNZPARM basic doubt ....
(in response to Venkatesh Mokshagundam)
Be careful using DSNTIJUZ, though. It also reassembles/links DSNHDECP as
well as updates the bootstrap with DDF information. You should only run the
steps for DSNZPARM.



Tina



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
Jeff Frazier
Sent: Monday, November 29, 2004 1:23 PM
To: [login to unmask email]
Subject: Re: DSNZPARM basic doubt ....




Raquel, first of all check and see if there is an already customized ZPARM
called dsntijuz within an install lib. also some of the parms are dynamic by
using the db2 command -set sysparm once you have assembled and linked
dsnzparm. I'm assuming you are V7 by the way. the list of updatable parms are
in Command Reference Appendix A. We very rarely use the install clist once we
are migrated to update zparm. i keep a customized zparm member within an
install library for each subsystem and when i make a change to a parm i
document it within the JCL as to the parm, from value, to value , date, etc.






Raquel Rodriguez <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

11/29/2004 12:57 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: DSNZPARM basic doubt ....




Our sysprog is on a long leave so I need to perform a
change in the DSNZPARM. Had a basic doubt regarding
this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above
ZPARM.

To change the value of this parameter, I am planning
to Run DSNTINST Clist with Install Type UPDATE,
navigate to the appropriate panel and change the value
of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new
DSNZPARM.

Now my question is: How do we ensure in this process
that some of the values that might have been changed
(by the systems DBA) are not overwritten by my
changes....in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of
various parameters (and not some default values or any
other values). How does DSNTINST pick up the values
corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

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

Jeff Frazier

Re: DSNZPARM basic doubt ....
(in response to Tina Hilton)
True and that is why i create 2 members, one for zparm and 1 for hdecp and
then make all updates thru those members. it is also a good idea as i said
to document the changes as well as the reason for change even if its a PTF
adding a parm to zparm.
Jeff




"Hilton, Tina" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
11/29/2004 01:54 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: Re: DSNZPARM basic doubt ....




Be careful using DSNTIJUZ, though. It also reassembles/links DSNHDECP as
well as updates the bootstrap with DDF information. You should only run
the steps for DSNZPARM.



Tina



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Jeff Frazier
Sent: Monday, November 29, 2004 1:23 PM
To: [login to unmask email]
Subject: Re: DSNZPARM basic doubt ....




Raquel, first of all check and see if there is an already customized ZPARM
called dsntijuz within an install lib. also some of the parms are dynamic
by using the db2 command -set sysparm once you have assembled and linked
dsnzparm. I'm assuming you are V7 by the way. the list of updatable parms
are in Command Reference Appendix A. We very rarely use the install clist
once we are migrated to update zparm. i keep a customized zparm member
within an install library for each subsystem and when i make a change to a
parm i document it within the JCL as to the parm, from value, to value ,
date, etc.






Raquel Rodriguez <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

11/29/2004 12:57 PM
Please respond to DB2 Database Discussion list at IDUG



To: [login to unmask email]
cc:
Subject: DSNZPARM basic doubt ....





Our sysprog is on a long leave so I need to perform a
change in the DSNZPARM. Had a basic doubt regarding
this. Our current ZPARM module in
DSN710.DSNT.SDSNEXIT(DSNZPARM).

I need to change a parameter (say PARM1) in the above
ZPARM.

To change the value of this parameter, I am planning
to Run DSNTINST Clist with Install Type UPDATE,
navigate to the appropriate panel and change the value
of PARM1. My understanding is that it will result in a
DSNTIJUZ JCL which I need to submit to create a new
DSNZPARM.

Now my question is: How do we ensure in this process
that some of the values that might have been changed
(by the systems DBA) are not overwritten by my
changes?.in other words, where do we tell DSNTINST
Clist to pick up the only the most current values of
various parameters (and not some default values or any
other values). How does DSNTINST pick up the values
corresponding to the current
DSN710.DSNT.SDSNEXIT(DSNZPARM)? Hope I am clear.

TIA
Raquel.



__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

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

Cathy Taddei

Re: DSNZPARM basic doubt ....
(in response to Jeff Frazier)
Venkatesh raises a good point, that not all parms are available through
the clist. You should always compare the output generated to the most
recent DSNTIJUZ to make sure that the only difference is the change you
intended. And as Tina pointed out, run only the needed step(s).

It is a good practice to run the install clist to keep your DSNTIDxx
member up to date, because when you upgrade to the next release, that
member will be input to the new install clist. It can get really messy
to try to compare a new DSNTIJUZ to your old one from a prior version.
Sometimes values will change, such as PARM= 1 becoming PARM= YES in a
new version of DB2, and with all the other changes due to the version
change, it can be a challenge to ensure you haven't missed a
customization. I have tried it both ways, and now I keep my DSNTIDxx
member up to date, either by directly updating it (careful doing this,
because sometimes the scales are different, i.e. a value given in bytes
in DSNTIDxx might be kilobytes in DSNTIJUZ), or by going through the
install clist (the safest way).

Regards,
Cathy


------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

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

Bob Jeandron

Re: DSNZPARM basic doubt ....
(in response to Cathy Taddei)
Be careful with update. I deleted the output sdsnsamp DSN the first time I
ran it. Don't know if it will still do that. We generate it once at
installation then just edit the parms. We include the date, values before
and after in a comment. Then just run the assemble and link of dsnzparm
only, not dsnhdecp or anything else.
If you do the update, put the new dsntijuz into a new sdsnsamp remove all
but assemble and link of zparm and send an email to the sysprog. The only
time I know of that you may get into trouble is if you change a parm which
is used is a calculation by the CLIST. The calculated values are on the
last panel during install, dsntipc "....-CLIST CALCULATIONS -...".
If you can logon to their ID they use during Install, the field values are
probably kept in their ISPF profile, ie. they will be filled in when you
start the clist. Good Luck.
Backups/renames are good.

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

Robin Willoughby

Re: DSNZPARM basic doubt ....
(in response to Bob Jeandron)
and just to add to all the belt and braces good advice you may want to run
something like stored procedure DSNWZP or have a look in your DB2 monitor
and record your current running Zparms for the subsystem....(there's
guarantee what you think is the source for your Zparms actually is the
source of what is running )

cheers,

Robin

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

Raquel Rodriguez

Re: DSNZPARM basic doubt ....
(in response to Robin Willoughby)
Thanks to Rob Crane, Cathy, Avram, Jeff Frazier,
Venkatesh, Tina Hilton,
Bob Jeandron and Robin for your extremely helpful
insights. I was able
to generate the new DSNZPARM.

The Sysprog will not be here for the next one month. I
needed to change
the CACHEDYN parameter from NO to YES. The reason for
this urgent
change
request is because lately, our developers are
performing QMF queries
almost round the clock and as a result, the DBAs are
not able to run
any
DDLs against any tablespace on those databases. With
CACHEDYN=YES, for
the most part, QMF queries do not lock DBD in Shared
mode and so, we
(DBAs) are hopeful that we will be able to run the
DDLs. And yes, I
will
monitor EDMPOOL usage to see if this has any untoward
influence.

One related question. As suggested by esteemed
listers, I changed
CACHEDYN using the Panels and this resulted in a new
DSNTID1A member in
DSN710.SDSNSAMP. Then I compared this newly generated
DSNTID1A member
with the 'original' DSNTID1A member (DSNTID1A member
before the
change).
As expected, the comparison showed that CACHEDYN was
changed from NO to
YES, but in addition, it showed the following
differences:

I - OVEDMDS CHAR M NONE NONE NULL

D - OVEDMDS CHAR M NONE NONE 0

I - OVEDMDSM CHAR M NONE NONE NULL

D - OVEDMDSM CHAR M NONE NONE 0


OVEDMDS and OVEDMDSM were NULL in the original
DSNTID1A and these
changed to 0 in the newly generated DSNTID1A. Does
anyone know what
OVEDMDS and OVEDMDSM are? No entries for OVEDMDS and
OVEDMDSM were
found
in the generated DSNTIJUZ members; also couldn't find
any references
for
these parameters in the DB2 bookshelf.

TIA
Raquel.

--- Robin WIlloughby <[login to unmask email]>
wrote:

> and just to add to all the belt and braces good
> advice you may want to run
> something like stored procedure DSNWZP or have a
> look in your DB2 monitor
> and record your current running Zparms for the
> subsystem....(there's
> guarantee what you think is the source for your
> Zparms actually is the
> source of what is running )
>
> cheers,
>
> Robin
>
>
---------------------------------------------------------------------------------
> 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
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Cathy Taddei

Re: DSNZPARM basic doubt ....
(in response to Raquel Rodriguez)
I have not been able to find the DSNTIDxx parms documented anywhere.
IBM clearly intends for us to use the install clist and "pay no
attention to the man behind the curtain", to quote the Wizard of Oz.
However, I would guess that OVEDMDS is the override value you filled in
for EDMDSPAC, and OVEDMDSM is the override value for EDMDSMAX. Mine are
both still NULL, even though I have CACHEDYN=YES, because I accepted the
calculated values for those in the install clist. However I did
override EDMPOOL, so I have that value plugged in for OVEDMPL in my
DSNTIDxx member.

It makes sense that the clist would update these values -- they were
meaningless before dynamic caching, but now their values indicate that
you chose not to use a data space for the dynamic cache. Did the clist
calculate values for EDMPOOL DATA SPACE SIZE and EDMPOOL DATA SPACE MAX
on panel DSNTIPC, and did you type 0 in the override column? I would
strongly suggest NOT using 0 for the dataspace values -- run the clist
again, and blank out the override column, and then it will use whatever
it calculates (assuming those values that it calculates are not 0).

Regards,
Cathy

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Raquel Rodriguez
Sent: Thursday, December 02, 2004 9:58 AM
To: [login to unmask email]
Subject: Re: DSNZPARM basic doubt ....

Thanks to Rob Crane, Cathy, Avram, Jeff Frazier,
Venkatesh, Tina Hilton,
Bob Jeandron and Robin for your extremely helpful
insights. I was able
to generate the new DSNZPARM.

The Sysprog will not be here for the next one month. I
needed to change
the CACHEDYN parameter from NO to YES. The reason for
this urgent
change
request is because lately, our developers are
performing QMF queries
almost round the clock and as a result, the DBAs are
not able to run
any
DDLs against any tablespace on those databases. With
CACHEDYN=YES, for
the most part, QMF queries do not lock DBD in Shared
mode and so, we
(DBAs) are hopeful that we will be able to run the
DDLs. And yes, I
will
monitor EDMPOOL usage to see if this has any untoward
influence.

One related question. As suggested by esteemed
listers, I changed
CACHEDYN using the Panels and this resulted in a new
DSNTID1A member in
DSN710.SDSNSAMP. Then I compared this newly generated
DSNTID1A member
with the 'original' DSNTID1A member (DSNTID1A member
before the
change).
As expected, the comparison showed that CACHEDYN was
changed from NO to
YES, but in addition, it showed the following
differences:

I - OVEDMDS CHAR M NONE NONE NULL

D - OVEDMDS CHAR M NONE NONE 0

I - OVEDMDSM CHAR M NONE NONE NULL

D - OVEDMDSM CHAR M NONE NONE 0


OVEDMDS and OVEDMDSM were NULL in the original
DSNTID1A and these
changed to 0 in the newly generated DSNTID1A. Does
anyone know what
OVEDMDS and OVEDMDSM are? No entries for OVEDMDS and
OVEDMDSM were
found
in the generated DSNTIJUZ members; also couldn't find
any references
for
these parameters in the DB2 bookshelf.

TIA
Raquel.

--- Robin WIlloughby <[login to unmask email]>
wrote:

> and just to add to all the belt and braces good
> advice you may want to run
> something like stored procedure DSNWZP or have a
> look in your DB2 monitor
> and record your current running Zparms for the
> subsystem....(there's
> guarantee what you think is the source for your
> Zparms actually is the
> source of what is running )
>
> cheers,
>
> Robin
>
>
------------------------------------------------------------------------
---------
> 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
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

------------------------------------------------------------------------
---------
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 is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

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

Raquel Rodriguez

Re: DSNZPARM basic doubt ....
(in response to Cathy Taddei)
Very good catch Cathy. That indeed was the case. We
have decided not to
use Data spaces as yet (until our OS is upgraded) and
hence the reason
had to override EDMPOOL DATA SPACE SIZE and EDMPOOL
DATA SPACE MAX to
zero.

Thanks,
Raquel.

--- "Taddei, Cathy" <[login to unmask email]>
wrote:

> I have not been able to find the DSNTIDxx parms
> documented anywhere.
> IBM clearly intends for us to use the install clist
> and "pay no
> attention to the man behind the curtain", to quote
> the Wizard of Oz.
> However, I would guess that OVEDMDS is the override
> value you filled in
> for EDMDSPAC, and OVEDMDSM is the override value for
> EDMDSMAX. Mine are
> both still NULL, even though I have CACHEDYN=YES,
> because I accepted the
> calculated values for those in the install clist.
> However I did
> override EDMPOOL, so I have that value plugged in
> for OVEDMPL in my
> DSNTIDxx member.
>
> It makes sense that the clist would update these
> values -- they were
> meaningless before dynamic caching, but now their
> values indicate that
> you chose not to use a data space for the dynamic
> cache. Did the clist
> calculate values for EDMPOOL DATA SPACE SIZE and
> EDMPOOL DATA SPACE MAX
> on panel DSNTIPC, and did you type 0 in the override
> column? I would
> strongly suggest NOT using 0 for the dataspace
> values -- run the clist
> again, and blank out the override column, and then
> it will use whatever
> it calculates (assuming those values that it
> calculates are not 0).
>
> Regards,
> Cathy
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On
> Behalf Of Raquel Rodriguez
> Sent: Thursday, December 02, 2004 9:58 AM
> To: [login to unmask email]
> Subject: Re: DSNZPARM basic doubt ....
>
> Thanks to Rob Crane, Cathy, Avram, Jeff Frazier,
> Venkatesh, Tina Hilton,
> Bob Jeandron and Robin for your extremely helpful
> insights. I was able
> to generate the new DSNZPARM.
>
> The Sysprog will not be here for the next one month.
> I
> needed to change
> the CACHEDYN parameter from NO to YES. The reason
> for
> this urgent
> change
> request is because lately, our developers are
> performing QMF queries
> almost round the clock and as a result, the DBAs are
> not able to run
> any
> DDLs against any tablespace on those databases. With
> CACHEDYN=YES, for
> the most part, QMF queries do not lock DBD in Shared
> mode and so, we
> (DBAs) are hopeful that we will be able to run the
> DDLs. And yes, I
> will
> monitor EDMPOOL usage to see if this has any
> untoward
> influence.
>
> One related question. As suggested by esteemed
> listers, I changed
> CACHEDYN using the Panels and this resulted in a new
> DSNTID1A member in
> DSN710.SDSNSAMP. Then I compared this newly
> generated
> DSNTID1A member
> with the 'original' DSNTID1A member (DSNTID1A member
> before the
> change).
> As expected, the comparison showed that CACHEDYN was
> changed from NO to
> YES, but in addition, it showed the following
> differences:
>
> I - OVEDMDS CHAR M NONE NONE NULL
>
> D - OVEDMDS CHAR M NONE NONE 0
>
> I - OVEDMDSM CHAR M NONE NONE NULL
>
> D - OVEDMDSM CHAR M NONE NONE 0
>
>
> OVEDMDS and OVEDMDSM were NULL in the original
> DSNTID1A and these
> changed to 0 in the newly generated DSNTID1A. Does
> anyone know what
> OVEDMDS and OVEDMDSM are? No entries for OVEDMDS and
> OVEDMDSM were
> found
> in the generated DSNTIJUZ members; also couldn't
> find
> any references
> for
> these parameters in the DB2 bookshelf.
>
> TIA
> Raquel.
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Charles Crockett

Re: DSNZPARM basic doubt ....
(in response to Raquel Rodriguez)
You learned well my child, you are now amoung the masters....

CC

P.S. If only I was up to date on this list (and at a shop where I got
to do things, oh well, the pay is ok)

Charles Crockett D1
DB2 Contractor assigned to
Information Technology Services
Wisconsin Public Service Corp
(920) 433-2258 (voice)
(920) 433-5747 (fax)
e-mail: [login to unmask email]


>>> [login to unmask email] 11/29/04 01:05PM >>>
Venkatesh raises a good point, that not all parms are available
through
the clist. You should always compare the output generated to the most
recent DSNTIJUZ to make sure that the only difference is the change
you
intended. And as Tina pointed out, run only the needed step(s).

It is a good practice to run the install clist to keep your DSNTIDxx
member up to date, because when you upgrade to the next release, that
member will be input to the new install clist. It can get really
messy
to try to compare a new DSNTIJUZ to your old one from a prior version.
Sometimes values will change, such as PARM= 1 becoming PARM= YES in
a
new version of DB2, and with all the other changes due to the version
change, it can be a challenge to ensure you haven't missed a
customization. I have tried it both ways, and now I keep my DSNTIDxx
member up to date, either by directly updating it (careful doing this,
because sometimes the scales are different, i.e. a value given in
bytes
in DSNTIDxx might be kilobytes in DSNTIJUZ), or by going through the
install clist (the safest way).

Regards,
Cathy


------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone
else, unless expressly approved by the sender or an authorized
addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying,
distribution or any action omitted or taken in reliance on it, is
prohibited and may be unlawful. If you believe that you have received
this email in error, please contact the sender, delete this e-mail and
destroy all copies.

=====

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