DSXchange

Hello, I have a command activity stage to get the job statistics as below DSHOME=`cat /.dshome`;. $DSHOME/dsenv; SRC_CNT=$($DSHOME/bin/dsjob -linkinfo DS_SANDBOX jb_SRC_TGT_Job_Extract ODBC_WELLHEADER_WELLBORE lnk_ODBC_Stage1 | awk 'NR>1{exit};1{print $5}'); TGT_CNT=$($DSHOME/bin/dsjob -linkinfo DS_...

Hello, In one of my Job, I have used a Exec command stage activity in which I am trying to capture the Job Statistics from the server as below DSHOME=`cat /.dshome`;. $DSHOME/dsenv; SRC_CNT=$($DSHOME/bin/dsjob -linkinfo MCB_IDAP_P jb_SRC_to_TGT_Norm_Load ODBC_Delta lnk_ODBC_Delta | awk 'NR>1{exit};1...

Hello,

Thanks for the reply.

We have added keepAlive variable in odbc.ini file but still getting the problem and involved the network team, they are not saying any connection break during the process.

What change you performed to mitigate the issue?

Regards
Neeraj

Hello, I am using DataStage to read from Azure SQL Server and Writing into Azure Sql Server. During the process of reading and writing using ODBC connector Job is performing the CDC . For the High Data volume jobs, if the job runs for more than 30 minutes, I get this error message ODBC_Target,5: ODB...

Hello, We have a new Azure SQL database created for our project. After updating the ODBC.ini file and changing the DataStage environment variable to point to new Database, when I opened the ODBC connector stage property tab and hit test, "It shows connection successful" that means DataStag...

Hello, Thanks a lot for the reply. We have another requirement of executing the IA rules outside the information analyzer either using Unix script or DataStage. The follow is as below Populate the Landing Area --> Execute the IA rules means we need to put the predecessor condition that once DataStag...

Hello,

We have created few rules in Information Analyzer and when I am trying to execute those rules using DataStage, I am not able to view the rules in Data Rules.

Please guide.


Regards
Neeraj

Hello, I am using ODBC connector stage to connect to Azure SQL Server and execute the 2 update statement in sequence as below: UPDATE HWP.WRK_VHEW_VOL SET EXP_DT = '2017-11-09' , STG_FL='D' FROM HWP.WRK_VHEW_VOL A WHERE EXISTS ( SELECT 1 FROM HWP.WRK_VHEW_VOL B WHERE A.ID=B.ID AND B.STG_FL='D' ) AND...

Hello,

I am executing the dsexport.exe command from windows command prompt. During execution, it open up EXPORT PROGRESS window and at the end provide the list of components exported.

Is there anyway these message windows don't pop during export and import?

Regards
Neeraj

Hello, We are currently using VSTS as the code repository as per the company standards. While looking at DSXchange, I have found a thread stating that we can use VSTS as a DataStage code repository and to do so first needs to download and install the eclipse TFS Plugin. I could not find any link exp...

Hello Arn,

I am sorry but due to some limitation could not read your complete sentence. But We are not using invoking any parameter set in this command.

Regards
Neeraj

Hello, I m trying to explain the issue once again and Hope it helps. I have a multi Instance Job. At same time 2 instances of the same job having different invocation ID are running in Parallel. Most of times, Jobs runs with Success i.e. from 20-July till today Job failed only once. My Analysis is:-...

Hi,

You are right. There are possibilities that 2 different instances trying to access the Authfile/Security file at same time as the multiple instances are running in Parallel.

But this is how the job is designed i.e. to run in parallel.

How can we handle such scenerio.

Regards
Neeraj

The Sequencer itself fails to start

The Job is not executed how can we have Director log for the Job.