Deletion of Files
Posted: Fri Dec 23, 2011 3:58 am
Hi,
We currently have an issue where datastage can create files on the windows server but is not able to delete them. This has been shown where we can not overwrite datasets or surrogate key files. When a dataset stage is used with the overwrite option the job works the first time round then fails and the header file is marked as .being_deleted eg D_CLUSTER_ANSWERS_LIKELIHOOD_DATA.ds.being_deleted.
We have also tried running the orchadmin command to delete a dataset from a sequence but with no success the return from the command gives the appearqance it has worked but the dataset remains.
Another symptom we have is that if we try to use the Dataset Management Tool it crashes most of the time and leaves a process running on the server that took 8% of the CPU. We had an occassion where 12 of these were hanging on the server and we had to kill them to get the sever back.
The operating system user that is used has admin rights and is also a member of the administrators group.
I've changed the permissions of the directory that holds the datasets scratch disk and physical datasets so that everyone has access, ( getting desperate). Still no luck.
We have a PMR raised with IBM for about 3 weeks now and the standard response we have is can you send us logs etc we've sent these to them for previous PMR's but still a new set is required.
I'm currently not sure if the installation was a full success any method of validating it?
Does Windows Server 2008 have some kind of security policy that is affecting the permissions of files as written via the datastage application?
I'm starting to think we should ditch windows server 2008 and go to linux but apparently windows server 2008 is a preferred platform.
If anyone has a tip list for Infosphere on Windows Server 2008 we'd be very grateful. Anybody know how to get datastage to delete files it creates I'd have a happy xmas indeed.
Thanks
Nick
We currently have an issue where datastage can create files on the windows server but is not able to delete them. This has been shown where we can not overwrite datasets or surrogate key files. When a dataset stage is used with the overwrite option the job works the first time round then fails and the header file is marked as .being_deleted eg D_CLUSTER_ANSWERS_LIKELIHOOD_DATA.ds.being_deleted.
We have also tried running the orchadmin command to delete a dataset from a sequence but with no success the return from the command gives the appearqance it has worked but the dataset remains.
Another symptom we have is that if we try to use the Dataset Management Tool it crashes most of the time and leaves a process running on the server that took 8% of the CPU. We had an occassion where 12 of these were hanging on the server and we had to kill them to get the sever back.
The operating system user that is used has admin rights and is also a member of the administrators group.
I've changed the permissions of the directory that holds the datasets scratch disk and physical datasets so that everyone has access, ( getting desperate). Still no luck.
We have a PMR raised with IBM for about 3 weeks now and the standard response we have is can you send us logs etc we've sent these to them for previous PMR's but still a new set is required.
I'm currently not sure if the installation was a full success any method of validating it?
Does Windows Server 2008 have some kind of security policy that is affecting the permissions of files as written via the datastage application?
I'm starting to think we should ditch windows server 2008 and go to linux but apparently windows server 2008 is a preferred platform.
If anyone has a tip list for Infosphere on Windows Server 2008 we'd be very grateful. Anybody know how to get datastage to delete files it creates I'd have a happy xmas indeed.
Thanks
Nick