DSXchange

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...

Our password is like some text and then some numeric numbers.Can be assumed like the below format
abc678

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...

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 ...

Entire partition is done on the reference link of the lookup stage
Inline sort on the reference link of the look up stage and it includes the frm col of the range look up in the reference link

Sort is already done on the reference link of the lookup stage.In spite of that it's throwing the error message

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...

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...

Yes,from my understanding also the current behavior is supposed to be right.But in current prod(8.5) the data is truncated in that way and that field has no further significance, but in 11.3 it's throwing warning and the job aborts

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...

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?

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...

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 ...

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...

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...