Monday, 12 March 2018

DB2 SYSTEM CONFIGURATION PARAMERTERS - DSNZPARM


DSNZPARM Dissected


What isDSNZPARM

Dataonly,subsystemparameterloadmodulecontainingtheDB2execution-timeparameters
InitiallysetatinstalltimethroughtheinstallationISPFpanels
Includesmacros:
o   DSN6ARVP–Archivedatasetparameters
o   DSN6ENV– DB2environmentsettings(removed)
o   DSN6FAC– DDF
o   DSN6LOGP–Logstuff
o   DSN6SPRM– InitializationparametersforDBM1
o   DSN6SYSP–Miscellaneoussystemparameters
o   DSN6GRP–Groupstufffordatasharing


Install DSNZPARM


SomeDSNZPARMsaresetoutsidetheinstallpanels

o   Hidden
§  Justwhattheword implies,theyareburiedwithinthemacros and notintended tobemodified bythegeneralpublic .IBM intervention needed to change those.

o   Opaque
§  Arenotavailableforchangeusingthepanels

o   Visible
§  Changedusingtheinstallpanels

DSNZPARM Values

Default values (recommended) / Minimum  values / Maximum values

Updating DSNZPARM

Ø  Permanent change
o   Need to recycle DB2 .
o   Changes will be permanent and will get updated in SDSNLOAD
o   New ZPARM name is recommended for each change
Ø  Temporary Change
o   Its Dynamic change – No need to recycle DB2
o   Not all values can be updated dynamically
o   Change will get rolled back , post recycle of DB2.

No comments:

Post a Comment