Announcing Db2 12 function level 504!
Paul_McWilliams 110000JT36 Visits (4755)
IBM z14 Huffman compression
Function level 504 introduces support for compression of Db2® data with IBM® Z hardware-based entropy encoding (Huffman) compression with the IBM z14 Compression Coprocessor (CMPSC). Look for more about this new capability in a future post. The functional code was delivered in APAR PH04424.
Prevent the creation of new deprecated objects
Function level 504 introduces the capability to prevent the creation of certain deprecated objects in your Db2 for z/OS environments. You can bind packages with APPL
Existing objects of these types remain supported, and they can still be created at application compatibility level V12R1M503 or lower. For more information about this new capability, see "Preventing the creation of new deprecated objects in Db2 12 function level 504." The functional code was delivered in APAR PH02873.
New support for built-in functions by pass-through to IBM Db2 Analytics Accelerator
Function level 504 introduces support for certain built-in functions, which are passed through from Db2 for z/OS to IBM Db2 Analytics Accelerator. Db2 for z/OS only verifies that the data types of the parameters are valid for the functions. The accelerator engine does all other function resolution processing and validation. For more about this new capability, see "Newly supported built-in functions in Db2 12 function level 504 with IDAA." The functional code was delivered in APAR PH00224.
|Existing Special Register||New Syntax Alternative|
|CURRENT CLIENT_ACCTNG||CLIENT ACCTNG|
|CURRENT CLIENT_USERID||CLIENT USERID|
For example, CURRENT_SERVER is now a supported spelling of the CURRENT SERVER special register, and CLIENT USERID is now a supported spelling for the CURRENT CLIENT_USERID special register. For a full list of the special register syntax variations now supported, see Special Registers.
ISNULL and NOTNULL are also now supported as alternatives for the IS NULL and IS NOT NULL. For details, see NULL predicates.
The functional code for the new SQL syntax alternatives was delivered in APAR PH02646.