use of backup database read only dbspace

[jmtorres]

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

[jmtorres]

Volker,Jong

Thank you

Very much

Regards

Jose

[former_member194571]

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

[jong-kil_park]

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