change of Zparm values

JITINDER CHOUDHARY

change of Zparm values

Hi All,

We are planning to change the zparm values for CDSSRDEF and DSMAX in our environment.

Could you please let us know the command that we need to use for that if any or we need to change in DSNTIJUZ job and submit it and after that we need to use SET SYSPARM RELOAD command.

Thanks in Advance!!!!

 

Javier Estrada Benavides

RE: change of Zparm values
(in response to JITINDER CHOUDHARY)

Hey Jitinder, it's been a while

  If you want to do it the dirty way, you can change CDSSRDEF by changing the dsntijuz member, submitting and executing the command, yep, but in a couple years and hundreds of PTFs applied, you'll realize that it was not a good idea back then.

  As for DSMAX, it's normally calculated for you based on your input on other panels (like the sizes panel), so since you want to change this anyway, I'd recommend follow the normal procedure, which is going through the installation panels to update the CDSSRDEF, and on the last panel you'll see the calculated number for DSMAX (and sure, you can just override it).

 

Hope that helps

 

Regards,

Javier Estrada Benavides, Mexico

IBM Champion

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS

JITINDER CHOUDHARY

RE: change of Zparm values
(in response to Javier Estrada Benavides)

Thanks Javier!!!

I got the how to change through CA tool. We can change through 'U' - update DB2 parameters option in CA tool.

But my question is if we are not using any tool then how we can change the zparm values.

Suppose we need to change the zparm value for DSMAX - 999 to DSMAX - 30000 then how we can do this without using any tool.

If possible please let us know. 

Russell Peters

RE: change of Zparm values
(in response to JITINDER CHOUDHARY)

We pull out the zparm jcl from the dsntijuz member and keep it in a controlled area to track changes. I just use the jcl to change the values, submit the job to assemble a new module, and use SETSYSPARM to load the new module. I never use the panels after migration. Not all zparm values can be loaded via the SETSYSPARM command. I checked CDSSRDEF and DSMAX in the installation and migration guide, both can be updated via SETSYSPARM. If you use a new module name you can easily back out the change if needed via the SETSYSPARM command.

JITINDER CHOUDHARY

RE: change of Zparm values
(in response to Russell Peters)

Thanks Peters!!!

Can we also update the zparm value for OUTBUFF via SETSYSPARM COMMAND. Could you please update on this.

Edited By:
JITINDER CHOUDHARY[Organization Members] @ Jan 22, 2018 - 04:56 PM (Asia/Calcutta)

James Campbell

change of Zparm values
(in response to JITINDER CHOUDHARY)
you use an
-ALTER BUFFERPOOL ...
command

James Campbell


On 22 Jan 2018 at 4:08, JITINDER CHOUDHARY wrote:

>
> Thanks Peters!!!
> Can we also update the zparm value for VDWQT via SETSYSPARM COMMAND. Could you
> please update on this.
>

JITINDER CHOUDHARY

RE: change of Zparm values
(in response to James Campbell)

Thanks James!!!

 

But 'OUTBUFF'  is a zparm value.

Could we change the zparm value by ALTER BUFFERPOOL command?

Russell Peters

RE: change of Zparm values
(in response to JITINDER CHOUDHARY)

OUTBUFF cannot be changed via the SETSYSPARM command. You have to bounce db2 to install the change. There is a chart in the Installation and Migration Guide that shows which zparms can be updated "online".

Russell Peters

RE: change of Zparm values
(in response to Russell Peters)

OUTBUFF is a zparm. It has nothing to do with bufferpools.