DSXchange

Hi all , Got a problem. When I run the job, right click and check in designer.. no performance statistics are displayed (not even 0 Rows 0 Rows/sec). The job is continuously running. When i Check the monitor in Director ... No stages are displayed. Job Design is : Dataset -> DB EE stage Any reasons ...

sarangadhar wrote:Thanks . am able to login to admin..

is it the same for designer/manager/director?

yes it is..... u can access all of the above from within each other without logging in again ..

I am trying to udpate a partitoned table using the upsert mode in the DB2 UDB Enterprise Stage. But the following fatal error keeps occuring: DB2_TEST: When preparing operator: When binding partitioner interface: Could not find input field "sk". I am using a User Defined Update and the par...

Will there be an increase in performance if the 'Load' option is used versus the Write/Append mode if the target table is not partitioned?

Thanks in advance

ray.wurlod wrote:What else was happening during the API test?
Was the DB2 Enterprise stage set up to use direct read or SQL? ...

Nothing else was happening during the API test. Enterprise stage was set up to read the same SQL. The same SQL as in API stage which involved a join statement.

Okay, I just tried this ....
the read speed from the Enterprise stage tripled! .. Is there an explanation to this ?

We are reading from a DB2 Table which has not been partitioned . This table is being read by a DB2 UDB API Stage (with a node constraint set to node1) . Will there be a performance improvement if we use a DB2 UDB Enterprise stage in reading this table ? I have read the article where it mentions ther...

Thanks a lot for the suggestions everyone( A shout out to ArndW ). The routine with the User Variables Activity stage idea worked. Thanks...

Hold on... you're trying to attach to a job, interrogate it for link counts (etc,etc) all in a UserVariables Activity stage expression? :shock: You'll need to write a routine to do ... So basically, I have to write a routine with these three function calls and returns the row count ? Call this rout...

I posted a full routine, but you would need to join as a premium member to use it. Lookup up DSAttachJob() in the docs, it has 2 parameters. ... Yeah I tried the function with the other parameter as well : New DSAttachJob("Job1",DSJ.ERRNONE) 'New' being the user variable defined in the us...

Yes, 3 separate user variables in that activity (I'm fairly certain that user variables can be used later in the same stage, analogous to what happens in Transform stage). I would write this as a simp ... From what i understand: there should be three user activity variables and we later use that us...

There are 3 calls you need to do, each is a function. 1. JobHandle variable from DSAttachJob({YourJobName}) 2. Use that handle in the call to DSGetLinkInfo() 3. Close the handle with DSDetachJob() ... When you say 'call', do you mean that there should be three separate user activity variables? I di...

I suppose my earlier post got cut off at whatever the 'premium poster' limit of words is, so you didn't see all that I wrote. You can find out how many rows went down a particular link using the DSGetLinkInfo() routine, which you can set up and call from within a user activity stage in a sequence. ...

But the original poster didn't want to abort the first job, just not execute the second one - otherwise it would have been simple to put a limit of 1 row on the exception link and trigger an immediate ... Yeah that's right.. The problem is each job has a separate sequence of its own. So the main se...

Why not make sure that any rejected records trigger a warning. Start both jobs in a sequence but make the second one dependant upon the first one not generating warnings. ... Its not exactly 'rejected records'. The next job should only start when there are no 'exception' records. There is an except...