Originally posted by: rarw

Hi,

We have a 500 MB file that takes 2 to 3 hours to sort. The current workspace settings for the map is File, PageSize 64, PageCount 8. In the dtx.ini file, we have set the StreamMaxMemLimit to 10 and we use WTx (8.1.0.2(38)) Command Server on Solaris 10.

Our next step is to do performance testing and try different combinations of PageSize and PageCount. The dtxpage command did not work:

server001:/opt/IBM/wsdtx_EXP/bin>dtxpage /opt/IBM/WTx_workdir/ENV/MAPS/WM_SEND_DRIVER.mmc
IBM WebSphere Transformation Extender
Page Setting Assistant for Maps - version 8.1(38)
Copyright (c) 2007 IBM Corporation. All rights reserved.
Map /opt/IBM/WTx_workdir/ENV/MAPS/WM_SEND_DRIVER.mmc has return code 12. dtxpage exiting.

Looking for advice.
Thanks for your help - Becky
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: NancyR

Data sorting is not a strong point for WTX. Can you use another product for the sorting and then pass the sorted data to WTX for transformation?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: rarw

Thank you NancyR.

We will do some performance testing and see what we get. I was also thinking that it might be better to do it outside of WTx.

I will try to post the results of the testing.

Thanks,
Becky
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender