A fix is available
APAR status
Closed as new function.
Error description
V13 Additional Functionality for Db2 Admin v13.1 in support of Db2 13.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool * * for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR adds functionality to * * support the Db2 13 feature "Online * * conversion of tables from growth-based * * (PBG) to range-based (PBR) partitions" * * during the ALTER TABLE (AL) flow. * * This APAR also fixes an ONCODE 350 * * error. * **************************************************************** The Db2 13 feature "online conversion of PBG to PBR" is already supported in Db2 Admin Tool 13.1 by using the ALT line command. This APAR adds support for this feature when using the AL line command. When issuing the AL line command on a table that is in a PBG table space, the user can now choose to convert its table space to PBR by selecting the ALTER PARTITIONING option on panel ADB21TA. If the values MAXVALUE (for ascending) or MINVALUE (for descending) are selected for the limit key columns, the new Db2 13 ALTER TABLE ALTER PARTITIONING statement is generated for the conversion. This APAR also fixes the following ONCODE 350 error in merge: IBM0361W ONCODE=350 The STRINGRANGE condition was raised. From entry point CONVERT_LIMITKEY at statement xxx at compile unit offset xxx at entry offset xxx at address xxx.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH47480
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-06-23
Closed date
2022-08-15
Last modified date
2022-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI81941
Modules/Macros
ADB21TA ADB21TAP ADB21TAV ADB2Z ADBCCMM
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI81941
UP22/08/17 P F208
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":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2022