Search found 406 matches

by JRodriguez
Tue Aug 25, 2020 6:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage on Azure
Replies: 2
Views: 12216

Information Server 11.7.1 is the only version available in docker containers that you would need to deploy on Microsoft Azure, Google Cloud, Amazon Web Services (AWS) or Red Hat Openshift. So the answer to your questions about upgrade is yes, you would need to use version 11.7.x Check in your Passpo...
by JRodriguez
Tue Jun 02, 2020 9:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Jobs Deprecated
Replies: 6
Views: 18819

Paul,
The information is embedded in the content of below link...search for "Features deprecated in 11.7.1 Fix Pack 1"


https://www.ibm.com/support/pages/new-f ... rsion-1171

Best Regards
by JRodriguez
Thu May 28, 2020 12:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looking for design suggestions
Replies: 2
Views: 11439

How many items in the list of ValX ValY ValCol ? If small number then one way to implement it is using a transformer/loop. It will be a matter of aggregating the values into a pipe separated list of ValX,ValY,ValCol | ValX,ValY,ValCol| ... This pipe list that will be your looping values In a transfo...
by JRodriguez
Fri Feb 14, 2020 1:32 pm
Forum: General
Topic: IBM Cloud Pak & Information Server
Replies: 1
Views: 11303

IBM Cloud Pak & Information Server

Hello all, The new IBM Cloud Pak offering looks very tentative and the right path for the governance side of IIS, especially that the new WKC3.0 will be only offered on the Data Pak. That put in the air a lot of questions about the path to follow if you are a big DataStage/IA shop... How about the D...
by JRodriguez
Sat Sep 07, 2019 9:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job aborting with Return Code :255
Replies: 4
Views: 6091

How long it takes since the starting of the execution until it failed? It might be that the inactivity time out setting in DataStage Administrator is too low and the client connection that is running the job is closed... if this is the case then augmenting the value for the time out activity will do...
by JRodriguez
Tue Jun 04, 2019 9:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ZipSecureFile.setMinInflateRatio() limit Unstructured stage
Replies: 5
Views: 5670

It turned out to be a mix of numeric and alphabetic values in a column that was expecting only numerics values. There were also non-printable characters. After cleaning up the data by the user, the process fijished normal...still looking an official answer from the Big Blue on how to set up the limi...
by JRodriguez
Thu May 30, 2019 11:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ZipSecureFile.setMinInflateRatio() limit Unstructured stage
Replies: 5
Views: 5670

8) Were you there? probably the video is all over the internet now. I did pull the trigger and called them up, also the fire dept and they checked all my drawers, garbage can and the hidden places and they couldn't find the bomb...What did find was the bottle of clear liquid that we add to the coffe...
by JRodriguez
Thu May 30, 2019 8:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ZipSecureFile.setMinInflateRatio() limit Unstructured stage
Replies: 5
Views: 5670

ZipSecureFile.setMinInflateRatio() limit Unstructured stage

Looking to find out if someone had faced this issue and know how to adjust the limit on ZipSecureFile.setMinInflateRatio() in the Unstructured Stage to fix the "Zip bomb detected!" error We have been using the Unstructured Stage to process regular MS Excel files for a while without issues ...
by JRodriguez
Tue Feb 19, 2019 12:42 pm
Forum: General
Topic: DataStage on Cloud
Replies: 2
Views: 3791

DataStage on Cloud

Hello All, Anyone having DataStage on the Cloud already? Planning to? We are a big Information server/DataStage shop and looking to take advantage of the new platform for the IGC side of the tool which is evolving at light speed and looking what others, especially in the financial industries, are do...
by JRodriguez
Tue Feb 19, 2019 12:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle connector - Deadlock issue
Replies: 9
Views: 6727

...Only wait to avoid the deadlock will be controlling the size of your transactions...I would follow Ray's respond to the point
by JRodriguez
Wed Feb 13, 2019 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Evaluate Arithmatic Expression coming in input string
Replies: 13
Views: 8434

Play around to force the evaluation of the string input as arithmetic by using the AsInteger, AsDouble, AsFloat functions. Just pass the input column to one of these and that might do the trick... You might need to enforce the result by multiplying by a constant factor like below....just play around...
by JRodriguez
Wed May 16, 2018 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert space to null
Replies: 8
Views: 5138

I wonder if the target database is Oracle by any chance? If yes then by just trimming the source field, without any other logic, the database will take take of setting the target field to null
by JRodriguez
Wed Apr 25, 2018 6:30 am
Forum: General
Topic: NLS automation
Replies: 2
Views: 3032

Short answer is not for the project but you could change the NLs to a specific process or interface developed in DS dynamically if that is what you are looking for
by JRodriguez
Mon Apr 16, 2018 7:53 am
Forum: General
Topic:
Replies: 0
Views: 2313

Ended up submitting an RFE for to see if the feature could be added in the future. If you feel like is a useful feature please vote for this request, the link is listed below https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=118932 In the meantime if someone is looking to get...