delete datasets

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

delete datasets

Post by reachmexyz »

Hello all

I wish to delete datasets located on UNIX by using orchadmin command.
What all i need to set up in my profile to gain privilege to that command.
I know i should export PATH and APT_CONFIG_FILE to my profile. Where can i get this information?
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

You should have permissions on dataset you are going to delete and permissions to execute the orchadmin command .Before running the command set APT_ORCHHOME and APT_CONFIG_FILE
Nag
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Post by reachmexyz »

nagarjuna wrote:You should have permissions on dataset you are going to delete and permissions to execute the orchadmin command .Before running the command set APT_ORCHHOME and APT_CONFIG_FILE
When you say set the variables, do i need to export it to my .profile on unix?
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

Yeah you can include those in .profile so that there is no need of explicily mentioning it before running the orchadmin.
Also make a note that APT_CONFIG_FILE may varies

reachmexyz wrote:
nagarjuna wrote:You should have permissions on dataset you are going to delete and permissions to execute the orchadmin command .Before running the command set APT_ORCHHOME and APT_CONFIG_FILE
When you say set the variables, do i need to export it to my .profile on unix?
Nag
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Post by reachmexyz »

nagarjuna wrote:Yeah you can include those in .profile so that there is no need of explicily mentioning it before running the orchadmin.
Also make a note that APT_CONFIG_FILE may varies

reachmexyz wrote:
nagarjuna wrote:You should have permissions on dataset you are going to delete and permissions to execute the orchadmin command .Before running the command set APT_ORCHHOME and APT_CONFIG_FILE
When you say set the variables, do i need to export it to my .profile on unix?
I have included both paths in my .profile and at the root prompt i have typed orchadmin and the output is orchadmin not found.
Do i need to execute this command from a specific directory path?
miwinter
Participant
Posts: 396
Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK

Post by miwinter »

I believe you'll need to have also run dsenv from $DSHOME
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

export APT_ORCHHOME="PATH"

export APT_CONFIG_FILE="PATH"

execute dsenv file

cd $APT_ORCHHOME/bin

orchadmin
Nag
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Post by reachmexyz »

miwinter wrote:I believe you'll need to have also run dsenv from $DSHOME
Still not working. Do i need to export PATH as well. I remember once i saw a .profile like

PATH=$PATH:XXXXX

Where can i get that information
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Post by reachmexyz »

nagarjuna wrote:export APT_ORCHHOME="PATH"

export APT_CONFIG_FILE="PATH"

execute dsenv file

cd $APT_ORCHHOME/bin

orchadmin
Hoe can i execute the dsenv file?
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

export DSHOME=/opt/IBM/InformationServer/Server/DSEngine

. $DSHOME/dsenv
Nag
vipson
Premium Member
Premium Member
Posts: 52
Joined: Thu Jan 03, 2008 10:31 pm

Post by vipson »

if don't want to get into different shells how they export the variables:
. /opt/IBM/InformationServer/Server/DSEngine/dsenv

Just another alternative.
Post Reply