Gen EDGE

 View Only
  • 1.  CA GEN Universal tablespaces and Extended RBA?

    Posted Apr 11, 2019 09:40 AM

    I was wanting to convert our CA Gen tablespaces to Universal and also convert the RBA to extended.  Has anyone else done this to ther CA Gen database?  I didn't want to encounter any issues with conversion.



  • 2.  Re: CA GEN Universal tablespaces and Extended RBA?

    Broadcom Employee
    Posted Apr 11, 2019 08:26 PM

    Hello Steve,

    From searching I think you previously raised a support case on this topic and you are referring to the Gen Host Encyclopedia database rather than a Gen application database - correct?

    We do now have some published KB articles but they still state both changes are not officially supported because they are not tested and would therefore be at own risk:

    Can CA Gen Host Encyclopedia (HE) table spaces be - CA Knowledge 

    Is CA Gen Host Encyclopedia (HE) impacted if chang - CA Knowledge 

     

    Hopefully there are some Gen community users out there who might have tried these changes and can provided input.

     

    Thanks,

     

    Lynn



  • 3.  Re: CA GEN Universal tablespaces and Extended RBA?

    Posted Apr 12, 2019 03:33 AM

    We converted to UTS for the GuardIEn tablespaces (DB2 on z/OS). For both Gen and GuardIEn databases the PLAN_TABLEs were converted to extended. Did not encounter any problems.

    Statements used:

    • ALTER TABLESPACE EHDBGD1.EHGD1CCB

      MAXPARTITIONS 10;                                                                       <----

    • //REORG1 EXEC DSNUPROC,SYSTEM=DB0O,UID='',UTPROC=''                    
      //SYSREC   DD UNIT=DISK,SPACE=(CYL,(25,25),RLSE)                       
      //SYSIN DD *   

             TEMPLATE SYSCOPY                                     
              DSN <dataset>
              UNIT SYSDA                                          
              RETPD 30                                            
             LISTDEF CONVERSI INCLUDE TABLESPACE EHDBGD1.PLANRTAB 
             REORG TABLESPACE LIST CONVERSI                       
             SHRLEVEL REFERENCE                                   
             COPYDDN(SYSCOPY)                                     
             RBALRSN_CONVERSION EXTENDED                                          <-----