Run the Shared Thread IVPs
Run the shared thread IVPs.
Enter
%RSHIVP
to display the IVP menu. This menu is organized as two pairs of BIND and RUN selections. The first selection of each pair binds the plan that is shared between a Db2/COBOL program and a RLX
exec. The second selection actually runs the shared thread application. The following panel shows the
RLX
/CAF - RLX
Shared Thread IVP's menu.-------------------- RLX/CAF - RLX Shared Thread IVP's ---------------------- Option ===> 1 BIND - Db2 plan shared between COBOL program and interpreted RLX EXEC 2 Run - COBOL/Db2 and interpretive RLX EXEC which share a Db2 thread 3 BIND - Db2 plan shared between COBOL program and compiled RLX EXEC 4 Run - COBOL/Db2 and compiled RLX EXEC which share a Db2 plan thread X Exit - Leave Shared Thread IVP Menu Enter END to exit
Select
Option 1
to bind the plan that is shared between a Db2/COBOL program and a RLX
module that makes use of interpretive REXX and dynamic SQL. ---------------- Bind RLX/CAF - RLX Shared Application Plan ------------------ Command ===> RLX370 - Specify BIND attributes for shared thread IVP RSHIVP1 Specify Action on Jobstream Jobstream Action ===> 1 (1 - Edit JCL, 2 - Submit Jobstream) Db2 Subsystem ===> DSN (In which to BIND plan) Db2 Version / Rel ===> 9.1 (Db2 Version / Release) RLX SQL DBRM name ===> RLXSQL (bound into shared thread Db2 plan) Specify Bind Parameters Isolation Level ===> C (C-Cursor Stability, R-Repeatable Read) Action on plan ===> R (R - Replace A - Add) Retain execution authority ===> Y (Y - Yes N - No) Plan validation time ===> R (R - Run B - Bind) Resource acquisition time ===> U (U - Use A - Allocate) Resource release time ===> C (C - Commit D - Deallocate) Explain path selection ===> N (Y - Yes N - No)
The BIND for the shared plan specifies both DBRM members and a collection of packages. The composite plan named RSHIVP1 includes the DBRM for the Db2/COBOL program RSHCOBOL. In addition, any shared thread application plans you BIND should include the
RLX
package collection via the BIND PKLIST option as in PKLIST(*.RLXvrm.*)
.Option 3
lets you bind the plan that is shared between a Db2/COBOL program and a RLX
application that runs in compiled mode and issues static SQL requests.---------------- Bind RLX/CAF - RLX Shared Application Plan ------------------ Command ===> RLX370 - Specify BIND attributes for shared thread IVP RSHIVP2 Specify Action on Jobstream Jobstream Action ===> 1 (1 - Edit JCL, 2 - Submit Jobstream) Db2 Subsystem ===> DSN (In which to BIND plan) Db2 Version / Rel ===> 9.1 (Db2 Version / Release) RLX SQL DBRM name ===> RSHREX2 (bound into shared thread Db2 plan) Specify Bind Parameters Isolation Level ===> C (C-Cursor Stability, R-Repeatable Read) Action on plan ===> R (R - Replace A - Add) Retain execution authority ===> Y (Y - Yes N - No) Plan validation time ===> R (R - Run B - Bind) Resource acquisition time ===> U (U - Use A - Allocate) Resource release time ===> C (C - Commit D - Deallocate) Explain path selection ===> N (Y - Yes N - No)
Once the shared plan is bound, you can run the shared thread IVPs.
Existing
RLX
SQL load modules (either static or dynamic) from releases of RLX
before Version 3.1.4 that participate in an application that shares a thread with a compiled program must be updated to replace its RLX
host language interface. Otherwise an 0C4 abend occurs during RLX
/CAF termination processing. Use the RLX
HLI replacement utility (RLX
Utility Menu Option 2) to implement the update.
Any new
RLX
SQL load modules you create supports the new shared thread mode of operation because they automatically link-edit the enhanced version of RLX
HLI.