DSXchange

OK I got a patch from IBM which solved my issue - JR35254.
HTH

Ray,

The executing user has same values too. Also the target location has plenty of free space.

We are currently running into an issue when the dat file created by the Oracle Bulk Load Stage exceeds 2 GB. The design of the job is pretty straight forward. OCI -----> Transformer ------> Oracle Bulk Load Error from log WSLdFactUsage_P1..Trf_Sur_Key: Error writing to the file: /data/etldata/Contro...

If you want to go the "Execute Command Activity" route -
Enter /NOLOG/ as the starting text in the parameter field.
This prevents the parameters from being logged in the job logs.

Thanks for the clarification, Appreciate your inputs.

Ray - That is right, I would not want to wait for all jobs (Job1, Job2 and Job3) to finish before it gets to the next set (Pardon my miscommunication) If any of them finishes, I would want to get to the next batch. But the last batch waits for all the prior jobs to complete before it signals that th...

We have an existing job sequence design as below Any Any All Job1------|------Job4------|------Job7------| | | | Job2------|------Job5------|------Job8------|------>Notify | | | Job3------|------Job6------|------Job9------| Above is just a sample of the jobs, there are around 20 jobs that are run si...

Valuable suggestions... Thanks Craig!
I miss walking up to you for my questions

If you are looking for different approaches, you could also consider creating a combination of touch files and "Wait for file Activity"

Thanks for the reply. True, we are going to have a UAT environment too, we would call it something like XXX-UAT. Since these environments would be on complete different machines, we were debating the purpose of naming if differently, but I get when it comes to Versioning, it is better to have differ...

Hi all, We are moving to a new set of DataStage servers and looking to see if we should use the same names for projects across all the environments, or different: Example XXX-DEV, XXX-TEST and XXX-PROD Also want to know if the oracle net_service_name (in the tnsnames.ora file) should be the same nam...

This is an oracle connection error.

Below is one of the link, to get details about the oracle error

http://ora-12154.ora-code.com/

Post your exact error message, for anybody to help you out.
If you already have the information use the same, since it would be specific to your company.

Craig, this is true with Server jobs too. I am unable to see the SQL in the logs for server jobs which uses an OCI/ODBC stage.

Sajid, Thanks for sharing the information. Making this parameter to "TRUE" does display the SQL information in the parallel jobs.

Hi all, I am unable to see the SQL queries that are being used in job, from the job logs. This is the same, when using Oracle OCI or ODBC stage. Same behavior while connecting to any database. Is there any parameter that needs to be enabled or do we need a patch? Please share if you have had similar...