Symptom
R3szchk and TP getdbobjsize do not return the correct size information for a table under SAP HANA.
Other Terms
HDB, SAP HANA, DBSL
Reason and Prerequisites
SAP HANA can only provide correct size information about a column
store table in SYS.M_TABLES if the table is completely loaded.
Otherwise, SAP HANA only provides estimated values in M_CS_TABLES.
Solution
The correction is available for the following SAP HANA DBSL libraries:
- 720 Patch Level 610
- 721 Patch Level 224
- 738 patch level 48
- 740 patch level 51
- 741 patch level 17
- 804 patch level 73
Switch to prepared statements to improve runtime
- 720 Patch Level 712
- 721 Patch Level 332
- 738 Patch Level 69
- 741 Patch Level 112
- 742 Patch Level 26
- 804 Patch Level 92
Use LAST_ESTIMATED_MEMORY_SIZE as of SAP HANA Rev. 91
- 722 patch level 2
- 741 patch level 215
- 742 patch level ?
- 743 Patch Level 18
The patch is available on SAP Service Marketplace. Follow
the procedure described in SAP Note 19466.
- 720 Patch Level 610
- 721 Patch Level 224
- 738 patch level 48
- 740 patch level 51
- 741 patch level 17
- 804 patch level 73
Switch to prepared statements to improve runtime
- 720 Patch Level 712
- 721 Patch Level 332
- 738 Patch Level 69
- 741 Patch Level 112
- 742 Patch Level 26
- 804 Patch Level 92
Use LAST_ESTIMATED_MEMORY_SIZE as of SAP HANA Rev. 91
- 722 patch level 2
- 741 patch level 215
- 742 patch level ?
- 743 Patch Level 18
The patch is available on SAP Service Marketplace. Follow
the procedure described in SAP Note 19466.
Header Data
| Released On | 17.03.2015 13:13:35 |
| Release Status | Released for Customer |
| Component | BC-DB-HDB-SYS Database Interface/DBMS for SAP HANA |
| Priority | Correction with medium priority |
| Category | Program error |
No comments:
Post a Comment