Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-11-20 02:44 AM

Improve performance with AS400 components

Hi,

 

I have a table (under db2/400) containing monthly records (2.5 Millions rows for a month) and I need them to get into another table from another library (schema) under db2/400.

 

It's a simple job :

 

tAS400Input =====>tMap ======> tAS400Output

 

It takes around 25 mins to run (huge considering I have 10 years history), I have tried many things such as using data storage on disk.

 

How can I improve the performance ? 

 

Kind regards,

 

Mohammad

Labels (2)
Labels
73 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-11-20 09:51 AM
Author

Hi,

 

    Could you please allocate more memory to your job and check whether its improving performance?

 

https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/...

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

73 Views
0 Likes