DSXchange

Hi, in the HD I have eough space (about 1GB). The file that I try to import contain about 10 - 20 jobs (job and job sequencer) I try to clueanup the projects but it doesn't produce any result. I try to delete and re-create the projects but it is impossible to recreate. How can I check the index in t...

Hi, After jobs I have many problem with Projects administration too. Now it is impossible to create a new project in the server (I have enough space: about 1 GB). When I try to create a new one the next errors occurs: DSR.ADMIN: Error executing UPDATE.ACCOUNT. When I try to recreate an old one that ...

Hi, sometime during the import of jobs in a project the next errors occurs: Error calling subroutine: *DataStage*DSR_SELECT (Action=2); check DataStage is set up correctly in project EBIS_REVISIONE_ARC (Subroutine failed to complete successfully (30107)) Can anyone help to explain/avoid this problem...

Hi wnogalski,
sorry but I don't understand

Can you explain?

Mario

Hi Ricardo,
Unfortunately I can't use this solution.



Is it possible to use a DataStage Routine in the "WHERE clause" of an ORAOCI8 Plug_in?

Thanks

Regards

Hi, I use the sequencer to run a job (named "JOB1") that need a parameter (named "PAR_XX") that is stored in a file. PAR_XX is in the parametr's list of JOB1 I think to read the parameter in the job control code of JOB1 and use it in the same job. When the job start, first of all...

Hi, i need to write a new routine that analyze the DataStage director log and write it in a table. In the past i used a Job contol code that did it. The code was: hJob = DSAttachJob("JOB1", DSJ.ERRFATAL) STATO = DSGetJobInfo(hJob, DSJ.JOBSTATUS) EVENT_ID = DSGetNewestLogId(hJob,DSJ.LOGANY)...

Hi, I have to do a join between a Flat file and an Hash file. In the flat file I have the timestamp FLAT.FIELD_DATE. In the hash file I have the timestamps HASH.START_DATE and HASH.END_DATE. I have to develop the oracle's command FLAT_DATE BETWEEN START_DATE AND END_DATE (I mean HASH.START_DATE <= F...

hi Ray,
in the Administrator the "Read cache size" is 128 M,
the server has 500M of memory and in the job I set "Pre-load in memory" = Enable.

Does it exixt a different method to enforce to load the entrire Hash file in memory?

Thank you

Mario

Hi Ray, I did the test in the same condition (same number of record, write cache etc). First of all I created the hash file and in a second job I used it to joins the data. In the second job the results obtained during the joins are: with modulo = 1 2500 row/sec with modulo = MINIMUM.MODULUS 400 row...

Hi, I tried to apply the suggest with this exemple: I have 1.000.000 of record in the principal stream. I 'd like to attach dimension to this data. The dimension are in 3 hash file with this number of records Hash 1 - 1.300.000 records Hash 2 - 2.500.000 records Hash 3 - 1.300.000 records. I try to ...

Hi Kenneth, i try to understand how to determine minimum modulus. I tried many many times but never i reached an over file of 2048 byte. The lower value are 372K!!!! You wrote "Since modulus is computed using average bytes per row and number of rows": which is the algorithms to calculate t...

Thank you for your information,
vmcburney, can you give me the link about IBM documentation of Unoverse administration?

Thanks in advance

Mario

Hi, I'm trying to create hash file. For Static Hash File there are about 16 different alghoritms named Type2 - Type18. I'd like to know the differences between the algorithms used during the creation of an hash file. Can anyone explain me the differences between alghoritms or tell me where i can fin...

Hi Fkana,
i suppose that DataStage log file are corrupt.

try to execute this unix command

cd <ascential project directory>
for i in RT_STATUS*
do
echo $i
<ascential direstory>DSEngine/bin/clear.file $i
done

this command clean the log file

regards

Mario