SAP Basis Tech Supports

Symptom
A problem in the database software has occurred.
Other terms
db2 db6 db2udb udb Fix Pack
Reason and Prerequisites
DB2 9 for Linux, UNIX and Windows is used.
Solution
Problems are / will be solved by the following APARs and DB2 for Linux, UNIX and Windows. For further details, see the SAP Notes mentioned below.
———————————————————————–
| FP | APAR | SAP Note | Problem Description |
———————————————————————–
| 2 | IY88918 | 977842 | No. of missing logfile in RF in diaglog |
| 2 | JR24820 | 869134 | MSCS: failing stored procedure calls |
| 2 | JR24996 | 1009350 | SQL0969N and CLI -99999 in DBA Cockpit |
| 3 | IY93078 | n/a | db2tapemgr failis with SQL1031N |
| 3 | JR25689 | n/a | VALUES clause may lead to subopt. plans |
| 3 | IY98624 | 1066104 | HP-UX: DB2 perf due to alignment issue |
| 3 | IY99283 | 1066104 | HP-UX: WPs dump in CLI due to alignment |
| 4 | IY97059 | 1099319 | ABAP TRUNCATE is locked |
| 4 | IZ05520 | 1099320 | Online backup failing due to tbsp state |
| 4 | LI72155 | n/a | Wrong result set with LIKE statements |
| 5 | JR27582 | 1108327 | SQL0443 in DBACOCKPIT |
| 5 | IZ11917 | 1009350 | Misleading error messages in db2diag.log|
| 5 | LI73038 | n/a | Deadlocks during concurrent CREATE / |
| | | | DROP VIEW (=> deferred table creation) |
| 5 | IZ18589 | 1156514 | missing INSERTs in CLI buffered insert |
| | | | on DPF / EEE |
| 5 | IZ06533 | 1159574 | Bad Page during / after RollFwd of |
| | | | split mirror DB |
| 5 | IZ16985 | 1159576 | Parallel backup of DPF split mirror |
| | | | returns SQL2406N |
| 5 | IZ17763 | 1138605 | SQL6048N with ssh as remote shell |
| 5 | IZ21943 | 1267419 | LOAD to MDC tables with row compression |
| | | | may cause table corruption |
| 6 | IZ16861 | 1154013 | HADR Standby activation fails |
| 6 | IZ19266 | none | db2iupdt failing with DBI1250E |
| 6 | IZ22768 | 1175804 | SQL0289N during WRITE SUSPEND in |
| | | | AUTORESIZE tablespace |
| 6 | IZ25933 | n/a | DB2 Agent may get signal 11 and then |
| | | | and then cause DB2 instance crash |
| 6 | IZ29117 | n/a | Incorrect results for OUTER JOINs with |
| | | | SELECT DISTINCT |
| 6 | IZ33174 | 1256153 | Rollforward may fail “Page count |
| | | | incorect during redo” |
| 6 | LI73566 | 1258012 | Memory Leak in the DB2 Application Heap |
| 6 | LI73604 | n/a | Index Scan using exclusive start key |
| | | | might return incorrect results |
| 6 | JR30491 | n/a | Crash on WinX64 compiling a query when |
| | | | memory addresses >4GB are in use |
| 6a | IZ38956 | n/a | Possible incorrect results from |
| | | | rewriting NOT EXISTS to Outer Join |
| 6a | IZ36534 | n/a | Security: EXCSAT+SECCHK can cause DB2 |
| | | | server to infinite loop |
| 6a | IZ39373 | n/a | SECURITY: Bad DSS header causes server |
| | | | to trap in SQEX /SQJS |
| 6a | IZ37640 | n/a | Query having a join over a range part. |
| | | | table may get incorrect result |
| 6a | LI73864 | n/a | UNEXPECTED RESULTS WHEN SELECTING FROM |
| | | | A VIEW WITH OUTER JOIN |
| 7 | IZ14287 | 1338478 | Slow DB Performance due to Internal |
| | | | V Locks |
| 7 | IZ29695 | n/a | SQLExeDirect() can fail with SQL_ERROR |
| | | | without SQLCODE returned from server |
| 7 | IZ34912 | n/a | DB2 AUTOMATIC TABLE MAINTAINANCE MAY |
| | | | SKIP TABLES FOR AUTO_REORG EVALUATION |
| 7 | IZ37842 | n/a | DB2 Page Cleaner can bring down instance|
| | | | w/ sig11 after running out of filedesc|
| 7 | IZ38568 | n/a | Align the writes when blocksize > 2k |
| | | | blocksize on HP-UX using VxFS 4.1 |
| 7 | LI87870 | n/a | LDAP: Trap in getenv() |
| 7 | JR31883 | 1330866 | Incorrect results of queries with outer |
| | | | joins |
| 7 | IZ35897 | 1349151 | Database Backup not possible |
| 8 | LI74163 | n/a | db2sysc’s supplementary groups not set |
| | | | if non-instance owner performs db2start |
| 8 | IZ43665 | n/a | High system CPU during Online Backup due|
| | | | to large number of db2bm processes |
———————————————————————–

