on 03-09-2010 2:43 PM
Hello gurus,
while doing a client copy, during the import for some tables we get the message:
'full scan in 4134406 entries because binary search is not possible for this table because key contains unsortable types, this may result in loss of performance'
In deed, the performance while writing those tables is REALLY bad.
Does anyone know what exactly might be wrong with those tables (all of them are Z-tables)?
We checked the export-logs, too and for those tables there are entries like
'3WETW000 scrap char 0x00 found in ZTABLE04.TXZ01, it will be coerced to ' ' automatically'
Could this have anything to do with the low performance at import?
Thanks
Alicia
Ok, thank you to both of you.
We will try this next time.
Regards
Alicia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Turning off DB archive log before client copy (and turning on after) is another thing you should consider doing. I had DB errors once when i forgot to do this, but when turning this off and had no errors.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alicia,
This issue is usually caused by bad Oracle (DB) performance.
Before Client Copy SAP strongly recommends to update the ORA statistics
and optimize the DB performance.
It is also recommended to delete the target client before starting
the import of the source client.
Kindly also check that you are using the latest kernel, specially the latest patch level of tp and R3trans.
This small bit of recommendation should help you out.
Regards,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Same issue here.
During a client-copy we get this message :
"ETW000 full scan in 3389873 entries because binary search is not possible for this table because key contains unsortable types, this may result in loss of performance".
Thanks for help !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.