Page 1 of 1
ETLStats question
Posted: Tue Sep 12, 2006 11:03 am
by abc123
I downloaded Kim Duke's EtlStats_20060704.zip. However, I am not sure as to how I should go about installing it. I see a file called ETLStatsInstall.txt and another one called ETLStatsInstall2.txt. ETLStatsInstall.txt starts as follows:
"You need to create some files at TCL. Probably DataStage Administrator
is the easiest. You can also telnet into your DataStage server and get
to TCL."
The instructions are not very clear. There are no step by step instructions. Can anybody help? Kim Duke?
Posted: Tue Sep 12, 2006 12:52 pm
by kduke
You need to telnet into to your DataStage server. Ken posted the code to get to a TCL prompt.
Code: Select all
export DSHOME=`cat /.dshome`
cd $DSHOME
export PATH=$PATH:$DSHOME/bin
. ./dsenv
dssh
The > is the TCL prompt. You need to Quit to get out of the DataStage engine.
Next
LOGTO MyProject
I would do:
PTERM CASE NOINVERT
Now you can cut and paste these lines into TCL:
CREATE.FILE Scripts 19
CREATE.FILE SqlScripts 19
CREATE.FILE KimD 19
CREATE.FILE Sql2Html 19
CREATE.FILE Staging 19
CREATE.FILE Rejects 19
CREATE.FILE Source 19
Follow the rest of the instruictions.
Import the jobs. Post when you get this done.
Posted: Thu Sep 14, 2006 10:03 am
by splayer
What is TCL? I know the L stands for Language? So I execute these lines at the LINUX prompt:
1)export DSHOME=`cat /.dshome`
2)cd $DSHOME
3)export PATH=$PATH:$DSHOME/bin
4). ./dsenv
5)dssh
Posted: Thu Sep 14, 2006 10:33 am
by kris007
splayer wrote: What is TCL?
Tool Command Language.
Posted: Thu Sep 14, 2006 3:01 pm
by ray.wurlod
After executing dssh in an apporpriate directory (one the is the DS engine directory or a project directory, containing a VOC file in either case) the prompt changes to ">". This prompt signifies that you are working in the TCL (terminal command language) environment. You return to the UNIX shell by executing one of the commands QUIT, LO, LOGOFF or OFF.
Posted: Tue Oct 24, 2006 8:10 am
by abc123
kim, I tried the following:
I executed
1)export DSHOME=`cat /.dshome`
from my home direcroy.
I get a message:
cat: /.dshome: No such file or directory
I executed:
2)cd $DSHOME
I get the prompt back but when I do a pwd, I get the same path as I was in before.
Also, can you explain what these 5 lines are doing?
Thanks.
Posted: Tue Oct 24, 2006 8:23 am
by chulett
Apparently nothing.
Are you sure you are executing these commands on the server where DataStage is installed?
Posted: Tue Oct 24, 2006 8:48 am
by abc123
Yes, from what I know. I am doing this on our dev box. Also, I would like to know, can I do any damage of these commands?
I am a developer and not a DS Admin. If needed, I can have my admin execute these commands for me.
Thanks.
Posted: Tue Oct 24, 2006 10:09 am
by abc123
I meant can I do any damage with these commands?
Posted: Tue Oct 24, 2006 10:27 am
by ArndW
These commands create files that would only be used within DataStage; so there is no potential for damage outside of DS and I can't see any potential within DS, either.