IDMS: AREA's extended attribute not in syntax

book

Article ID: 196540

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database

Issue/Introduction

If a database area has been extended, this fact is displayed as commented out even if the display request was AS SYNTAX.

Environment

Release : 19.0
Component : CA IDMS

Resolution

Note the following DISPLAY of an area that has been extended, and that it is AS SYNTAX.

DIS AREA EMPDEMO.EMP-DEMO-REGION AS SYN;
*+ Status = 0        SQLSTATE = 00000
     CREATE
     PHYSICAL AREA EMPDEMO.EMP-DEMO-REGION
...
*+       FOR NONSQL
*+       PAGE GROUP 0
         PRIMARY SPACE 70 PAGES  FROM PAGE 75001
*+       *** PRIMARY SPACE HAS BEEN EXTENDED ***
*+       ORIGINAL PRIMARY SPACE 50 PAGES
         MAXIMUM SPACE 100 PAGES
         PAGE SIZE 4276 CHARACTERS
         WITHIN FILE EMPDEMO
             FROM 1 FOR 50 BLOCKS
*+           MAP TO PAGES 75001 THRU 75050
         WITHIN FILE EMPDEMOX
             FROM 1 FOR 20 BLOCKS
*+           MAP TO PAGES 75051 THRU 75070
         ;

The ORIGINAL PRIMARY SPACE clause is commented.

This means that you cannot use this syntax to re-create the AREA definition if the area it defines is still extended. If you do, the calc page range will be treated as being 75001 to 75070, and calc requests will unexpectedly fail with an 0326 error-status.

To re-create such an area, you must use the syntax which originally defined it that way. Example:

     CREATE
     FILE EMPDEMO.EMPDEMO
         ASSIGN TO EMPDEMO
         DSNAME 'IDMS.CV01.EMPDEMO.EMPDEMO'
         DISP SHR  
         NONVSAM
         ;
     CREATE
     PHYSICAL AREA EMPDEMO.EMP-DEMO-REGION
         PRIMARY SPACE 50 PAGES  FROM PAGE 75001
         MAXIMUM SPACE 100 PAGES
         PAGE SIZE 4276 CHARACTERS
         WITHIN FILE EMPDEMO
             FROM 1 FOR ALL BLOCKS
         ;  
CREATE FILE EMPDEMO.EMPDEMOX
ASSIGN TO EMPDEMOX
DSNAME 'IDMS.CV01.EMPDEMO.EMPDEMOX';
ALTER AREA EMPDEMO.EMP-DEMO-REGION
EXTEND SPACE 20 PAGES
WITHIN FILE EMPDEMOX;

PHYSICAL AREA definitions have always worked this way and this is not considered a bug.

To extend an area is a short-term solution and the extension should be removed at the earliest opportunity by running unload/reload or reorg against the area.

Additional Information

AREA Statements