1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Various questions

Discussion in 'Database Admin' started by raviraju, Apr 17, 2012.

  1. raviraju

    raviraju New Member

    multivolume database and single volume db

    can you explain what is multivolume database and single volume db?
  2. raviraju

    raviraju New Member

    ai files

    how we can find the sequence no of ai files and how to perform roll-forward recovery by sequence.


    as far as i know that we can roll forward in orders the ai files fills but how we know that?
  3. raviraju

    raviraju New Member

    Another "I can't read documentation" thread

    1.suppose we have test db and production db. than we will take
    4 incremental backup simultaneously in production database and restore it in test db
    is there is any effects of on table i mean change in table .. i mean to say that is there is difference between
    tables ...
  4. raviraju

    raviraju New Member

    ai files

    how we take ai files in seperate disk? here what does sepearate disk mean?
  5. raviraju

    raviraju New Member

    crontab

    how to write script for ai files by crontab?
  6. RealHeavyDude

    RealHeavyDude Well-Known Member

    Re: multivolume database and single volume db

    Since Progress V9 ( which is already ancient, obsolete and unsupported - to say it with Tom's words ) there are only multi-volume databases. Why would you ask?

    But to explain: A multi-volume database is one where the data is split across more than 1 file which are called extents which in turn are grouped into storage areas.

    Heavy Regards, RealHeavyDude.
  7. RealHeavyDude

    RealHeavyDude Well-Known Member

    Re: ai files

    You would know if you would log it - or, if you have the time you can try and error ( trying to roll forward the wrong ai does not do any harm to the database ).

    Heavy Regards, RealHeavyDude.
  8. RealHeavyDude

    RealHeavyDude Well-Known Member

    Re: ai files

    You do know that there can be more than one hard disk in a computer and that something like RAID exists, don't you?

    Heavy Regards, RealHeavyDude.
  9. raviraju

    raviraju New Member

    Re: multivolume database and single volume db

    what is the major diffrence between progress 9 and 10
  10. raviraju

    raviraju New Member

    Eviction

    what is exactly mean eviction. i read - it occurs when buffer is saved to disk .. please explain?with examples.
  11. raviraju

    raviraju New Member

    Re: After image

    look ai files are optional coz we can use it in bi crash situation. And ai file must be put in seperate disk? it contains only commited transction. we can write some script which can run automatically.. in production db.
    l
  12. raviraju

    raviraju New Member

    storage area

    what is type I and type II storage area how they differ?please tom explain me?
  13. RealHeavyDude

    RealHeavyDude Well-Known Member

    Re: After image

    BI and AI is not the same thing, they are for completely different purposes:
    The before image ensures the consistency of the database in that it undoes all transaction that were open at the time a crash occurred.
    The after images fills the gap between two backups.


    Running a database without after image - although it is optional - is a recipe for disaster.

    Heavy Regards, RealHeavyDude.
  14. Cringer

    Cringer ProgressTalk.com Moderator Staff Member

    Re: After image

    Many thanks to RHD for his patience. I no longer have patience. Please read the documentation before posting these questions. And search the forums too. It gets a little waring to have the same questions over and over again from lazy people. Please come back when you have done your research if you have further questions.
Similar Threads
Forum Title Date
Comments Various questions Apr 17, 2012
Database Admin Various questions Mar 1, 2012
PSDN Community Discussion Forum Forum Post: What is new and has changed in various service packs for Corticon 5.3 ? Mar 24, 2014
Progress Blog Stress-free Connectivity for MS Access to Various Data Sources Sep 12, 2013
Development various font color in text content of editor Jul 13, 2012

Share This Page