-SET SYSPARM [RELOAD]

David Booher

-SET SYSPARM [RELOAD]
Hello Listers,

I've been looking at the -SET SYSPARM RELOAD command to refresh to DSNZPARM load module in DB2.   Is there a definitive list as to which ZPARM variable values will take effect immediately?  It seems to me that some of these variables should only take effect after a re-cycling of the SUBSYSTEM, but the DOC is unclear.

Thanks,
David Booher

---------------------------------------------------------------------------------
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: -SET SYSPARM [RELOAD]
(in response to David Booher)
DB2 Instalation Guide Appendix 2 has a table with all the ZPARM and HDECP values.
One of the columns in the table indicates if the value can be updated online.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of David Booher
Sent: Tuesday, January 11, 2005 10:37 AM
To: [login to unmask email]
Subject: [DB2-L] -SET SYSPARM [RELOAD]

Hello Listers,

I've been looking at the -SET SYSPARM RELOAD command to refresh to DSNZPARM load module in DB2. Is there a definitive list as to which ZPARM variable values will take effect immediately? It seems to me that some of these variables should only take effect after a re-cycling of the SUBSYSTEM, but the DOC is unclear.

Thanks,
David Booher

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

David Booher

Re: -SET SYSPARM [RELOAD]
(in response to Avram Friedman)
That's exactly what I was looking for (my book says Appendix B).

Thanks!

David Booher


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Friedman, Avram (IT)
Sent: Tuesday, January 11, 2005 9:44 AM
To: [login to unmask email]
Subject: Re: [DB2-L] -SET SYSPARM [RELOAD]

DB2 Instalation Guide Appendix 2 has a table with all the ZPARM and
HDECP values.
One of the columns in the table indicates if the value can be updated

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