AREA's extended attribute not in syntax
Article ID: 196540
Updated On:
Products
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: All supported releases.
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 this syntax cannot be used to re-create the AREA definition if the area it defines is still extended. If it is, 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, be sure to 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
Feedback
