[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

5101.0. "duplicate storage area name" by ORAREP::KYOSS1::WALKER (Clarke Walker, NJ DC, DTN:323-4040) Tue Mar 04 1997 13:58

    We have a situation where the same storage area name was used twice. 
    Something I didn't think was allowed.  I would like to drop one or both
    of these storage areas.  However when I enter:
    
    Alter Database filename CRIS$DB drop storage area PAGE_IMAGE_AREA54A;
    
    I get:
    
    %RDB-E-BAD_DPB_CONTENT, invalid database parameters in the database
    parameter block (DPB)
    -RDMS-E-NOSTAREAEXT, storage area  not defined in the database
    
    A SQL> Show storage area lists this storage area name twice.  And a SQL>
    Show storage area PAGE_IMAGE_AREA54A shows the information for the first
    occurance of this area.
    
    Oracle Rdb V6.1-1 on OpenVMS V6.2
T.RTitleUserPersonal
Name		DateLines
5101.1M5::LWILCOXChocolate in January!!Wed Mar 05 1997 08:251
Could note 3183 apply or 4141?
5101.2NOVA::FISHERWed Mar 05 1997 09:4812
    The important problem here is how'd you do that?  If you can
    figure out what was done to get the area defined more than once
    then please bug it, especially if we can determine that it hasn't
    been fixed.  We think we've seen this before and fixed the bug that
    allowed the multiple definition.
    
    That said, it appears we never did anything that allows fixing the
    db once it gets bollixed.  Not only can you not drop the offending
    area, you can't drop any area.  This problem has been corrected in a
    future update.
    
    ed
5101.3Simple Alter ... add storageORAREP::KYOSS1::WALKERClarke Walker, NJ NISI, DTN:323-4040Wed Mar 05 1997 10:2322
    I looked at 3183 and 4141, and the result seems to be same but maybe
    not the cause.  In this database we do not have "multithread areas" at
    least I do not see any line to this effect in the dump of the header. 
    The database was created 3 1/2 years ago.
    
    The problem was created by executing:
    
    	Alter Database filename CRIS$DB 
    		Add storage area PAGE_IMAGE_AREA54A
    		filename 'CRIS_IMGA:[CRIS.PAGEDB]PAGE_IMAGE_AREA54A.RDA'
    		page format is MIXED
    		page size is 32 blocks
    		allocation is 99986 pages	
     ... and so on ...
    	;
    
    from two processes.  (The boss decided to help out!)  Because of
    the size of the database area it takes awhile for them to be created. 
    So the second job was actually started 10 minutes later.
    
    This database has about 10 gbytes of read/write data and 80 Gbytes of
    data on optical storage.
5101.4note 4398 and Rdb70 qar 189612293::ALLEMEERSCHIn Flanders fields ...Thu Mar 06 1997 11:353
    See also note 4398 in this conference and Rdb70 qar 1896.
    
    _Luc