High-speed Apply Engine - Using Prebound Plans and Packages

Knowledge Article

Article Number

000404085

Old Article Number

Article Type

FAQ/Procedural

Title

High-speed Apply Engine - Using Prebound Plans and Packages

Summary

Creating pre-bound Plans and Packages in High-speed Apply Engine?

Product

High-speed Apply Engine

Component

Applies to

Question

How do you create Pre-Bound Plans and Packages in High-speed Apply Engine?

Answer

If you want to use a prebound plan and package this is what you need to do:

Run High Speed Apply first with these bind parameters. Plan name I want to use is APTABCPL and package is APTABCPG.

/BIND/
  BINDACTION=ADD
  PLANNAME=APTABCPL
  PACKAGENAME=APTABCPG
  FREEOPTION=NONE

Any subsequent runs where you want to use the pre-bound processes – you would use these parameters

/BIND/
  BINDACTION=USE
  PLANNAME=APTABCPL
  PACKAGENAME=APTABCPG

The user can code these in their JCL or they can be set in default options.

Note: This is not the way most customer use HSA (high speed apply). Most customers change the default options of Apply Plus (APT$OPTS – jcl located in the UBMCCNTL dataset) - Changing the BINDOWNER and/or AUTH parameter to an ID that has the authority to do binds and access to the tables. Because this is an option module that gets compiled the user doesn’t need to know what is passed.

Below is the JCL to create the plan and packages

//APPLYPLS EXEC PGM=APTBMAIN,
//            PARM='CFN=SYSIN',
//            REGION=0M
//STEPLIB DD DISP=SHR,DSN=SYS3.DJJ.DSNEXIT
//         DD DISP=SHR,DSN=CSGI.DJJ.SDSNLOAD
//         DD DISP=SHR,DSN=BMCSCD.RTEGA.UBMCLINK
//         DD DISP=SHR,DSN=BMCSCD.RTEGA.BMCLINK
//APTPRINT DD SYSOUT=*
//APTLOG   DD SYSOUT=*,LRECL=550,RECFM=VB
//SYSPRINT DD SYSOUT=*
//SYSOUT   DD SYSOUT=*
//APTERR   DD SYSOUT=*,LRECL=200
//APTDUMP DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD *,DLM=##

/STARTUP/
    FILENAME=USERID.D221130.T073018.UNDO.SQL
    INPUTTYPE=SQL
    SSID=DJJ1
/DISTRIBUTIONTUNING/
    PARTITIONCLUSTERING=NO
    RICLUSTERING=YES
/CONFLICT/
/BINDTUNING/
    SYNCHRONOUS=YES
/BIND/
    BINDACTION=ADD
    PLANNAME=APTABCPL
    PACKAGENAME=APTABCPG
    FREEOPTION=NONE
##

The JCL to run subsequent jobs:

//APPLYPLS EXEC PGM=APTBMAIN,
//            PARM='CFN=SYSIN',
//            REGION=0M
//STEPLIB DD DISP=SHR,DSN=SYS3.DJJ.DSNEXIT
//         DD DISP=SHR,DSN=CSGI.DJJ.SDSNLOAD
//         DD DISP=SHR,DSN=BMCSCD.RTEGA.UBMCLINK
//         DD DISP=SHR,DSN=BMCSCD.RTEGA.BMCLINK
//APTPRINT DD SYSOUT=*
//APTLOG   DD SYSOUT=*,LRECL=550,RECFM=VB
//SYSPRINT DD SYSOUT=*
//SYSOUT   DD SYSOUT=*
//APTERR   DD SYSOUT=*,LRECL=200
//APTDUMP DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD *,DLM=##

/STARTUP/
    FILENAME=USERID.D221130.T073018.UNDO.SQL
    INPUTTYPE=SQL
    SSID=DJJ1
/DISTRIBUTIONTUNING/
    PARTITIONCLUSTERING=NO
    RICLUSTERING=YES
/CONFLICT/
/BINDTUNING/
    SYNCHRONOUS=YES
/BIND/
    BINDACTION=USE
    PLANNAME=APTABCPL
    PACKAGENAME=APTABCPG
##

Attachment(s):