Setting special registers in Data Studio
agburke 060001QPDN Visits (874)
I need to set Special Registers like CURRENT QUERY OPTIMIZATION, CURRENT PACKAGESET, etc. on the DB2 ZOS connection created in Data Studio. How can I accomplish this?
By setting specialRegisters parameter on the connection level, it will not have to be set manually in each SQL script.
Please note that for using Special Registers you need to have JDBC driver 4.15. Data Studio 3.2 ships with JDBC driver 3.64.106 and 4.14.113 but is not packaged with JDBC driver 4.15
The link also includes directions on how to manually add these registers to the driver's URL.