Search found 4605 matches

by kduke
Wed Sep 19, 2007 8:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: automation of making jobs readonly
Replies: 5
Views: 1214

If you are doing from Windows and DataStage is on UNIX then you need something like Dwn_ExecTCL.exe. Do a search.
by kduke
Wed Sep 19, 2007 8:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: automation of making jobs readonly
Replies: 5
Views: 1214

Code: Select all

DSHOME=`cat /.dshome`
cd $DSHOME
$DSHOME/bin/dssh "UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE @ID LIKE '%ROOT' AND OBJIDNO IN (SELECT JOBNO FROM DS_JOBS WHERE NAME = 'MyJob');"
 


This should be close.
by kduke
Wed Sep 19, 2007 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load Balancing using job Control
Replies: 15
Views: 3554

Ken Bland gave away job control which would do this. Do a search. Craig uses it maybe he can explain it.
by kduke
Tue Sep 18, 2007 9:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems using -jobstatus with dsjob -run -mode RESET
Replies: 7
Views: 2794

Need to change my sig.
by kduke
Tue Sep 18, 2007 9:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems using -jobstatus with dsjob -run -mode RESET
Replies: 7
Views: 2794

Need to change my sig.
by kduke
Mon Sep 17, 2007 8:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing GenHTML -- trouble with JobReport routine
Replies: 8
Views: 3444

Thanks Brian. I am not sure why JobReport is not working. It could be a lot of things. This routine was written several years ago before the Designer could document a job. It is not the same. I did post a DOS bat file which document all jobs in a project using the Designer called from the command li...
by kduke
Mon Sep 17, 2007 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems using -jobstatus with dsjob -run -mode RESET
Replies: 7
Views: 2794

I think it works with -wait option.
by kduke
Mon Sep 17, 2007 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Any way to put parameter?
Replies: 8
Views: 2512

I would put the parameter values in a text file. Read the text file in a loop. Feed the lines into your jobs one line at a time.
by kduke
Sat Sep 15, 2007 7:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Do you have to be in a Unix Group to use Windows Datastage?
Replies: 7
Views: 1625

Typical install on UNIX is by root. The admin user is usually dsadm. dsadm is usually in a group like dstage. All DataStage users should be in the dstage group in not then you need to change permissions in the DSEngine directory. I posted the code a long time ago to make that happen. This does not a...
by kduke
Sat Sep 15, 2007 6:57 am
Forum: General
Topic: Mapping tool
Replies: 7
Views: 1919

I need a real microphone. I have one of those cheap Radioshack ones. I will work on it.
by kduke
Sat Sep 15, 2007 6:56 am
Forum: General
Topic: Mapping tool
Replies: 7
Views: 1919

Ray, I it is a memo field. You can see it more in the form. You can drag and drop a bunch of stuff into it.
by kduke
Fri Sep 14, 2007 11:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: New EtlStats soon
Replies: 34
Views: 13529

I did know that Walter had posted this m This talks you through installing EtlStats. I talk way too fast and you need to crank up the volume but if you can understand what I am saying then it will teach you a little about TCL and the repository. Thanks Walter. The link was on this newsletter m I do...
by kduke
Fri Sep 14, 2007 11:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: generating jobs reports
Replies: 60
Views: 24753

If you do not have write permission to these directories then you will have problems. It fails hard without any error messages. I should have else clauses on my writes but maybe I missed some. The JobReport routine should be there as well. I did not write this so I cannot fix it. There are notes on...
by kduke
Fri Sep 14, 2007 11:01 pm
Forum: General
Topic: Mapping tool
Replies: 7
Views: 1919

I created a tool to do mapping. It is included in the Meta Data Navigator portion of DwNav. Here is the video. Turn up your volume. Sorry.

http://www.duke-consulting.com/MetaDataMapping.html
by kduke
Fri Sep 14, 2007 10:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing GenHTML -- trouble with JobReport routine
Replies: 8
Views: 3444

Ray, you were right the first time. Tony's routine is called JobReport. I saved it in a dsx named DSJobReport.dsx. My bad. :oops: