SET SYSPARM - DSNZPARM

Anthony Ray Gould

SET SYSPARM - DSNZPARM
We are trying to install a new DSNZPARM module without bringing down DB2
after changing SMSDCFL SMSDCIX.

We reassembled the DSNZPARM (Called it a different name) and issued:

-SET SYSPARM LOAD (DSNZ00X);

The command is come back saying it was successful.

When we look at our activity monitor (BMC AM) we still see the old
settings for:

SMSDCFL
SMSDCIX

Are we doing something wrong or is there a known problem with changing
the SMS Dataclass names for tablespaces and indexes in the DSNZPARM and
being able to load the new DSNZPARM module without shutting down DB2?

I have looked at the DB2-L archive and the DB2 APAR database and found
nothing related to this problem.

Thanks.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Michael Ebert

Re: SET SYSPARM - DSNZPARM
(in response to Jeff Frazier)
Only some ZPARMs are online-updatable. The info is a bit difficult to
find: look in Appendix 1.2.2 in the DB2 V7 Installation Guide (Directory
of subsystem parameters and DSNHDECP values). Actually, the online version
lists the online changeability of SMSDCFL and SMSDCIX as neither "yes" or
"no", but as "--". It's anybodys guess what that might mean...

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany



We are trying to install a new DSNZPARM module without bringing down DB2
after changing SMSDCFL SMSDCIX.

We reassembled the DSNZPARM (Called it a different name) and issued:

-SET SYSPARM LOAD (DSNZ00X);

The command is come back saying it was successful.

When we look at our activity monitor (BMC AM) we still see the old
settings for:

SMSDCFL
SMSDCIX

Are we doing something wrong or is there a known problem with changing
the SMS Dataclass names for tablespaces and indexes in the DSNZPARM and
being able to load the new DSNZPARM module without shutting down DB2?

I have looked at the DB2-L archive and the DB2 APAR database and found
nothing related to this problem.

Thanks.


---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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: SET SYSPARM - DSNZPARM
(in response to Anthony Ray Gould)
According to the Command Reference you can not change those 2 parms by the
set sysparm command.




"Gould,Anthony R" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/17/03 11:48 AM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: SET SYSPARM - DSNZPARM


We are trying to install a new DSNZPARM module without bringing down DB2
after changing SMSDCFL SMSDCIX.

We reassembled the DSNZPARM (Called it a different name) and issued:

-SET SYSPARM LOAD (DSNZ00X);

The command is come back saying it was successful.

When we look at our activity monitor (BMC AM) we still see the old
settings for:

SMSDCFL
SMSDCIX

Are we doing something wrong or is there a known problem with changing
the SMS Dataclass names for tablespaces and indexes in the DSNZPARM and
being able to load the new DSNZPARM module without shutting down DB2?

I have looked at the DB2-L archive and the DB2 APAR database and found
nothing related to this problem.

Thanks.

