Unicode-Conversion using Socket-Option possible ?

[Former Member]

Hello,

we plan to do a unicode-conversion.

System is DB2 on AIX.

In the guide from IBM regarding Copy-Optimization there is a info, that the socket-Option will bring a reduction of runtime.

But in Note 2311023 there is the hint, that it's not possible to use the socket-Option with unicode-conversion.

Does someone know, which info is correct ?

[former_member188883 · Accepted solution]

Hi Christoph,

Socket option is useful incase you want to perform parallel export-import during unicode coversion or system migration.

Socket option is preferred in case of Windows environment.

In case you have source and target on Unix environment, you can very well have NFS mount created of the export directory and mount it on the target server. You may still use parallel export-import method to reduce the downtime.

So inorder to reduce the overall downtime you may implement downtime reduction techniques

Some of them are listed below

1) Use of parallel export/import

2) Rampup the CPU and Memory resources of source and target servers

3) Implement database specific tuning parameters suggested by SAP for migration

4) Have DB statistics updated

5) Implement latest R3* tools for migration

6) Use of table and package splitting

You may read through SAP guides and SDN for more inputs on optimization.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

thank you for your Information.

That means, that note 2311023 is only valid for Special cases ?

As described we are using AIX, but we want to test if the socket-Option is usefull for this OS also,

because the transfer should be faster with direct network communication than t read/write files...

Kind regards

Christoph

[former_member188883 · Accepted solution]

Hi Christoph,

As per the SAP note, it says R3load has some limitations in transferring data over socket if there is a code page change. It may support only data migration having similar code page.

So for Unicode conversion it may not be a viable solution.

As you are on AIX best approach will be to have NFS share created will be still serve the purpose of parallel export-import and  help in reducing downtime.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Okay... Thank you for the Information...

Kind regards

Christoph