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 [...]
Symptom
To install FixPakslower than FixPak 9, see
Note 940551
You want to install one of the following FixPaks for DB2 UDB for UNIX and Windows Version 8.2 (which we will refer to as DB6):
FixPak 9FixPak 10FixPak 11FixPak 12FixPak 13SAP (*)FixPak 14SAP (*)FixPak 15FixPak 16FixPak 17
(*) “Special Builds” for SAP are called FixPak xSAP.
Other terms
DB2 UDB for Unix [...]
Symptom
To install FixPakslower than FixPak 9, see Note 940550.
You want to install one of the following FixPaks for DB2 UDB for UNIX and Windows Version 8.2 (which we will refer to as DB6):
FixPak 9FixPak 10FixPak 11FixPak 12FixPak 13SAP (*)FixPak 14SAP (*)FixPak 15FixPak 16FixPak 17
(*) “Special Builds” for SAP are called FixPak xSAP.
Other terms
DB2 UDB for [...]
Symptom
You use 11.50.xC4.
You consider whether or not you want to compress the data of some tables.
Other terms
Compression, extents, performance, reorg, reorganization
Reason and Prerequisites
You use 11.50.xC4 or higher.
The table contains data that can be compressed (no cluster or similar).
Solution
11.50.xC4 provides you with the option of controlling the compression of tables using sysadmin functions:
Activate compressionCompress existing [...]