ALTER of an IDMS AREA with NEW/OLD page size

Awanti · New User Joined: 11 Mar 2016 Posts: 4 Location: India

Hello All,

I am new to IDMS (its just been 4 months that i am working on idms).
One of my colleague did an ALTER EXPAND PAGE of an area. We did not do UNLOAD-RELOAD of that area yet.
The page size earlier was 5724 and now its 7476.
Because of page size expand and max no of rows allowed per page, there is an increase in amount of unusable space and available space is reduced to 9% from 23% in span of 4 months.

We are now considering to do 1. ALTER the page size back to 5724 and increase page range and 2.UNLOAD-RELOAD of area .

My question is, while doing ALTER of AREA now, do we need to give ORIGINAL PAGE SIZE 7476 (or it should be 5724) and PAGE SIZE 5724 CHAR (as new page size) ? Or no need to mention page size of 7476 at all?

I am confused about the ALTER sytnax to be used.

Rohit Umarjikar · Posted: Mon Mar 14, 2016 10:30 pm

Welcome!!
I think , you may do it in this way,

Awanti · New User Joined: 11 Mar 2016 Posts: 4 Location: India

Hi Rohit,

Thanks for your response.

I still want to know, for my particular case, do i have to code

ALTER AREA <>
PAGE SIZE 5724 ?
ORIGINAL PAGE SIZE 7476 ??

I am confused because i have not done unload-reload when i changed the page size to 7476 ...