Search found 2886 matches

by qt_ky
Wed Jan 07, 2015 8:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Startup Time is More
Replies: 3
Views: 1331

It could be due to this known issue. If so, install the patch.

viewtopic.php?t=152133
by qt_ky
Wed Jan 07, 2015 8:53 am
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 3663

Try
-domain 9.x_server:port
and
-server 9.x_engine:port

Ex.
-domain abc9.def.ghi.com:9080
(or port 9443, etc. - port of services tier)
and
-server ABC9:31539
(or if default engine port 31538 is used, leave port number off)
by qt_ky
Wed Jan 07, 2015 8:39 am
Forum: General
Topic: MySQL ODBC Connection Issue - "SQLSTATE = IM003"
Replies: 9
Views: 10737

Double check the driver file name; it doesn't seem to match the instructions.
by qt_ky
Tue Jan 06, 2015 7:23 am
Forum: Enhancement Wish List
Topic: Unselect All Option in Data Browser
Replies: 1
Views: 6677

I agree. Even 11.3.1 selections must be done one by one.

It would be useful if you could toggle all with a single mouse click, use the Shift and Ctrl keys with mouse and keyboard selections, as well as select all with a keyboard shortcut, such as Ctrl+A, then hit Space to toggle the selection.
by qt_ky
Tue Jan 06, 2015 7:00 am
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 3663

Make sure the /.dshome file got deleted. I usually just rename it.

Make sure $DSHOME env var is set correctly.

When you call dsjob, use the -domain and -server arguments with the correct names and port numbers.
by qt_ky
Mon Jan 05, 2015 5:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of readers value in sequential file stage
Replies: 7
Views: 2171

Distributing such questions or answers is a big no-no...
by qt_ky
Sat Jan 03, 2015 1:34 pm
Forum: General
Topic: Regd datastage project jobs status monitor
Replies: 2
Views: 1333

I have not tried this myself but I am pretty sure you can configure an operations database to be shared between multiple engines. There is an abundance of console setup related documentation. Here is a link. http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.monitor.do...
by qt_ky
Fri Jan 02, 2015 6:36 pm
Forum: General
Topic: ERROR:80011:Failed to open project
Replies: 12
Views: 4195

It sounds like an environment problem.

One script option you could try:

http://www-01.ibm.com/support/docview.w ... wg21507350
by qt_ky
Thu Jan 01, 2015 9:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of readers value in sequential file stage
Replies: 7
Views: 2171

As Craig asked, have you dumped the score? Share what you find there.
by qt_ky
Thu Jan 01, 2015 9:21 pm
Forum: IBM QualityStage
Topic: NUMERIC Comparison Takes Too Long
Replies: 7
Views: 4466

That is a lot of hours. How many records are involved? Were the two methods run at the same time as each other? Were there other jobs or a varying workload running during either test? Are there a lot of other commands or steps? If so, it would help to create a test that only does that one step using...
by qt_ky
Thu Jan 01, 2015 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem-Hash Partitioning with a decimal column
Replies: 2
Views: 2241

There is documentation that mentions hash partitioner limitations, although there is not a limitation on using decimals. This quote is from http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_9.1.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/c_deeadvrf_Specifying_Hash_Keys.html Specifying hash ke...
by qt_ky
Wed Dec 31, 2014 5:27 am
Forum: General
Topic: Deployment packages
Replies: 2
Views: 803

by qt_ky
Tue Dec 30, 2014 7:36 pm
Forum: General
Topic: dsjob command without passing password - Active Directory
Replies: 9
Views: 3892

I think you cannot provide the -user argument only unless you also provide the -password argument. Try it with both arguments and also try it without either argument, as the user under which it will execute. There is a -domain NONE option and alternative setting you could try; I'm not sure if those ...
by qt_ky
Tue Dec 30, 2014 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job score explanation
Replies: 1
Views: 2240

1) Right. 2) ds0: 1st dataset carried by link lnkFromSrc, right? Right. + The [1p] means it has 1 partition; not that is will be executed on node1. + In the source stage, do you "Enable partitioned reads" set to Yes? If not, it is reading sequentially. 3) The <> means the data is going fro...
by qt_ky
Tue Dec 30, 2014 12:56 pm
Forum: General
Topic: SRVE0255E: A WebGroup/Virtual Host to handle localhost:9080
Replies: 10
Views: 4570

I'm curious if you opened any Support case.