DSXchange

I am sorry for submitting twice. Thanks for your reminder. I had search the post you metioned before posting this question. I am confused that why failed when puting oracle and teradata enterprise stage together. Different NLS result in this error? how to set the NLS_LANG in dsenv under this situati...

how to remove this one? click edit/delete this post?

Hi, Has anyone met this problem? when i seperately accessed Oracle or Teradata, things is ok, but it failed when contained oracle with teradata together in one job. my job is simple, Oracle---->Teradata The failed log as follow, main_program: The NLS character map <ASCL_ISO8859-1> specified may not ...

Hi, Has anyone met this problem? when i seperately accessed Oracle or Teradata, things is ok, but it failed when contained oracle with teradata together in one job. my job is simple, Oracle---->Teradata The failed log as follow, main_program: The NLS character map <ASCL_ISO8859-1> specified may not ...

Thank clickart. I got almost 100k rows/second loading speed when i using shell db2 "load from person.csv of del replace into db2inst1.person" . I got only 2967rows/second when using UDBDB2Load. (APT_RDBMS_COMMIT_ROW=5000,Load Method=NamedPipe,Load Mode=Insert) How to improve the loading pe...

Hello Experts, I am getting error when loading data in a DB2 table using DB2 UDB enterprise stage via LOAD method. The error as follows. DB2_UDB_Enterprise_0,0: DB2 Load Binary Error. DB2_UDB_Enterprise_0,0: SQLCODE = -27959; SQLSTATE=/opt/datastage/Ascential/DataStage/Scratch/ordb255309099d04d07_ D...

i can't fould load log at scratch disk, looks like it didn't generator load log file. the warning message begin with: TB_TMP_USER_ORDER_INFO,1: /usr/lib/pa20_64/dld.sl: '/opt/datastage/Ascential/DataStage/DSEngine/java/jre/lib/PA_RISC2.0/hotspot/libjvm.sl' is not a valid load module: Bad magic numbe...

I've met two problems when using oracle load (parallel=true,direct=true,remote server,dataset to oracle or transformer to oracle) 1, there are a lot error mixed warning messages in logs, it overflow the rows count that can show in director. how can easy to get all the logs from the starting of job? ...

The problem solved. The reason is c++ compiler
It works good when upgrading acc3.55 to acc6.0.
thanks all

hi, ray.
i created a new parallel job, drag transformer from the palette.
i checked its Target properties, showing the Stage type name as CTransformerStage.
so it is a regular transformer?

It is a regular transformer stage

I just wanted to try whether transformer work or not after installation, so the job is very simple, one coulmn(aa: char(2), not null) in RowGenerator, directly map in transformer.

Hi, my job is row generator--->transformer---->peek, i got the compile error as follows. Output from transformer compilation follows: ##I TFCN 000001 19:02:45(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Right...

thanks a million,ray

i finish it in server job control,cause the job parameter is dynamicly got from another job's output, i don't know how to do this between startloop and endloop

thanks

i'm newer to parellel job, i find that startloop and endloop in sequence job palette,

how to use startloop plugin to run job every 5 minutes?

can i use server job control to loop run a parallel job, is it bad performance or structure?

thanks

i think it's maybe cause by "Unable to get disk shared memory segment"

Is it possible get disk shared memory segment by stop other services,not restart machine?