ETLStats question

abc123 · Post by **abc123** » Tue Sep 12, 2006 11:03 am

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?

kduke · Post by **kduke** » Tue Sep 12, 2006 12:52 pm

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.

splayer · Post by **splayer** » Thu Sep 14, 2006 10:03 am

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

kris007 · Post by **kris007** » Thu Sep 14, 2006 10:33 am

splayer wrote: What is TCL?

Tool Command Language.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 14, 2006 3:01 pm

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.

abc123 · Post by **abc123** » Tue Oct 24, 2006 8:10 am

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.

chulett · Post by **chulett** » Tue Oct 24, 2006 8:23 am

Apparently nothing.

Are you sure you are executing these commands on the server where DataStage is installed?

abc123 · Post by **abc123** » Tue Oct 24, 2006 8:48 am

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.

abc123 · Post by **abc123** » Tue Oct 24, 2006 10:09 am

I meant can I do any damage with these commands?

ArndW · Post by **ArndW** » Tue Oct 24, 2006 10:27 am

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.