Solution : https://service.sap.com/sap/support/notes/1032273 (SAP Service marketplace login required)
Summary :
Following a migration or new installation of a DB2 V9 system for z/OS hosting SAP, certain system parameter settings recommended for the previous V8 system need revisions. DB2 V9 brings significant enhancements beneficial to SAP environments. Thus, this SAP Note provides updated recommendations on system parameters, buffer pool settings, and DBM1 virtual storage for all SAP releases. It emphasizes maintaining default settings unless specified otherwise. Detailed guidance on configuring these parameters is available in the SAP Database Administration Guide for DB2 for z/OS. Additionally, considerations for the randomized GROUP ATTACH processing in DB2 V9 are outlined for systems using ICLI or application servers on z/OS.
Key words :
tbsbpool bp2 idxbpool bp3 tbsbplob bp40 tsqty 144 ixqty 144 mgextsz, >= 64000 kb maxrblk >= 100000 chkfreq 2 minutes dsmax 20000 retlwait 1 utimout 3 urchkth 1 urlgwth 100, -data sharing 124 mb data sharing 237 mb rid pool, 50 gb starjoin 2 sjtables 4 max_opt_cpu 2 mxqbce 1023 mxdtcach 128 mb, db2 data sharing members run, cpus pcloset 25 pclosen 15 mlmt 4 gb, ebcdic invariant character set sap >= 700, edmstmtc 300000 kb maxkeepd <= 8000 srtpool >= 28000 kb, connection pooling mechanism creates sysds, runcleanupthreadinterval ---------------------------------------------------------------------randomized group attach processing
Related Notes :
| 1426172 | DB2-z/OS: Connection Profile for SAP Java Stack |
| 1399929 | DB2-z/OS: Avoiding automatic recommendations for REORG |
| 1398993 | DB2-z/OS: Running two or more DB2 members on one z/OS LPAR |
| 1339644 | DB2-z/OS: DB2 Connect 9.1 JDBC Failover for SAP Java stack |
| 1085521 | DB2-z/OS: Seamless JDBC Database Failover for SAP Java stack |
| 1043951 | DB2-z/OS: Release of DB2 V9 for SAP Components |
| 536074 | DB2 z/OS: BI: Configuring buffer pools for SAP BI |
| 534036 | SAP LT: System settings for conversions |
| 427748 | DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x) |
| 217093 | DB2 z/OS: CCMS transports for 4.6C |
| 81737 | DB2-z/OS: APAR List |