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

Conference azur::mcc

Title:DECmcc user notes file. Does not replace IPMT.
Notice:Use IPMT for problems. Newsletter location in note 6187
Moderator:TAEC::BEROUD
Created:Mon Aug 21 1989
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:6497
Total number of notes:27359

3901.0. "RDB and Export driving me crazy.." by PLUNDR::LOWEG (Don't believe a word) Wed Oct 14 1992 13:44

    
    I am no expert at RDB (or even MCC for that matter) but I am trying to
    assist a customer to do something which is documented..
    
    The problem is to do with EXPORT and its RDB database..
    
    I followed the text in the performance analyzer FM Use manual PAGE 7-4
    and 7-5 but was still none the wiser..
    
    I went into DATATRIEVE and typed
    
    dtr> define database mcc_export on
               $1$DIA1:[MCC.MCC_REPORTS_FILES.RDB]routers.rdb
    
    to which I recieved a dfn> prompt (which puzzled me why the prompt
    changed), I then typed..
    
    dfn> show mcc_export
    
    This objected to the SHOW command and I then recieved the dtr> prompt.
    I then recalled the command..
    
    dtr> show mcc_export
    
    And got the error message Element "MCC_EXPORT" not found in dictionary.
    
    So I have 2 questions at the moment ..
    
    1. What is the dfn> prompt for ??
    
    2. What am I missing or doing wrong ?? 
    
    This seems to be the reason why the customer when running an export
    command as below he recieves the error message "REPOSITRIES DO NOT
    EXIST"... 
    MCC> export node4 .rh.rh2dms export target=mcc_export:routers.rdb, begin
         time "whatever", end time "whatever", in domain=mcc.alderley_park
    
    I suppose in a nutshell I could ask how do we create an .RDB file or
    should the "define database mcc_export" do this for us ??
    
    Help greatly appreciated before I decide to pack it all in and open a
    Fruit & Veg store.. 
    
    Gary Lowe NUK CSC comms.. 
    
T.RTitleUserPersonal
Name
DateLines
3901.1start with simple exampleTOOK::SHMUYLOVICHThu Oct 15 1992 10:3845
	Gary,

	It works in opposite order:
	 - Firstly you have to export data to the RDB using Exporter;
	 - Secondly you can access exported data.

	Your problem is that the export command returns an exception telling
    that it can not export data. I think that even RDB file are not created
    ( you can check this by "dir mcc_export:routers.rdb").

	The simplest case when you can receive this exception is when MCC
    process does not have required privileges (you can find them in the
    release notes for Exporter).

	If this is not your case I would recommend to simplify an export
    command, for example in the command:

>    MCC> export node4 .rh.rh2dms export target=mcc_export:routers.rdb, begin
>         time "whatever", end time "whatever", in domain=mcc.alderley_park

	in the "export target" argument your customer uses a logical mcc_export.

     Does this logical points to correct directory specification?
     Is this logical defined as a system wide logical?
     In the Historical Services Use manual you can find a description how
     we recommend to use logicals in the export command.
 
     Does your customer have experience with Exporter? I think not because
     he/she uses "in domain" qualifier in the export command. May be there is
     a reason at least in the beginning to avoid logicals in "export target"
     argument. 
  
     You can ask him/her to specify some thing simple like:

     export node .rh.rh2dms export target=routers.rdb, export period = 00:05:00

     This command should create an RDB files in the current directory.
     If every thing is OK try to use logicals. If not it will be easier for us
     to understand your customer problem.

      Good luck,
	
		Sam 
    
3901.2Thankyou !!PLUNDR::LOWEGDon't believe a wordFri Oct 16 1992 11:276
    
    Thankyou for your reply I am trying it..
    
    I will let you know how I get on..
    
    Gary Lowe.. NUK CSC comms
3901.3Still a problem..PLUNDR::LOWEGDon't believe a wordMon Oct 19 1992 13:4131
    
    Tried your recomendations but still failed to get it to work..
    
    all privileges set then went into datatrieve..
    
    dtr> show mcc_export
    Unable to show _CDD$TOP.DECMCC.MCC_EXPORT relational database,
    %RDB-E-BAD_DB_FORMAT, UD1:[MCC.EXPORTED_DATA]ROUTERS.RDB does not
    reference a database known to rdb
    -RMS-E-FNF, file not found
    
    dtr> exit
    
    $ man/ent
    DECmcc (V1.2.0)
    
    MCC> export node4 .rh.rh2dms export target=router.rdb, export period
    00:05:00
    
    Node4 LOCAL_NS:.rh.rh2dms
    
    AT 19-OCT-1992 14:07:22
    
    Repositories do not exist
    
    MCC> exit
    
    
    Any other thoughts or have we missed something out ??
    
    Gary Lowe NUK CSC comms..
3901.4AAAAAAAAAAAAAAAAggggggggggggghhhhhhhhhhPLUNDR::LOWEGDon't believe a wordTue Oct 20 1992 12:049
    
    
    Am I right in believing that the .RDB file is the repositery that
    doesn't exist. If so then this should be able to be easily fixed if
    someone can tell me how to create a .RDB file..
    
    Here's hoping....
    
    Gary Lowe NUK CSC..
3901.5Thanks Sam you put me on the right tracks..PLUNDR::LOWEGDon't believe a wordTue Oct 20 1992 14:2815
    
    
    I have sussed it out.. It was a problem with protection on the batch
    que running the exporter background task. I changed from the
    recommended values to s:rwed o:rwed g:rwed w:rwed and it worked.
    
    I think it is significant to get the /owner qualifier correct but I
    decided to open it up to everybody and work it out later.
    However imagine my distress when I told the customer I had cracked it
    and then he told me that he was exporting historical data which
    apparently doesn't use a background process..
    
    Something I don't know so I am going back to the drawing board..
    
    Gary Lowe.. NUK CSC..