IBM Sterling Transformation Extender

 View Only

 How to set up multithreading for database access?

NeverXP YANG's profile image
NeverXP YANG posted Mon February 03, 2025 02:35 AM

Hi, my WTX map needs to run a procedure in Oracle. I have set multithreading in the system msl file (max instances = 4). However, I can only see the procedure being called one by one, not concurrently. So how can I make it work concurrently on database access? Do I need to use unique dbl logs? How can I generate dbl logs per instance?

Rex Chan's profile image
Rex Chan posted Mon February 03, 2025 01:14 PM

This is the link for more information on generating a unique trace.

https://www.ibm.com/docs/en/ste/10.1.2?topic=hac-adapter-log-file-full-path-t-t-tv-tv-te-te

To generate a trace with different name: -TV myJDBC.mtr

To generate a trace with unique name, I think you have to use a rule instead of an output card (perhaps somebody knows how to do it)?

=GET("JDBC", "-URL jdbc:db2://192.168.40.141:50000/SAMPLE -USR db2inst1 -PWD password -SCH DB2INST1 -PROC TEST_SP -QTY 1 -LSN 0 -AS 0 -TV " + FROMDATETIME(CURRENTDATETIME()) + "myJDBC.mtr")

This trace file is produced: 20250203121010myJDBC.mtr