Scribd Logo
Upload

Welcome to Scribd!

  • 288 views

    Sybase ASE 16 On Linux-System and Database Administration

    Uploaded by

    mehukr
    This 6-day training course covers system and database administration for Sybase ASE 16.x. Over the 6 days, participants will learn how to install, configure, maintain, backup, monitor, tune and replicate Sybase ASE databases. The course consists of lectures, demonstrations and hands-on labs covering topics such as installing ASE, configuring memory and devices, managing users and permissions, backups, recovery, replication and performance tuning.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Sybase ASE 16 On Linux-System and Database Administration

    Uploaded by

    mehukr
    288 views4 pages
    This 6-day training course covers system and database administration for Sybase ASE 16.x. Over the 6 days, participants will learn how to install, configure, maintain, backup, monitor, tune and replicate Sybase ASE databases. The course consists of lectures, demonstrations and hands-on labs covering topics such as installing ASE, configuring memory and devices, managing users and permissions, backups, recovery, replication and performance tuning.

    Original Description:

    content

    Original Title

    Sybase ASE 16 on Linux-System and Database Administration

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This 6-day training course covers system and database administration for Sybase ASE 16.x. Over the 6 days, participants will learn how to install, configure, maintain, backup, monitor, tune and replicate Sybase ASE databases. The course consists of lectures, demonstrations and hands-on labs covering topics such as installing ASE, configuring memory and devices, managing users and permissions, backups, recovery, replication and performance tuning.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    288 views4 pages

    Sybase ASE 16 On Linux-System and Database Administration

    Uploaded by

    mehukr
    This 6-day training course covers system and database administration for Sybase ASE 16.x. Over the 6 days, participants will learn how to install, configure, maintain, backup, monitor, tune and replicate Sybase ASE databases. The course consists of lectures, demonstrations and hands-on labs covering topics such as installing ASE, configuring memory and devices, managing users and permissions, backups, recovery, replication and performance tuning.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 4

    Sybase ASE 16.

    x : System and Database Administration


    Duration : 6 Days

    Day 1
    1. Introducing Adaptive Server
    Adaptive Server Enterprise 15.x
    Adaptive Server Databases
    System Administrator Responsibilities
    2. Installing Servers
    Loading ASE Software
    Installing Adaptive Server
    ASE Directory Structure
    Starting and Stopping Servers
    3. Establishing Connectivity
    The interfaces file
    The Windows sql.ini file
    Maintaining the interfaces files
    Introduction to LDAP directory services
    Lab : Connecting to Database. Trouble Shooting tips for connectivity. Using
    databases
    4. Configuring Server Behavior
    The Configuration Values
    Viewing Configuration values
    Modifying Configuration values
    Multiple Configuration files
    Lab : Working with Database configuration Parameters

    Day 2
    5. Configuring Memory
    Components of Memory
    Allocation of Memory
    Major uses of Memory
    Estimating Initial Configuration Values
    6. Initializing and Using Devices
    Creating and Dropping Devices
    Default Devices
    Mirroring Devices
    7. Creating and Using Databases
    Sizing and Creating Databases

    Setting Ownership and options


    Expanding Databases
    Lab : Create database, Drop database ,Start database, Stop database
    8. Suggested Disk Resource Strategies
    Resource Allocation for System Databases
    Resource Allocation for User Databases
    Monitoring Space Usage
    Lab : Adding/Modify Devices (data files) in Databases
    9. Auto Expansion
    Overview of Auto Database Expansion
    Installing Auto Expansion
    Managing Auto Expansion using sp_dbextend

    Day 3
    10. Managing tempdb
    Review of System tempdb
    Installing multiple tempdbs
    Binding to a tempdb
    Managing tempdbs - Precedence
    Troubleshooting and Recommendations
    11. Administering System Roles and Logins
    Overview of Access
    System Roles
    Logins
    Proxy Authorization
    12. Managing Database Access and Users
    Database Owners
    Database Users
    Object Creation Permissions
    Lab : Create user, Drop user ,Manage user permissions
    13. Implementing Object Permissions, Groups and Roles
    Object Permissions
    Groups
    Overview of User-defined Roles
    Implementing User-defined Roles

    Day 4
    14. Using Bulk Copy Utility

    Copying Definitions
    Bulk Copy Overview
    Bulk Copy Syntax
    15. Overview of Automatic Recovery
    Overview of Automatic Recovery
    Recording Modifications
    Recovering Modifications after a Shutdown
    Checkpoints
    Recovery Order
    16. Checking and Fixing Database Consistency
    Overview of dbcc Command
    Checking Page Linage
    Checking Page Allocation
    Setting up the dbccdb Database
    Using dbcc checkstorage
    17. Planning for Backups
    Backup Basics
    Backup Server
    Truncating the Transaction Log
    Developing a Backup Plan

    Day 5
    18. Performing a Backup
    Making Backup Servers known to Adaptive Server
    Dumping Databases
    Loading Databases
    Dumping Transaction Logs
    Loading Transaction Logs
    Lab : Adhoc Database backup - FULL, Adhoc Database backup - Users, Taking
    dump of the database, backup logs
    19. Practicing Advanced Backup Techniques
    Thresholds
    Transaction Log Recovery
    Database Recovery
    Rebuilding the master Database
    Lab : Restore backups into database, Restore database - full, Database
    Reload(refresh),
    20. Sybase Control Center
    Sybase Central Defined
    Using Sybase Central

    Administration Tasks
    Job Scheduler
    Interactive SQL

    Day 6
    21. Monitoring the System
    Monitoring Errors
    Monitoring Processes
    Monitoring System Performance
    Lab : Applying Patches, patchset, Database upgrade
    22. Replication
    Replication concept, architecture
    Install/configure replication
    MSA Multi-Site Availability replication
    Replication Server RSSD
    Replication administration
    Monitor replication
    Rebuild replication
    23. Performance Tuning and Optimization
    Optimizing the Server
    Optimizing the Database
    Optimizing the Operating System
    Optimizing Queries
    Server Configuration Parameters

    You might also like