DSXchange

i am not sure..what is going wrong.
how can i capture job statistics in table.
i was suppose call this routine everytime,whenerver one job call and it will capture job statistics in our table.

I am added several DSLogInfo() in my code.
In place i have added it for OsStatus code.

During Routine Testing I am getting OsStatus return code =0
But in Routine Activity I am getting OsStatus return Code=4 ,
means DB2 command or SQL statement error . Iam still not able to find root cause of it.

See routine is executing and finishing sucessfully. But in routine i am inserting one record per job execution. So,here record is not inserted for this case[routine called from activity stage]. But if i test with passing proper arguments,record is being inserted in database. Why could be the issue? ...

Hi Ray, the warnings already resolved now. Now my concern is i am not able excute it in routine activity stage. i can test the routine and output is being written to database. I am not able to find out why this routine is not executing in routine activity stage. if i need to trace it in some place/f...

Hi Mike, Now routine is working when i am testing. But when i am testing in a routine activity stage with same parameter its not working. please help. logs: Arg1 = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' Arg2 = 'XXXXX' Arg3 = 'XXXXX' Arg4 = 'XX...

Now routine is excuting when i am testing. But when i put this to routine activity stage it is not working. Please help.

$INCLUDE DSINCLUDE JOBCONTROL.H FLAG=0 InRowCount=0 OutRowCount=0 RejRowCount=0 Call DSLogInfo('Running Routine', RtnValidateLinks) Call DSLogInfo('Using Param' : Arg1,RtnValidateLinks) JobName=Field(Arg1,';',1) StgLink_Name=Field(Arg1,';',2) JobHandle=DSAttachJob(JobName , DSJ.ERRFATAL) JobStatus=...

Thanks everyboday. I am unable to read premium content right now.Is that mean i should go with whatever i have done?

I need to create incremental load for 18 tables. This is how i implemented incremental load. 1. created one server job for calculating max timestamp and saved in setuser status. 2. one PX job , has a local parameter use to extract the data. (Main job for extraction) 3.One sequence job used to get as...

Sorry friends.No luck..its still not working..Yes we have access to tables that hold partitioning information.
describe table syscat.tables provides all information. Do u have any other solution?

I have requested same to DBA team.

'DB2 connector' collecting method is not working in DB2 connector and job is being aborted due to this. If I use any other collecting method,its working. Error - W_VHCL_ORDR_OTHR: An error occurred while preparing the table partitioning information. The method db2CfgGet returned reason code 0, SQLCO...

Hi Selina,
if You are not running that Jobs,proceses will create based on combinality mode of all stages/operators.

Best or accurate way to see that
connect to etl server or unix box
and run the below command ps -ef | grep userid

Hi Hari,
i made it though 8.5 loop variables.
i understand ur logic. I will try this today and let u know if it is working.

thanks buddy.

i have a input like this SRC_KEY SRC_NK SRC_NAME SRC_PRNT_KEY 1 A Name_A 0 2 B Name_B 1 3 C Name_C 2 4 D Name_D 3 where pk is first two column. output will be like this ID NAME HIRCH_LVL PRNT_ID PRNT_NAME PRNT_LVL REP_LVL 1 A 1 2 B 2 1 A 1 1 3 C 3 1 A 1 2 3 C 3 2 B 2 1 4 D 4 1 A 1 3 4 D 4 2 B 2 2 4 ...