Converting Tablespaces from RBA_FORMAT 'U' to RBA_FORMAT 'E'
search cancel

Converting Tablespaces from RBA_FORMAT 'U' to RBA_FORMAT 'E'

book

Article ID: 239446

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Listing the RBA_FORMAT for the DB2 Tools Product Tablespaces in SYSIBM.SYSTABLEPART(tablespace partitions) show several with a 'U' (Unknown since Define NO was used). 

How do these tablespaces get converted to a value of 'E' Extended-10-byte?

Environment

Release : 20.0

Database Management for DB2 for z/OS Products

Resolution

If the tablespace was created with Define NO, once the table is populated the RBA_FORMAT will go to 'E'  extended 10 byte.

 

Powered by Wolken Software