Gen Batch Dynamic Action Blocks and DB2 call attachment (SQL -805)
search cancel

Gen Batch Dynamic Action Blocks and DB2 call attachment (SQL -805)

book

Article ID: 19995

calendar_today

Updated On:

Products

Gen Gen - Host Encyclopedia

Issue/Introduction

This document clarifies the installation of action blocks that are common to both online and batch. They may have code that access DB2. If call attachment is not installed correctly, a SQL -805 will occur at runtime.

Resolution

  • When there exist common action blocks between batch and online, they can both be installed at the same time.

  • If an action block contains DB2, Gen will include the correct DB2 call attachment (DSNCLI=CICS, DFSLI000=IMS, DSNELI=Batch) for the online and batch versions of the load module.

  • When specifying internal construction libraries, include a PDSE library format library in "Exec batch dynam AB library".
    If it is desired to have the binder control cards for dynamic batch action blocks (optional), specify a FB 80 BLOCKSIZE=3120 dataset on the"Specify Internal Libraries" panel.

  • Generate and install the online load module and Gen will automatically generate and install the batch action blocks.

Gen now has support for DSNULI. When DSNULI support is enabled, the installation process link-edits the dynamic action blocks including z/OS Library modules only once. The DB2 attachment type is DSNULI. The DLLs are populated in the DSNULI Exec library and can be shared between CICS and TSO Batch (JES) applications, with some exceptions. For more information reference Create Executable Load Modules.

Additional Information

SQL -805 PROBLEM/SOLUTION:

If a change is required to one of the common action blocks, the online load module containing the dynamic action block must be installed and then Gen will automatically install the batch version at the same time.
If the batch version is installed, Gen will NOT install the online version.
This will result in SQL -805 abend at runtime. This is working as designed.