DSXchange

"1) Set the parameters in the profile of your different user and nourish them by operationsystemparameters, so you never have to edit anywhere within DataStage. (2) Use Version management. " Wolfgang, thanks for your reply. We do not have version management, and I am not sure how much it c...

I am trying to replicate production environment to a test environment. All jobs have parameters set in properties, which include database name/password and bunch of directories. In prod environment the database is myProdDb and in test is myTestDb I want to change all the parameters for all jobs that...

One way to generate unique numbers is using SDKSequences hash file and its key management routines. steps are 1. update the hash file with max value 2. open hashfile in exclusive mode 3 . read value 4. update value + 1 5. close file Since we are loading thousands of rows, alternative was to use this...

Thanks to everyone for help. This is (I think ) what happened Someone / somehow the hashed file got corrupted, either type was changed or something else lead to 1. having multiple files in the SDKSequences ( generated by account ) hashed file directory. D_SDKSequences was 0 bytes. 2. could not remov...

my 2 cents

in our application, we have used the keymgtGetnextvalue , but
the key and value are stored in an hashed file
can some one explain what is better, using a table inside Datastage ( I do not know anything about it ) or a hashed file

thanks
Praveen

Ray, I used the userno ( a column by same name, middle column ) I think I found out the problem. There is a key generator routine which uses a hash file this hash file contains two columns, key and value, key is equivalent of sequence name and value is current value of the sequence. This was a Type ...

Kris, there is no known change on this job looks like the job was killed during last run ( based on log ) the job ran for 8 hours with 0 rows retrieved on all hash files. In designer, I can open the hash file to see the data and I can see data for each of the source hash files and sequence file. I t...

Thanks for your reply

this is a job, very simple, with 8 hash files and one sequence file to read from, 3 stage transformer and writes to a seq. file and database table.
I do not know if this is sufficient, but if you ask specific question, I can answer.

thanks in advance
praveen

I have a job running in production, just did not finishyesterday, when I monitor the job, 0 rows were retrieved in wave#7 and nothing happened after that. Stopped the job in director, ran again, still 0 rows retrieved. Tried to cleanup resources, nothing found. any pointers highly appreciated. thank...