I ran a command 'ALTER TABLESPACE DBDV36JP.HMTMACCT MAXPARTITIONS 1;' to convert the segmented TS to PBG.
Then the tablespace status became RW,AREOR. I ran a reorg and ran a command STAFO to remove AREOR but it doesn't go away.
How can I remove AREOR status?
The REORG utility must use either SHRLEVEL REFERENCE or SHRLEVEL CHANGE.
I ran a reorg with SHRLEVEL REFERENCE and AREOR status is gone and the TS got converted to a PBG.
4569 Technology DriveSte 1 Wilmington, NC 28405Phone: (910) 660-8649Fax: (910) 523-5504