Search found 2886 matches

by qt_ky
Wed Apr 04, 2018 9:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Memory usage by lookup stage
Replies: 1
Views: 2466

I do not know for sure but strongly suspect that it uses standard memory allocation, which via your operating system also provides virtual memory. I also think there is more going on behind the scenes than the classroom training or the documentation tells us. For instance, I once had a normal lookup...
by qt_ky
Thu Mar 29, 2018 8:51 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Which TLS version does ISD use?
Replies: 3
Views: 17732

My coworker was able to resolve this on 11.3 with an all-encompassing dynamic setting change in WAS (no WAS restart required)! 11.3 has SSL_TSL which supports all SSL and TLS 1.0, but not TLS1.2. 11.7 has SSL_TLSv2, which supports all SSL and TLS variants. For WebSphere Network Deployment: In WebSph...
by qt_ky
Mon Mar 26, 2018 1:30 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Which TLS version does ISD use?
Replies: 3
Views: 17732

Which TLS version does ISD use?

One of our ISD application web service consumers has said they just disabled TLS 1.0 on their side and can no longer access the secure web services we host using ISD. Does that mean that ISD 11.3.1.2 only has TLS 1.0 enabled out of the box? We are being asked to switch to TLS 1.2, which I thought IS...
by qt_ky
Fri Mar 23, 2018 5:27 am
Forum: General
Topic: ISS 11.5 FP1 Connection to SAP/HANA
Replies: 3
Views: 4354

In general first thing I would check with a connection failed / host unreachable type of error is to check for a firewall in the way between your server and the database server on the specified port. One way you can check is from your DataStage server's command line, use the telnet command with synt...
by qt_ky
Wed Mar 14, 2018 7:29 am
Forum: General
Topic: DS Compile -CLI options
Replies: 2
Views: 2561

Sounds like a good question for IBM Support. A quick support portal search on JR42097 reveals that "No results found." Of course, that could mean the search is not working...
by qt_ky
Wed Mar 14, 2018 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MySql Connection Issue In Datastage 11.5
Replies: 25
Views: 16921

I have also found that the ODBC DSN needs to be <= 8 characters; you've got 9.

And, the DSN <SKYRPD> in the uvodbc.config file needs to match the DSN [MYSQLPROD] in the .odbc.ini file.
by qt_ky
Wed Mar 14, 2018 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MySql Connection Issue In Datastage 11.5
Replies: 25
Views: 16921

Doing a ping is a reasonable, general test but not quite the same as making a database connection. Just because ping succeeds or fails does not mean that you will be able to connect to the database. It is better to do a ' telnet target_db_server db_port ' command from your AIX Information Server. If...
by qt_ky
Wed Mar 14, 2018 7:05 am
Forum: General
Topic: Client Repository structure in DS server
Replies: 6
Views: 4272

If you just want to create a text dump of the folder structure, then I suppose you could piece it together from a DSX or ISX export file. Is that what you're looking for? What have you tried?
by qt_ky
Tue Mar 13, 2018 7:07 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to get rejected records in information analyzer
Replies: 4
Views: 16960

Yes there can be tables, if you define your rules that way. See this help topic.

https://www.ibm.com/support/knowledgece ... _daui.html
by qt_ky
Tue Mar 06, 2018 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert hexadecimal string to decimal
Replies: 2
Views: 4213

In a Parallel job: Use the Conversion() function to convert an input string from hexadecimal to decimal with conversion code MX and conversion mode I. Conversion(link.column, 'MX', 'I') See the Knowledge Center online or the Parallel Job Developer's Guide Appendix B. Parallel transform functions for...
by qt_ky
Fri Mar 02, 2018 8:39 am
Forum: General
Topic: DataStage Designer 11.7.x hangs
Replies: 2
Views: 1305

We have indeed looked into the web-based flow designer and acknowledge that it is a work in progress. In general I think it is a move in a good direction. We have not, however, used it to help narrow down the hang issue in the thick-client Designer. Thank you for the idea.
by qt_ky
Thu Mar 01, 2018 3:43 pm
Forum: General
Topic: DataStage Designer 11.7.x hangs
Replies: 2
Views: 1305

DataStage Designer 11.7.x hangs

We've had one developer report that DataStage Designer 11.7.x hangs a lot as he is opening multiple jobs, but it does not enter into a "Not Responding" state and does not give an error. He's on a normal, wired connection (no wireless), and it's the same connection he uses for 11.3.x. We ha...
by qt_ky
Thu Mar 01, 2018 8:10 am
Forum: General
Topic: Undraleu
Replies: 6
Views: 4562

Never heard of it...

Just curious, how can a code quality checking tool go beyond checking if naming conventions are followed to checking whether or not the code (or job design) met the requirements? Kind of seems like you need a human involved.
by qt_ky
Thu Mar 01, 2018 8:05 am
Forum: General
Topic: Monitoring ETL Loads
Replies: 11
Views: 4858

If you want a more active type of monitoring, then yes, they could have staff monitor using Director which you have to install, but the the web-based Operations Console is also available. Just give them access and the URL. As far as text alerts go, most wireless carriers have an email-to-text path a...
by qt_ky
Wed Feb 28, 2018 7:07 am
Forum: General
Topic: Monitoring ETL Loads
Replies: 11
Views: 4858

We did something very simple and made it part of our development standards, which was to always send sequence job abort notifications to a separate mailing list and always include "Aborted" in the subject line so that everyone receiving the emails could create mail rules to help alert them...