A fix is available
APAR status
Closed as program error.
Error description
If DB2 objects are migrated from the old version (V7 and earlier), some fields in catalog records for it may be padded by spaces. In some cases trailing spaces are not trimmed by ARY, and generated DDL is incorrect. Specifically, we see this issue for storage groups: GSMS
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: If DB2 objects are migrated from the * * old version (V7 and earlier), some * * fields in catalog records for it may be * * padded by spaces. In some cases * * trailing spaces are not trimmed by * * ARY, and generated DDL is incorrect. * * Specifically, we see this issue for * * storage groups: * * USPTF= PDPTF= * * DUPS 0 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI88407
Reported component name
DB2 REC EXPERT
Reported component ID
5697H7400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-10-04
Closed date
2017-11-06
Last modified date
2017-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI51711
Modules/Macros
ARY$$SEQ ARY$BPRU ARY#YCTL ARY@FD28 ARY@FFN8 ARYACONN ARYA00 ARYA01 ARYA02 ARYA03 ARYA04 ARYA05 ARYA06 ARYA07 ARYA08 ARYA09 ARYA10 ARYA11 ARYA12 ARYA13 ARYA14 ARYA15 ARYA16 ARYA17 ARYA18 ARYA19 ARYA20 ARYA21 ARYA22 ARYA23 ARYA30 ARYA31 ARYA32 ARYA33 ARYA34 ARYA35 ARYA36 ARYA40 ARYA41 ARYA42 ARYA43 ARYA44 ARYA45 ARYA46 ARYA47 ARYA48 ARYA49 ARYA50 ARYA51 ARYA52 ARYA53 ARYA54 ARYA55 ARYA56 ARYA57 ARYA58 ARYA59 ARYA60 ARYA61 ARYA62 ARYA63 ARYA64 ARYA65 ARYA66 ARYA67 ARYA68 ARYA70 ARYA71 ARYBIND1 ARYCAL9D ARYCAL9L ARYCAL9S ARYCAQ1D ARYCAQ1L ARYCAQ1S ARYCATDB ARYCATDC ARYCATDR ARYCATDX ARYCAUTH ARYCCT9D ARYCCT9L ARYCCT9S ARYCDB9D ARYCDB9L ARYCDB9S ARYCDPND ARYCDPNL ARYCDPNS ARYCDTND ARYCDTNL ARYCDTNS ARYCDT0D ARYCDT0L ARYCDT0S ARYCDT1D ARYCDT1L ARYCDT1S ARYCDT9D ARYCDT9L ARYCDT9S ARYCFNND ARYCFNNL ARYCFNNS ARYCFN0D ARYCFN0L ARYCFN0S ARYCFN9D ARYCFN9L ARYCFN9S ARYCIXND ARYCIXNL ARYCIXNS ARYCIX0D ARYCIX0L ARYCIX0S ARYCIX1S ARYCIX2D ARYCIX2L ARYCIX2S ARYCIX9D ARYCIX9L ARYCIX9S ARYCPKND ARYCPKNL ARYCPKNS ARYCPK0D ARYCPK0L ARYCPK0S ARYCPK1D ARYCPK1L ARYCPK1S ARYCPK9D ARYCPK9L ARYCPK9S ARYCPLND ARYCPLNL ARYCPLNS ARYCPL0D ARYCPL0L ARYCPL0S ARYCPL1D ARYCPL1L ARYCPL1S ARYCPL9D ARYCPL9L ARYCPL9S ARYCRL2D ARYCRL2L ARYCRL2S ARYCRL9D ARYCRL9L ARYCRL9S ARYCRO9D ARYCRO9L ARYCRO9S ARYCRTND ARYCRTNL ARYCRTNS ARYCSG9D ARYCSG9L ARYCSG9S ARYCSN9D ARYCSN9L ARYCSN9S ARYCSPND ARYCSPNL ARYCSPNS ARYCSP9D ARYCSP9L ARYCSP9S ARYCSQND ARYCSQNL ARYCSQNS ARYCSQ1D ARYCTBND ARYCTBNL ARYCTBNS ARYCTB0D ARYCTB0L ARYCTB0S ARYCTB2D ARYCTB2L ARYCTB2S ARYCTB9D ARYCTB9L ARYCTB9S ARYCTRND ARYCTRNL ARYCTR0D ARYCTR0L ARYCTR0S ARYCTR9D ARYCTR9L ARYCTR9S ARYCTSND ARYCTSNL ARYCTSNS ARYCTS0D ARYCTS0L ARYCTS0S ARYCTS2D ARYCTS2L ARYCTS2S ARYCTS9D ARYCTS9L ARYCTS9S ARYCVA1D ARYCVA1L ARYCVA1S ARYCVT0D ARYCVT0L ARYCVT0S ARYCVT9D ARYCVT9L ARYCVT9S ARYCXAND ARYCXANL ARYCXANS ARYCXT9D ARYCXT9L ARYCXT9S ARYDALT3 ARYDDL1 ARYDDL3 ARYECONN ARYFSLA1 ARYFSLB1 ARYFSLRX ARYFSL01 ARYFSL91 ARYGMSQT ARYGRAOP ARYGSIXN ARYGSIX2 ARYGSLSN ARYGSSGN ARYGSTBN ARYGSTSN ARYGSTS1 ARYGSTS2 ARYGUIW ARYHRAOP ARYINB ARYINBR ARYINBX ARYINBXR ARYIN1 ARYIN1R ARYIN1X ARYIN1XR ARYIN4 ARYIN4R ARYIN4X ARYIN4XR ARYJCMN ARYJIMGM ARYJIMGX ARYJMSGS ARYJOGEN ARYJRGEN ARYLBBUK ARYLBBUL ARYLB0UQ ARYLB2UQ ARYLB9UL ARYLGNL ARYLJBAQ ARYLJBRD ARYLJBVA ARYLJBVW ARYLJ0RL ARYLJ0TR ARYLJ7AL ARYLJ7CL ARYLJ7CP ARYLJ7DB ARYLJ7DT ARYLJ7GS ARYLJ7IP ARYLJ7IX ARYLJ7OP ARYLJ7PK ARYLJ7PL ARYLJ7RL ARYLJ7RT ARYLJ7SG ARYLJ7SN ARYLJ7SQ ARYLJ7TB ARYLJ7TP ARYLJ7TR ARYLJ7TS ARYLJ7VW ARYLJ8AL ARYLJ8CL ARYLJ8CP ARYLJ8DB ARYLJ8DT ARYLJ8GS ARYLJ8IP ARYLJ8IX ARYLJ8OP ARYLJ8PK ARYLJ8PL ARYLJ8RL ARYLJ8RT ARYLJ8SG ARYLJ8SN ARYLJ8SQ ARYLJ8TB ARYLJ8TP ARYLJ8TR ARYLJ8TS ARYLJ8VW ARYLJ9AL ARYLJ9CL ARYLJ9CP ARYLJ9DB ARYLJ9DT ARYLJ9GS ARYLJ9IP ARYLJ9IX ARYLJ9OP ARYLJ9PK ARYLJ9PL ARYLJ9RL ARYLJ9RO ARYLJ9RT ARYLJ9SG ARYLJ9SN ARYLJ9SQ ARYLJ9TB ARYLJ9TP ARYLJ9TR ARYLJ9TS ARYLJ9VW ARYPSIXN ARYPSIX2 ARYPSLSN ARYPSSGN ARYPSTBN ARYPSTSN ARYPSTS1 ARYPSTS2 ARYR74 ARYR749W ARYR986E ARYSQL0 ARYSQL0A ARYSQL0B ARYSQL1 ARYSQL1A ARYSQL1B ARYSQL1C ARYSQL2 ARYSQL2A ARYSQL2B ARYSQL9 ARYSQL9A ARYSQL9B ARYSQL9C ARYSQ1CA ARYSQ1CB ARYSQ9CA ARYSTAT ARYT00 ARYT01 ARYZAGT ARYZASOR ARYZMSGS ARY7120 ARY90 ARY91 ARY94
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI51711
UP17/11/15 P F711
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":"3.2.0"}]
Document Information
Modified date:
31 March 2021