Search found 2886 matches

by qt_ky
Tue Jul 17, 2018 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: $Apt_disable_combination
Replies: 4
Views: 8458

Why enable? Because you need to debug a problem. After you resolve the problem, set it back to False again.
by qt_ky
Mon Jul 16, 2018 6:06 am
Forum: General
Topic: Datastage closes all the time
Replies: 4
Views: 3414

6. Reboot again after installing

You could also try from another client machine or virtual desktop. Perhaps you have some conflicting software on your client.
by qt_ky
Thu Jul 12, 2018 12:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Junk Characters
Replies: 2
Views: 2846

One approach is to use a string function first to strip all white space then use another string function like AlNum() to checks whether the given string contains only alphanumeric characters or not.
by qt_ky
Tue Jul 10, 2018 1:12 pm
Forum: General
Topic: Best way to handle password parameters
Replies: 9
Views: 7144

Perfect. Thanks!
by qt_ky
Tue Jul 10, 2018 1:10 pm
Forum: General
Topic: How to delete a schedule for another user
Replies: 15
Views: 7726

From Director, an admin user, again, can only unschedule their own jobs--only the jobs that they themselves scheduled. In Director, no user can unschedule any other users' jobs. The only option in that case is at the operating system level through root access or sudo root access, is as you mentioned...
by qt_ky
Tue Jul 10, 2018 7:28 am
Forum: General
Topic: Best way to handle password parameters
Replies: 9
Views: 7144

I agree with those comments. I showed a developer once a simple way and he was surprised to learn about it. Even in a locked down production environment a sneaky developer could potentially include such a debug hack among dozens or hundreds of job changes and slip it in to a promotion. DataStage may...
by qt_ky
Tue Jul 10, 2018 7:18 am
Forum: General
Topic: What's new in 11.7 Fix Pack 1
Replies: 6
Views: 6989

Fix Pack 1 is definitely available on Fix Central. We installed it June 13, 2018. As far as having it bundled as part of a fresh install, sometimes IBM will make those available and sometimes not. No idea about their plans... You would need to ask IBM Support about that. Don't hold your breath while...
by qt_ky
Tue Jul 10, 2018 6:07 am
Forum: General
Topic: User Variable Activity syntax for timestamp
Replies: 6
Views: 4939

On AIX, if you want a space in the middle, then use double quotes: date "+%Y-%m-%d %H:%M:%S" Watch out for the %s option though as that is not fractional seconds, rather it is the number of seconds since 1/1/1970. I do not think the AIX date command has an option for fractional seconds. Se...
by qt_ky
Tue Jul 10, 2018 5:47 am
Forum: General
Topic: How to delete a schedule for another user
Replies: 15
Views: 7726

The 11.x scheduling behavior is the same as ever. If you want to unschedule a job from Director, then you must log into Director as the user who scheduled the job in the first place. Simple as that.
by qt_ky
Fri Jun 29, 2018 5:22 am
Forum: General
Topic: Best way to handle password parameters
Replies: 9
Views: 7144

I am glad to discuss this, although it could probably be its own separate topic. We are using a slightly different approach which dates back 7+ years to version 8.5, then later version 8.7, where we had found that using environment variables worked fine for database names, user names, schema names, ...
by qt_ky
Thu Jun 28, 2018 7:03 am
Forum:
Topic: IGC 11.7-Governance Monitor
Replies: 4
Views: 4819

I tried to open ours for a comparison and found that yours is in better shape. When I click on the 11.7 Governance Monitory from the launchpad, it says, "Error 404: com.ibm.ws.webcontainer.servlet.exception.NoTargetForURIException: No target servlet configured for uri: /ibm/iis/govmon". I ...
by qt_ky
Thu Jun 28, 2018 6:28 am
Forum: General
Topic: WML impact on performance
Replies: 2
Views: 2659

You can see it in real time from Director as the jobs are run. The status will say Queued instead of Running. You can also see it in near real time from the Operations Console. Go to the Workload Management (WLM) tab. In the top box under System Policies you will see some boxes light up bright red i...
by qt_ky
Wed Jun 27, 2018 12:11 pm
Forum: General
Topic: Best way to handle password parameters
Replies: 9
Views: 7144

We use parameter sets. Within those it would not matter if a user name parameter value changed; a scheduled job would pick up the new value fine, but we have found time and time again that with an encrypted password parameter, if you change the value then the next job run will not pick up the change...
by qt_ky
Fri Jun 22, 2018 5:52 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Save Scripts
Replies: 3
Views: 15967

Is has not changed that I know of. The setting is working the same for us on 11.7 as it did on 8.x, 11.3, and 11.5. I can see over 100 job logs in Director 11.7 in the default IA project. Is the analysis task completing successfully?
by qt_ky
Fri Jun 22, 2018 5:31 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Database Credentials
Replies: 2
Views: 14653

Have you tried following the steps to import the metadata using IMAM? It seems like in 11.3 and 11.5 you had to open up IMAM and start with creating a database connection there.