client copy taking long time for HCM LSO* table

[Former Member]

Hi all,

We have 1 TB  HCM  ecc 6.0 on ehp5 on db2.

LSOCPSCORMSSTR table is taking long time during client copy almost couple of days with this table as last in scc3 log....

Please suggest is there any performance tips  to copy LSO* table in a better way.

Thanks,

Subhash.G

[Former Member]

Can you check how many lines there are in the table LSOCPSCORMSSTR? While you are at it, check also table LSOCRPCNTXTPRTCL.

[Former Member]

Hi ,

Below are the table rows for those tables...

LSOCPSCORMSSTR ->137,450,146

LSOCRPCNTXTPRTCL->4106845

Thanks,

Subhash.G

[Former Member]

137 million lines, that's just crazy. Anyway, I don't remember seeing any LSO specific recommendations for client copy. Assumed your system has all the generic client copy optimizations in place, the only thing that comes to my mind to improve the performance is to use system copy instead of client copy.