Dataset Deletion

gopskrish · Post by **gopskrish** » Thu Jun 16, 2005 4:31 am

Hi,

When i try deleting dataset files using orchadmin, I am getting following error messages. can anyone throw me some light on that ? How can i overcome this?

orchadmin delete /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds
##I TFCN 000001 06:08:03(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TUTL 000031 06:08:03(001) <main_program> The open files limit is 1024; raising to 4096.
##I TCOA 000024 06:08:03(002) <main_program> Deleting /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds.
##I TFSC 000001 06:08:03(003) <main_program> APT configuration file: /tmp/aptoa1445023d2a079
##E TFDM 000038 06:08:04(000) <delete /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds> Rename /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds to /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds.being_deleted failed.
##I TCOA 000026 06:08:04(001) <main_program> Delete FAILED for /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds

I posted the same in the wrong location lasttime and thanks roy for correcting me the same.
cheers,
gopskrish

ArndW · Post by **ArndW** » Thu Jun 16, 2005 4:57 am

Did you go into your /staging directory and delete the files? If they are there, does the user you are calling orchadmin have owner or delete rights? Can you view the data or access the descriptor from the datastage client?

gopskrish · Post by **gopskrish** » Thu Jun 16, 2005 6:31 am

Hi Arnd,

When i tried deleting the files using rm command in unix, i was getting the message permission denied.
The execution permission is there for the Owner but not for the user and group.

Yeah, I can view the data and access descriptor from datastage client.

But Andw, u know for some of the conditions (like deleting records which are 10 days old), some of the files are getting deleted from the staging but not from Dataset directory.

Kindly let me know how can i proceed further on this and thanks a lot for a prompt reply.

cheers,
gopskrish

ArndW · Post by **ArndW** » Thu Jun 16, 2005 7:57 am

Gopskrish,

you have identified the reason for the deletion failure - insufficient access rights. Now you need to revisit your user setups and group permissions and perhaps also your umask settings. Who is the owner for the files you can't delete?

The subject is exhaustively described in the DataStage Administrator's Guide pages 1-15 ff.

gopskrish · Post by **gopskrish** » Thu Jun 16, 2005 8:48 am

Thanks Arndw for your valuable inputs. I think I can go from here onwards. Thanks a lot onceagain.

cheers,
gopskrish

ray.wurlod · Post by **ray.wurlod** » Thu Jun 16, 2005 9:18 pm

orchadmin delete /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds

Is not the correct command orchadmin rm dataset ?

richdhan · Post by **richdhan** » Fri Jun 17, 2005 9:40 am

Hi Ray,

I have used both rm and delete commands and it seems to work well. Is there any difference?

I will also check from my end.

TIA
Rich