Search found 15603 matches

by ArndW
Sat Oct 14, 2006 3:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: One file regarding the info of the all files in the folder
Replies: 1
Views: 509

I think that this is a clear case of using a UNIX shell script. The KISS principle applies and a short script is better than a medium-sized DS job/program.
by ArndW
Fri Oct 13, 2006 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failed.
Replies: 17
Views: 5559

Does that mean Oracle to Oracle with no other stages?
by ArndW
Fri Oct 13, 2006 3:16 pm
Forum: General
Topic: See you at the IBM show
Replies: 6
Views: 3296

Ray - I'm changing lawyers. No visa issued for poor lil' me yet. I'll be there in spirit, though... (going back to the Caribbean in 2 weeks, though; so only part of my spirit will be there). I can send a picture. It will probably be subtitled "Please call the police immediately if you see this man. ...
by ArndW
Fri Oct 13, 2006 3:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COBOL COPY BOOK
Replies: 16
Views: 3412

I'm not sure why the button is dimmed, but your lines all need to start on column 8 or 12 except for the comment, which need to start on column 7
by ArndW
Fri Oct 13, 2006 3:02 pm
Forum: General
Topic: See you at the IBM show
Replies: 6
Views: 3296

Can I get an autograph?
by ArndW
Fri Oct 13, 2006 3:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failed.
Replies: 17
Views: 5559

There is more to it than a DB stage to DB stage. The "Heap" is used when sorting (or repartitioning), so perhaps you could explain a bit more about what you are doing.
by ArndW
Fri Oct 13, 2006 9:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSJOB.exe - returncode is 0 but job was aborted
Replies: 3
Views: 2272

you can add the -userstatus or -jobstatus to the dsjob command.
by ArndW
Fri Oct 13, 2006 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job performance
Replies: 9
Views: 2008

Craig - I wasn't sure until I checked it on Google, and MS marketing blurb said that you can; so it must be true.
by ArndW
Fri Oct 13, 2006 8:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dsx readonly
Replies: 2
Views: 669

You could do a global change of the .dsx file from UNIX or your favorite editor and replace occurrences of Readonly "1" to Readonly "0"
by ArndW
Fri Oct 13, 2006 8:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job performance
Replies: 9
Views: 2008

Can you partition your SQL server table to reduce the slowdowns as the table grows?
by ArndW
Fri Oct 13, 2006 8:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error running Sequence
Replies: 6
Views: 1606

What sort of hardware is this running on and how complex are the PX jobs you are starting. Perhaps you have flooded the system with hundreds of processes and the pipe setup hasn't completed in time.
by ArndW
Fri Oct 13, 2006 8:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: EBCDIC to ASCII Conversion
Replies: 7
Views: 1565

That is correct, unless you convert the data while reading the PX engine doesn't have builtin functionality to perform that conversion.
by ArndW
Fri Oct 13, 2006 7:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Authorization Codes
Replies: 10
Views: 3088

The authorization code looks at your OS and number of CPUs and the actual product being installed. Could you be entering the DSDES codes for the server by misteak?
by ArndW
Fri Oct 13, 2006 7:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Privileges on the tables in DB2
Replies: 1
Views: 760

The necessary SELECT priviliges are sufficient, except for the tables you are actually using.
The privileges refer to those of the userid that connects to DB2.
by ArndW
Fri Oct 13, 2006 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Authorization Codes
Replies: 10
Views: 3088

That should not cause the problem. It is important to go through the registry after an unintall to make sure all DataStage related entries have been removed.