CADB2 TOOLS COMPATIBILITY WITH DB2V11

Document ID : KB000005101
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

IBM has listed several db2 v11 utility incompatibilities, do these IBM incompatibilities affect CA Tools at all?. ie fast load etc. 

Resolution:

CA DB2 utilities (ie CA Fast Load, CA Rapid Reorg, etc..) are not affected by IBM incompatibilities but we'd encourage you to be current with your maintenance if at all possible or minimally the recommended DB2V11 maintenance. Being current on maintenance would be highly suggested.

Additional Information:

Page 48 in the v11 installation guide - GC19-4056-08 

Chapter 2. Preparing your system to install or migrate to DB2 11 . . . . . . . . . . . 5 

Hardware and software requirements for DB2 . . . . . . . . . . . . . . . . . . . . . . . . 5 

Required maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 

Storage requirements for DB2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 

DB2 subsystem storage requirements . . . . . . . . . . . . . . . . . . . . . . . . . . 6 

Virtual storage requirements for address spaces . . . . . . . . . . . . . . . . . . . . . . 15 

Virtual storage requirements for storage pools and working storage . . . . . . . . . . . . . . . 21 

Calculating real storage requirements. . . . . . . . . . . . . . . . . . . . . . . . . . 29 

Planning for performance of DB2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 

Changes to DB2 that might impact your migration to DB2 11. . . . . . . . . . . . . . . . . . . 32 

Application and SQL release incompatibilities. . . . . . . . . . . . . . . . . . . . . . . 32 

V10R1 application compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 

Utility release incompatibilities. . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 

Command release incompatibilities . . . . . . . . . . . . . . . . . . . . . . . . . . 55 

Storage release incompatibilities . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 

Other release incompatibilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 

Deprecated function in DB2 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 

Functions that are no longer supported . . . . . . . . . . . . . . . . . . . . . . . . . 65 

Preparing for DB2 data sharing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 

DB2 data sharing in a Parallel Sysplex . . . . . . . . . . . . . . . . . . . . . . . . . 68 

Data sharing naming conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 

Planning for availability in a data sharing environment. . . . . . . . . . . . . . . . . . . . 87 

Storage estimates for data sharing environments . . . . . . . . . . . . . . . . . . . . . 101 

Before you enable DB2 data sharing. . . . . . . . . . . . . . . . . . . . . . . . . . 114 

Application design planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 

Release coexistence considerations . . . . . .