DB2-z/OS: Upgrade to SAP NW AS 7.1 and higher – free space

[] [] [] [] [] []

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 [...]

DB2-z/OS: Index compression with DB2 V9.1

[] [] [] []

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. [...]

DB2-z/OS: Avoiding automatic recommendations for REORG

[] [] [] [] []

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 [...]

DB2-z/OS: Running two or more DB2 members on one z/OS LPAR

[] [] [] [] [] [] [] [] []

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 [...]

640PC: Drop J2EE Content with Schema other than default

[] [] [] [] [] [] [] [] [] [] [] []

Symptom
You are not able to drop a J2EE content with a schema other than the default schema SAPDB.
Other terms
SAPDB SAPSIDDB DROP DROP DATABASE z/OS DB2 640PC JAVA J2EE SCHEMA
Reason and Prerequisites
With the 640PC we allow J2EE schemas other than the default. But if you want to drop the J2EE Database content, you cannot specify [...]

DB2-z/OS: Recommended settings for HiperSockets (zLinux)

[] [] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
This note describes the recommended settings for HiperSockets (HS) communication between SAP Application Servers running under Linux on System z and z/OS DB2 Database Server and/or SAP Enqueue Server.
The developer (dev) trace files of the work process contains the following message:
EncCliReq: timeout on enqueue connection
Other terms
EncCliReq Enqueue Server performance HiperSockets z/OS Linux on [...]

DB2-z/OS: Install MS Cluster solution

[] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
You want to install a high availability system for DB2 on z/OS on an MS Cluster, but the corresponding installation options are missing.
In particular, you would like to install the SCS instance (and ASCS for ABAP) and the enqueue replication server on an MSCS (Microsoft Cluster Server) environment.
Other terms
MSCS Microsoft Cluster DB2 z/OS [...]

DB2-z/OS: Distribution of Java instances to DB2 members

[] [] [] [] [] [] [] [] [] [] [] []

Symptom
If you have configured more than one SAP JAVA instance and are running DB2 as data sharing group, then you might want to statically distribute their database connections to the available DB2 members. In order to achieve this, use the 3-step procedure described below. This is only an option that you [...]

DB2-z/OS: Transports & Support Packages (7.0 and higher)

[] [] [] [] [] [] [] [] [] [] []

Symptom
This is a release-dependent attachment to note 101217. It contains a list of all corrections available:
for SAP Basis Release 7.0 and higheron DB2 for z/OS
Other terms
DB2/390 DB2 390 z/OS zOS
ABAP transport correction fix
DDIC CCMS Update
Reason and Prerequisites
n/a
Solution
As of 7.0 there are no mandatory corrections to be applied to the system. For recommendations, please refer [...]

DB2-z/OS: PLAN_TABLE & DSN_STATEMNT_TABLE for v9.1

[] [] [] [] [] [] [] []

Symptom
The note describes a fix that allows to create PLAN_TABLE and DSN_STATEMNT_TABLE according to the IBM DB2 v9.1 documentation.
Other terms
DB2, MVS, OS390, z/OS
Reason and Prerequisites
-
Solution
Please proceed as follows:
1. Download the latest lib_dbsl patch (dbdb2slib.o/so/dll) from Software Marketplace. It should contain the patch text:
DB2-z/OS: PLAN_TABLE & DSN_STATEMNT_TABLE for v9.12. Exchange lib_dbsl and re-start the SAP system.3. [...]

Next Page »