Search found 4605 matches

by kduke
Mon Oct 03, 2005 2:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data warehouse failures
Replies: 14
Views: 4950

They covered up the fact that the design serks and they went ahead and approved it.
by kduke
Sun Oct 02, 2005 7:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data warehouse failures
Replies: 14
Views: 4950

successfull project" is concidered as one that met the objectives defined by the "customer" Most of the failures I have seen had nothing defined, a customer which changed their mind everytime they turned around. There are customers which are never satisfied. How can you meet expectations or objecti...
by kduke
Sun Oct 02, 2005 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data warehouse failures
Replies: 14
Views: 4950

My point is this. I would like more people to examine their work outside of what you were told to do. Was it a success or was it a failure? In your eyes was it a success. In the end users eyes was it a success. If you ask your boss then they always say it was a success. If you ask management then yo...
by kduke
Sun Oct 02, 2005 8:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Multi Instance Job
Replies: 13
Views: 2935

Your code is correct. Just duplicate the InvocationId in the parameter named JOBINVOCATIONID. I would chose a new name.
by kduke
Sun Oct 02, 2005 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data warehouse failures
Replies: 14
Views: 4950

Was this a failure, Ray because it was late? Did they use the results? Were they happy with whatever they delivered when it was finally delivered?

I have seen source-to-target documents once before I got on site. That was by far the best implementation too.
by kduke
Sat Oct 01, 2005 6:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data warehouse failures
Replies: 14
Views: 4950

I know a customer which 3 developers for 18 months to develop 200 production jobs. That is 3*18*20=1080 man days. Is that excessive? The users have no reports which can be validated against any source system. There are lots of meetings trying to figure out if the data warehouse is accurate. The ETL ...
by kduke
Sat Oct 01, 2005 5:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Multi Instance Job
Replies: 13
Views: 2935

Too short an answer again. Thanks Ray man. Just lazy today.
by kduke
Sat Oct 01, 2005 4:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data warehouse failures
Replies: 14
Views: 4950

Data warehouse failures

I was wondering if anyone has been on or seen a data warehouse fail. 1. How do you measure failure? 2. What is your definition of failed? 3. Why did it fail? 4. How did it get fixed? 5. How would you of fixed it? 6. I guess all of us have experienced some messed up solutions but is that a failure? 7...
by kduke
Sat Oct 01, 2005 1:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Multi Instance Job
Replies: 13
Views: 2935

JOBINVOCATIONID is also a parameter name.
by kduke
Sat Oct 01, 2005 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to create a user in DataStage.
Replies: 9
Views: 11567

Best sage advice of all


:lol:
by kduke
Fri Sep 30, 2005 5:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to create a user in DataStage.
Replies: 9
Views: 11567

Now you know all my tricks. No private emails please!!!
by kduke
Fri Sep 30, 2005 5:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to create a user in DataStage.
Replies: 9
Views: 11567

Here is my .profile: #!/bin/ksh # ---------------------------------------------------------------------- # Created by Kim Duke # ---------------------------------------------------------------------- set -o vi DSHOME=`cat /.dshome` export DSHOME export PATH=$PATH:$DSHOME/bin:$HOME/scripts export PS1...
by kduke
Fri Sep 30, 2005 5:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to create a user in DataStage.
Replies: 9
Views: 11567

Here is my backup script to backup critical files. KimBackup.ksh #!/bin/ksh set -x cd mkdir $HOME/SavedFiles cp .profile SavedFiles DSHOME=`cat /.dshome` cd $DSHOME sudo cp .[a-z]* $HOME/SavedFiles cp dsenv* $HOME/SavedFiles cp uvodbc* $HOME/SavedFiles cp uvconfig* $HOME/SavedFiles cd ../Projects fi...
by kduke
Fri Sep 30, 2005 5:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to create a user in DataStage.
Replies: 9
Views: 11567

To fix the UV account or the DSEngine directory if you do not know what the UV account is then here is the script FixUVAccount.ksh:

Code: Select all

set -x
cd `cat /.dshome`
sudo chmod -R 777 .DBsetup.log DSOStemp* DS_LICENSE UV_* catdir sql unohist
sudo chmod -R o+rx bin
sudo chmod -R o+rx lib
by kduke
Fri Sep 30, 2005 5:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to create a user in DataStage.
Replies: 9
Views: 11567

The roles are controlled by 3 files in UNIX: -rwxr--r-- 1 dsadm dstage 7 Mar 29 16:34 .developer.adm -rwxr--r-- 1 dsadm dstage 0 Feb 9 13:24 .operator.adm -rwxr--r-- 1 dsadm dstage 0 Mar 29 16:39 .prodmgr.adm Notice there are no operator groups and prodmgr is also 0 bytes long. The .developer.adm fi...