When converting a segmented Tablespace to a UTS PBG, the original SEGSIZE is not honored.

Document ID:  TEC1142613
Last Modified Date:  07/04/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


  • CA RC/Migrator for DB2 for z/OS


  • CA RC/Migrator for DB2 for z/OS:RCM

When altering a segmented Tablespace from a segmented Tablespace to a Partition-by-Growth (PBG) Universal Tablespace (UTS), RC/Compare generates the following DDL to make the change:


A Reorg utility is also generated to materialize the Tablespace to PBG UTS. Once the Reorg has been executed the SEGSIZE of the altered object is now 32G.



As per the DB2 SQL Reference Guide, if MAXPARTITIONS is specified on a simple or segmented table space, the table space is converted to a partition-by-growth universal table space that can grow to a maximum number of integer partitions. The SEGSIZE is set to the default of 32 if the SEGSIZE prior to conversion is less than 32.


If it is a requirement to retain the original SEGSIZE, then currently you must avoid using DB2 Alter. This can be done by performing a DROP/CREATE in the Analysis. To do this set the following Analysis Option to 'Y':


Additional Information:

Please refer to the alteration considerations section in the RC/Migrator documentation.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required


We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile

  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.

    Rate Your Chat Experience.


agent is typing