Posted: Thu Sep 18, 2014 5:55 am Post subject: Select STMT from mapping node/ESQL
Novice
Joined: 10 Mar 2014 Posts: 19
Hi All,
I am working on a flow which needs to fetch around 12 million records from a SQL database and creates a file. Earlier this interface was running on a standalone WTX Windows environment and WTX map hardly finished this flow in 5 minutes now we are migrating this interface to IIB on zLinux. We are not able to migrate the WTX map to IIB environment as WTX doesn't support ODBC on zLinux. So we are trying to implement this through ESQL or Mapping node we tried both but system got crashed every time when we ran this flow. We tested for limited records like 5000 it ran successful.
Can someone please suggest or provide some tweaking to complete this flow successfully.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum