Search found 22 matches
- Fri Jul 17, 2015 9:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connecting to sql server using Windows Authentication
- Replies: 5
- Views: 8576
- Tue Sep 02, 2014 4:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job reports failure (code 139)
- Replies: 6
- Views: 5144
- Tue Sep 02, 2014 12:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job reports failure (code 139)
- Replies: 6
- Views: 5144
Re: Parallel job reports failure (code 139)
These are the two confifuration parameters , which has been recommneded by others to change..
APT_MONITOR_SIZE = 50000
APT_MONITOR_TIME = 10
APT_MONITOR_SIZE = 50000
APT_MONITOR_TIME = 10
- Tue Sep 02, 2014 12:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job reports failure (code 139)
- Replies: 6
- Views: 5144
Parallel job reports failure (code 139)
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 ...
- Sat Aug 09, 2014 1:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage DB2 Bulk load vs DB2 load utility
- Replies: 2
- Views: 4271
Re: Datastage DB2 Bulk load vs DB2 load utility
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
Though am still not clear ,when to use DEL and when to use ASC
- Tue Aug 05, 2014 1:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage DB2 Bulk load vs DB2 load utility
- Replies: 2
- Views: 4271
Datastage DB2 Bulk load vs DB2 load utility
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...
- Thu May 22, 2014 4:41 pm
- Forum:
- Topic: Limited asset getting displayed Data Linage
- Replies: 1
- Views: 2123
Limited asset getting displayed Data Linage
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 ...
- Tue May 13, 2014 12:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pattern matching in datastage join stage
- Replies: 2
- Views: 2408
Pattern matching in datastage join stage
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...
- Thu Sep 05, 2013 4:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC function "SQLBindParameter" reported: SQLSTA
- Replies: 1
- Views: 2959
ODBC function "SQLBindParameter" reported: SQLSTA
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...
- Sat Jun 01, 2013 5:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: derive max occurrence
- Replies: 4
- Views: 2674
- Sat Jun 01, 2013 1:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: derive max occurrence
- Replies: 4
- Views: 2674
derive max occurrence
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...
- Wed Mar 07, 2012 1:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hash lookup in parallel
- Replies: 7
- Views: 3954
- Wed Mar 07, 2012 12:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hash lookup in parallel
- Replies: 7
- Views: 3954
Hash lookup in parallel
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...
- Thu Feb 16, 2012 12:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Binary to bit
- Replies: 2
- Views: 2153
Convert Binary to bit
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"...
- Wed Jul 27, 2011 11:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SORT stage does not fulfill the sort requirements for remove
- Replies: 2
- Views: 2159