Solution : https://service.sap.com/sap/support/notes/304923 (SAP Service marketplace login required)
Summary :
SAP Note addresses a known issue with the DB2B buffer pool tuning tool, which does not support 8K and 16K buffer pools, incorrectly suggesting a 4K buffer pool for tables with these page sizes. This leads to a DBIF_DSQL2_SQL_ERROR with SQL code -671 during the execution of the ALTER statement. The resolution involves importing specified transports according to your R/3 Release as indicated in Note 101217 and checking for updates. Specific transports for releases 4.6C, 4.6B, and 4.6A are listed for proper implementation.
Key words :
buffer pool tuning tool db2b, additional key words db2, runtime error dbif_dsql2_sql_error occurs, 4k buffer pool, 16k buffer pools, prerequisites solution make, latest maintenance level, buffer pool, support 8k, alter statement
Related Notes :
| 217093 | DB2 z/OS: CCMS transports for 4.6C |
| 191215 | DB2/390: Transports for 4.6B |
| 166083 | DB2/390: Transports for 4.6A |
| 101217 | DB2 z/OS: Overview of transports and corrections |
| 13719 | Preliminary transports to customers (note for customers) |