Search found 10 matches

by philolaos
Mon Sep 14, 2009 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Experiencing issue with ODBC - decimal truncated
Replies: 6
Views: 2872

Re: Experiencing issue with ODBC - decimal truncated

Yes. That worked. Thanks! However my orginal question about why this worked in 7.5.2 and is not working in 7.5.3 is unanswered. So far, we have 2 solutions to get this to work: - change write method from upsert to Write - change column from decimal to double. We have a problem that look a lot like ...
by philolaos
Fri Jun 19, 2009 10:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File descriptor out of range in fd_set
Replies: 9
Views: 11346

Nope! We already checked that extensively. Although, we may look at it this way; the problem is not with the values present in the "limits.conf" file of Datastage Server that is running that code but with the "limits.conf" on the system that compiled the shared object (*.so) that...
by philolaos
Fri Jun 19, 2009 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File descriptor out of range in fd_set
Replies: 9
Views: 11346

Someone ask me to clarify my previous post because he was not able to use it to go around that limit in his setup. Let's try to explain a bit more the usefulness of my suggestion. It is just a way to mitigate the risk to cross that 1023 limit. I mean, if your job, solely by itself, consume more than...
by philolaos
Tue Feb 03, 2009 6:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to load oracle table
Replies: 3
Views: 2062

Someone ran a test with my dsxchange account! Oracle library was not properly installed at that time. Just ignore this.
by philolaos
Tue Feb 03, 2009 6:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File descriptor out of range in fd_set
Replies: 9
Views: 11346

I forgot to say that this problem is not related to the limit on the number of open files for the system or for my user. In fact, I were able to open more than 1024 files at the same time (and monitored that with lsof) on this system but without relying on the GNU C Library. $ ulimit -a core file si...
by philolaos
Tue Feb 03, 2009 6:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File descriptor out of range in fd_set
Replies: 9
Views: 11346

I'm running into a similar "file descriptor" problem. main_program: Fatal Error: File descriptor out of range in fd_set (requested 1312, limit 1023 I'm running DataStage 8.1 on a RedHat Linux Advanced Server 4 using glibc 2.3.4. My job showing the problem is pretty simple; it reads data fr...
by philolaos
Wed Jan 21, 2009 11:01 am
Forum: General
Topic: Pb building a package with the Manager
Replies: 0
Views: 962

Pb building a package with the Manager

When I tried to build a package, I received the following error: com.ascential.xmeta.exception.data.UniqueConstraintViolationException: A unique constraint violation occured on the object with RID "3b37fb44.7dc2088e.6601059c.10815d10-107a-4ad5.a4a9.622c4162a9aa" of type "Folder" ...
by philolaos
Fri Aug 15, 2008 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to load oracle table
Replies: 3
Views: 2062

unable to load oracle table

hi, I'm trying to load a binary file into an oracle table. I'm using a sequential file stage to read the file. I'm getting this message The call to sqlldr failed; the return code = 32,512; please see the loader logfile: /appsdb/lvoradb09/opt/IBM/InformationServer/Server/Scratch/ora.6396.205060.0.log...
by philolaos
Tue Aug 21, 2007 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Version 8.0.1 Installation
Replies: 16
Views: 16993

If you plan to install everything (all the servers) on one machine, then you'd better have lots of grunt in that machine. Ok, then if I want to install on two machine (the engine, the domain and the repository... with the client obviously on a third!), would I be better off to dedicate a machine so...
by philolaos
Mon May 07, 2007 9:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Use OS Level Authentication
Replies: 5
Views: 3355

b) Enter DB name, leave ID/pswd fields

On a Job Server 7.5.2 running on Windows, you can't just left empty the User ID/Password fields. You need at least a blank character (or anything else!) in those fields. Other than that, it works!