Search found 53125 matches

by ray.wurlod
Tue Jun 22, 2010 4:11 pm
Forum: IBM QualityStage
Topic: Survive stage error
Replies: 2
Views: 1366

I've not seen that particular error before. What precise version of DataStage/QualityStage are you using?
by ray.wurlod
Tue Jun 22, 2010 4:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Different ways to upgrade from 7.5.2 to 8.1
Replies: 8
Views: 1979

The itag is a unique identifier used as part of the shared memory keys used by the engine. For example, the shared memory in which the locks are stored has an identifier of 0xadec7521, the itag is "ade". Installing with a different itag, such as "adc", would mean that the shared ...
by ray.wurlod
Tue Jun 22, 2010 4:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multirow Hash File Lookup
Replies: 5
Views: 1902

You can not do it with a Hashed File stage. You can, however, do it with a UniVerse stage that references the hashed file through a VOC pointer.
by ray.wurlod
Tue Jun 22, 2010 2:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem Connecting to ODBC
Replies: 12
Views: 3988

Not quite. On any UNIX system it's /etc/hosts

(On UNIX, \etc\hosts would become etchosts.)
by ray.wurlod
Tue Jun 22, 2010 2:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Best installation Method fo Information Server 8.1
Replies: 6
Views: 2466

antonyraj.deva wrote:What exactly is the "X" in 7.5.X?
Just a placeholder. 7.5.X might represent 7.5.1, 7.5.2 or 7.5.3.
by ray.wurlod
Tue Jun 22, 2010 2:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC stage
Replies: 4
Views: 1742

Did the error message include SQLSTATE and DBMS Code? If so, you might search for these on the internet. It seems to me that there is a finite limit imposed on the mainframe application server on the number of concurrent connections, and your connection attempt was thwarted by that limit already hav...
by ray.wurlod
Tue Jun 22, 2010 1:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Upsert option
Replies: 23
Views: 11656

Only the obvious one - in the Before and After commands.
by ray.wurlod
Tue Jun 22, 2010 12:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to specify the key in schema file
Replies: 15
Views: 6821

Schema file can use

Code: Select all

 /* C-style comments */
by ray.wurlod
Mon Jun 21, 2010 11:09 pm
Forum: Enhancement Wish List
Topic: Web Console for Information Server Lists
Replies: 0
Views: 7292

Web Console for Information Server Lists

It is highly annoying to get the "You must select a value in the server list." message because one forgets to select the only item in a list of one. Can the list dialogs be made cognizant of the fact that there's only one item in the list so that, when an item is selected from the Tasks li...
by ray.wurlod
Mon Jun 21, 2010 8:19 pm
Forum: Enhancement Wish List
Topic: No storage locations should be able to defined.
Replies: 4
Views: 9444

This thread and this companion thread seem to be arguing for a "storage search list" - something akin to PATH and LD_LIBRARY_PATH, but for storage. I discussed this off line with the OP, who agrees with that assessment - that storage could only be allocated in directories in the search pat...
by ray.wurlod
Mon Jun 21, 2010 8:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job in Hung state
Replies: 3
Views: 1415

Probably that the job HAS finished but for whatever reason has not updated the status table that is read by Director. Or maybe you have a really long-running after-job subroutine, or your after-job subroutine set its ErrorCode argument to a non-zero value. This is an occasion for the Clear Status Fi...
by ray.wurlod
Mon Jun 21, 2010 6:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert PST to GMT in DataStage?
Replies: 3
Views: 2311

Yeah, that's a good plan. Other time zones don't have whole hour differences from GMT (Nepal, for example, or India).
by ray.wurlod
Mon Jun 21, 2010 5:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sql driver issue
Replies: 14
Views: 9380

... and absolute power corrupts absolutely.

:lol:
by ray.wurlod
Mon Jun 21, 2010 5:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC SQL SERVER special characters
Replies: 11
Views: 5749

Still verify that the correct values have been passed, in the "job starting" event for the job itself.
by ray.wurlod
Mon Jun 21, 2010 5:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concurrent running job use 95% CPU but less than 30% memory
Replies: 1
Views: 858

Like any batch process, a DataStage job will consume as much CPU as it can to get the job done as quickly as possible. Since streaming I/O is used wherever possible, there are no waits on I/O to preclude use of the CPU. That you aren't using much memory means exactly that you aren't using much memor...