Solution : https://service.sap.com/sap/support/notes/1250466 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidelines on conducting database administrative tasks without halting SAP application servers, specifically for UNIX or Linux operating systems using DB2 V8 or newer. Techniques include placing the database into quiesced mode, effectively prohibiting SAP connect users from establishing new connections during maintenance, thus avoiding full system restarts. Administrators should remove specific users from SYSMAINT, SYSADM, and SYSCTRL groups temporarily and ensure they do not possess DBADMAUTH and QUIESCECONNECTAUTH privileges before initiating maintenance. After tasks are completed, these settings are reversed to restore normal operation and connectivity. This method supports various scenarios, including offline backup/restores and parameter changes without affecting system availability.
Key words :
su - root id sap<sid>/sapr3 id sap<sid>db/sapr3db, maintain sap instance profile parameter rsdb/reco_add_error_codes, <sid> user sap<sid>db/sapr3db, <sid> user sap<sid>/sapr3, increase db cfg parameters logfilsiz, 2 db2 update db/dbm cfg, start_stop_time database manager configuration parameter, sapr3db/sap<sid>db, avoiding stopping sap application servers, prevent sap connect users connecting
Related Notes :
1329179 | DB6: DB2 9.7 Standard Parameter Settings |
1308895 | DB6: File System for Transaction Log is Full |
1293475 | DB6: Transaction Log Full |
1086130 | DB6: DB2 9.5 Standard Parameter Settings |
1027336 | DB6: New functions in the DBA Cockpit |
1019242 | DB6: SQL0960C "maximum number of objects in tablespace" |
956214 | DB6: SQL0443N after upgrade to a new SAP release |
899322 | DB6: DB2 9.1 Standard Parameter Settings |
780586 | DB reconnect mechanism in J2EE Engine 6.20 |
584952 | DB6: DB2 UDB Version 8 Standard Parameter Settings |
427982 | DB6: Offline backup ends with job error (DB13) |
396907 | DB6: SQL0289 Error Code |
101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |
98051 | Database Reconnect: Architecture and function |
41678 | DB reconnect: additive error return codes |
24806 | Database Reconnect: technical details and settings |