Storage Optimization and Operational Scalability

    By: Mr. Vinod Chandran on Jan 01, 2014

    This article discusses the storage optimization and operational scalability features that SAP Sybase ASE has introduced in version 15.7 SP100.

    In today’s knowledge-based economy, business critical information must be continuously available, from internal IT systems that manage company-wide sensitive data such as HR and financials, to applications that manage crucial partner and customer relationships. When disaster, error, or corruption strikes, data must be quickly and accurately recovered and restored. One of the responsibilities of a DBA is to ensure that the database is backed up and the latest database backup is available in case there is a need to recover from a crash. Until recently, the backup sequence in SAP Sybase ASE typically consisted of a database dump as well as one or more transaction log dumps, with the database dump and all transaction log dumps loaded at the same time. Although this is a safe and proven method to backup and restore critical data, it could present an operational challenge to ensure business critical information is continuously available particularly when trying to make certain that data and transaction log dumps are loaded in proper sequence.

    SAP Sybase ASE 15.7 SP100 introduces the following enhancements to the backup procedure, making it easier to backup and restore databases:

    • Enhancements to the dump and load commands to include ‘dump configuration’ and ‘dump history’.
    • Changes to the ‘dump header’ that will help to regenerate any sequence of ‘disk init’, ‘create database’, and ‘alter database’ commands that can be redirected to a file and used to create a target database with the same layout as the source database.
    • Cumulative/incremental backup to backup only those database changes since the last full database dump.

    Cumulative Backup/Incremental Backup
    Traditionally in the database world, the backup and recovery process has posed challenges with regards to either the backup size or the recovery time depending on the size of the database and the need to meet business SLAs.


    Login to read the article. Not a member? Create a free account!




    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk