mlreplay updating Consolidated ?

[former_SQLA_member1694969]

Hello

I'm leading the database element of an upgrade/migration project,to upgrade our Oracle consolidated db to Oracle 12c (from 9i), and Mobilink Server 16.

Currrently : about 1300 remotes (SQLAnywhere 10), syncing to Oracle 9i (approx 12 tb; billions of rows).

I had hopes that 'mlreplay' (came in with SQLA 12 ?) would help me with volume testing, but the docs/examples are a bit sparse.

So, may be a stupid question, but, will/can 'mlreplay' actually try and re-apply inserts/updates to the consolidated db ? If so, how does it generate new PK values ?

Or does it just simulate the load on the Mobilink serve, without trying to commit to the consolidated ? Which is still helpful, but not clear from the docs.

Thank you

[Vlad]

five years ago, I played with VTO. To be short, not with Mobilink. I didn't like replay, because it doesn't allow "scripting". You cannot change the parameters much. There was only one solution, that I used -> write a .NET application using Ultralite libraries, and start this app on a powerful VM with a RAM drive.

Very rough estimations are -> you can launch two apps per VM core. Otherwise the price for EXE files execution will be very high. Your VM will be overloaded.

It is not a good answer, and maybe not a good comment.

[former_SQLA_member1694969]

Hi Vlad, is VTO the SAP Volume Test Optimization toolset ? Thanks

[Vlad]

I don't know if this is called toolset, but yes, you are right. This transcription is what you said.

I was interested in the possibility to generate the "right" system load coming from Mobilink applications. It is a dirty exercise.