A fix is available
APAR status
Closed as program error.
Error description
Fields used adb2rep.pli in gen_unique_constraints() to count rows fetched from systabconst and syskeycoluse are defined as signed binary halfwords, so are limited to holding values up to 32,767.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who use the GEN command on a database that * * has a large number of constraints across all * * tables in the database * **************************************************************** * PROBLEM DESCRIPTION: The GEN command results in RC 12 for: * * IBM0342S ONCODE=340 * * The SIZE condition was raised. * * Program ADB2REP * * Procedure GEN_UNIQUE_CONSTRAINTS * **************************************************************** ADB2REP has been updated prevent the SIZE condition from being raised when a database has more than 32,767 constraints across all tables in the database.
Problem conclusion
The problem has been resolved. Search keywords: ONCODE340 MSGIBM0342 MSGIBM0342S
Temporary fix
Comments
APAR Information
APAR number
PH50088
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
2022-10-10
Closed date
2023-01-20
Last modified date
2023-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI90195 UI90196
Modules/Macros
ADB2CDC ADB2DEP ADB2RE ADB2REC ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2WVL ADBGDDL
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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.
[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 February 2023