DSXchange

We have problems with hash files in server 8.0. DS is installed on Unix with RAID5. The jobs have problems with performance. The job begin to work at 3000 row/seg but when the hash reache 260 mb it becomes at 200 row/seg, but after 10 seg it works ok with good performance another time. there is some...

DataStage shows you :
14792 that is the internal date format.
If you don't want ro use internal date format of DS use type = char.

no,

aborts with a core

the size of the xml file is 83 mb. as "From previous .." there is no message, but it has appear a core with this message: Abnormal termination of DataStage. Fault type is 4. Layer type is BASIC run machine. Fault occurred in BASIC program DSP.ActiveRun at address 7a. It seems to be a memor...

I've try with the URL/ file path option
but fails with :
'Abnormal termination of stage ' error.

Hello, I have a problem with reading xml files up to 49 mb. My job is like this: Folder Stage -> XML input -> Transformer -> Seq file The problem is with memory exceed: (Abnormal termination of DataStage. Fault type is 4. Layer type is BASIC run machine. Fault occurred in BASIC program DSP.ActiveRun...

you have transforms like MONTH.LAST already created by DS

yes, I use this practice a lot of times.

we have a similar problem with version 5r2 and Oracle8.

to solve it we did a link to the correct driver.

try to create a file in lib32 called libclntsh.so.10.1 and link it to the right one.

with a routine

a solution could be to group the 30000 files in n files of a prudent size, and then load it in Oracle. 1.-to group files you can use the unix command cat file* > file_grouped 2.-I think it could be better group in BD than in DS, so first load in table and after do: insert into table2 select columkey...

Hi,

you can use an agregator stage.
if not required values are null, then you can use Max(col)

regards,
Cristina.

you should identify first all the unix process relationated, and also you should identify all the universe internal process.
To do this you need a very height knowledge of DS machine.

If you don't have this knowledge better do what Ray advise you.

regards,
Cristina.

In Parallel seq file there is a property called Schema File: Name of a file containing a schema for the data. Setting this property will override any settings on the Format & Columns tabs. an example of this file is: record {final_delim=end, delim=',', quote=double} ( INICIAL:string[28] {delim=n...

If you are using text files, you can try to use a seq file with only a column defined, then with substrings funtion load the especific value of columns in vbles and then work with them depends on what file you are treating. example. file column varchar 255 in transformer you can use vbles: for file1...