Search found 153 matches
- Wed Jun 29, 2016 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance issue while extracting from SAP BW
- Replies: 0
- Views: 2277
Performance issue while extracting from SAP BW
We have SAP BW on SAP HANA. extracting from SAP BW using SAP BW extract stage using OHD. Now while triggering the job extraction finishes within 1-2 mins in the SAP but the job taking to complete 15-20 mins for 7-8 millions of data. While extracting directly from SAP HANA through ODBC connector agai...
- Sun Jan 17, 2016 4:46 am
- Forum: General
- Topic: Datastage connectivity with SAP BW
- Replies: 3
- Views: 2907
- Fri Jan 15, 2016 1:24 pm
- Forum: General
- Topic: Datastage connectivity with SAP BW
- Replies: 3
- Views: 2907
Datastage connectivity with SAP BW
Our requirement to extract data from SAP BW. To perform with that we are trying to establish connection with SAP BW.In the BW extract stage we are givibg the following details Application Server System id Client No User Id Password Language While trying to connect it's not connecting stating the pas...
- Tue Dec 01, 2015 11:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in range lookup
- Replies: 6
- Views: 4603
Yes, I have also tried that option.I put a sort stage in the ref link and run this sort stage sequential only, else are running in parallel This time the job is running fine. From my understandings it seems that anything running on multi node just before the lookup stage in reference link cause the ...
- Tue Dec 01, 2015 6:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in range lookup
- Replies: 6
- Views: 4603
- Mon Nov 30, 2015 11:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in range lookup
- Replies: 6
- Views: 4603
- Sun Nov 29, 2015 12:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in range lookup
- Replies: 6
- Views: 4603
Issue in range lookup
I have a simple job where range look up is occuring based on two equality operator and one range(range cols are from reference link).The reference link is made entire partition and sorted on the look up keys. In datastage 8.5 the job ran fine but in datastage 11.3 the job is failing with the below r...
- Thu Nov 05, 2015 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic configuration file in grid
- Replies: 1
- Views: 2441
Dynamic configuration file in grid
The job design is like that DB2 Connector---->Copy Stage---->Dataset Environment is grid enabled.There are four physical nodes in the grid C1,C2,C3,C4(Say).The grid setting is as below. $APT_GRID_ENABLE = YES $APT_GRID_COMPUTENODES = 4 $APT_GRID_PARTITIONS = 1 $APT_GRID_QUEUE = The dynamically gener...
- Wed Sep 09, 2015 3:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file behaviour
- Replies: 4
- Views: 6723
- Wed Sep 09, 2015 2:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file behaviour
- Replies: 4
- Views: 6723
Sequential file behaviour
I have job where it reads from sequential file and stores the data in dataset.There is one column in the sequential file named VERSION(say) and it's defined as VARCHAR(1). Now in the file if any records are coming say 'AB' for VERSION then it truncates up to 'A' in both 8.5 and 11.3.But in 11.3 am g...
- Tue Jul 28, 2015 11:44 am
- Forum: General
- Topic: Performence measurement through operational console
- Replies: 2
- Views: 1987
Performence measurement through operational console
Datastage is running on grid environment. Now if I want to see the hardware utilization I can use operational console to see it. Now my operational console is on the engine server . What is the procedure to see the hardware utilization of all processing nodes through operational console?
- Mon Mar 30, 2015 7:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Absence of distribution key in the design schema
- Replies: 4
- Views: 3674
Thanks a lot Craig for your response. I will check it from the database level.meanwhile I have checked the below link from IBM: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.conn.db2db.messages.doc/topics/IIS-CONN-DB2-00371E.html It's stating that partition column sh...
- Mon Mar 30, 2015 6:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Absence of distribution key in the design schema
- Replies: 4
- Views: 3674
Absence of distribution key in the design schema
I have a simple parallel job with the below design: Dataset--------->copy--------->DB2 connector(running in partition type as DB2 connector) In the above design in the DB2 connector I'm updating a table(Assuming T1).Now T1 is hash partitioned(DPF in DB2) on the basis of C1 in the DB2 level. Now I'm ...
- Wed Feb 11, 2015 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Information on stages
- Replies: 3
- Views: 2868
Thanks a lot for the reply. You are right am not saving the table definition of the dataset. I have missed in the requirement,extremely sorry for that. My input is the sequence job name (S2) from that I need to get the result. I have tried it with some kind of shell scripting on the .dsx file of who...
- Wed Feb 11, 2015 11:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Information on stages
- Replies: 3
- Views: 2868
Information on stages
I have a situation where I have to determine any cross flow dataset dependency which is like below Assumes one sequence job S1,it consists two parallel job P11 and P12 and another sequence S2,it consists two parallel job P21 and P22. Now assume one dataset has been written in the P11 job and which i...