Advanced Administration and Troubleshooting for Adaptive Server Enterprise

Goals

• Create a new ASE server and perform post-installation security tasks
• Describe ASE connectivity and implement balanced network and port utilization with fail-over safety
• Describe Sybase Asset Management and Licensing Architecture
• Describe the mechanics of database and table allocation/deallocation
• Use DBCC commands to detect and resolve table fragmentation, allocation, and linkage problems
• Perform effective backups, and troubleshoot dump, load, and recovery problems
• Rebuild a damaged database with up-to-the-minute data
• Rebuild the master device and database
• Describe the working details of Component Integration Services
• Describe advanced database monitoring tools and options
• Configure ASE for optimum Data Security

Audience

• Database Administrators, System Administrators

Prerequisites

• * System and Database Administration: Adaptive Server Enterprise (EDB356)

Content

• Installation
• LDAP and CIS
• Understanding Sybase Asset Management
• Controlling space allocation and fragmentation
• Advanced dbcc commands
• Troubleshooting database backup and recovery
• Advanced monitoring tools
• Device failures and Recovery Fault Isolation
• Data Security, Encryption and Auditing

Notes

• Learn the extended skills of server administration: what to do when hardware fails, and how to implement special-use features of Adaptive Server Enterprise 15. Practical troubleshooting techniques and disaster prevention will make ASE highly available. Special features allow for greater flexibility in migration and automating administration, server monitoring, integrated data spaces, and resource management.

Popular tags

No tags submitted for this course yet