DSXchange

All of a sudden I am getting the following error in the all my jobs and even while checking config file, they were working fine:

Program "/bin/sh" core dumped. [SIGIOT] IOT instruction

I have cleared all the scratch disks, resource disks and have max ulimits.

Please help.

Thanks,
Abhi.

I am using DB2 EE stage to write data into a DB2 V9.1 range partitioned table. The job aborts with main_program: Fatal Error: Table `ADW_SALES_ITEM' must exist before querying the node group. The job runs fine if we remove the range partition on the table. Did anybody use the range partition feature...

Goodness this resoultion worked. Thanks.

You need to set the environment var. NLS_LANG to whatever is in your database.

When I had this problem I used join stage instead of lookup stage, do that if its feasible for you. Here are some of the previously posted solutions: 1) If this is AIX I believe that the per-process memory limit for the OSH executable is 512MB. Thus, any lookup stage which attempts to load over 512 ...

Look whether the PX ENgine mountpoints are mounted or not on the DB2 server.

If its db2udb you can also use orchestrate schema definitions option to import metadata.

How many char fields you got, I always try to drill it down that way?

What stage are you using?

Even i would like to see a better solution?

Has this been resolved, could you post the script you are using.

Again search would be a good thing to do: (from another post): One way nulls can be handled is When you have this problem of dates being null and you wish to use them in routines or stage variables, it can be usefull if you have a 'special date' that is outside of the domain of your data, i.e. 9999-...

search the forum, here are some samples:

string_from_timestamp (timestamp, string)
timestamp_from_string (string, timestamp)
timestamp_from_ustring (ustring, timestamp)
ustring_from_timestamp (timestamp, ustring)

Please post the exact error message one of the things you can check is how are the parameters being passed if any?

I have an integer source(AS400) field which I need to convert into DB2UDB date field.
The value of the field is like this 060526(yymmdd). Please let me know the best way to do it.

Thanks in advance.
Abhi.

Might as well try 2055/00/00:" ":"00:00:00"

I believe even then the production manager needs to unprotect the project ,then save and compile. Correct me if I am wrong.

Thanks.