System requirements

Before you install the product, make sure that your environment meets the hardware and software requirements.


Related topic

Planning

Product compatibility matrix

Db2 support

This version of the LOADPLUS product supports IBM Db2 Versions 12 and later (new-function mode only) and subsystems.

System requirements

  • IBM System z10 processor or a later 64-bit z/Architecture processor
  • Minimum hardware EC12 and Z114
  • z/OS Version 2.4 

Software requirements

This version of LOADPLUS has the following requirements for additional IBM or BMC software:

  • For all types of load jobs, you must have a minimum of the following versions of BMC common components:
    • Version 2.4.01 of BMCSORT
    • Version 13.1.00 of the Db2 Utilities Common Code (D2U)
    • Version 13.1.00 of the Db2 Solution Common Code (SCC)
  • To update Db2 catalog statistics or the DASD MANAGER PLUS database statistics tables, you must have installed a minimum of version 13.1.00 of the BMC Common Statistics component.
  • To perform a LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY load, you must have installed a minimum of version 13.1.00 of the BMC High-speed Apply Engine product.

  • For the following features, LOADPLUS requires version 6.2.01 or later of either the BMC SNAPSHOT UPGRADE FEATURE (SUF) (also known as EXTENDED BUFFER MANAGER (XBM) ) product.

    • When checking referential constraints during your load job
    • When you specify LOAD RESUME YES SHRLEVEL REFERENCE

    For Db2 V13 support, XBM PTF BPE0556 is required. If you use the XBMID option to specify a particular SUF (also known as XBM) subsystem, that subsystem must be at this maintenance level. If you do not specify a particular SUF (also known as XBM) subsystem and snapshot processing is required, LOADPLUS searches for an SUF (also known as XBM) subsystem at this level.

  • To offload eligible processing to a zIIP, LOADPLUS requires version 6.2.01 or later of either SUF (also known as XBM).

    If you use the XBMID option to specify a particular SUF (also known as XBM) subsystem, that subsystem must be at this maintenance level. If you do not specify a particular SUF (also known as XBM) subsystem and ZIIP ENABLED is in effect, LOADPLUS searches for an SUF (also known as XBM) subsystem at this level.

  • To use any features that invoke DSNUTILB, you must be licensed to use the IBM Db2 LOAD utility.

    Important

    For information about the features that invoke DSNUTILB, see DSNUTILB.

Required authorizations

Using the LOADPLUS product requires that you have the appropriate authorization within Db2 and through your system security package, such as the IBM Resource Access Control Facility (RACF).

You need sufficient authorization to access resources and perform the tasks that are accomplished during LOADPLUS processing.

Authorization verification mechanisms for the Utility products

The Utility products use one of the following mechanisms to verify authorizations:

  • If the Db2 DSNX@XAC authorization exit is available for your system, the product uses this exit to verify authorization for external access. The exit is available from the following sources:

    • IBM provides a sample exit with Db2 for the IBM Resource Access Control Facility (RACF) component.
    • CA Technologies provides the DSNX@XAC exit with the CA-ACF2 and CA-Top Secret products.

    We recommend this mechanism for implementing external security. The access control authorization exit must be available in the STEPLIB, JOBLIB, link list, or SYS3.DSN exit.

  • If the DSNX@XAC exit is not available, the product uses the standard Db2 method to check security.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*