Hi
I am using one of my job DB2 stateg --- > Sort Stage --> Dataset
Linux OS
------------
When i run this jobs I am seeing lot of following tsort files in /scratch folder . Due to this some time scratch fill up or Server itself haung.
tsortCKdncT6O
tsortCKdUgqoF
tsortCQgnfXQN
tsortFKdncT6O
tsortFKdUgqoF
tsortFQgnfXQN
tsortGie0BCYl
tsortGie5xKRD
tsortGie7ElLD
tsortGie7ZR8k
tsortGieByIY3
tsortGieCcvnP
tsortGief3OHD
tsortGiek_@Uh
tsortGiel4zLG
tsortGienUwZZ
tsortGiepnSc2
How to solve this
Thanks
Man
Sort Stage - tsort CKdncT6O
Moderators: chulett, rschirm, roy
Increase your /tmp workspace or have Datastage use a different disk for it's soft workspace.
When you sort data, all the data must be present in order to determine the order of the data. This may require more memory than the system actually has. Datastage uses a scratch workspace on the HDD to process the data.
In your APT config file, you can specify the path for each node to use for sorting as well as general scratch space. You can find this information if you click the "HELP" button within designer and enter the search term "resource sort". The first option is Sort Configuration.
Modify your APT file with a sort resource that has enough disk space to handle your data volume.
Regards,
Ray Daignault
When you sort data, all the data must be present in order to determine the order of the data. This may require more memory than the system actually has. Datastage uses a scratch workspace on the HDD to process the data.
In your APT config file, you can specify the path for each node to use for sorting as well as general scratch space. You can find this information if you click the "HELP" button within designer and enter the search term "resource sort". The first option is Sort Configuration.
Modify your APT file with a sort resource that has enough disk space to handle your data volume.
Regards,
Ray Daignault