A fix is available
APAR status
Closed as program error.
Error description
DDL or GEN of an ACCELERATOR-ONLY TABLE (AOT) generates DDL that contains the LOGGED keyword, which is invalid for such a table. Executing such DDL would result in SQLCODE -4747 / SQLCODEN4747: -4747 THE CREATE OR ALTER TABLE STATEMENT FAILED BECAUSE SOME FUNCTIONALITY WAS SPECIFIED IN THE TABLE DEFINITION THAT IS NOT SUPPORTED WITH THE TABLE TYPE. UNSUPPORTED FUNCTIONALITY: LOGGED
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration Tool * * for z/OS who uses GEN/DDL on * * accelerator only tables. * **************************************************************** * PROBLEM DESCRIPTION: GEN incorrectly generates a LOGGED * * clause on accelerator only tables, * * which is not allowed. * **************************************************************** * RECOMMENDATION: * **************************************************************** When running GEN or a function that uses GEN (like the DDL function) on an accelerator only table, the LOGGED clause is generated. If executed, this DDL would cause error SQLCODE=-4747 / SQLCODEN4747: -4747 THE CREATE OR ALTER TABLE STATEMENT FAILED BECAUSE SOME FUNCTIONALITY WAS SPECIFIED IN THE TABLE DEFINITION THAT IS NOT SUPPORTED WITH THE TABLE TYPE. UNSUPPORTED FUNCTIONALITY: LOGGED
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH08817
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-02-20
Closed date
2019-05-30
Last modified date
2019-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63339
Modules/Macros
ADB2REG
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI63339
UP19/06/04 P F906
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
31 March 2021