Memory Usage and CPU consumption by the DSTX Maps

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
bhushanpatil
Participant
Posts: 4
Joined: Wed Feb 07, 2007 8:28 am
Location: Mumbai

Memory Usage and CPU consumption by the DSTX Maps

Post by bhushanpatil »

In our application we develope maps and deploy them to run on solaris (UNIX) platform to perform the real time transactions. We have two different architectures to support our complete systems.
1. The maps are used to form the query and calls the C libraries for connection to backend and further transactions, the response of the quries are again formatted by the DSTX maps and sent it to frontend.

2. Everything from,forming the query to connection and getting the response is done in maps itself( including logging the transactions)
we decomission the C libaries in this design.

Now as the maps became bulky they are utilizing more CPU time and memory of the solaris box. Can anyone suggest some tricks to reduce the CPU time consumption and memory usage by the map ( Tuning) to optimize the system performance to upto the mark of C code transactions. Thanks in Advance
jvmerc
Participant
Posts: 94
Joined: Tue Dec 02, 2003 12:57 pm

Post by jvmerc »

Unfortunatly 7.n doesn't have the performance tuning tools that 8.n does. If you have 8.n available you could run maps thru with perf tuning on and see what it tells you.

Hard to tell you a lot other than that but... Are you parallel processing? How big are you files on average? What adapters are you using? Can you tell what maps are consuming the most time? Do you have 'trace' off on all maps?

Beyond that, search the forum. There are all sorts of tips on ini file and map settings as well as ways to enhance/inprove performance around adapters.
Post Reply