A fix is available
APAR status
Closed as new function.
Error description
Convert PWH tablespaces to single table tablespaces based upon Db2 V12 FL504 requirement. See Technote at https://www-01.ibm.com/support/docview.wss?uid=ibm10957133
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM * * users of component * * PE Server Subtask * * PWH(Host Part) * **************************************************************** * PROBLEM DESCRIPTION: Multi-table tablespaces cannot be * * created after Db2 V12 FL504. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** PWH is unable to create multi-table tablespaces for its database causing PWH related functions to fail in Db2 V12 subsystems activated at FL504 or later.
Problem conclusion
The PWH performance database now uses single table tablespaces for all supported Db2 releases. Search Keywords: V12R1M504 PDB LOAD DSNU327I MSGDSNU327I MSGDSNU327
Temporary fix
Comments
APAR Information
APAR number
PH08213
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
540
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-02-05
Closed date
2019-06-25
Last modified date
2019-07-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63851
Modules/Macros
DGOVMSTR DGOZCHKB DGOZDB DGOZDMDB DGOZLOAD DGOZMT1I DGOZMT2 DGOZMT3 DGOZMT4 DGOZMT5 DGOZPRV1 DGOZSIDS FPEZPMS
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R540 PSY UI63851
UP19/06/26 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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 July 2019