IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ALTER of an IDMS AREA with NEW/OLD page size


IBM Mainframe Forums -> IDMS/ADSO
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Awanti

New User


Joined: 11 Mar 2016
Posts: 4
Location: India

PostPosted: Mon Mar 14, 2016 10:01 pm
Reply with quote

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.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Mon Mar 14, 2016 10:30 pm
Reply with quote

Welcome!!
I think , you may do it in this way,
Code:
ALTER AREA xxxxxx
     PAGE SIZE <new page size>
     ORIGINAL PAGE SIZE <old page size>
     WITHIN FILE zzzzzzz
     FROM   <START-BLOCK> FOR ALL;
Back to top
View user's profile Send private message
Awanti

New User


Joined: 11 Mar 2016
Posts: 4
Location: India

PostPosted: Tue Mar 15, 2016 5:40 pm
Reply with quote

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 ...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IDMS/ADSO

 


Similar Topics
Topic Forum Replies
No new posts DROP & ALTER PARTITION-PBR DB2 0
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Abend S0C4 11 (Page Translation Excep... PL/I & Assembler 16
No new posts Masking variable size field - min 10 ... DFSORT/ICETOOL 4
Search our Forums:

Back to Top