(ID 730) Technical bulletin: November 2019 enhancements for version 12.1.00 of the NGT products are available


Products

Next Generation Technology Reorg for DB2 for z/OS, version 12.1.00
Next Generation Technology Load for DB2 for z/OS, version 12.1.00
Next Generation Technology Unload for DB2 for z/OS, version 12.1.00
Next Generation Technology Stats for DB2 for z/OS, version 12.1.00
Next Generation Technology Check for DB2 for z/OS, version 12.1.00
Next Generation Technology LOBMaster for DB2 for z/OS, version 12.1.00
REORG PLUS for DB2, version 11.2
LOADPLUS for DB2, version 11.2
UNLOAD PLUS for DB2, version 11.2
CHECK PLUS for DB2, version 11.2

Date

BMC is announcing enhancements for the listed products.

Overview of the enhancements

This section summarizes the new enhancements in this release:

Enhancements for all utilities

EnhancementDescriptionReference
Availability of DB2 function level information

All NGT and Plus utilities now provide the following standard information about IBM DB2 function levels:

  • Current DB2 function level
  • DB2 catalog level
  • Highest DB2 function level
  • DB2 code level

Message NGTC380

Message BMC50658

Message BMC50659

Message BMC50660

Message BMC50661

Deletion of utility history information after a utility runs successfully
You can now delete utility ID (UID) history records from the NGT checkpoint (CKPT) data set after a successful utility run.

+UIDHISTORY

+DELETEOUTPUT

New support for installation configuration parameters

For +SVRPROCMSGLVL, you can now specify N to tell NGT to exclude stmtlevel or msglevel parameters on the STC card.

+SVRPROCMSGLVL

Ability to display claims and locks

Using the +DRAIN_DLOCKS parameter, you can control when to display claims and locks that are preventing a drain from being obtained:

  • After each attempt
  • After the last attempt
  • Not at all  

+DRAIN_DLOCKS (PTF BQU2620 applied)

Ability to filter the NGTDISP report by utility typeUse the TYPE keyword to filter the NGTDISP report by utility type or to view utility types for all utility IDs in the report.
  • NGTDISP command
  • NGTDISP report
Ability to process any size PBR and PBG

NGT utilities support both partition-by-range (PBR) and partition-by-growth (PBG) table spaces of any page or partition size with one exception :

NGT Reorg does not support PBG tablespaces that contain more than 16 million pages per partition.

  • Requirements and restrictions (NGT Reorg)
  • Requirements and restrictions (NGT Load)
  • Requirements and restrictions (NGT Unload)
  • Requirements and restrictions (NGT Stats)
  • Requirements and restrictions (NGT Check)
  • Requirements and restrictions (NGT LOBMaster)

Enhancements for NGT Check

EnhancementDescriptionReference
Ability to process any size PBR and PBG
The NGT Check product now supports both partition-by-range (PBR) and partition-by-growth (PBG) table spaces of any page or partition size.

Requirements and restrictions

Enhancements for NGT Load

EnhancementDescriptionReference
Ability to process any size PBR and PBG
The NGT Load product now supports both partition-by-range (PBR) and partition-by-growth (PBG) table spaces of any page or partition size.

Requirements and restrictions

Delete discard data sets if no discards

You can now use either the new +DELETEDISCARD Load parameter or the new DELETEFILES SYSDISC keyword to delete empty discard files.

DELETEFILES

+DELETEDISCARD

Enhanced ENFORCE options for compatibility with LOADPLUS
If you use the LOADPLUS product and are migrating to NGT Load, you can specify handling for DB2 defined referential integrity and informational referential integrity checks.
  • ENFORCE
  • +ENFORCERI
  • Message NGTL011
  • Message NGTL012
  • Message NGTL013

Enhanced support for mixed subsystemsNGT Load processes correctly on mixed subsystems, even if the columns do not specify MIXED.

Field specification

Enhancements for NGT LOBMaster

EnhancementDescriptionReference
Ability to process any size PBR and PBG
The NGT LOBMaster product now supports partition-by-range (PBR) table spaces of any page or partition size.

This enhancement lifts the DSSIZE restriction on PBG table spaces; however, NGT LOBMaster does not support PBG objects that contain more than 16 million pages per partition.

Requirements and restrictions

