Search found 124 matches

by pneumalin
Mon Jul 14, 2008 11:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation of DataStage 7.5.2 on RedHat Linux 4.0
Replies: 4
Views: 1895

Don't count on the installation guide too much, though you should read through the Guide before you proceed since you don't want to get into situation stated by Arnold... There are a couple tricks on installing 7.5.2 in RH Linux 4, where the installation guide doesn't touch too much. Post your messa...
by pneumalin
Wed Jul 09, 2008 10:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while compiling the job
Replies: 15
Views: 10670

This compiler error is nothing to do with your PX Routine based on the error message you posted. Your Transformer Stage is possibly corrupted by RCP option in Output link. Try the followings: 1. Remove the Transformer Stage, Drag a new one to designer, and remap all the Output link columns. 2. Ensur...
by pneumalin
Wed Jul 02, 2008 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning when using environment variable in transformer stage
Replies: 5
Views: 2568

Just a friendly correction to the exact syntax of using GetEnvironment: It should be GetEnvironment("EnvVar"), NOT GetEnvironment("$EnvVar") . The '$' in the double quote however confuses the function and won't return the correct value. I am using AIX 7.5.2, don't know if Windows...
by pneumalin
Wed Jun 04, 2008 1:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Routine in dataStage PX
Replies: 17
Views: 7023

Yeah, that really sucks! Somebody should open up a case to IBM to fix it.
I will definitely put this alert to my client for upgrading to V8. Maybe that is IBM's strategy to suppress DataStage community from using Server jobs... :cry:
by pneumalin
Thu May 08, 2008 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COnver Server routine to parallel
Replies: 7
Views: 2180

To convert your basic routine to C routine is doable. The first two lines are ok via using strcat and system in C, but you may have to dig into the include files in .../DSEngine/include or .../PXEngine/include to find out if those functions such as trim, Ereplace/Convert, Field are declared, and sea...
by pneumalin
Thu May 08, 2008 10:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Never use basic transformers!!!
Replies: 22
Views: 9566

Did you compile the job and run through some data?
Please tell me what is your OS and V8.0.1 or V8.0.0.
by pneumalin
Thu May 08, 2008 10:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Never use basic transformers!!!
Replies: 22
Views: 9566

You may need to do the following to add Basic Transformer to your palette: 1. Create a PX job in designer. 2. Right Click on Palette window and select "Customization->Customize" 3. On the Top-Left window, click on StageType->Parallel->Process to select "Basic_Transformer" 4. Clic...
by pneumalin
Thu May 08, 2008 9:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Never use basic transformers!!!
Replies: 22
Views: 9566

MPP is for sure not in the case I described in my previous post. My clients has already paid the premium price upfront upon purchasing the product, so the license issues never come across to their attention. It's good to know the limitation for helping out the new clients in the future, Thanks for t...
by pneumalin
Wed May 07, 2008 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Never use basic transformers!!!
Replies: 22
Views: 9566

I'd like to defend on the method using Basic Transformer in PX job via following observations: 1. Place Basic Transformer in a PX job won't break Partitioned Parallelism inscribed by PX engine, since it can be run in Parallel to map with Partitioned method declared in its Predecessor stage and its S...
by pneumalin
Wed May 07, 2008 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use Basic Transformer in PX job
Replies: 8
Views: 2611

ray,
I believe there must be some patches around to fix this issue for Windows XP and 2003 server since I found the other clients had no problem on this topic using Windows 2003 server. Will talk to IBM for a patch, and will let you know if this patch works.
by pneumalin
Mon May 05, 2008 10:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use Basic Transformer in PX job
Replies: 8
Views: 2611

Ray, I tried to save the job as a new one, and replace the Basic Transformer with a regular PX transformer and the job finished no error. I have also created a new job from scratch using PX tranformer and the job finished no error also. Any other hint? BTW, I tried to change UVTEMP to the other driv...
by pneumalin
Mon May 05, 2008 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use Basic Transformer in PX job
Replies: 8
Views: 2611

Ray, I have reboot the Windows XP several time to ensure there is no system resource issue before I rerun this job. However, the problem is consistenly occuring no matter what I tired to run. To my understandings, there is only one version 7.5x2 in Windows and I don't have any patch related to this ...
by pneumalin
Sun May 04, 2008 6:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use Basic Transformer in PX job
Replies: 8
Views: 2611

Ray, thanks for reply. I am executing the PX job in a single PX machine(Server/Client installed), and I have ensured UVTEMP point to C:\TEMP and C:\TEMP is empty and C: got plenty of space, but the problem persists. The same patch level of DataStage server/client installed in Windows 2000 server D: ...
by pneumalin
Sat May 03, 2008 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use Basic Transformer in PX job
Replies: 8
Views: 2611

Use Basic Transformer in PX job

Hi All,
Has anyone encountered the following problem:
ds_ipcopen() - call to OpenMutex() failed - The system cannot find the file specified.

When using Basic Transformer in a PX job.

I have no problem in Windows 2000 server, the problem is in XP.

Please help!
by pneumalin
Thu Dec 06, 2007 11:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UNIX just resetting the job
Replies: 4
Views: 2557

As advised by Ray, the job is not being RESET. Therefore you ran into BADJOB state when you executed dsjob -run. Simply run dsjob -run - reset prject_name job_name or reset the job from director before dsjob -run, and the problem shall go away...