DSXchange

Hi, Background: We have 150+ tables are being loaded on daily basis from One DB2 instance to Other DB2 instance. The volume ranges from 100 to 2 million rows. All these jobs are running in sequencer with the following parameters. $SRCDBTYPE = IBM DB2 [$PROJDEF] $TARRAY = 500 [$PROJDEF] - Target Arra...

Hi,

I was curious, which approach you followed. If you have followed the Ascential approach, do u have example code for that.

Venkat Ranga

Hi, We are having the difficulties to bring up the Ascential server on AIX environment. Please let me know how to kill this process... netstat | grep dsrpc tcp4 0 0 ktazp1891.dsrpc 10.237.135.211.3976 CLOSE_WAIT This is been hanging more than 16 hours... Any thoughts... Regards Venkat Ranga

Thank you for your response Venkat Ranga, I really appreciate if you could elaborate a bit. 1. PS load FC and DM's in destrictive mode. If you want to change FC to incremental mode... you may need to observe closely depending dimensions. -- What does FC stand for? Did you mean Datamart or Datamap w...

Hi,

I was able to improve the performance by replacing all Lookup as has lookups. The performance went up by 3000 rows per seconds.

Regards

Venkat Ranga

Hi, We are planning to migrate 100+ tables in incremental mode. Out of which 25 of them are Fact and Rest of them are dimension tables. I am trying to come up with optimal mechanisam to produce Surrogate Key. Is there any out of the box solution available from Ascential (like Oracle Sequences ) or D...

Ray, This is what I found... When I try create a flat file from Mainframe DB2, system was able to create a file at the rate of 600 rows per second... The same file I used and outputted to other flatfile on the sever, it was processed at the rate of 3900 rows per second. It seems like ODBC/network is...

Hi,

The out of the box Ascential installation is only able to perform 100 rows per second for most my jobs (simple loads too). I was hoping to findout if I need to setup any additional parameters to improve the job Performance.

Regards
Venkat Ranga

I am looking after similar exercise for one of my client. We have the same issue. I spent considerable amount of time to look through how to change the extracts to incremental. Very highlevel this is what I found out. The logic is different from each dataset you are trying to change incremental. Cou...

Hi, I am getting following warning message in one of my jobs. Can someone explain me what it is all about.... DataStage Job 201 Phantom 15431 Creating file "SDKSequences" as Type 2, Modulo 1, Separation 1. Creating file "D_SDKSequences" as Type 3, Modulo 1, Separation 2. Added &q...

It shouldn't be an issue with a VC move, but I believe it can be when using export/import if the 'include defaulted properties' (or some such) is not checked. :? No... I tried that.. Similar problem I am facing too. What I found out is, when you define the variables they written to the dsparms file...