New history records in the object history tableNGT LOBMaster updates the NGT object history table for partition-by-growth (PBG) table spaces.Not applicable
REPORTONLY return codeNGT LOBMaster ends with a valid return code when in REPORTONLY mode.
  • SYSIN syntax
  • +LOBORPHANS(action,message)
  • +LOBMISSING(action,message)

Enhancements for NGT Reorg

EnhancementDescriptionReference
Ability to process any size PBR and PBG

The NGT Reorg product now supports partition-by-range (PBR) table spaces of any page or partition size.

This enhancement lifts the DSSIZE restriction on PBG table spaces; however, NGT Reorg does not support PBG objects that contain more than 16 million pages per partition.

Requirements and restrictions

Support for keywords equivalent to the +COPY parameter
You can now use the runtime COPY NO option to prevent producing copies during a reorganization and to determine whether to set objects to copy-pending status.
  • COPY (PTF BQU2620 applied)
  • REORG TABLESPACE options

Enhancements for NGT Stats

EnhancementDescriptionReference
Ability to process any size PBR and PBGThe NGT Stats product now supports partition-by-range (PBR) and partition-by-growth (PBG) table spaces of any page or partition size.

Requirements and restrictions

Collects frequency statistics for any COLGROUP
Use the COLGROUP specification block to collect frequency statistics for any combination of correlated table columns.
  • NGTSTATS syntax
  • Message NGTT122 - NGTT123
  • Messages NGTT125 - NGTT130
Nonzero return codes for SQL errorsNGT Stats now issues a nonzero return code when an SQL error occurs.
Not applicable


Enhancements for NGT Unload

EnhancementDescriptionReference
Ability to process any size PBR and PBG
The NGT Unload product now supports partition-by-range (PBR) and partition-by-growth (PBG) table spaces of any page or partition size.

Requirements and restrictions

Support for CNTLCARDS DB2 and CNTLCARDS DB2DDL
You can now use new CNTLCARDS options, DB2DDL and DB2, to generate either CREATE TABLE DDL or both CREATE TABLE DDL and LOAD CNTL cards in the SYSCNTL output file.
  • CNTLCARDS
  • UNLOAD syntax diagrams

Enhancements for SmartSwitch

EnhancementDescriptionReference
Ability to disable SmartSwitch  via a DD statementYou can now use a DD statement to disable SmartSwitch.
  • BMCSSOFF (PTF BQU2519 applied) UNLOAD PLUS
  • SmartSwitch feature UNLOAD PLUS
  • BMCSSOFF (PTF BQU2519 applied) LOADPLUS
  • SmartSwitch feature LOADPLUS
  • BMCSSOFF (PTF BQU2519 applied) REORG PLUS
  • SmartSwitch feature REORG PLUS
Ability to ignore PRELOAD PAUSE when switching to NGT

You can use a new installation option, SSIGNRPAUSE, to tell LOADPLUS to ignore PRELOAD PAUSE and allow SmartSwitch to switch to NGT.

Note

If PTF BQU2542 is applied, you do not need to update the existing options unless you want to use this new feature.

  • Basic installation options
  • Descriptions of basic installation options
  • Messages BMC52100 through BMC52199
Improved formatting of NGTSSJCL and NGTSSSYNThe field specification section can now print one field spec per line instead of a continuous string.Not applicable

Obtaining the enhancements

Use the following procedure:

  1. To enable the NGT enhancements, download and apply PTF BQU2620.

    Tips

    BMC recommends using BMC Internet Service Retrieval (ISR) to obtain PTFs. For more information, see the maintenance topics in the Installation System documentation.

    You can also obtain PTFs from eFix PTF Distribution Services (eFix) or from the support site. For information about eFix, see the online Help.

  2. (Optional)  To enable the SmartSwitch and Plus product enhancements, download and apply the following PTFs for version 11.2 of REORG PLUS, LOADPLUS, UNLOAD PLUS, and CHECK PLUS:

    • BQU2519
    • BQU2542
    • BQU2576

If you have questions, call BMC Support. If outside the United States, use the Select Another Country drop-down list to search for local phone numbers.

 


Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Mark Goto
    Message NGT012
    Instead of Message NGT012, the text should say Message NGTL012
    Nov 22, 2019 10:10