DSXchange

all the stages in Datastage Enterprise ediion 7.5.2 cant capture 'unique key constraints or foreign key constraints' even though you see the error in the log. i tried with server DRS , oracle, odbc stages, and also with parallel oracle enterprise, DRS and odbc stages. none of it worked. i did this ...

By the way, an IBM case has been open for the issue. They have been able to reproduce the error internally and they are currently investigating...

I don't see nocheck in the ctl file. $ more ora.26371.825195.0.ctl OPTIONS(DIRECT=TRUE, PARALLEL=TRUE, SKIP_INDEX_MAINTENANCE=YES) LOAD DATA CHARACTERSET UTF8 INFILE 'ora.26371.825195.fifo.0' "FIX 113" APPEND INTO TABLE OLY_DEV.P1Q_testtable ( KNB1_KUNNR POSITION(1:80) NULLIF (1:80) = BLAN...

Did anyone get the resolution for this warning? I have received the same thing. "oraVBEP: When checking operator: When validating export schema: Unrecognized top level format property: nocheck " update: I've found that this warning occurs even without using a transformer stage. It seems to...

found another compiler process... 20:54:52 up 19 days, 9:11, 12 users, load average: 9.18, 5.95, 3.40 400 processes: 394 sleeping, 6 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait idle total 87.2% 0.0% 6.4% 0.0% 1.9% 0.2% 3.9% cpu00 83.3% 0.0% 7.7% 0.0% 3.9% 0.3% 4....

I have confirmed that the user "clph" has been compiling two jobs, which have taken longer than usual to compile. One of the job's compilation has been running for around 1 hour thus far.

Hello all, I did a quick search, and was surprised to not find any threads on this topic. I've recently noticed that our RedHat Linux dataStage server is pegged quite often with 0% idle CPU. During this time, I noticed that often, there are one or more "cc1plus" processes comsuming a lot o...

ok thanks for the confirmations. We'll probably end up upgrading to both 8.0 and rhel4 at the same time later this year.

Hey all, I'm looking to upgrade from RHEL AS3,update5 to RHEL AS4, update 4. I've heard from the RedHat reps that there are significant performance improvements with this upgrade, given that the Linux kernel is updated, etc. The official word from IBM is that support for AS4 will come in the 8.0 DS ...

Hi All, I'm looking to do the same (upgrade from RHEL AS3,update5 to RHEL AS4, update 4). I've heard from the RedHat reps that there are significant performance improvements with this upgrade, given that the Linux kernel is updated, etc. The official word from IBM is that support for AS4 will come i...

Hello, I'm having issues loading spanish unicode data from Oracle (UTF8) into a SQL Server 2000 database. I've tried using NCHAR datatypes, which didn't resolve the problem. But, after setting the ODBC Enterprise stage datatype on the column to LongVarBinary for the target SQL Server db, it seemed t...

Hi, I've having similar issues, loading spanish unicode data from Oracle (UTF8) into a SQL Server 2000 database. I've tried using NCHAR datatypes, which didn't resolve the problem. But, after setting the ODBC Enterprise stage datatype on the column to LongVarBinary for the target SQL Server db, it s...

We do have groups for each project, which are used to secure each project's data files, though the project files are owned by dstage. We also use project-specific groups for controlling access to the projects. But I think the problem is that since the primary group is not dstage or the project speci...

this is because our developer's unix id's have their own group as their primary group (instead of dstage). Therefore, we set the guid on the Projects directories recursively and intentionally, so that all of these files will be owned by the dstage group. Otherwise, developers will not be able to edi...

Interesting... The job compiled ok. Then I tried running the job from Designer, but ran into the same ol' error: Cannot open file RT_BP806.O Then I tried to look at the log in Director, and got this message: Error selecting from log file RT_LOG806 Command was: SSELECT RT_LOG806 WITH @ID LIKE '1N0N' ...