Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

ALTER of an IDMS AREA with NEW/OLD page size

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
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    Post subject: ALTER of an IDMS AREA with NEW/OLD page size
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

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Mon Mar 14, 2016 10:30 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm
No new posts Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm
No new posts ADS 3270 Batch simulator for IDMS rel... gpowell382 IDMS/ADSO 1 Thu May 05, 2016 8:02 pm
No new posts Subschema of area to be unloaded Awanti IDMS/ADSO 0 Wed Mar 16, 2016 3:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us