Skip to Content

use of backup database read only dbspace

Hello,

Using IQ 16.0 SP02 with VLDB option, I'm trying to figure out which is the purpose of using:

BACKUP DATABASE READONLY DBSPACES <xx>

and in which case it may apply to do such thing ..? (simplex , MPX, backing up a parte of the db )

Usually we  use Backup full and the Incremental and manual just says"these BACKUP commands specify read-only files and dbspaces"

Thank you

Regards

Jose

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 01, 2016 at 07:32 AM

    Hi,

    I think it could be applicable usefully in a very large database.

    As the database size gets larger, it will be getting longer to complete a database backup.

    If you have a readonly dbspace and have a backup only for it using the backup command, then you can make it shorten the time to take a database backup.

    It's because you can back up the readwrite dbspace only in every full backup until you have a new readonly dbspace or you have to change something on the readonly dbspace thereafter.

    Best regards,

    Jerry

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 01, 2016 at 10:28 AM

    Hi Jose,

    the feature supports the IQ internal data life cycle mgmt in order to keep very large databases maintainable. You can direct data at the end of their life cycle (where they remain unchanged) into read only DBSpaces. There, they can be backed up once and for all (as long as they remain read-only). We assume that with a continuously growing data history, the live part of data will grow rather moderately or even remain at constant size, regardless of the total database size.

    If you utilize this feature, your restore process becomes somewhat more sophisticated, but the resource requirements and processing time for a full backup will be independent of the size of read only data. For incremental or ISF backups, there won't be any difference, of course.

    HTH

    Volker

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 01, 2016 at 03:53 PM

    Volker,Jong

    Thank you

    Very much

    Regards

    Jose

    Add comment
    10|10000 characters needed characters exceeded