November 7, 2009 at 8:34 pm
Symptom
Disk space required for an upgrade to SAP Basis Release 7.1 and higher.
Other terms
DB2, OS/390, z/OS, zOS
Upgrade, release, switch
Reason and Prerequisites
-
Solution
Additional disk space requirement:
Productnon-UnicodeUnicodeNW30GB30GB
General remarks
1. The value specifies the free space required in addition to the currently allocated disk space.2. Depending on the source release and the size of the existing database, you may [...]
October 28, 2009 at 9:03 am
Symptom
DB2-z/OS v9.1 offers as a new feature index compression. We strongly recommend to not apply this feature generally but to use it selectively for the most beneficial indexes.
Other terms
DB2 z/OS
index compression
Reason and Prerequisites
There are some aspects to consider before you switch on index compression:
1. Index compression may increase the CPU time and elapsed time
2. [...]
October 28, 2009 at 4:41 am
Symptom
You want to move table data online using the stored procedure ADMIN_MOVE_TABLE.
Other terms
online table move stored procedure, DB2 LUW
Reason and Prerequisites
You are using DB2 9.7 GA and you would like to move table data online.For DB2 9.7 GA, the stored procedure ADMIN_MOVE_TABLEmust notbe used.There is a known problem which will be corrected in DB2 [...]
October 27, 2009 at 7:21 pm
Symptom
With DB2 for z/OS, you can automate the scheduling of the REORG utility based on real-time statistics and the stored procedures DSNACCOR or DSNACCOX. Based on the amount of changes in a table and other criteria, tablespaces are suggested to be reorganized. In some situations, like after running an SAP installation [...]
October 27, 2009 at 7:18 pm
Symptom
SAP NetWeaver 7.0 incl.EHP 2 on Windows with DB2 V9.1 + DB2 V9.5 + DB2 9.7 for Linux, UNIX, and Windows only (including the DB2 Thin Client)!
Other terms
NW2007 installation, SAPinst, DB2 for Linux, UNIX and Windows, DB6
SAP Web AS
Reason and Prerequisites
Problems discovered after publication of the installation guide.
Solution
Provide any feedback, questions or comments [...]
October 27, 2009 at 7:17 pm
Symptom
SAP NetWeaver 7.0 incl.EHP 2 on UNIX with DB2 V9.1 + DB2 V9.5 + DB2 9.7 for Linux, UNIX, and Windows only (including the DB2 Thin Client)!
Other terms
SAPinst, DB2 UDB for UNIX and Windows, DB6
Reason and Prerequisites
Problems discovered after publication of the installation guide
Solution
Provide any feedback, questions or comments on this or platform-related [...]
October 26, 2009 at 5:27 am
Symptom
Failover/failback solution provided to support planned outages of a DB2 member doesn’t work anymore.
Example:
For the sake of simplicity let assume there are two DB2 datasharing members DB2 A and DB2 B and two application servers App A and App B. All connection of App A go to member DB2 A and all connections [...]
October 22, 2009 at 8:43 pm
Symptom
An DB2 error occurred and you would like to open a message on one of the components BC-DB-DB6* or BW-SYS-DB-DB6.
Note that a detailed problem description significantly simplifies the processing of the message.
Other terms
DB2 UDB LUW INTERNAL MESSAGE V8 V9
Reason and Prerequisites
The problem description is not sufficient to effeciently process the message.
Solution
An internal problem message [...]
October 22, 2009 at 8:33 pm
Symptom
This SAP Note describes how you can set up a DB2 data sharing group so that two or more members are running on the identical z/OS LPAR.
Other terms
HA Failover z/OS System z DB2 data sharing LPAR
Reason and Prerequisites
Your SAP system is running with DB2 in data sharing mode and DB2 Connect as database [...]
August 6, 2009 at 9:38 am
Symptom
This SAP Note is valid for the following releases:
mySAP CRM 4.0 SR1 on Unix and Windows for IBM UDB for z/OSmySAP ERP 2004 SR1 on Unix and Windows for IBM UDB for z/OSSAP R3E 4.7 Extension Set 2 SR1 on Unix and Windows for IBM UDB for z/OSSAP SCM 4.1 on Unix and Windows for [...]