Search found 15603 matches

by ArndW
Fri Oct 10, 2008 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to use mathamatical function of Exp in datastage
Replies: 5
Views: 2566

Are we in the Server world (as defined by the posted forum) or Parallel world (as declared in the post header)?
by ArndW
Fri Oct 10, 2008 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling Jobs at V8
Replies: 3
Views: 966

Ahh, that explains it, when I tested it I must have clicked on a once-only button. Now that I tried it again with "weekly" I get the expected cron error message (since the user really doesn't have the required access)
by ArndW
Fri Oct 10, 2008 6:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling Jobs at V8
Replies: 3
Views: 966

Scheduling Jobs at V8

Perhaps I am just having a bad day and a mental "whiteout", but a colleague has just brought up an issue that I cannot quite understand or explain. We are running Version 8 on AIX. If I try to schedule a job from the director I get an error message stating that I have insufficient privileges to perf...
by ArndW
Thu Oct 09, 2008 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Julian day
Replies: 7
Views: 4493

Would using the IsValid() function be an option for you?
by ArndW
Thu Oct 09, 2008 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: packs in Pallet
Replies: 1
Views: 1116

This is a volunteer site. "Urgent", "Immediate", "Emergency" and other such terms usually guarantee that the question will be answered much later than would otherwise be the case. Perhaps while you wait for a qualified response you could look at the documentation that is delivered with the SAP Pack,...
by ArndW
Thu Oct 09, 2008 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue with multiple installation on same box
Replies: 4
Views: 1334

What error message do you get on the second instance? If you go to UNIX, does "ps -ef | grep aaa" return any segments? What about "ps -ef | grep dsrpcd"?
by ArndW
Thu Oct 09, 2008 5:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TYPES OF LOOKUP
Replies: 3
Views: 1437

Ray - I didn't specify "commited" intentionally, because a lookup can also be against non-database sources; so to be complete one would need to say committed or written (and SYNCd) or otherwise made visible.
by ArndW
Thu Oct 09, 2008 5:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup FILESET Configuration
Replies: 2
Views: 996

Hello byjones,

How many nodes in your configuration file and what is the exact error message that you get?
by ArndW
Wed Oct 08, 2008 11:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TYPES OF LOOKUP
Replies: 3
Views: 1437

The "normal" lookup takes the complete contents of the link and loads it to a virtual dataset in memory. Each row being looked up is already in memory, so is quite fast. "Sparse" lookups actually do a lookup/select for each row separately. Each is used in a different scenario. If your data has 100 r...
by ArndW
Wed Oct 08, 2008 8:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No row was found for FETCH, UPDATE or DELETE; or the result
Replies: 5
Views: 6869

Always add a dummy record where the date is >60 months old so that the DELETE always has at least one row to process.
by ArndW
Wed Oct 08, 2008 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle write hangs infinitely
Replies: 20
Views: 7858

the full outout above is too much for me. Are you doing a load or normal table writes? Can you actually do an insert or update manually to this table?
by ArndW
Tue Oct 07, 2008 2:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle write hangs infinitely
Replies: 20
Views: 7858

Does it hang if you use a 1-node configuration file?
by ArndW
Tue Oct 07, 2008 1:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: performance issue--hash file?
Replies: 3
Views: 1093

Hashed files only have one key, when you define multiple keys the actaul key used is a concatenation of the fields, separated by a special character. You have not stated whether your problem is read speed or write speed. If the write speed has slowed down, then it is due to the number of bytes in th...
by ArndW
Mon Oct 06, 2008 11:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: working the Mainframe data
Replies: 3
Views: 1141

What is assembler data? Were these files flattened on the host or did you somehow receive binary images of the VSAM/QSAM structures? Do you have the COBOL copybooks for the data and have you looked at the files with a binary tool and tried to compare what you see with what the COBOL definitions are?
by ArndW
Mon Oct 06, 2008 11:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record count
Replies: 5
Views: 2568

Or use search to look for example DSGetLinkInfo in DSXchange.