The following error occurs during an Apply Check for DB2 Management Tools R20 (108 newest Maintenance PTFs):
An error occurred while parsing report page header ! PAGENUM clause in ALTER TABLESPACE statement for partition-by-range!. Expected to find ZONE name but failed.
Release : 6.0
Component : Chorus Software Manager
The "An error occurred while parsing report page header ! PAGENUM clause in ALTER TABLESPACE statement for partition-by-range!. Expected to find ZONE name but failed" message is caused by SO14832 and SO14833.
The problem is in this section of the HOLDDATA text in SO14832/SO14833:
On Db2 12 subsystems, you can now generate DDL that contains the
PAGENUM clause in ALTER TABLESPACE and ALTER INDEX statements for
partition-by-range tablespaces using relative page numbering
(PBR2 tablespaces). The PAGENUM option specifies the type of page
numbering that is used for a range-partitioned table space. Valid
values are: A (absolute) or R (relative). Relative page numbering
provides more flexibility and availability and higher limits in
The word PAGENUM is significant to CSM's internal parsing which is causing this exception. This will be reported to the DB2 group to be corrected.
For now as a circumvention :
Apply the PTF's outside CSM.
Reject the HOLDDATA for these PTFs:
//SMPGO EXEC PGM=GIMSMP,REGION=4096K,PARM='DATE=U' //SMPCSI DD DISP=SHR,DSN=your.DB2.R20.CSI //SMPSNAP DD SYSOUT=* //SMPHOLD DD DUMMY //SMPCNTL DD * SET BDY(GLOBAL). REJECT SELECT(SO14832) HOLDDATA. REJECT SELECT(SO14833) HOLDDATA. /*
In CSM from the Products tab click on release 20.0 of the DB2 product to which these PTF's are being installed. Products such as CA Bind Analyzer for DB2 for z/OS MIPS - MVS,
CA Bind Analyzer for DB2 for z/OS - MVS,
CA Database Management Solutions for DB2 for z/OS - MVS.
Locate these PTF's in the list and for each click actions to the right then deleted.
Download these PTF's from support.broadcom.com to a dataset.
Change PAGENUM in the HOLDDATA section only from upper to lower case.
Re-add these PTF's to CSM. Right click on 20.0 then click 'add external maintenance' and enter the dataset containing the modified PTF.