Remarks on SAP special builds
Some Fix Packs named above are not identical to those found on official IBM websites. These are the Fix Packs with a suffix SAP. Those Fix Packs are available from SAP only. They are built on top of official IBM Fix Packs (i.e. Fix Pack 2SAP is Fix Pack 2 + some APARs).These APARs will go into one of the subsequent official IBM Fix Packs and can be found in the list of included APARs for this Fix Pack.More details on these APARs can be found on official IBM websites.You should ensure to use DB2 Fix Packs from SAP only.IBM has issued Fix Pack 3 and Fix Pack 3a. Fix Pack 3SAP is based on Fix Pack 3.
Subsequently, the APAR numbers added to official IBM Fix Packs are listed.
OS-Related issues on IBM Web sites
For some OS platforms, IBM reports DB2-related issues on separate Web pages as follows:
Solaris: http://www-1.ibm.com/support/docview.wss?&uid=swg21257606
HP: http://www-1.ibm.com/support/docview.wss?rs=0&uid=swg21257602
AIX: http://www-1.ibm.com/support/docview.wss?rs=0&uid=swg21165448
Database Problems Caused by OS-Problems
———————————————————————–
| OS / Release | SAP note | Description |
———————————————————————–
| Solaris 10 | 1167317 | DB2 Load / R3load will hang |
———————————————————————–
Special builds:
Problems are / will be solved by the following APARs and Fix Packs (FP) of DB2 for Linux, UNIX and Windows.
For further details, see the related SAP Notes mentioned below.
———————————————————————-
| FP | APAR # | Problem Description |
———————————————————————-
| 2SAP | IY96287 | retarting TSM agent fails |
———————————————————————- | 3SAP | IY91492 | Bad performance of snapsh tab func in DPF environ|
| 3SAP | IY94994 | HADR stdby logfile set never shrinks |
| 3SAP | IY97401 | SAMPLING runstats: AVGCOLLEN for column |
| 3SAP | IY97543 | Deadlocks while engine terminates FMPs |
| 3SAP | IZ00581 | New MDC insert variable into DB2_WORKLOAD=SAP |
| 3SAP | IZ01137 | No upd of LOGARCHOPT if logfile mgr in err state |
| 3SAP | IZ01160 | ‘db2pd -alldbp’ crash/hang on multi host DPF |
| 3SAP | IZ03102 | buffered INSERT slow with increasing # of nodes |
| 3SAP | IZ03753 | v9.1 FP inst fails on SPARC (certain chips platf)|
| 3SAP | IZ04929 | SQLNLSMESSAGE attempts to free mem from stack |
|——————————————————————–|
| 4SAP | IZ08381 | DUPLICATE OBJECT IDs IN A TABLESPACE |
| 4SAP | JR27947 | Windows extended security |
| 4SAP | IZ06533 | DB MARKED BAD BECAUSE OF BAD PAGE DURING OR AFTER|
| | | ROLLFWD FROM AN OFFLOADED DB2 BACKUP IMAGE |
| 4SAP | IZ08779 | EXTEND INLIST2JOIN TO HIGH FILTERING IN PREDICATE|
| 4SAP | LI72700 | TRAPS AFTER FAILED ONL REORG OF INDEX ON PART.TAB|
| 4SAP | IZ07906 | ?bufferpool flushing? and ?softmax change” tool |
| 4SAP | JR27582 | DBM_GET_CFG CAN RETURN SQL5066W IN DB2DIAG.LOG |———————————————————————-