About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Product Documentation
Abstract
Updates that apply to DB2 Sort for z/OS V2.1 User's Guide (SC19-4387)
Content
The most recent update is listed first.
Update 1
Date of change: March 2015
Topic: Default installation options
Change description: Add a new default installation option, PAGEMONL:
Update 3
Date of change: December 2020
Topic: Default installation options
Change description: Add a new default installation option, SORTL.
Utilize the Z Sort option
This value specifies the use of IBM Integrated Accelerator for Z Sort with DB2 Sort, which can help reduce CPU usage and improve elapsed time for eligible sort workloads.
SORTL
YES
Enables the use of IBM Integrated Accelerator for Z Sort. YES is the default.
NO
Disables the use of IBM Integrated Accelerator for Z Sort.
Topic: Default installation options
Change description: Add a new default installation option, SWCRYPT.
Encryption of SORTWORK data sets option
This value specifies whether to use encryption for SORTWORK data sets with DB2 Sort.
SWCRYPT
YES
DB2 Sort will encrypt all SORTWORK data sets.
NO
DB2 Sort will not encrypt any SORTWORK data sets. NO is the default.
Topic: Worksheets: Gathering required data set names and parameter values
Change description: Add PAGEMONL, SNAPDUMP, SORTL, and SWCRYPT to DB2 Sort installation options table.
DB2 Sort installation options
Use this worksheet to record the values for the DB2 Sort installation options.
|
Installation option |
Delivered default value |
Discovered? |
Your value |
|
Sort work DASD pool |
SYSDA |
Yes |
|
|
Sort work DASD type |
3390 |
Yes |
|
|
Number of allocations retry attempts |
5 |
Yes |
|
|
Minutes between retry attempts |
3 |
Yes |
|
|
Sort work storage class |
None |
Yes |
|
|
Maximum number of sort works |
32 |
Yes |
|
|
OPTMODE |
ELAP |
Yes |
|
|
PAGEMON |
OFF |
Yes |
|
|
PAGEMONL |
0M |
Yes |
|
|
SNAPDUMP |
YES |
Yes |
|
|
SORTL |
YES |
Yes |
|
|
SWCRYPT |
NO |
Yes |
|
|
TUNEMSG |
ON |
Yes |
|
Topic: Runtime considerations
Change description: Add PAGEMON, PAGEMONL, SORTL, and SWCRYPT to the Default installation options that you can override at run time section.
You can specify the DYNALLOC, OPTMODE, PAGEMON, PAGEMONL, SORTL, SWCRYPT, and TUNEMSG parameters at run time.
PAGEMON
This parameter specifies the type of DB2 Sort storage allocations.
Syntax
>>-PAGEMON-- = -+-ON--+----------------------------------------><
'-OFF-'
Options
·ON: Choose if your system is highly sensitive to paging activity.
·OFF: Choose if you use the default options for DFSORT's DSPSIZE, HIPRMAX, and MOSIZE installation.
PAGEMONL
This parameter specifies the maximum amount of memory that the DB2 Utility can use.
Syntax
>>-PAGEMONL-- = -+-nM--+----------------------------------------><
Option
·nM: This value specifies the maximum memory in megabytes that the DB2 Utility (including DB2 Sort) can use. n can be a value from 0 to 8,388,607. A specification of 0 will make DB2 Sort to use the maximum amount of memory available.
SORTL
This parameter specifies the use of IBM Integrated Accelerator for Z Sort with DB2 Sort, which can help reduce CPU usage and improve elapsed time for eligible sort workloads.
Syntax
>>-SORTL-- = -+-YES-+----------------------------------------><
'-NO--'
Options
·YES: Enables the use of IBM Integrated Accelerator for Z Sort.
·NO: Disables the use of IBM Integrated Accelerator for Z Sort.
SWCRYPT
This parameter specifies whether to use encryption for SORTWORK data sets with DB2 Sort.
Syntax
>>-SWCRYPT-- = -+-YES-+----------------------------------------><
'-NO--'
Options
·YES: DB2 Sort will encrypt all SORTWORK data sets.
·NO: DB2 Sort will not encrypt any SORTWORK data sets.
Topic: DB2 Sort messages
Change description: Add two new messages: CNK558I and CNK560I.
CNK558I SORTL INSTRUCTION USED
Explanation: DB2 Sort used IBM Integrated Accelerator for Z Sort in this sort subtask.
System action: None.
User response: No action is required.
Parent topic: DB2 Sort messages.
CNK560I SORTWORK ENCRYPTION USED
Explanation: DB2 Sort used encryption mode for SORTWORK. All data in SORTWORK data sets is encrypted.
System action: None.
User response: No action is required.
Parent topic: DB2 Sort messages.
Update 2
Date of change: April 2015
Topic: Default installation options
Change description: Add a new default installation option, SNAPDUMP:
- Generation of SNAP dump option
This value specifies whether DB2 Sort generates a SNAP dump in the event of an ABEND during a sort or merge operation.
SNAPDUMP- YES
Enables the generation of a SNAP dump when an ABEND occurs in a sort or merge operation. YES is the default.
NO
Disables the generation of a SNAP dump when an ABEND occurs in a sort or merge operation unless the DEBUG run time parameter is specified.
- YES
Update 1
Date of change: March 2015
Topic: Default installation options
Change description: Add a new default installation option, PAGEMONL:
- Limiting memory usage option
This value specifies the maximum amount of memory that can be used by the DB2 utility.
PAGEMONL- nM
Specify the maximum number of megabytes of memory that the DB2 utility (including DB2 Sort) can use. n can be a value from 0 to 8 388 607. A specification of 0 causes DB2 Sort to use the maximum amount of memory available. The default value for n is 0.
- nM
Publication Number
SC19-4387-00
Related Information
[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DB2 Sort","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
IBM Db2 Administration Tool for z/OS
Software version:
2.1.0
Operating system(s):
z/OS
Document number:
616123
Modified date:
01 April 2021
UID
swg27045447
Manage My Notification Subscriptions