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
Dataset Deletion
Moderators: chulett, rschirm, roy
Dataset Deletion
I am verymuch interested to learn an ETL tool and i find datastage as the best one to do so.
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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
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
I am verymuch interested to learn an ETL tool and i find datastage as the best one to do so.
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is not the correct command orchadmin rm dataset ?orchadmin delete /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.