DSXchange

Yea that is question for DBA. But my question is from where datastage is picking up this value. The thing is the value is different for dsadm user id alone. Is this something to do with user profile?

We are getting the following value. ORA_NLS33=/home/oracle/ocommon/nls/admin/data instead of ORA_NLS33=/u01/app/oracle/product/9.2.0/ocommon/nls/admin/data We never used to set this in dsenv. Yesterday UNIX admin installed a patch after which the value got changed and we had to explicitly define in ...

Hi, When a job runs, the director lists the environmental variables used for initializing the job. It has one parameter called ORA_NLS33. Where does this value come from. We've not defined in dsenv. UNIX admin installed a patch in UNIX and this caused the value of ORA_NLS33 to be changed. This is ca...

Thanks a lot Craig & Ray. I'll try those.

No I'm confused now.. What is meant is.. say the dsenv has ORACLE_HOME="/oracle/product/9.2.0" LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32 Now I goto datastage administrator and set the values as ORACLE_HOME="/oracle/product/10.2.0" LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACL...

Following are the 5 variables defined in dsenv. ORACLE_HOME ORAHOME LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32.... ORACLE_SID ORASID When a job starts, all these will be set by dsenv. Now when I override with project specific settings, what will happen to variables like LD_LIBRARY_PATH. LD_...

Thanks a lot Ray. I'll try that.

Hi, Is there a way to point Datastage server to multiple ORACLE_HOME. The ORACLE path is currently set in dsenv. We've oracle 9i and 10G. We want two projects to configure two different oracle versions for testing. It is basically migration of Oracle 9i to 10G and we want to test the performace and ...

Datastage Parallel jobs runs parallely (provided you use two node config file) in sequential fashion in the way its sequenced in Job Sequence.

OK. I'll Check there. But why it is different in the exported DSX?

Hi, I exported a DSX file to analyze CPP code in an exported DSX file. These are small codes that are generated in DSX file. I want to know the following details. 1. Significance of generated code. Does that really give exact logic of what is implemented in job? 2. I tried to check point no.1 using ...

I'm completely lost now...

The job is running fine even i uncheck that option. I'm absolutely sure that the job failed multiple times when i posted this topic...I tested with the same data and same scenario. Its working fine. I've no explanation on why it failed before!!!

No Craig, Job completed successfully. Problem was after-job subroutine was called before job completed successfully. Job was actually updating the table, which has put a lock on that. At that time, subroutine was attempting to insert. Problem was solved when i check the option "Only run job sub...

Thanks Craig and Bharani!!!

That was my biggest error. I missed to check the option "Only run job subroutine on successful completion". I checked and it went through fine.
I can't believe i missed that!!!

Thanks,
Firvin

Hi, I've job which updates a table using Oracle stage. A sequential file will have the list of keys to be updated and another with new records to be inserted. I insert the data using SQLLDR into the same table using after-job subroutine. It is basically marking some records as inactive using update ...