DSXchange

In uvconfig file, i couldn't locate the NLSMODE parameter. It seems i need to reinstall Datastage 8.5 server again witn NLS enabled. But while doing the reinstallation, Datastage option is not available to select. I don't know how to proceed with the NLS installed. Please help?

Hi All, We found many unknown folders/fine in our DataStage project path which are created a year back. These folders are having some undefined naming standers and also contains files like ipf__1 and opf__1 etc. Could please let me know how these files being created through DS jobs. Shall I remove t...

the problem was been solved with the inclusion of DS_NO_FF in the desenv file. DS_NO_FF=1 export DS_NO_FF Hi All, Here you have mentioned that the above statements have to be included in desenv file. Could you please let me know this file path. hope this is not an dsenv file which is available in D...

Hi,

When i try to create a project in Datastage 8.5, it is getting created as <Project Name>(broken) example: dsproject1(broken). If any one have come across this issue, kindly let me know how you solved this.

Thanks.

Hi, Our infrastructure is undergoing a Database migration from Oracle 10g to Oracle 11gR2 in Exadata Server. The effect of this migration is Datastage migration from 7.5.2 to 8.1. So I request you to share the experience in case of any similar migration happened in your projects. Please highlight th...

Thanks Ray for the Info.

Hi all, I have a requirement where I need to extract the files from a path in UNIX directory and place it in the sharepoint path which will be reflected in the sharepoint portal. Is there a method available in Data Stage to do the above task? Are there plug-ins or tools that could be integrated with...

Any running clients (director or designer) will have this file open. RESIZE DS_JOBS * * * has thrown an error saying "Unable to gain exclusive use necessary to continue. File is currently in use by other processes. Please try again at a later time when the file is not in use" This has occ...

As far I know there is no measure to identify the size of DS job but all that you can identify is to find out the space occupied by the job in the project directory by executing the below command.

execute du -h <directory> in the project path would give you the size of the directory in MB.

Is there a way to identify the running clients in a particular project? I have the below command ps -ef |grep dsapi since we have several projects, this command lists out the opened client connection of all the projects in the server.

RESIZE DS_JOBS * * * has thrown an error saying "Unable to gain exclusive use necessary to continue. File is currently in use by other processes. Please try again at a later time when the file is not in use" The error is strange becuase no one has logged into the system and none of the job...

Hi Arndw, I have requested the admin (having root prvillege) to run the below command even then issue with DS_JOBS was not sorted out. find the log below. ./fixtool -file DS_JOBS -level 5 -fix 3 Errors found in file groups. 0 Other errors found in file. 5190 records processed. 3 Errors on file. Star...

Hi ArndW, Thanks for your response. I ran the UVFIXFILE utility in DSADMIN window but thrown a message saying "User does not have superuser privileges! Disabling the FIX option and continuing" even when I run it with dsadm user which I guess is the administrator. Please let me know if my u...

This is the output of the command UVFIXFILE DS_JOBS >UVFIXFILE DS_JOBS Beginning TRACE of DS_JOBS. ID "\\\15000 - AtomicExport" doesn't hash to primary group 1. ID "DiRDMActivityDimn" doesn't hash to primary group 1. ID "\\\15000 - AtomicExport\15070-EDMR" doesn't hash ...

Hi Ray,

Thanks for your suggestion.

Could you please tell me how do we run this UVFIXFILE utility i.e. command line to run this utility and from where it has to be run.

and these RT files existed but got deleted while running the DS.CHECKER tool.

Thanks
Narayan