DSXchange

Hi Ray, I've paid for premium membership but can't yet see your response. I've logged it with the admin. But if I read between the lines based on the first sentence of your response . . . Sounds like the issue won't be resolved either if I can't copy /appl/datastage/IBM/InformationServer/Server/. ov...

Hi, previously we were able to copy a project from our production environment on DS 7.5 by copying the project directory. Now when I copy from the following directory on production: .. /Projects/EDW_PROD to the same directory on our development box: ..Projects/EDW_PROD - the jobs don't seem to be sy...

Hi Craig, Given we are not on HP should not increase SPINTRIES now? Or should I go ahead anyway and set SPINTRIES to 250? This timeout waiting for mutes problem seems to be occuring sporadically, and I have no means to prevent it other than removing the link collector stage and replacing it with a h...

Looks like if I put an entry for SPINTRIES (say 250) I will have to put an entry for SPINLOCKS in the uvconfig as well. What, in your opinion, is a sensible combination of these 2 variables?

Hi, Ray It's currently set to zero. I can't see an entry for Spinlocks (as below) - what's your recommendation? Should I set to 250? ************ # SPINTRIES - On an HP multi-processor system this # value determines whether spin locking is used # instead of regular semaphore locking. This value # de...

Hi Craig and Ray, I'm not quite clear on what you mean by timeout at the "stage" level, I don't adjust the timeout at the stage level, merely at job or project level. Can you kindly clarify? Increasing the timeout does help, sometimes. Are there also settings I can tune at the back end of ...

Hi Craig, and further updates on this query? I've just come back from holidays and we still seem to be having this issue in our test environment.

yes, it's a link collector.

Hi, thanks for your reply! The job design is 2 oracle sources feeding a transform each, then each transform feeds into a common merge stage. Finally, the merge stage feeds a transform that goes out to a target oracle stage. The issue is fixed by populating a hashed file instead of a merge, but I hav...

Hi we are on linux rh 5, running DS server 8.5 and are gettting the following error: ds_ipcput() - timeout waiting for mutex on a merge job. We have changed the project tunables to be: Interprocess, tried all options of buffer size and timeout. The current buffer size is 512 and timeout 60. (we have...

we are using linux redhat 5 (server) with a windows 7 client on oracle 11g. We are using the datastage ORAOCI9 stage.

Hi there, just realised my post got cut off. I'm getting the message: dsloadlibrary: error in dlopen of oraoci9.so. The above entry is what I have in my dsenv file. I've included the oracle variables . . . but I still have an issue connecting to oracle.

ORACLE_HOME=/appl/oracle/product/11.2.0.3/client_1 ORACLE_SID=edwprod export ORACLE_HOME ORACLE_SID if [ -n "$DSHOME" ] && [ -d "$DSHOME" ] then ODBCINI=$DSHOME/.odbc.ini; export ODBCINI HOME=${HOME:-/}; export HOME #LANG="<langdef>";export LANG #LC_ALL="<l...

think I've figured out a way to update the voc file with a datastage job. Just want to confirm that - assuming the voc has been updated - there's no other issues with copying old hashed files (7.5.2) across to the new DS 8.5 platform??

Hi, thanks for your speedy response. Ideally I'd like to update the voc manually, because we have well over 400 jobs etc. I'm assuming there's already a voc file as part of my install and import of the existing jobs. I can get a list of existing hashed files and insert them into the VOC? Is this sim...