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

Conference orarep::nomahs::dbms

Title:VAX DBMS
Notice:THIS NOTESFILE IS NOT A FORMAL SUPPORT CHANNEL
Moderator:SCARY::CHARLAND
Created:Thu Feb 20 1986
Last Modified:Tue Jun 03 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2642
Total number of notes:11044

2604.0. "new(?) DBO/MODIFY/JOURNAL behavior" by M5::JAKUHN ([email protected]) Mon Mar 03 1997 17:42

    DBMS 6.1.1
    
    I have a customer who wanted to do a DBO/MODIFY/JOURNAL=ENABLE and
    got the "Journal will be overwritten ect." message. In the past he
    has been able to do this and if the journal file was out there, it
    would not overwrite it.
    To get around this, he did a DBO/MODIFY/AFTER=the_aij_file.aij.
    
    Is the old behavior he is seeing pre-v6 behavior? Or if you create
    the journal with a /AFTER= qualifer instead of /AIJ_OPTIONS does 
    DBMS behave differently? 
    
    Thank you
    Jay Kuhn
T.RTitleUserPersonal
Name		DateLines
2604.1NOVA::R_ANDERSONOracle Corporation (603) 881-1935Tue Mar 04 1997 07:5515
>    I have a customer who wanted to do a DBO/MODIFY/JOURNAL=ENABLE and
>    got the "Journal will be overwritten ect." message. In the past he
>    has been able to do this and if the journal file was out there, it
>    would not overwrite it.

This is the correct behaviour (using the new v6.0) syntax.  This syntax has
never allowed a journal to be overwritten.

>    To get around this, he did a DBO/MODIFY/AFTER=the_aij_file.aij.

This is the obsolete (pre-v6.0) syntax which adds a new journal and enables AIJ
journalling.  This syntax does not work if the customer is using circular
journals.

Rick
2604.2M5::JAKUHN[email protected]Tue Mar 04 1997 16:275
    Ok. The cust was telling me that the  DBO/MODIFY/JOURNAL=ENABLE 
    gave him a message "journal may be overwritten" and aborted. 
    This was after a reload was done.
2604.3NOVA::R_ANDERSONOracle Corporation (603) 881-1935Wed Mar 05 1997 06:467
>    Ok. The cust was telling me that the  DBO/MODIFY/JOURNAL=ENABLE 
>    gave him a message "journal may be overwritten" and aborted. 
>    This was after a reload was done. 

That is correct.  What's the problem?

Rick
2604.4i misunderstood...M5::JAKUHN[email protected]Wed Mar 05 1997 13:026
    I misunderstood the difference between DBO/MODIFY/JOURNAL=ENABLE and
    DBO/MODIFY/AFTER=.  And the customer thought that DBO/MODIFY/JOURNAL
    and DBO/MODIFY/AFTER (with no options) should behave the same. 
      
    thanks very much.
    jay