Search found 2886 matches

by qt_ky
Thu May 29, 2014 12:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset reading with different nodes
Replies: 5
Views: 1262

What is the size of the Data Set that is connected to your Lookup reference link?
by qt_ky
Wed May 28, 2014 6:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml
Replies: 3
Views: 1528

I'm unaware of any urgent limitations.
by qt_ky
Wed May 28, 2014 6:39 am
Forum: General
Topic: Clean up temp and Phantom Directory (&PH&)
Replies: 4
Views: 1910

And if it complains about those pesky & signs, it can help to double quote the path.
by qt_ky
Tue May 27, 2014 6:32 pm
Forum: General
Topic: Semaphore Process Server/Parallel
Replies: 6
Views: 2434

I've used DataStage a long time and never had to dive that deep into semaphores. "There are 64 public semaphore locks..." - LOCK statement blurb from the BASIC Language Reference. I encountered a semaphore leak problem in 8.7 on AIX, which was related to a specific ODBC driver manager vers...
by qt_ky
Tue May 27, 2014 6:19 pm
Forum: General
Topic: error while Installing IBM datastage 9.1.2
Replies: 6
Views: 5809

Review the installer log files for clues. You may have missed a prerequisite step (documented or not).
by qt_ky
Sat May 24, 2014 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Losing compiled status of jobs
Replies: 12
Views: 5468

Maybe someone will have another idea. In the meantime, start an "unsolved mystery list." :wink:
by qt_ky
Sat May 24, 2014 9:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic sequential file name generation
Replies: 13
Views: 7940

You're welcome. Personally I think the elegant solution is to parameterize the filename to begin with (easy sequence job logic) and avoid renaming files post-job or creating two files via the tee command. The tee idea is certainly an elegant workaround given your constrained environment. However, it...
by qt_ky
Sat May 24, 2014 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Losing compiled status of jobs
Replies: 12
Views: 5468

An admin could unlock the project, rename the job or folder or do anything otherwise, and lock it back when done. What do the job log event details show just before and after the timestamp of when the status changed? Open the Detailed Repository View in Designer and review details by clicking on the...
by qt_ky
Fri May 23, 2014 7:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Losing compiled status of jobs
Replies: 12
Views: 5468

Welcome aboard. There are likely several possible causes. What version are you on? I recall seeing similar behavior on version 8.5 when jobs were moved to different folder or a folder was renamed, the status would change to 'Not Compiled.' That corresponds with JR38253 which was included in 8.5 Fix ...
by qt_ky
Fri May 23, 2014 6:33 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Any add-on utility that can erase analysis results in IADB?
Replies: 5
Views: 3340

The IA 8.7 table management workspace allows deletion of multiple tables at once by using standard Windows selection methods of holding down Shift while clicking to select a range or Ctrl to pick and choose multiples.
by qt_ky
Fri May 23, 2014 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic sequential file name generation
Replies: 13
Views: 7940

:idea: Workaround to opening a "Filter command" expansion (command substitution) support case: Reusable shell script (i.e. tee_today.ksh): #! /bin/ksh tee /data/file/path/or/path/parameter/`date +"%Y%m%d"`_data.txt Filter command: /shell/script/path/or/path/parameter/tee_today.ksh
by qt_ky
Thu May 22, 2014 7:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Install 9.1.2 IIS bigdata file stage does not work
Replies: 8
Views: 1844

I had a similar experience on 8.7 with a different stage type. It turned out to be a client tier problem related to 64-bit Windows, proven by comparing a different client install on 32-bit Windows. Worked with IBM to resolve it...
by qt_ky
Thu May 22, 2014 3:25 pm
Forum: General
Topic: Cluster vs SMP
Replies: 10
Views: 4590

But if one goes down it says "A failure of single server will have a corresponding fractional impact on the total server resources that are available." In an active-active cluster, or MPP, or grid setup, you do have to license the max that is active. In your scenario, if one engine system...
by qt_ky
Thu May 22, 2014 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field value to the length of the column
Replies: 13
Views: 4860

Just in case the target field is a 200 character length and has 50 input characters, is it that the only option as we have to mention 200 zeros(or a padding character for string fields) and then concatenate and apply the right function (as left padding is what I am interseted in)? Instead of hard-c...