Chorus Software Manager (CSM): Parsing Error during Apply Check - PAGENUM clause in ALTER TABLESPACE
search cancel

Chorus Software Manager (CSM): Parsing Error during Apply Check - PAGENUM clause in ALTER TABLESPACE

book

Article ID: 201118

calendar_today

Updated On:

Products

Mainframe Software Manager (Chorus Software Manager) CHORUS SOFTWARE MANAGER

Issue/Introduction

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.

 

Environment

Release : 6.0

Component : Chorus Software Manager

Resolution

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  
partition growth.                  

 
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.

Alternatively...

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.