Validation of TIUUSQLX functionality in Gen Implementation Toolset (IT)

Products

• Gen

Issue/Introduction

Applying PTFs to Gen Implementation Toolset (IT) that deal with TIUUSQLX. The new DBRM was deployed to CEHBDBRM, the new load module was deployed to CEHBPLD0 and the IT was retested. However it has not been possible to witness the package execution of the item.

The expectation is that something would have been visible in the log to confirm that the process was still functioning correctly after the changes.  What actions can be taken on the IT to validate that the changes execute as expected? 

Resolution

The IT uses program TIUUSQL to execute SQL dynamically. Validations for TIUUSQLX would be to verify the bind is successful, verify the program deployed and that the program executes DDL without issue.

TIUUSQLX is used to install DDL. To verify that TIUUSQLX is executing after the Package Bind completes, install an Implementation Package (IP) to execute DDL/create an application DB. IVP job TIXIVPDS (storage group) is probably the best, or TIXIVPDB (VSAM). For more information reference Verifying Installation.

To determine what Packages have been bound for TIUUSQL, run SQL similar to:

  SELECT BINDTIME, VERSION, COLLID, CONTOKEN FROM SYSIBM.SYSPACKAGE   
    WHERE NAME LIKE 'TIUUSQL' ;  

Additional Information

TIUUSQL shipped in PTFs LU00269 (2021) and LU17133 (2025) and applies to the CEHB860 FMID.
When upgrading a z/OS Gen IT, PTF LU00570 (2021) is applied on top of GA+PTFs and will have Co-Req and HOLDDATA for PTF LU00269. When upgrading by using the PAXfile, the same Co-Req and HOLDDATA will be there. The HOLDDATA instructions are to run ITJOB03.

This IT Tech Doc gives solutions for TIUUSQL errors - Implementation Toolset Installation Errors.