Originally posted by: johnxp

Hi, we got a requirement to process millions records using WTX. My question is how big input file can WTX handle? Any memory issue if we have input file around 10 GB?

What is the maximum file size that WTX can handle?

Thanks.

Originally posted by: PaulBrett

ITX 9 can handle any input file that the operating system and underlying disk format can handle, but bear in mind that work files can be 3 or 4 times as large as the original input file, so the actual limit may be quite a lot less than the OS limit.

Thank you

Paul

Follow me on Twitter

Originally posted by: Suriya Prakash

Hi Paul Brett,

We are getting Disk Write Error for source trigger map while running 100MB file. We are using ITX version 9.0.0.3 in linux environment. we have been trying several combinations of pagesize and pagecount and work space directory as Memory and File. Please help us to overcome this failure.

Thanks,

Suriya

Originally posted by: Suriya Prakash

At the output side modified the Adapter settings as below.

1. Target as "File"

2. OnSuccess as "!Create"

3. OnFailure as "Rollback"

And it got worked.

Thanks 

Suriya Prakash

Originally posted by: PaulBrett

Suriya,

I recommend you raise the issue (with a testcase) with the IBM Support team.

Thank you

Paul

Follow me on Twitter