---------------------------------------------------------------------------------
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". If you will be out of
the office, send the SET DB2-L NO MAIL command to
[login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Anthony Ray Gould

Re: SET SYSPARM - DSNZPARM
(in response to Jeff Frazier)
Jeff,

Thanks!

Where did you find that in the Command Reference?

We are v7.1 OS/390.

A search on SMSDCFL showed only a reference to appendix A - Directory of
subsystem parameters and DSNHDECP values.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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: SET SYSPARM - DSNZPARM
(in response to Anthony Ray Gould)
Anthony, Within Appendix A is a list of zparm values that can or can't be
changed online by SET SYSPARM. We are DB2 V7 and z/OS 1.4.
Regards, Jeff




"Gould,Anthony R" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/17/03 03:21 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: Re: SET SYSPARM - DSNZPARM


Jeff,

Thanks!

Where did you find that in the Command Reference?

We are v7.1 OS/390.

A search on SMSDCFL showed only a reference to appendix A - Directory of
subsystem parameters and DSNHDECP values.

---------------------------------------------------------------------------------
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". If you will be out of
the office, send the SET DB2-L NO MAIL command to
[login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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: SET SYSPARM - DSNZPARM
(in response to Michael Ebert)
Its in the DB2 V7 instalation manual appendix 2

A.2 Directory of subsystem parameters and DSNHDECP values

There is a column in table 13 that says Update online. its value is YES or NO.

"Gould,Anthony R" wrote:

> Jeff,
>
> Thanks!
>
> Where did you find that in the Command Reference?
>
> We are v7.1 OS/390.
>
> A search on SMSDCFL showed only a reference to appendix A - Directory of
> subsystem parameters and DSNHDECP values.
>
> ---------------------------------------------------------------------------------
> 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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: SET SYSPARM - DSNZPARM
(in response to Avram Friedman)
Most of the values with '--' in table 130 of the instalation manual column Update online are part of DSNHDECP. If one followes the hyper link to
the associated doc page they may find a statement like

"Migrating or updating the parameters: If you alter parameter values that specify that a change during migration or update is "not recommended,"
it can make the syntax of existing SQL statements invalid or affect the way application programs run. Update is allowed, but must be handled
with caution."

The way I read this is even if allowed, don't update these values dynamicly.





On Wed, 17 Dec 2003 18:07:21 +0100, Michael Ebert <[login to unmask email]> wrote:

>Only some ZPARMs are online-updatable. The info is a bit difficult to
>find: look in Appendix 1.2.2 in the DB2 V7 Installation Guide (Directory
>of subsystem parameters and DSNHDECP values). Actually, the online version
>lists the online changeability of SMSDCFL and SMSDCIX as neither "yes" or
>"no", but as "--". It's anybodys guess what that might mean...
>
>Dr. Michael Ebert
>DB2 Database Administrator
>aMaDEUS Data Processing
>Erding / Munich, Germany
>
>
>
>We are trying to install a new DSNZPARM module without bringing down DB2
>after changing SMSDCFL SMSDCIX.
>
>We reassembled the DSNZPARM (Called it a different name) and issued:
>
>-SET SYSPARM LOAD (DSNZ00X);
>
>The command is come back saying it was successful.
>
>When we look at our activity monitor (BMC AM) we still see the old
>settings for:
>
>SMSDCFL
>SMSDCIX
>
>Are we doing something wrong or is there a known problem with changing
>the SMS Dataclass names for tablespaces and indexes in the DSNZPARM and
>being able to load the new DSNZPARM module without shutting down DB2?
>
>I have looked at the DB2-L archive and the DB2 APAR database and found
>nothing related to this problem.
>
>Thanks.
>
>
>---------------------------------------------------------------------------------
>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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

[login to unmask email]

Re: SET SYSPARM - DSNZPARM
(in response to Avram Friedman)
Don't forget that you may have to refresh lla after the DSNTIJUZ run if your exit library is link-listed, before you reload the ZPARM ( assuming the parm is update-able online )

Otherwise it might look like your change did not work.


-----Original Message-----
From: Gould,Anthony R [mailto:[login to unmask email]
Sent: Wednesday, December 17, 2003 10:48 AM
To: [login to unmask email]
Subject: SET SYSPARM - DSNZPARM


We are trying to install a new DSNZPARM module without bringing down DB2
after changing SMSDCFL SMSDCIX.

We reassembled the DSNZPARM (Called it a different name) and issued:

-SET SYSPARM LOAD (DSNZ00X);

The command is come back saying it was successful.

When we look at our activity monitor (BMC AM) we still see the old
settings for:

SMSDCFL
SMSDCIX

Are we doing something wrong or is there a known problem with changing
the SMS Dataclass names for tablespaces and indexes in the DSNZPARM and
being able to load the new DSNZPARM module without shutting down DB2?

I have looked at the DB2-L archive and the DB2 APAR database and found
nothing related to this problem.

Thanks.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Leslie Pendlebury-Bowe

Re: SET SYSPARM - DSNZPARM
(in response to jack.oconnell@MCMASTER.COM)
Well I never knew that ... I'm glad I'm on this list.

Nice one Avram.

Les

-----Original Message-----
From: Avram Friedman [mailto:[login to unmask email]
Sent: Wednesday, December 17, 2003 8:59 PM
To: [login to unmask email]
Subject: Re: SET SYSPARM - DSNZPARM


Most of the values with '--' in table 130 of the instalation manual column
Update online are part of DSNHDECP. If one followes the hyper link to
the associated doc page they may find a statement like

"Migrating or updating the parameters: If you alter parameter values that
specify that a change during migration or update is "not recommended,"
it can make the syntax of existing SQL statements invalid or affect the way
application programs run. Update is allowed, but must be handled
with caution."

The way I read this is even if allowed, don't update these values dynamicly.





On Wed, 17 Dec 2003 18:07:21 +0100, Michael Ebert <[login to unmask email]>
wrote:

>Only some ZPARMs are online-updatable. The info is a bit difficult to
>find: look in Appendix 1.2.2 in the DB2 V7 Installation Guide (Directory
>of subsystem parameters and DSNHDECP values). Actually, the online version
>lists the online changeability of SMSDCFL and SMSDCIX as neither "yes" or
>"no", but as "--". It's anybodys guess what that might mean...
>
>Dr. Michael Ebert
>DB2 Database Administrator
>aMaDEUS Data Processing
>Erding / Munich, Germany
>
>
>
>We are trying to install a new DSNZPARM module without bringing down DB2
>after changing SMSDCFL SMSDCIX.
>
>We reassembled the DSNZPARM (Called it a different name) and issued:
>
>-SET SYSPARM LOAD (DSNZ00X);
>
>The command is come back saying it was successful.
>
>When we look at our activity monitor (BMC AM) we still see the old
>settings for:
>
>SMSDCFL
>SMSDCIX
>
>Are we doing something wrong or is there a known problem with changing
>the SMS Dataclass names for tablespaces and indexes in the DSNZPARM and
>being able to load the new DSNZPARM module without shutting down DB2?
>
>I have looked at the DB2-L archive and the DB2 APAR database and found
>nothing related to this problem.
>
>Thanks.
>
>
>---------------------------------------------------------------------------
------
>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". If you will be out of the office, send
the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm


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

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

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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