DSXchange

This is the error message : DB2udb_PS_TGT_L_BUS_UNIT: Error Idx = 1; DB2 Driver Embedded SQL message: SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 ; sqlcode = -911; sqlstate = 40001 A timestamp conflict occured Att...

Thanks chulett
Run the X server jobs when none of the Y server jobs are running vice versa.

When we got the issue we contacted the DBA as per them There were no locks on the table.

HI , We have two ETL server say X and Y , from both the server we are connecting to same database say D1. Server X is uses db2connect ver1 and Server Y uses db2connect ver1.5 to connect the D1 database by using the DB2 EE Stage.Issue is if we trigger the jobs from both the servers then only jobs fro...

Hi,

Is there any command to list all the routines in a project ?

Thanks in advance

Hi ,

Is there any query/command which can list out all the job parameters used in a given stage, Like for a job we used the command "dsjob -lparams <Project> <job Name> " to list all the parameters.

Thanks in advance.

Chulett- every time we are recompiling...same error is incurring in all the runs

Hi Sainath,

We are not providing any default values...

Hi , We are getting the following error while loading the data into DB2 table using DRS stage.In the same project other jobs are running fine only few jobs are throwing the following error. Error messages: DSP.Open GCI $DSP.Open error -100. Additional Info: 1. DB connection is good. 2. I have rename...

Hi,

There are thousands of jobs and sequences present in my project.I need to find job/sequence name which uses the some 'X' as parameter.

Is there any command/query to find the job/sequence references?

Thanks in advance

Hi jib - Thanks for response, If the job ran atleast once then we can find the respective sequence with DSJobController , thats is the good option....Thank you

Yes Ernie - I want that way

For Give job 'X' find the sequence that invokes it.

Hi,


In my project i have 'N' no. of Jobs and 'M' no of sequences bult for the jobs. Now my question is How can i find the Sequence Name for the particular job 'X'.

Thanks in advance

Hi All,

How to get the Given month end date?
Is there any way to add month to the current date.
Eg: current is 2008-08-07 (yyyy-mm-dd)
my output should be 2008-08-31 (yyyy-mm-dd)

Thanks

Hi,


Is there any way to capture the how many rows updated,inserted and rejected to the target.Source is CSV file and target is DB2.

Regards,
Ramakrishna.M

Can we use DateFromJulianDay(JulianDayFromDate(input.field) + 185)) in the Parallel Routine?

Regards,
Ramakrishna