Skip to Main Content
IBM Data and AI RegTech Ideas Portal - Redirect to Data and AI Portal


Status Future consideration
Created by Guest
Created on Apr 9, 2019

FTM Purge Utility : Support jdbc type2 connection on z/OS

Add support for jdbc type2 connection from the purgeDB utility and FTM core.
This support is requested for 2 reasons :
1 - Performance : With type-2 ( cross mem ), we expect to reduce communication overhead for jdbc link.
2 - Workload Management : With Type-4, CPU consumption is on the DB2DIST address space ( used by all applications doing t4 jdbc). Because the purge utility consumes a lot of mips ( so $$ ), we would like to limit his consumption with a WLM Resource Group but this is not possible on DB2DIST itself. We hope that with type-2 cross mem, the CPU consumption will remain on the batch doing the purge, so we would be able to use WLM Resource Group.