Search found 42189 matches

by chulett
Wed Jan 06, 2010 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split file into different parts based on a given number.
Replies: 5
Views: 1515

Use a Server job with the Folder stage as the target.
by chulett
Wed Jan 06, 2010 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deletion of Dataset without Orchadmin command
Replies: 7
Views: 3060

Bad Idea. What exactly did you remove - a file that ended with a .ds extension? If so, that's not the dataset but rather the dataset descriptor file that has all of the metadata, including the location of the actual dataset file(s) which could be located across multiple nodes. Deleting things manual...
by chulett
Wed Jan 06, 2010 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading files into Siebel in xml format
Replies: 1
Views: 758

You... extract the data from Oracle, convert it to XML using the XML Output stage and then invoke whatever loader utility Siebel uses. :? Surely, however, you've been given more information than that? What the XML needs to look like? How to load that into Siebel? Kind of retarded if the answer is no...
by chulett
Wed Jan 06, 2010 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Oracle Enterprise stage in DS 8.1
Replies: 6
Views: 2132

Your linked post shows your answer as well. Not sure what else anyone could add.
by chulett
Wed Jan 06, 2010 9:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error using Before job sub routine
Replies: 3
Views: 2624

As long as there is an H: drive there, I would assume you'd be fine.
by chulett
Wed Jan 06, 2010 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: decimal number format issue in fixed length file
Replies: 9
Views: 4622

Yes, expected. Declare your output field as Char and then use DecimalToString() to get whatever output format you desire.
by chulett
Wed Jan 06, 2010 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: problem installing DS 8.1 on AIX 6.1
Replies: 9
Views: 5607

If you checked the ulimit values manually from the command line, that won't help. You need to check from a job to get accurate information - add the command as before job ExecSH and post the results.
by chulett
Wed Jan 06, 2010 9:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to start Web Console for IBM Information Server
Replies: 8
Views: 11416

You've got another post for the backup question (as you should) so won't address that here. And when you say "still is down" does that mean that you still cannot start it? If so, you'd need to go through those logs again and see what the issue is now.
by chulett
Wed Jan 06, 2010 8:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage import taking long time to complete
Replies: 4
Views: 2473

Do you have the same issue if you do the import from the GUI, i.e. from the Manager?
by chulett
Wed Jan 06, 2010 8:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Best Practices job fails to output data
Replies: 23
Views: 6429

Yes, we're glad, too. And figured it would come down to a namespace issue, they can be quite a PITA at times. :wink:
by chulett
Tue Jan 05, 2010 4:23 pm
Forum: General
Topic: Using underlying database to get audit trail of job mods
Replies: 3
Views: 3475

None of the repository tables, be it the new XMETA relational database or the 'traditional' Universe repository are documented. What I'm assuming you are referring to is the Universe table DS_AUDIT which contains the type of information you are looking for. A search for that table name here should t...
by chulett
Tue Jan 05, 2010 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Oracle Enterprise stage in DS 8.1
Replies: 6
Views: 2132

What O/S? It sounds like you've hit a kernel parameter limit with regards to the number of open files.
by chulett
Tue Jan 05, 2010 2:43 pm
Forum: General
Topic: 'Abnormal Termination of Stage' and 0 byte coredump
Replies: 11
Views: 2908

Next time that happens, Reset the aborted job and let us know if a new log entry is added labeled 'From previous run...'. Sometimes the details that it logs are the only clue we get as to the exact nature of the failure.
by chulett
Tue Jan 05, 2010 2:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: problem installing DS 8.1 on AIX 6.1
Replies: 9
Views: 5607

And you're certain of this why? Have you made the change it suggested and still have the same error? Also, have you ensured your kernel parameters meet the minimal values shown in the documentation?
by chulett
Tue Jan 05, 2010 2:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS_JOBS
Replies: 5
Views: 1697

Not really. :wink: