Search found 2886 matches

by qt_ky
Wed Mar 11, 2015 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datasatge job performance with version 9.1 and Oracle 12C
Replies: 13
Views: 6725

I vaguely recall similar issues posted and patches or fix packs solving similar problems on version 9.1. Have you looked on Fix Central and checked with Support?
by qt_ky
Tue Mar 10, 2015 7:11 am
Forum: General
Topic: Job sequencer problem
Replies: 21
Views: 4964

Try using the User Variables stage.
by qt_ky
Mon Mar 09, 2015 10:45 am
Forum: General
Topic: Patch for MDM Connector stages in DS 9.1
Replies: 3
Views: 2272

You could directly load the MDM database tables with database connector stages, however it is not recommended (likely due to the complexity of relationships, triggers, and how easy it would be to make mistakes and lose integrity in MDM). As I understand it, the approach you are using is the recommen...
by qt_ky
Mon Mar 09, 2015 7:13 am
Forum: General
Topic: Patch for MDM Connector stages in DS 9.1
Replies: 3
Views: 2272

None that I am aware of...

The MDM Connector stage was first introduced in DataStage 11.3 and is limited to reading and writing to MDM Standard Edition.
by qt_ky
Fri Mar 06, 2015 4:27 pm
Forum: General
Topic: Named License for DS/QS Designer
Replies: 4
Views: 1560

There was an update in this topic about unlimited users in version 11.3. The IBM license information documents for 11.3 appear to confirm that, as there is no mention of Authorized User (AU) licensing.
by qt_ky
Thu Mar 05, 2015 7:47 pm
Forum: General
Topic: DSODB RunStartTimestamp
Replies: 1
Views: 918

The operations database stores UTC timestamps, regardless of the time zone of the engine. This is documented on developerWorks; possibly elsewhere too. Do you see correctly converted times in the browser? When you log into the console, on the main dashboard, look at when the engine started. Does it ...
by qt_ky
Thu Mar 05, 2015 8:15 am
Forum: General
Topic: How to display project protection status from command line?
Replies: 7
Views: 4079

Specific searches on this question have come up empty. Thank you for the tip, Ray. On 11.3.1, the LIST DICT UV.ACCOUNT command reports PERMISSIONS as field number 13. I tried a LIST UV.ACCOUNT EVAL "@RECORD<13>" AS ABC command. It lists the project names in the first column and the second ...
by qt_ky
Thu Mar 05, 2015 6:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting started with the IIS Operations Console Database!
Replies: 7
Views: 3672

Perhaps it is "unofficial" IBM documentation. :wink:
by qt_ky
Thu Mar 05, 2015 6:02 am
Forum: General
Topic: Authfile option usage with DStageWrapper.sh script
Replies: 11
Views: 5659

Do you have your credentials file permissions set to 600?
by qt_ky
Wed Mar 04, 2015 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 V10.5 Install location
Replies: 6
Views: 2068

The value you found must be incorrect.

Login or su - to the db2inst1 user then run command:

set | grep -i db2

Compare each value in the dsenv file to the output from the command above.

After updating dsenv accordingly, restart the DataStage engine.
by qt_ky
Tue Mar 03, 2015 9:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Accessing DSODB using DB2 Connector Stage
Replies: 10
Views: 5449

You may also want to try leaving the db2 instance value blank.
by qt_ky
Tue Mar 03, 2015 12:56 pm
Forum: General
Topic: How to display project protection status from command line?
Replies: 7
Views: 4079

The amount of silence so far may indicate it's time for a small enhancement request. :?
by qt_ky
Tue Mar 03, 2015 12:53 pm
Forum: General
Topic: Authfile option usage with DStageWrapper.sh script
Replies: 11
Views: 5659

Mine works fine by having only the user and password in the authfile, and by calling with only the domain argument, and excluding the server argument. When I add the server option into the call, then it produces the same error you reported. Just to confirm, have you tried excluding the server argume...
by qt_ky
Tue Mar 03, 2015 6:54 am
Forum: General
Topic: Job sequencer problem
Replies: 21
Views: 4964

Not everyone can read your mind. Your original question was quite vague. Adding an example later helps a bit, later...
by qt_ky
Tue Mar 03, 2015 6:51 am
Forum: General
Topic: ODBC.ini file Alternatives
Replies: 5
Views: 1931

I think you would have to very carefully implement some fancy shell scripting to modify the .odbc.ini file.