We have a requirement to write the data into 64 target files. The data is written into one of the 64 files based on value of a column. The target file is an ebcidic file.
Same is the design for 6 of the jobs. These leads to bottleneck with most of the execution time involved in write operations.
These hampers performance. Is there any environment variable which can be set to improve the write performance.
Writing 64 Target files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: