Search found 53125 matches

by ray.wurlod
Mon Jan 07, 2013 7:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: date conversion from small int
Replies: 5
Views: 1258

Day zero could be 1968-12-31 if it's come from UniVerse or UniData.
by ray.wurlod
Mon Jan 07, 2013 7:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TSort scratch space is full
Replies: 5
Views: 2766

How have you proven the available space? Can you show us the output of that command?
by ray.wurlod
Mon Jan 07, 2013 7:54 pm
Forum: General
Topic: Large DSParams File
Replies: 7
Views: 2042

If you do everything via Director use values files for your parameter sets and make the "value" of the Parameter Set the name of an appropriate values file.

You do not need to re-compile if you change the values of parameters. They are read at run time. That's the whole idea, after all.
by ray.wurlod
Mon Jan 07, 2013 7:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Loading Date
Replies: 4
Views: 2508

Read up about format strings and about century pivot. You can, in fact, combine the two. For example, a format string of "2000yy-mm-dd" will force the century part of the year to be "20". Where you only have two digit years you will definitely need to specify the century pivot ye...
by ray.wurlod
Mon Jan 07, 2013 7:49 pm
Forum: General
Topic: Trouble importing - Job cannot be found in the repository
Replies: 7
Views: 5194

It does not check for dependent objects so that references to the deleted job(s) can be deleted from them.
by ray.wurlod
Mon Jan 07, 2013 3:54 pm
Forum: General
Topic: Trouble importing - Job cannot be found in the repository
Replies: 7
Views: 5194

Are you sure you deleted them from both repositories (the local project repository and the common metadata repository (XMETA))?
by ray.wurlod
Mon Jan 07, 2013 3:53 pm
Forum: General
Topic: Large DSParams File
Replies: 7
Views: 2042

I'm not aware of any limit on the size of the DSParams file, though its contents do need to be read into the private memory area of certain processes, so that might impose some kind of indirect limit. That, in turn, would be affected by your system's ulimit settings.
by ray.wurlod
Mon Jan 07, 2013 3:46 pm
Forum: General
Topic: Trouble importing - Job cannot be found in the repository
Replies: 7
Views: 5194

Contact support. They may be able to offer something similar. All I could see was that you are on 8x.
by ray.wurlod
Mon Jan 07, 2013 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_ipcput() - timeout waiting for mutex
Replies: 16
Views: 8694

Have you tried increasing SPINTRIES (maybe doubling it)?
by ray.wurlod
Mon Jan 07, 2013 3:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DateGenericIsDate is NOT working
Replies: 13
Views: 6481

So, 2013 does not exist for US-English locale. Did the fiscal cliff thing actually happen?
by ray.wurlod
Mon Jan 07, 2013 3:41 pm
Forum: General
Topic: Trouble importing - Job cannot be found in the repository
Replies: 7
Views: 5194

You probably need to use the SyncProject functionality in ISALite.
by ray.wurlod
Mon Jan 07, 2013 3:40 pm
Forum: General
Topic: Job Dependency List From Master Sequencer
Replies: 5
Views: 2554

You need to identify any object that is a sequence and search that recursively.

(You could also script an iterative solution.)
by ray.wurlod
Mon Jan 07, 2013 3:38 pm
Forum: General
Topic: All available licenses in use
Replies: 22
Views: 7074

You can kill the dsdlockd process.
by ray.wurlod
Mon Jan 07, 2013 3:31 am
Forum: General
Topic: What activities are performed when indexes are rebuilt ?
Replies: 1
Views: 712

The report produced by DS.REINDEX command (which is invoked from the DS.TOOLS menu) documents everything that happens. In short, for each hashed file mentioned its indexes are dropped, re-created and re-populated from the base data.
by ray.wurlod
Sun Jan 06, 2013 6:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_ipcput() - timeout waiting for mutex
Replies: 16
Views: 8694

What Craig said. Don't worry about the "mutex" part of the message; this is simply how semaphores are implemented on your system (MUTually EXclusive locks).