Search found 2886 matches

by qt_ky
Tue Feb 19, 2019 11:13 pm
Forum: General
Topic: DataStage on Cloud
Replies: 2
Views: 3802

We are not considering moving any part of our Information Server installations to the cloud. I'm in government. I would say the primary reason is financial. We are able to keep the software current by applying patches as they are released.
by qt_ky
Tue Feb 19, 2019 1:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Stage Socket Error
Replies: 6
Views: 7582

In my situation I did not have to change any settings on Information Server. I had to request the firewall team to change the "extended session timeout" firewall settings. But like Craig said, that usually depends on idleness, so if your job was actively transferring data, then maybe a dif...
by qt_ky
Fri Feb 15, 2019 12:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Stage Socket Error
Replies: 6
Views: 7582

Along those lines, it could be a keep alive or connection timeout setting in a firewall. We ran into that before with a different type of database connection.
by qt_ky
Wed Feb 13, 2019 1:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Evaluate Arithmatic Expression coming in input string
Replies: 13
Views: 8458

That I don't know. Sounds like a custom routine may be a better fit.
by qt_ky
Tue Feb 12, 2019 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Evaluate Arithmatic Expression coming in input string
Replies: 13
Views: 8458

I ran a quick test file with expressions through an External Filter stage with 'bc' as the filter command and got correctly evaluated outputs.
by qt_ky
Tue Feb 12, 2019 1:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Evaluate Arithmatic Expression coming in input string
Replies: 13
Views: 8458

Seems like an unusual requirement... The first thing that comes to mind is to take the expression and put in into a UNIX Korn shell for evaluation inside of the $(( )) syntax: $ echo $((4+5)) 9 $ echo $(((20*5)+9)) 109 $ echo $(((30/5)+4)) 10 $ echo $((7 / 0)) ksh: 7 / 0: 0403-056 Cannot divide by z...
by qt_ky
Tue Feb 12, 2019 1:03 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD / Rest - Authentication for web service
Replies: 2
Views: 32292

I ran into the same issue on version 8.x in 2011 and to my knowledge, the authentication and the "ISD consumer" security role behavior has remained unchanged. See this topic. My not-so-ideal workaround was to also embed a couple of additional input columns in my job design, which I called ...
by qt_ky
Mon Feb 11, 2019 12:47 am
Forum: General
Topic: How to Read DBF File in datastage
Replies: 2
Views: 2987

Put the ODBC data source name into the ODBC Connector stage's database name. Leave the user name and password empty. Put the name of the file in as the table name. It's been a while, but I believe those are case-sensitive and you would leave off the extension, because you've defined that in your .od...
by qt_ky
Fri Feb 01, 2019 1:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to retain ONE record after comparing 2 different columns
Replies: 5
Views: 4177

Your solution should work based on your sample data. In case your data comes in a different way, like below, where 200=200 but the other values differ, then it would not remove the duplicates. Column Party1 Party2 -------------------------------------- Record1 --> 100 200 Record2 --> 200 300 Have yo...
by qt_ky
Thu Jan 31, 2019 3:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Salesforce Pack - java.net.UnknownHostException
Replies: 1
Views: 2834

I am not sure if those settings exist for the Salesforce Connector or where they might be. You might be better off taking the question to Support. Our environment used to have a lot of network problems, and while this had nothing to do with Salesforce connectivity, a lot of our nightly jobs would ab...
by qt_ky
Tue Jan 15, 2019 3:47 am
Forum:
Topic: IGC environment approach
Replies: 6
Views: 4483

Sure thing. Don't know if your environment supports this or not... With our hardware and virtualization, we have been able to build multiple LPARs within the same shared CPU pools, and avoid licensing additional PVUs. For example, our dev/test server's LPAR resides in the same CPU pool as our sandbo...
by qt_ky
Mon Jan 14, 2019 11:08 am
Forum:
Topic: Test driving new Custom Attribute Filter option in IGC 11.7
Replies: 1
Views: 3590

This is really interesting, and I am not sure I would have noticed it unless I came across your post. Thank you for highlighting it! We are on 11.7.0.2 and the interface as a "Restrict" button. I actually found a knowledge center page that details how to create, edit, or delete restriction...
by qt_ky
Mon Jan 14, 2019 10:56 am
Forum:
Topic: IGC 11.7-Governance Monitor
Replies: 4
Views: 4819

I can't speak to the Windows part because ours is on UNIX, but I was able to confirm with IBM that some of the newer web interfaces like the Governance Monitor were packaged together with Information Server on 11.7.0.0, but after applying Fix Pack 1, the newer components then required the separate L...
by qt_ky
Mon Jan 14, 2019 10:39 am
Forum:
Topic: IGC environment approach
Replies: 6
Views: 4483

Moderator, the original posts' links 1 and 2 are missing the www parts in the URLs, which cause topics to be blocked because dsxchange thinks you're not logged in... Wondering if you wanted to patch up those URLs? Thank you.
by qt_ky
Mon Jan 14, 2019 10:30 am
Forum:
Topic: IGC environment approach
Replies: 6
Views: 4483

You can also use your sandbox environment to pre-test all new feature packs/fix packs, service packs, upgrades, and security patches. Sounds like a good plan. We have Info Server Enterprise Edition with a mature DataStage and QualityStage workload, with all server tiers on one server. This supports ...