Topic: 2014 EMEA
Subtopic: Cross Platform DB2 for z/OS & LUW
During his involvement with a large compliance project the presenter, as well as designing a resonable sized enhancement to the largest database in the shop, had to expand his knowledge and dip into the rich set of features available to provide the overall database solution utilised in terms of DB2 for z/OS.
In doing so the following set of features were utilised and developed as part of the solution.
1. SQLJ connections instead of direct JDBC.
2. Utilisation of a technique to transform Relationally structured data into XML as the result set data format from the majority of SQL being called via the SQLJ connection.
3. Development of a MQT to significantly simplify the access path and improve the performance of much of the SQL being called via SQLJ.
4. Lastly plug a hole in the application design by utilising the DB2 MQ Send API via a database trigger to invoke a service to maintain functionality and data integrity.
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.