ETLStats question
Moderators: chulett, rschirm, roy
ETLStats question
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?
"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?
You need to telnet into to your DataStage server. Ken posted the code to get to a TCL prompt.
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.
Code: Select all
export DSHOME=`cat /.dshome`
cd $DSHOME
export PATH=$PATH:$DSHOME/bin
. ./dsenv
dssh
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.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>