Search found 2886 matches

by qt_ky
Mon Apr 16, 2012 7:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datadirect Driver
Replies: 2
Views: 2061

Check out the how-to-check-version link I put into the middle of this topic:

viewtopic.php?t=145041
by qt_ky
Mon Apr 16, 2012 7:14 pm
Forum: General
Topic: Conencting DS 7.5.3 server from my 7.5.2 Client version
Replies: 10
Views: 4536

The issue I recall is a bit sketchy as it was around 2007 I would guess... I did not involve 7.5.3 at all but it's representative of what bad things can happen due to a client/server version mismatch. It was related to 7.5.1 vs. 7.5.1A and strange runtime problems. We spent many hours getting to the...
by qt_ky
Mon Apr 16, 2012 7:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert julian date to YYYYMMDD
Replies: 9
Views: 4030

What date format is your incoming string in to begin with???
by qt_ky
Mon Apr 16, 2012 7:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ds_ipcgetnext() timeout waiting for mutex
Replies: 19
Views: 9587

What inter process timeout setting values have you tried also? Those are set per project in Administrator.

Have you opened any support case after trying all the setting changes?
by qt_ky
Sun Apr 15, 2012 8:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: working of join stage!
Replies: 16
Views: 5536

The LastRow() function added in 8.5 can be used to detect if the current row is the last row in the data, or the end of wave.
by qt_ky
Sun Apr 15, 2012 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC DSN in odbc.ini
Replies: 3
Views: 1275

You would have to search in the DataDirect ODBC User's Guide for that release to find out for sure.

The PDF files should be available under the branded_odbc directory structure. Binary FTP them to your PC to review.
by qt_ky
Sat Apr 14, 2012 9:30 pm
Forum: General
Topic: DataStage best Practices doc
Replies: 20
Views: 10460

To set auto-purge project wide to existing jobs, export all the jobs and import with overwrite.

That recreates the jobs and applies the setting to each job upon import.
by qt_ky
Sat Apr 14, 2012 9:25 pm
Forum: General
Topic: XMETA owner password
Replies: 9
Views: 4320

It looks like that patch was produced...

JR42148: APPSERVERADMIN SCRIPT NEEDS TO BE UPDATED TO DEAL WITH XMETA STAGE PASSWORD

"The -dbs option was added to the AppServerAdmin tool..."

http://www-01.ibm.com/support/docview.w ... wg1JR42148
by qt_ky
Sat Apr 14, 2012 9:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: look up aborting even when scratch disk is available
Replies: 14
Views: 3783

Check your ulimit settings by adding the ulimit -a Unix command to a before-job subroutine, running the job, and getting the output from the job log. It's not enough to run the command from a telnet session alone. Many or most ulimits settings should be "unlimited" for the server and in an...
by qt_ky
Sat Apr 14, 2012 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: size of time datatype
Replies: 11
Views: 2934

I found this info in an old Orchestrate document, so it would stand to reason that time requires 5 bytes no matter what, and I still don't know how it's actually stored internally. In other words, time must always store microseconds whether you use them or not. The time data type has a size of 5 byt...
by qt_ky
Sat Apr 14, 2012 8:30 am
Forum: General
Topic: Manager
Replies: 10
Views: 2070

I think the point is that the pre-8 DataStage Manager had a server-level respository view. If I recall right, it was a project level view by default, but there was an option you could enable to take it to the server level. I used to use it all the time too. From there you could expand any project an...
by qt_ky
Fri Apr 13, 2012 9:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ds_ipcgetnext() timeout waiting for mutex
Replies: 19
Views: 9587

In DataStage Administrator:

Have you tried increasing the inter process timeout setting in the project properties from default 10 seconds to max 600 seconds?

Have you tried increasing the project's Parallel, Operator-specific DSIPC_OPEN_TIMEOUT environment variable from the default of 30?
by qt_ky
Fri Apr 13, 2012 9:23 pm
Forum: General
Topic: Backing up to Disaster Recovery server
Replies: 6
Views: 2424

I would recommend your company consult with IBM or equivalent consultant who has done it before, in order to setup a fail-over environment properly. Obviously it is being done in a wrong way so far. It sounds like it has been attempted blindly without respect to IBM software / architecture requireme...
by qt_ky
Fri Apr 13, 2012 9:16 pm
Forum: General
Topic: Not able to login in DS 8.5 and getting some error
Replies: 8
Views: 2173

Most likely the reason is that any unsupported OS lacks required features so there would be expected issues with that combination. The solution is to install the server on a supported OS. If your other server is truly fully functional on XP, then I suppose you could attempt to clone the whole thing ...
by qt_ky
Fri Apr 13, 2012 9:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: nulltovalue
Replies: 5
Views: 2563

It depends on whatever version you're using and its options.

Read through this topic and the tech notes about legacy null processing options and stage variables:

viewtopic.php?t=145218