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.
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.
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
