DSXchange

Hi karumudi7, you were close to the solution already. Try following settings in the DB2 Connector Write mode: Insert Table action: Truncate Generate truncate statement at runtime: No Truncate statement: truncate tabe_xxx reuse storage immediate This is assuming you have at least DB2 9.7 running. Oth...

Hi, the application consuming my DataStage WebService gets error messages (probaly timeouts from the queue) but I can not explain this because I can not imagine that the number of parallel instances of the webservice is reached. Is there a way to monitor the number of Webservice instances and also t...

Hi Ernie, If you are timing out, increasing it is a fine thing to do, but it is also a very good indicator that it is time to increase the number of instances for that particular Operation... We have done this also for several times. Playing araound is exactly what I try to stop now because after ev...

Hi, we ran into problems with our WebServices in a load test scenario but the problem seems well known if I look at following pages: http://www-01.ibm.com/support/docview.wss?uid=swg21449932 http://www-01.ibm.com/support/docview.wss?uid=swg21441350 Here is a error message I got (for reference and se...

Hi ysrini9 SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032. If you read the message carefully it says that your connection has been terminated ...

Hi nikhil_bhasin

see also

http://www-01.ibm.com/support/docview.w ... wg1JR29181


and make sure to lookup any further problem descriptions based on
APT_OSL_PARAM_ESC_SQUOTE

Hi darrreever, the backupo pending in DB2 comes for a reason - to be recoverable! I strongly recommand that you tak to the DB2 admins before you go on! So here is the answer to your question: The DB2 Connector has a option "Copy loaded data" you can use this to create the copy. A copy to /...

Hi, we are tryinfg to use the "great" new XML stage with multiple inputs to create a single XML document from several relational sources. Within the assembly we have added a HJoin operator and the composer step and we mapped several columns. We get following error at runtime: [Info] XML_Le...

Hi chulett

yes I agree but maybe someone has done it already and I do not need to invent the "wheel" again...

thanks

Hi ulab I think you got me wrong - the point is not the creation of a parameter set it is about the usage within the Connector stages. To change a connector from hard coded or global parameters to parameter sets you have to open the connector and change at least the database name, user and password ...

Hi, we are in the process of migrating from DataStage 7.5 to DataStage 8.5 and we plan to use the Connectors (via the Connector Migration Tool). It would be useful in my eyes to change the Connector stages afterwards to use parameter sets. Is there a tool (or job or whatever) that can help to change...

Hi times29

well just look at you logic:
1. you compare if the STATUS field equals AGENT
2. The result shoul not be zero

If you do just number 1, it will work - your logic is kind of doubled this is producing the error

Hi manoj_23sakthi

the question and answer referred to the DB2 Connector.

With mainframe ( DB2 for z/OS) you can not use the DB2 EE stage
although the DB2 API stage is an option.

Hi kanasai167

this has been asked before by the way.
Try it with the instance property left empty - this should work for most situations.
Please keep in mind that they want you to put in the CLIENT Instance name on the DataStage server (if so).

Hi

we are in front of an architecture decision - we will not get a LPAR for every environemnt so I am very interested in your opinions.
Every answer is very much appreciated.

Thanks in advance