DSXchange

Hello All,

I am trying to copy a dataset using orchadmin copy command.Though the source dataset is of 160GB,(Counted the data file bytes), orchadmin copy command is making a file bigger than target file of 480GB(Again counted the data file bytes) and failing with no space on device-3times the size of source file. My command is pretty straight forward.

Did anyone face this issue? Please let me know

Thanks & Regards
Koti

I did a quick test on a much smaller 80 MB data set. The new copy was 106 MB.

Sounds potentially like that old varied behavior with datasets sometimes storing varchar with fixed sizes. Maybe orchadmin copy defaults to that behavior.

You could try setting the environment variable that controls the behavior.

Raise the issue with your support provider.

You could always create a generic DataStage job to copy datasets.

Mike

This may help...

Craig
you rock....Thanks for your help

For what it's worth, I tested orchadmin copy again after setting APT_COMPRESS_BOUNDED_FIELDS=1 and still got the inflated result on disk. I'm on version 11.3.1.2. Perhaps the orchadmin command does not honor the environment variable.