Search found 2288 matches

by roy
Mon Sep 16, 2013 10:59 am
Forum: General
Topic: How to release a job in DataStage 8.x
Replies: 5
Views: 2496

Hi, From version 8.5, if I'm not mistaken, there is actually a package utility enabling the packaging and deploying of repository objects into different projects and servers. I can't recall the exact name of this utility but I did use it a few times. I'll try to get the name (if no one posts it befo...
by roy
Wed Sep 11, 2013 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Run-Time is inconsistent, minutes can turn to hours
Replies: 17
Views: 9229

I agree craig, but I dont think if all goes well anyone will mark this post as having a workaround.
by roy
Wed Sep 11, 2013 7:18 am
Forum: General
Topic: Sequencer status inside another sequencer
Replies: 18
Views: 7502

I bet the time of the scheduals is derived from the need to sequence them one after the other.
By the way, if your using any schedualer (organization wide) you can also define those dependancies there.
IHTH,
by roy
Wed Sep 11, 2013 7:11 am
Forum: General
Topic: SFTP Datastage 9.1 server job failing
Replies: 3
Views: 2207

Hi,
Did you run the sftp from command line on the DS server machine?
by roy
Tue Sep 10, 2013 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Run-Time is inconsistent, minutes can turn to hours
Replies: 17
Views: 9229

It seems you have a workaround :)
Marking topic as such...
by roy
Tue Sep 10, 2013 4:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Run-Time is inconsistent, minutes can turn to hours
Replies: 17
Views: 9229

Note that having a size of over 2GB means you must have created the file with a 64Bit setting (unless your entire instance was built with 64bit), this limit is foreach of your data and overflow files seperatly. So eliminating the overflow might cause your data file to go over the limit and crash you...
by roy
Tue Sep 10, 2013 3:58 am
Forum: General
Topic: WebSphere errors during fixpack install
Replies: 3
Views: 6003

Thanks for sharing!
I took the liberty of marking the topic resolved.
by roy
Mon Sep 09, 2013 8:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Viewing data with Teradata API Stage
Replies: 2
Views: 3456

Hi,
This might be user related and/or parameter related.

Are you using the same user in the actual run and the one you log in with when viewing from the designer?

What is the difference in parameter values when the job runs and when you try to view the table from the designer?

IHTH,
by roy
Mon Sep 09, 2013 2:29 am
Forum: General
Topic: dsx is 0 kb after changing read-only from 1 to 0
Replies: 11
Views: 5205

Hi, I was wondering, was the read only attribute the product of importing to a protected project? Might be worth while to protect and unprotect (via Administrator client) turn your jobs to editable? (just thinking, cause I don't have DS V7 available) P.S. If you want to be able to edit your jobs you...
by roy
Thu Dec 06, 2012 8:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HFC hashed file calculations
Replies: 5
Views: 2701

Hi, Generally the most significant , performance wise, impact is the number of groups built as you create the file. The number og groups required depends on the number of records your about to process divided by the number of rows that fits in one group (the hashed file is built from) the size of ea...
by roy
Sun Sep 09, 2012 1:39 am
Forum: General
Topic: UTF-8
Replies: 8
Views: 2882

Any one knows the solution ?!
(even a year later as it may be)
I think it is not ok to open a topic and then simply say its resolved!
How about something regarding the solution :?:
by roy
Tue Jul 03, 2012 1:50 am
Forum: General
Topic: Execute command issue
Replies: 1
Views: 1235

Execute command issue

Hi All, I came across a strange behaviour. A server routine that calls dsexecute to performs: more +n filea > fileb works fine when executed from the test routine option but when used from a sequence job both via routine stage or exec command stage the output file is empty. parameters are same for t...
by roy
Sun Mar 25, 2012 1:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fold Basic Routine, Limit on string length?
Replies: 7
Views: 4159

Re: Fold Basic Routine, Limit on string length?

NLS was mentioned in the original post, so I had to ask. Is your job still hanging, or is it able to process around 8144 characters at a time, no problem? The 8144 characte limit was experianced in the routine test environment, the actual data tested had less then 8,000 charaters. I ended up keepin...
by roy
Sun Mar 18, 2012 2:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance statistics not visible in container
Replies: 2
Views: 2491

Are you talking about viewing the statistics on the links in the designer?
you should be able to see the performance via the monitor in the director.
by roy
Mon Mar 12, 2012 6:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fold Basic Routine, Limit on string length?
Replies: 7
Views: 4159

Wel I got the Fold out but still no change :cry: Guess this wraps the thread... I did get to a limit on testing the input string via the routine test option and hit the old 8192 string length limit notification, actual was 8180 anf actual length with no data problems was around 8144 characters IHTH ...