SAP Note 1523227 - DB6: Use of BLOCKNONLOGGED database configuration parameter

Component : DB2 Universal Database for Unix / NT -

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 :

1527970DB6: Log overflow during query processing
1513862DB6: Table conversion using DB6CONV Version 5.01 or higher
1420036DB6: DB2 9.8 pureScale Standard Parameter Settings
1329179DB6: DB2 9.7 Standard Parameter Settings
1086130DB6: DB2 9.5 Standard Parameter Settings