[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

2638.0. "Using DBM$MONITOR to redirect log?" by M5::BLITTIN () Wed May 28 1997 16:47

    
    In the DBMS (V6.0) Database Maintenance and Performance Guide, Section 2.2.2,
    page 2-4, a process is defined that can be used to change the monitor
    log file specification, specifically it describes methods of defining
    a different location by using one of the following,
    
    1) dbo/monitor start/out=device:[dir]
    
    or
    
    2) define/system dbm$monitor device:[dir]
    
    however, if I 
    
    1) dbo/mon stop
    2) define/syst dbm$monitor device:[dir]
    3) dbo/mon start
    
    this doesn't work.  Monitor log file is still in sys$system.
    
    If I use dbo/mon start/out=dbm$monitor, this works.
    
    I tested this on 6.1-11.  Is this just a doc error?
    
    Thank You...
T.RTitleUserPersonal
Name		DateLines
2638.1Some clarification re: .0M5::BLITTINWed May 28 1997 21:286
    
    Let me clarify one point:
    
    The default location is sys$system and when I change this via
    DEFINE/SYST DBM$MONITOR DISK1:[LOGFILE] and restart the monitor
    with DBO/MON START, the log file still goes to SYS$SYSTEM.
2638.2Additional info...M5::BLITTINThu May 29 1997 16:1713
    
    The DBMS Admin Guide, DBO/MONITOR START, defines the /OUTPUT
    qualifier default as SYS$OUTPUT, under the format section, but
    under the command qualifiers section states that the /OUTPUT
    default is SYS$SPECIFIC:DBMMON.LOG
    
    The RMU Guide states that the default for /OUTPUT is
    SYS$SYSTEM:RDMMON.LOG.  The example in the RDB maint guide for
    changing the location of the monitor log also uses a logical, but
    defines this with the /EXECUTIVE_MODE.  Haven't tried this yet,
    but if it works, then the doc (dbms) should be clarified.
2638.3Doc bug?M5::BLITTINThu May 29 1997 16:567
    
    Appears that the DEFINE/SYST DBM$MONITOR to another location other
    than SYS$SYSTEM does not work by itself.  You can define a logical
    but you must use it when starting the monitor, eg., 
    DBO/MON START/OUT=logical or pathname.
    
    Should I doc bug this?
2638.4HOTRDB::PMEADPaul, pmead@us.oracle.com, 719-577-8032Thu May 29 1997 17:242
    I can't find anything in the code that uses that logical.  Please
    submit a DOC BUG.
2638.5Thank youM5::BLITTINThu May 29 1997 20:032
    
    Thank you....
2638.6ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportTue Jun 03 1997 09:025
    I seem to remember reading that DBM$MONITOR no longer worked. This
    would be in the release notes around the 3.x timescale, or just
    possibly 4.0.
    
    Peter