Search found 19 matches

by Cranie
Tue Apr 07, 2015 4:40 am
Forum: General
Topic: Is it possible to separate DS runtime from the server
Replies: 4
Views: 2448

This is possible, you could have: AIX / scripts and from this server call the Linux DS engine. However, things to consider would be, what are your scripts doing? Do they manipulate data / source files Ds relies upon? If so then ou would have to cross-mount disks, scp them etc. I would really conside...
by Cranie
Wed Apr 01, 2015 9:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find out the bytes moved by a datastage job
Replies: 13
Views: 8658

This is very possible. We have a process that captures the DS logs, design and run information. This runs every few hours. The job is DS basic and captures 1500 job instance runs in about 10minutes (so it's pretty quick and not resource hungry) We can then extrapolate details such as how much data (...
by Cranie
Tue Feb 19, 2013 5:11 am
Forum: General
Topic: removed
Replies: 10
Views: 7181

Easiest way to "recover" a password is to stick a basic routine / before call to write the password parameter to the log file. (i.e. no special job / tool required). DS has to decrypt it for passing to external stages, so it is only secure before run / passing to DS and not while running. ...
by Cranie
Sun Jul 17, 2011 5:01 pm
Forum: General
Topic: Default port is not being used for dsjob command
Replies: 1
Views: 1397

I would check /etc/services as this is where the dsjob command is looking for the ports (handy truss command). If you are running multiple engines, upgrading etc and have switched the ports I would check for an old entry of dsrpc (even if it is now on a differing port). dsjob seems to have a check i...
by Cranie
Fri Jun 24, 2011 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Runtime Column Propagation and inserting into DB
Replies: 2
Views: 2662

Think you are right.. Think I have over complicated this.. lol.

Its the next job (comparing all columns). which I will need to do something similar. I'm going to close this topic and hang my head in shame.
by Cranie
Fri Jun 24, 2011 5:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Runtime Column Propagation and inserting into DB
Replies: 2
Views: 2662

Runtime Column Propagation and inserting into DB

Hi, Its been a long time since I have developed in DS (usually admin only). I am trying to write the following job: Teradata1 -> sort1 -> Copy1 -> merge then Teradata2 -> sort2 -> Copy2 -> merge From the merge (same stage) I have two output links, one for good records, one for bad as following: Merg...
by Cranie
Wed Nov 10, 2010 10:52 am
Forum: General
Topic: Information Server 8.5 released this week!
Replies: 21
Views: 11349

Re: Just reviewing my notes from IOD 2010

ray.wurlod wrote:There are no bugs in 8.5.
Only undocumented features and opportunities.

---
Paul Christensen
I smiled when that was mentioned at IOD...
by Cranie
Wed Nov 10, 2010 10:47 am
Forum: General
Topic: DataStage via the Web
Replies: 6
Views: 2920

We have VPN, but that requires us to use the companies laptops. Citrix is handy as can use anywhere on any machine, also overseas support use it. Director via Citrix can be slow and sometimes not as effective as the real client - like 3 second refresh on large projects / folders with lots of instanc...
by Cranie
Wed Nov 10, 2010 7:04 am
Forum: General
Topic: DataStage via the Web
Replies: 6
Views: 2920

OK, I probably didn't explain so well :-( I have the following working: <img src="http://cl.ly/9ebbe4f8b34ee3fcafbe/content" /> <img src="http://cl.ly/8b02a0a9be6028c1dd2f/content" /> <img src="http://cl.ly/3627c1e64248cd19f009/content" /> <img src="http://cl.ly/be...
by Cranie
Mon Nov 08, 2010 9:44 am
Forum: General
Topic: DataStage via the Web
Replies: 6
Views: 2920

DataStage via the Web

Where I work we have two options to dial in Citrix and VPN, the former is the quickest (and can be used on any PC with the software installed). The issue we had, via Citrix is the time it took to start DS client to review a job error. So I dutifully wrote a Web client to replicate some of the functi...
by Cranie
Mon Jun 02, 2008 8:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Debug menus greyed out
Replies: 4
Views: 2269

Should of done.. i'd of shown you the delights of Boza (Bolsover) hehe. Got a bad foot at moment.. dunno whats wrong with it.. hopping along :-)
by Cranie
Mon Jun 02, 2008 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Debug menus greyed out
Replies: 4
Views: 2269

:-) thought someone would appreciate it. Thanks for the help. It was because the job wasn't compiled by the user who was trying to run it!

Cheers!
by Cranie
Mon Jun 02, 2008 7:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Debug menus greyed out
Replies: 4
Views: 2269

Debug menus greyed out

Hi,

We have 2 jobs (both server) both created by same user and same unix permissions.

One job we are able to set breakpoints via the debug menu, but the other we are not, ay ideas?
by Cranie
Thu Apr 17, 2008 3:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSX stage names to meaningful stage names
Replies: 10
Views: 12415

Thanks Ray, that looks like what I need.

Cheers
by Cranie
Wed Apr 16, 2008 8:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSX stage names to meaningful stage names
Replies: 10
Views: 12415

Sorry yes, the list jmckeever provided is incomplete. For example: CCustomInput CHashedInput CTrxOutput CHashedOutput CCustomOutput CJSJobActivity CJobDefn CCustomStage CTrxInput CContainerView CJSActivityOutput CJSActivityInput CODBCInput CSeqInput CContainerDefn CSeqOutput There are others this is...