Solution : https://service.sap.com/sap/support/notes/1523227 (SAP Service marketplace login required)
Summary :
Using DB2 for Linux, UNIX, and Windows, the BLOCKNONLOGGED database configuration parameter, introduced in DB2 V9.5 FP5 and DB2 V9.7 GA, should be set to NO when operating SAP applications. This configuration enables standard database operations and ensures HADR systems and database recoverability are not compromised. SAP systems predominantly utilize fully logged operations, excluding specific controlled scenarios detailed in SAP Notes 1527970 and 1513862. Setting BLOCKNONLOGGED to YES can restrict critical maintenance functions and should only be considered to prevent unauthorized use of certain DB2 commands outside of SAP system contexts.
Key words :
sap netweaver bw /bi0/0p tables, terms db2 luw db6 reason, db2 stored procedure sysproc, experienced dedicated dba staff, negatively affect hadr setups, database configuration parameter blocknonlogged, -recoverable load operations result, db2 explain tables, dba cockpit creates, database manager blocks
Related Notes :
| 1527970 | DB6: Log overflow during query processing |
| 1513862 | DB6: Table conversion using DB6CONV Version 5.01 or higher |
| 1420036 | DB6: DB2 9.8 pureScale Standard Parameter Settings |
| 1329179 | DB6: DB2 9.7 Standard Parameter Settings |
| 1086130 | DB6: DB2 9.5 Standard Parameter Settings |