DSXchange

ray.wurlod wrote:Is the night run under a different user ID from the one used for the successful run? ...

No its same user id for OS
And DB user is a parameter .. and we use same user ids for manual runs

And the characterset of both the source and target are... ? ... Our Source/target MS SQL DB (Collate) is Latini1-General and we do not have NLS for datastage. But I have doubt whether character set has to do anything with my problem, as because this job runs fine when I execute again after failure ...

Does it create any issues like database/table locks while performing insert/update/delete? if so what are other options ? Issue will be there - if the same entity/row is being inserted, updated, deleted - if the same row with same key is in more than one link. How will you gurantee that first inste...

Are you sure you really need NLS installed? ... I am facing problem with special characters (famous Umlaut characters). my simple job gets aborted while creating Hash File with key fields having these special characters. Although these characters are easily read from DB and is being stored in Seque...

I have installed DataStage without NLS. Now I want to set the NLS on.

How to proceed? And how to make all the existing projects to NLS compliant?

Regards
Arun

solved after reindexing

Thanks Craig Before submitting this post I did check the .dsx file and I did found the following in the dsx COMMENT No records found in this section - Job designs No job design was found. In Designer I do find the jobs. Where as for other projects in the same server I find the log entries like I - E...

Hi I am trying to export a project using dscmdexport, using following command dscmdexport.exe /H=%DSHOST% /U=%DSUSER% /P=%DSPASSWD% %DSPROJECT% %DSBKUPDIR%\%DSPROJECT%\%DSPROJECT%.dsx >> %LOGFILE% The log is shown below I - Exporting DataStage project DSFER_DEV Attaching to 'DSFER_DEV' ... Exporting...

it works with my configuration

Thanks Craig

I have a license of 4 cpu, my physical server has 8 cpu, and I am virtualising my server (making virtual machine with 4 cpu), now can I install Datasatge server (with 4 CPU license) on this virtual machine (with 4 CPU), although underlying physical machine has 8 CPU?

Hi We are trying to install 7.5x2 server on a virtual machine. During installation we all know we need to provide number/count of CPU. I need to know the DataStage consider which CPU count - number of CPU of the Virtual machine or number of CPU of the physical machine (which will host the virtual ma...

chulett wrote:In all honesty you shouldn't need to do that. ...

I will be grateful if any one please let me know is there any other alternatives.

I found what was the problem and resolution is a below

When you are accessing Oracle Database that is RAC
Then you need to identify the All RAC server node as host file in the DS Server.
Include the All the RAC SERVER NODE IPs and and SERVER NODE Names in
\drivers\etc\host file

aoriano wrote:Hi,

You wrote the Jobs are running with the old Database. What's the difference between your databases ? Version ?

Have you tried using an oracle Oci Stage instead of an Oracle Oci 8 ?

The only diffrence is the new Oracle database is in RAC now

chulett wrote:Sorry, but what does "job is working fine with old database" mean?

I meant while executing the job pointed to old database the job works, but we try to same to new database it fails giving the following error