DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 38 matches
Author Message
 Topic: TWT relation does not exist
jackson.eyton

Replies: 0
Views: 33

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 15, 2017 9:47 am   Subject: TWT relation does not exist
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi everyone,
We seem to have intermittent issues with jobs that write to our netezza using the standard netezza connector. The error looks something like the following:
ERROR: relation does not ...
 Topic: automatically turn off RCP for every stages
jackson.eyton

Replies: 4
Views: 169

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 14, 2017 8:50 am   Subject: automatically turn off RCP for every stages
Out of curiosity here, when you enabled RCP at the project level, did you also check the box to "Enable Runtime Column Propagation for new links"? IF not, very strange, IF yes, can you confirm that RC ...
Resolved
 Topic: Balanced Optimizer missing / unavailable
jackson.eyton

Replies: 11
Views: 704

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 12, 2017 8:41 am   Subject: Balanced Optimizer missing / unavailable
Yea it turns out we started with 11.3 and upgraded to 11.5. The individual who did the upgrade was not aware that this was now a non-charged inclusion and just used the same response file he used befo ...
 Topic: Custom Routine Issues
jackson.eyton

Replies: 5
Views: 369

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 08, 2017 11:56 am   Subject: Custom Routine Issues
Thanks Chulett, I have to assume its configured correctly for us as eCapitol did our DataStage setup and configuration. I will open a case with IBM to have them confirm this however.

Here is an exp ...
 Topic: Custom Routine Issues
jackson.eyton

Replies: 5
Views: 369

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 08, 2017 11:02 am   Subject: Custom Routine Issues
*sigh* definitely shed some light on some things for me, not entirely sure things were setup correctly. Though we are able to compile jobs normally fine so it seems to be. However, I am finding it mor ...
 Topic: Custom Routine Issues
jackson.eyton

Replies: 5
Views: 369

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 2:35 pm   Subject: Custom Routine Issues
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi everyone,
I have reviewed some training in an advanced DataStage class that covers custom stages and routines, etc. I have a significant use case scenario where something like this would great ...
Resolved
 Topic: Balanced Optimizer missing / unavailable
jackson.eyton

Replies: 11
Views: 704

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 11:40 am   Subject: Balanced Optimizer missing / unavailable
Thanks QT_KY,
We are indeed 11.5 here, it sounds like this is something that our server administrators may not have setup when they installed InfoSphere?
Resolved
 Topic: Balanced Optimizer missing / unavailable
jackson.eyton

Replies: 11
Views: 704

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 8:11 am   Subject: Balanced Optimizer missing / unavailable
Yea, pretty sure we paid for it but I will have to double check. I will have to check into the self optimization further, netezza uses some SQL functions that I am not familiar with and omits some tha ...
Resolved
 Topic: Balanced Optimizer missing / unavailable
jackson.eyton

Replies: 11
Views: 704

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 06, 2017 3:55 pm   Subject: Balanced Optimizer missing / unavailable
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi everyone,
I'm about midway through an advanced DataStage class with existBI and we recently went over job optimization in the lab.

I have a good number of jobs that are essentially just mo ...
 Topic: Date Conversion
jackson.eyton

Replies: 3
Views: 180

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 06, 2017 3:47 pm   Subject: Date Conversion
Another similar post:
----- VERSION 6 -----
--Required XFM Variables--
CurrentYear = YearFromDate(CurrentDate())
--- (C) MMDDYYYY Optimized ---
IF $1 <> 0
THEN ( ...
Resolved
 Topic: Slow DataStage performance
jackson.eyton

Replies: 15
Views: 518

PostForum: General   Posted: Wed Dec 06, 2017 3:41 pm   Subject: Slow DataStage performance
Marking this Resolved as I believe we have identified the cause of the issue. IT won't budge so far, thank you everyone for your ideas and feedback!
Resolved
 Topic: Slow DataStage performance
jackson.eyton

Replies: 15
Views: 518

PostForum: General   Posted: Fri Dec 01, 2017 8:44 am   Subject: Slow DataStage performance
qt_ky,
Yes our server is a vm on a cluster, and our IT department is resistant to adding more cores to our vm as that could potentially decrease performance due to the server having to potentially ...
Resolved
 Topic: Slow DataStage performance
jackson.eyton

Replies: 15
Views: 518

PostForum: General   Posted: Thu Nov 30, 2017 1:25 pm   Subject: Slow DataStage performance
I have done some playing around with those myself in the past, however our APT settings are configured as a two node system. Our Dev server does only have two cores however. I am of the mind that the ...
Resolved
 Topic: Slow DataStage performance
jackson.eyton

Replies: 15
Views: 518

PostForum: General   Posted: Thu Nov 30, 2017 11:38 am   Subject: Slow DataStage performance
Correct, as far as the compiler licensing goes. However the issues we see when we run jobs in addition to the fact that there are only two of us, really raises a red flag for me. I imagine there are c ...
Resolved
 Topic: Slow DataStage performance
jackson.eyton

Replies: 15
Views: 518

PostForum: General   Posted: Thu Nov 30, 2017 9:56 am   Subject: Slow DataStage performance
Yea, we have done the standard AV disabling, as well as network sniffing and monitoring and so far that all looks fine. I was able to verify the CPU is pegged when I run a transfornation job.

This ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours