DSXchange

@priyadarshikunal: Your quote (in your signature) is an apt way to classify this post.

@vivek thanks for that but i contacted my admin about this he said DB2 for Z/OS is standard for everyone... What do you mean by that? As I mentioned in my previous posts, check for some logs when this problem is happening. See if you could figure out if something is happening on the database side t...

TRUNCATE TABLE TABLE_NAME DROP STORAGE There is no truncate table command for DB2 - at least not for UDB. The way to do truncate is to do a LOAD REPLACE. OP - Please check with your DBA about the logging. May be, the table is left in a copy pending state or some other state in which no further acti...

What is the database that you are writing to? If it is DB2, I remember going through a scenario (vaguely remember is the right word) where we had commit/rollback problems because the database default was set in the background to be '32768' for the Transaction log. All I can remember is that we had t...

I was also looking for DB2 connector information. However,as I couldn't find it, I kind of extrapolated the ODBC connector advantages for the DB2 connector. In case OP doesn't have this, an excerpt from the ODBC connectory documentation is as follows: The ODBC connector provides some ease-of-use ben...

I wonder if there is a space/spaces arriving within any one of the fields which is causing the tool to throw this error message . Please check and see if there is a need to add function to handle this.

As mentioned by "creatingfusion", I too am wondering if there is a Null that is coming in your data. Post more details on this so that we can provide a better solution.

vinothkumar wrote:... another one will be fired if the count >0 and it will send a mail.

Can you post the condition you have for this trigger?

I fixed this one too.. he..he...it is my mistake :) \bisdata\ \bis_data\ But...the jobs were not initialized properly from the .csv file. :( Looking it now... karthi_gana - Just a friendly advice (not to be misconstrued...) We understand that you are doing several iterations. However, you do not ne...

Though the script is successful while running from shell manually, from datastage I'm unable to execute the script successfully. Which Id did you use to run the script manually? I am thinking probably it has something to do with the environment DataStage sets (it sets a static environment with the ...

taral wrote:Did not find any blog related to server job performance and in which condition to use server jobs.

You did not look hard enough then!

For starters:
http://it.toolbox.com/blogs/infosphere/ ... stats-6976

I am trying to code a Server job to parse the input file which gets created by a Unix script. At a high level, this script just runs "df -h" command and outputs it to a file. I am trying to read this file and put the data into a csv file as the output is a little ragged. I am reading the i...

@vivekgadwal Yes, you made a good point but all you explained is to move from version to version like 7.5 to 8.x. Which is straight forward with some traps. But in this case He is trying to move from server to parallel, which is a lenghty and complex task, IBM does have tool to convert it but that ...

Not a correct test to define benchmark. They both have different benifits and should be used to according to requirements to properly utilize the capabilities of the tool. And I strongly agree to Arnd's comment. Agreed! One of the things that works in favor of server jobs is the job start-up time. ...

It is long and complex, and fraught with little traps (like a spurious error message about unsupported operating system) that aren't documented. rsunny, Migration from project to project or from version to version can be quite striaght forward given everything is set-up properly for you. However, a...