DSXchange

What iexactly nodes refers to?
I think that it is for pationating process in n process in s.o. and for use diferrents memory zones.
If you hav more or less cpus it doesn't matter, isn't?

I have 2 nodes in configuration file. I have 4 cpus. if a haven't do a lot of transformatios y better use parallel than server. I think that if you the job imports data to memory , do transforms , and write data in seq, becouse of working in sequential mode, is no better performance. regards, Cristina

if i have a parallel job and I use a sequential file to read data and to write data, i have no better performance than using a server job, isn't?

regards,
Cristina

You can use 64-bits Hash file. resizing the Hash file created by the job.

execute the TCL command:
RESIZE HashFile * * * 64
before write in the hash file

regards,
Cristina.

it seems that the problem cuold be that you have no informed the value of the key o_st_uid regards, Cristina Hi , I am geeting the following error while running the DS job.And got aborted Please help me out. Stlkp..Transformer_1: [Informix][Informix ODBC Driver]Unspecified System Error = -11103. SQL...

Or you can write a before/after subroutine that calls your tcl commads

try with SqlScript = "SET HEADING OFF\n" SqlScript = SqlScript:"Delete from ":TABLENAME:" Where ETL_KEY in\n" SqlScript = SqlScript:"(Select ETL_KEY from OLB_ETL_LOAD_FACT where BATCH_ID in\n" SqlScript = SqlScript:"(Select BATCH_ID from OLB_ETL_BATCH_FAC...

if you put the err variable = "" then the len(err) = 0 if you want to reject the row ,isn't it? I think you must use if len() = 0 instead of len> 0 to reject. any suggestion: whay don't you use in the constraint: isnull(field) --> then set the reject row option = true regards, Cristina.

You can use the isnull function.
in a lookup, if the row doesn't mach the condition, the fields of the row are set to null.

regards,
Cristina

Thanks a lot Ray and Craig

regards,
Cristina

How I can change the hash file to 64-bit in DS Designer?

I must do the CREATE.FILE command in universe?

regards,
Cristina.

Yes for root the ulimit is: time(seconds) unlimited file(blocks) unlimited data(kbytes) 131072 stack(kbytes) 32768 memory(kbytes) 32768 coredump(blocks) 2097151 nofiles(descriptors) 2000 in uvconfig is: ULIMIT 128000 I think that the limit of 2Gb of Hashed files was "removed" in the lastes...

how i can set it to unlimited?

it is relationated with the max Hash file size?

regards,
Cristina.

it is dangerous to chage ULIMIT param in uvconfig?
it should be better change this param that change the ulimit value for root, isn't it?

what value could be good ?

it is relationated with max size of a Hash file?

regards,
Cristina

Hello, do you know where datastage changes the value of ulimit data,stack and rss? the parameter ULIMIT in uvconfig, at what value is referenced? nofiles? I change the ulimit in the enviroment of the user in Unix but when i execute a job this limit are not the same. I have look in dsenv file and the...