DSNZPARM Data Set and Database Parameters
This panel shows information about the data set and database-related installation parameters in the DSNZPARM module. It shows the name of the DSNZPARM module that is specified for Db2 startup and the date on which the module is assembled. It also shows a list of the default values of the Db2 application.
If a field is not available for the current Db2 release,
the string
N/A
is displayed. For other conditions, for example, if specific Db2 traces are not started or control block data is not available,
the string N/P
is displayed.
________________ ZPDSN VTM O2 V550.#P SC11 S 07/08/16 10:16:33 2
> Help PF1 Back PF3 Left PF10 Right PF11
> R.H.H
> DSNZPARM INFORMATION: Enter a selection letter on the top line.
> A-THREAD B-TRACE C-LOGGING D-ARCHIVING E-AUTH/RLF/DDF F-IRLM
> G-STORAGE *-DATASET I-DDCS J-DATA SHARING K-STORED PROC L-UTIL
> M-APPL N-DATA O-PERF P-BUFFERPOOL Q-OTHERS
===============================================================================
> DSNZPARM DATASET AND DATABASE PARAMETERS
ZDSN
+ Collection Interval: REALTIME SNAPTIME: 07/08/16 10:16:33.22
+
+ DSNZPARM Module DSNZPARM
+ Assembly Date 04/14/16
+ Initial Module DSNZPARM
+ Assembly Date 04/14/16
+ Previous Module DSNZPARM
+ Assembly Date 04/14/16
+
+ DSNTIP7-SQL Object Defaults 1
+------------------------------------
+ Reordered Row Format (RRF) N/A
+ (OBJECT_CREATE_FORMAT) EXTENDED
+ (UTILITY_OBJECT_CONVERSION) NONE
+ Vary DS Control Interval (DSVCI) YES
+ Table Space Allocation (TSQTY) 0
+ Index Space Allocation (IXQTY) 0
+ Optimize Extent Sizing (MGEXTSZ) NO
+ (TS_COMPRESSION_TYPE)
+
+ DSNTIP71-SQL Object Defaults 2
+------------------------------------
+ Default Partition Segsize (DPSEGSZ) 32
+ Pct Free for Update (PCTFREE_UPD) 0
+ (PAGESET_PAGENUM) ABSOLUTE
+ (RETRY_STOPPED_OBJECTS) NO
+ Pad Index By Default (PADIX) NO
+ (INDEX_MEMORY_CONTROL) SELECTED
+ INDEX_MEMORY_CONTROL(Selected IX) 2000
+ (DDL_MATERIALIZATION) ALWAYS_IMMEDIATE
+ (DEFAULT_INSERT_ALGORITHM) FAST
+ (FTB_NON_UNIQUE_INDEX) YES
+
+ DSNTIP72-SQL Object Defaults 3
+------------------------------------
+ Define Data Sets (IMPDSDEF) YES
+ Use Data Compression (IMPTSCMP) NO
+ (PREVENT_ALTERTB_LIMITKEY) NO
+ (IX_TB_PART_CONV_EXCLUDE) YES
+ Rename Table (RENAMETABLE) DISALLOW
+
+ DSNTIP91-Workfile Database
+------------------------------------
+ Max Temp STG/AGENT (MAXTEMPS) 0
+ Separate Work Files (WFDBSEP) NO
+ Max Temp RID (MAXTEMPS_RID) 0
+ (WFSTGUSE_AGENT_THRESHOLD) 0
+ (WFSTGUSE_SYSTEM_THRESHOLD) 90
+
+ DSNTIPS-Auto Start DB/TS
+------------------------------------
+ Restart or Defer (RESTART) RESTART
+ Auto Start Type (LIST or ALL) ALL
===============================================================================
Navigation
For additional information about:
- Related topics, select one of the options on the top of the panel.
- Other topics, use the PF keys.
Fields
The DSNZ command displays the following lines to reflect the usage of the
Db2
SET SYSPARM command. To each of these lines, the corresponding date on which this
particular module is assembled is displayed.
- DSNZPARM Module
- The name of the DSNZPARM module that is specified for Db2 startup.
- Initial Module
- The name of the initial DSNZPARM load module.
- Previous Module
- The name of the previous DSNZPARM load module.
- Assembly Date
- The date on which this module was assembled.
DSNTIP7-SQL Object Default 1
- Reordered Row Format (RRF) (QWP4RRF)
- This parameter determines whether reordered row format is enabled.
- YES
- Enables reordered row format.
- (OBJECT_CREATE_FORMAT) (QWP4OBCF)
- This parameter determines whether new table spaces and indexes are created in one of the
following formats:
- 1
- Extended log record format
- 0
- Basic log record format
- (UTILITY_OBJECT_CONVERSION) (QWP4UTOC)
- If RBALRSW format is not specified, this parameter converts existing table spaces and indexes that use extended log record addressing to basic log record addressing and vice versa. Db2 11 and later.
- Vary DS Control Interval (DSVCI) (QWP1VVCI)
- This parameter determines whether CI SIZE=PAGE is used when Db2-managed data sets are defined.
- Table Space Allocation (TSQTY) (QWP1TSQT)
- This parameter determines the default values in KB for PRIQTY and SEQCTY for table spaces.
- Index Space Allocation (IXQTY) (QWP1IXQT)
- This parameter determines the default values in KB for PRIQTY and SEQCTY for index spaces.
- Optimize Extent Sizing (MGEXTSZ) (QWP1MESZ)
- This parameter determines whether a sliding scale for secondary space allocations for Db2-managed data sets is enabled.
- (TS_COMPRESSION_TYPE) - (QWP4TSCT)
- The TS_COMPRESSION_TYPE subsystem parameter specifies the type of compression algorithm to use
when Db2 creates new compressed table spaces, loads into, and reorganizes existing compressed table
spaces.
ZPARM NAME: DSN6SPRM.TS_COMPRESSION_TYPE
Valid values are:
- FIXED_LENGTH
- (Default) Db2 uses its existing compression algorithm to perform compression and decompression of data stored in the table space. This is the default setting.
- HUFFMAN
- Db2 uses Huffman compression provided by IBM z14 or later hardware to perform compression and decompression of data stored in the table space. Huffman compression only applies to universal table spaces. All other table space types will use fixed-length compression regardless of the TS_COMPRESSION_TYPE setting.
DSNTIP71-SQL Object Default 2
- Default Partition Segsize (DPSEGSZ) (QWP1DPSS)
- This parameter determines the default segment size that is used for a partitioned table space when the CREATE TABLESPACE statement does not include the SEGSIZE parameter.
- Pct Free for Update (PCTFREE_UPD) (QWP4PFUP)
- This parameter determines the default percentage of each page that Db2 leaves as free space for updates when you create a table space without specifying the FOR UPDATE CLAUSE of the PCTFREE option and a table within that table space is populated. Db2 11 and later. Db2 11 and later.
- (PAGESET_PAGENUM) (QWP4PSPN)
-
Specifies whether range-partitioned table spaces and associated indexes will be created to use absolute page numbers across partitions or relative page numbers.
- A
- Absolute page numbers
- R
- Relative page numbers
- (RETRY_STOPPED_OBJECTS) (QWP4RSO)
-
Specifies whether Db2 should immediately reject requests for a stopped object or retry them, up to the IRLM timeout limit, to see if the object has been started.
- NO
- This is the default. It indicates that Db2 immediately rejects requests for a stopped object.
- YES
- Db2 retries such requests, up to the IRLM timeout setting, if the stopped object is restarted.
- Pad Index By Default (PADIX) (QWP4PDIX)
- This parameter determines whether new indexes are padded
- (INDEX_MEMORY_CONTROL) (QWP4IXMC)
- The amount of memory Db2 allocates for fast traversing of Db2 indexes. In a data sharing environment, it is recommended that all members use the same setting.
- INDEX_MEMORY_CONTROL(Selected IX) (QWP4IXMCS)
- Indicates the storage limit for fast index traversal for selected indexes when INDEX_MEMORY_CONTROL is set to SELECTED.
- (DDL_MATERIALIZATION) (QWP4DDLM)
- Specifies when Db2 materializes changes to the definition of an object. Valid values are:
- ALWAYS IMMEDIATE (default)
- Changes are materialized at the time the request is executed, and the containing table space is placed in the AREO* or REORP status.
- ALWAYS PENDING
- Changes are not materialized at the time that the request is executed, and the affected objects are available until it is convenient to implement changes. The containing table space is placed in the AREO* status.
- (DEFAULT_INSERT_ALGORITHM) (QWP4DINA)
- Specifies the default algorithm for inserting data into table spaces. Valid values:
- BASIC(1) (default)
- The basic insert algorithm is used.
- FAST(2)
- The fast insert algorithm is used.
- (FTB_NON_UNIQUE_INDEX) (QWP4FTBUO)
- Indicates whether fast index traversal for non-unique indexes is enabled.
- Define Data Sets (IMPDSDEF) (QWP1DIDS)
- This parameter determines the underlying data sets when a table space that is in an implicitly created database is created.
- Use Data Compression (IMPTSCMP) (QWP1CITS)
- This parameter determines whether data compression in table spaces in implicitly defined databases is used.
DSNTIP72-SQL Object Default 3
- Define Data Sets (IMPDSDEF) (QWP1DIDS)
- This parameter determines the underlying data sets when a table space that is in an implicitly created database is created.
- Use Data Compression (IMPTSCMP) (QWP1CITS)
- This parameter determines whether data compression in table spaces in implicitly defined databases is used.
- (PREVENT_ALTERTB_LIMITKEY) (QWP4XPKE)
- Determines whether Db2 disallows altering the limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces. This alter operation places the table space in REORG-pending (REORP) restrictive status, and the data is not available until the affected partitions are reorganized. Use PREVENT_ALTERTB_LIMITKEY to avoid this data unavailability.Db2 11 and later.
- NO
- Specifies that you can alter a limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces. NO is the default.
- YES
- Specifies that it is not permitted to alter a limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces. An ALTER TABLE statement must not attempt to alter the limit key for an index-controlled partitioned table.
- (IX_TB_PART_CONV_EXCLUDE) (QWP4XPKE)
- This parameter determines whether to include all columns in the partitioning key during the conversion from index-controlled partitioning to table-controlled partitioning.
- Rename Table (RENAMETABLE) (QWP4ERTS)
- Specifies whether the RENAME TABLE statement should extend to tables that are referenced in a view definition or the definition of an SQL table function:Db2 12 and later.
- ALLOW_DEP_VIEW_SQLTUDF
- YES
- DISALLOW_DEP_VIEW_SQLTUDF
- NO
DSNTIP91-Workfile Database
- Max Temp STG/AGENT (MAXTEMPS) (QWP4WFAL)
- Specifies the maximum number of megabytes of temporary storage in the work file database that can be used by a single agend at any given time for all temporary tables. If 0 is specified, a limit is not enforced.
- Separate Work Files (WFDBSEP) (QWP4WFDBSEP)
- This parameter determines whether Db2 provides an unconditional separation of table spaces in the work file database based on the allocation attributes of the table spaces.
- Max Temp RID (MAXTEMPS_RID) (QWP4WFRD)
- The maximum number of RID blocks of temporary storage in the work file database that a single RID list can use at any point in time.
- (WFSTGUSE_AGENT_THRESHOLD) (QWP4WFAT)
- Determines the percentage of the space that is available in the work file database on this Db2 subsystem or in this data sharing member that can be consumed by a single agent before a warning message is issued.
- (WFSTGUSE_SYSTEM_THRESHOLD) (QWP4WFST)
- Determines the percentage of the space that is available in the work file database on this Db2 subsystem or in this data sharing member that can be consumed by all agents before a warning message is issued.
DSNTIPS-Auto Start DB/TS
- Restart or Defer (RESTART) (QWP7STR )
- This parameter determines whether Db2 databases are started automatically or are deferred.
- Auto Start Type (LIST or ALL) (SWP7STR )
- This parameter determines the Db2 databases that are started or deferred.