Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 580 Location: London
|
|
|
|
Seems like a rediculously inefficient process from what I can understand, as a non-programmer. Why don't you read the whole file in and create one output CSV file with all the records in it and then upload and post process that to generate the separate excels on a PC somewhere. Even then it seems strange to be generating <hundreds?> of separate excel spreadsheets. Why can't you add to an existing spreadsheet for each existing customer?
The result of the space release and use of extents is perfectly reasonable given the nonsense way it is being used. You're allocating in cylinders, so initial allocation is 100cyls, but on file close is released to the nearest cylinder. Next output to the file will then add to that existing cylinder and so on until it fills up, after which another 100cyls secondary is allocated and used the same way until full. Repeat that until you have taken all possible 16 extents on the volume, then waste time on this forum.
Just remove the RLSE and let DFHSM or whatever you use to release the space later. |
|