DSXchange

Yes We are using IBM Data Direct sql wire 7.1.3 drivers

yes have gone through that link before posting..we are not getting this type of error in any other develpoment enviroment...
Unforutunatel no other message except for the 139 error

These are the two confifuration parameters , which has been recommneded by others to change..
APT_MONITOR_SIZE = 50000
APT_MONITOR_TIME = 10

Hi, I went through all the related posts , which give me a understanding that the Parallel job reports failure (code 139) is more sort of generic message and there could be many reason for the error . However in my case am not getting other message like core dump / Segementation fault etc. There is ...

changing File Type option seems to have resolved the issue , after changing it from ASC to DEL the Load completed in nearly 4 mins ..same as DB2 load .
Though am still not clear ,when to use DEL and when to use ASC

We a simple job of dataset to Table Bulk load using DB2 connector bulk load without any other stages . This has around 4 millon records and the load time is around 25 mins . When we run the same through DB2 Load utility its takes only 4 mins ?? So my question here is does Datastage bulk load interna...

While creating Data Lineage not all assets are getting displayed , and we get the below warning message "Data lineage results include additional information assets which are not displayed. This can occur when many complex calculation must be performed with the given system resources " Can ...

We are applying a logic currently using sparse lookup which is causing performance issue, would like to check if it can be implemented in any other way.. my source record would be like 98456728 (calling number) corresponding records n lookup table num_pfx svc_usg_refr_id 9 aaa 98 abb 567 ccc 9845 xx...

Hi I am trying to update SQLServer DB reading data from a dataset. while updating the DB i am getting the below error. ODBC_STGY_STR,0: ODBC function "SQLBindParameter" reported: SQLSTATE = HY104: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver]Invalid prec...

Sorry for the confusion ..What I meant was "most frequently occurring set of values" as Ray correctly pointed out.
Thanks for ur replies

Hi, Have a requirement to find max occurrence value in a column for a group. Have given the sample data below. One approach that have used is to group by key1 key2 and value1 get the count(*) ,then pass it through remove duplicate stage to keep the max count row alone. But since I have to find the m...

Thanks for your reply...what if the var1 is coming from a seq file or .ds??

Hi, I have to extract data from a table based on the below sql select * from xx where col1 = #var1# The #var1# is a variable to be populated at run time (could be from a seq file or another table) In server we can write 2 job first to have #var1# to be populated into a hashfile , then do a utilityha...

Hi, While extracting data from salesforce to load to sql server 2008 , one of the field is defined as "boolean" in salesforce , The definition of the same in sql server table is "bit" . I was able to get the data from salesforce by defining the field metadata as "binary"...

Mike wrote:In your sort stage, partition by the 2 keys defined in your remove duplicates stage, then sort by those 2 keys + the additional third key (i.e. partition by first 2 keys and sort by all 3 keys).

Mike

Thanks Mike...