Search found 2886 matches

by qt_ky
Fri Jun 08, 2018 11:09 am
Forum: General
Topic: Error delete
Replies: 3
Views: 3156

Those are all informational ("INFO") log entries. Is there an error message as well?

By the way, it would be a good idea to edit the post and remove user names, server names, and IP addresses.
by qt_ky
Wed Jun 06, 2018 12:20 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD application limit
Replies: 7
Views: 21103

Thanks for responding. The warnings consistenly come in late afternoons, pretty much within minutes of each other, even across days and weeks. We had initially assumed traffic would be the cause--that there must be an unusually large number of ISD requests hitting our server at once during that time...
by qt_ky
Wed Jun 06, 2018 5:54 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: What is ODF and where is it documented?
Replies: 5
Views: 20206

I suspect the engineers are so busy developing new code using open source that nobody has taken time to properly document it as of yet. Here is one technote that mentions "IBM Information Server Open Discovery Framework." Troubleshooting / Monitoring Analyses for Unified Governance If anyo...
by qt_ky
Wed Jun 06, 2018 5:37 am
Forum: General
Topic: Database connector problem between DS8.7 and DS11.5
Replies: 5
Views: 3872

I saw strange behavior like that on Windows 7 Home Edition, which was not supported. Double check that it's Professional Edition and also revisit the documented Information Server client prerequisites to make sure you got them all. If not, then you might try uninstalling each client and doing some m...
by qt_ky
Mon Jun 04, 2018 6:41 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD application limit
Replies: 7
Views: 21103

We already bumped up the max to 60, for our 6 cores, based on the guidance found here (warning: heavy reading): IBM WebSphere Application Server Performance Cookbook "Thread pools need to be sized with the total number of hardware processor cores in mind." ... "Good practice is to use...
by qt_ky
Mon Jun 04, 2018 6:24 am
Forum: General
Topic: free, trial, or community edition
Replies: 3
Views: 2229

Thank you for the information!
by qt_ky
Fri Jun 01, 2018 9:24 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD application limit
Replies: 7
Views: 21103

ISD application limit

We are seeing regular warnings in the SystemOut.log about 1-2 times a week: 00006595 ThreadPool I WSVR0652W: The size of thread pool "WebContainer" has reached 80 percent of its maximum. 00006561 ThreadPool I WSVR0652W: The size of thread pool "WebContainer" has reached 100 perce...
by qt_ky
Fri Jun 01, 2018 9:09 am
Forum: General
Topic: free, trial, or community edition
Replies: 3
Views: 2229

free, trial, or community edition

A coworker was asking if there any any free, trial, or community edition of DataStage or Information Server that may be used at home for learning purposes. I said, no, never has been, and in fact, connectivity to free databases, such as mysql community edition is disabled. Please correct me if wrong...
by qt_ky
Wed May 30, 2018 5:40 am
Forum: General
Topic: Information Server Group security reporting
Replies: 2
Views: 2745

Try using a DStageWrapper query like in this topic:

viewtopic.php?t=154942&highlight=dstagewrapper
by qt_ky
Tue May 29, 2018 6:07 am
Forum: General
Topic: non-database sparse lookup alternative options
Replies: 18
Views: 8430

Thank you, Ray. That gives us another avenue to explore. Must the server engine's uvconfig file be modified from the default of: 64BIT_FILES 0 to: 64BIT_FILES 1 and regenerated/restarted to enable 64-bit hashed file capability? Craig, could you elaborate or post a link to your reference about the 64...
by qt_ky
Fri May 25, 2018 5:55 am
Forum: General
Topic: non-database sparse lookup alternative options
Replies: 18
Views: 8430

A normal Lookup is doing something more behind the scenes that does not appear to be documented--as it reads data from the reference link, it writes it to some sort of memory mapped file that may or may not have an index built on the key columns (I don't know), and then finally it reads that file in...
by qt_ky
Fri May 25, 2018 5:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameterized password in Stored Procedure stage
Replies: 12
Views: 7365

We have also worked cases where the password that contains prohibited special characters works just fine when you click "View Data" on a Connector stage but the same password aborts the same job at run time. The password-handling code behind the "View Data" service provided by th...
by qt_ky
Thu May 24, 2018 9:57 am
Forum: General
Topic: non-database sparse lookup alternative options
Replies: 18
Views: 8430

Yes, we do scheduled bouncing for those having normal lookups. I have scripted some ISD commands to disable then enable the ISD applications, and those scripts are called at the tail end of any sequence job that rebuilds the reference data. Those sequence jobs are scheduled to run either after hours...
by qt_ky
Thu May 24, 2018 7:50 am
Forum: General
Topic: non-database sparse lookup alternative options
Replies: 18
Views: 8430

Those are good points. The ISD jobs do not need to be parallel jobs; that's just what how were developed to begin with, out of familiarity, each running under a single node config file. Most are serving up reference data that is updated daily, weekly, monthly, or every 5 years. The smaller ones use ...
by qt_ky
Thu May 24, 2018 6:58 am
Forum: General
Topic: non-database sparse lookup alternative options
Replies: 18
Views: 8430

The security group is pushing to revoke any database privilege that smells like it could be elevated, as well as pushing changes that would force us to change database passwords on application/system IDs that were already exempted to be non-expiring, which would force us to recompile thousands of jo...