1 / 46

MC421 Adaptive Server Anywhere 7.0 New Feature Overview

MC421 Adaptive Server Anywhere 7.0 New Feature Overview. Mike Paola Engineering Product Management iAnywhere Solutions mpaola@sybase.com. Introduction ASA 7.0 New Features and Enhancements Adaptive Server Anywhere Administration Tools UltraLite / MobiLink Behavior Changes Upgrade Issues

minya
Download Presentation

MC421 Adaptive Server Anywhere 7.0 New Feature Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MC421Adaptive Server Anywhere 7.0New Feature Overview • Mike Paola • Engineering Product Management • iAnywhere Solutions • mpaola@sybase.com

  2. Introduction ASA 7.0 New Features and Enhancements Adaptive Server Anywhere Administration Tools UltraLite / MobiLink Behavior Changes Upgrade Issues A Peek at 7.0.1 Summary Agenda

  3. Extending Corporate Information Sybase iAnywhere Solutions • Delivery of enterprise information anywhere • Synchronize information seamlessly • from the enterprise to... • workgroups • desktops • laptops • handheld computing devices • pagers • intelligent appliances • … and back again

  4. Performance out of the box Ease of use Interoperability/Open Cross platform support Being responsive to our customers SQL Anywhere Design Goals

  5. Adaptive Server Anywhere 7.0 Performance improvements Scheduling and event handling OLE DB Provider MS DTC Support Connectivity improvements Miscellaneous enhancements ASA 7.0 Enhancements

  6. New index hash size option Primary / foreign key index split Enhanced dynamic cache sizing Separate storage for long values New database page sizes Optimizer enhancements Performance Improvements

  7. New index hash size option Previous restrictions Determining proper hash size to use sa_index_levels system procedure Other factors Configuring index hash sizes CREATE INDEX … WITH [MAX] HASH SIZE nn MAX_HASH_SIZE database option Performance Improvements

  8. Primary / foreign key index split Pre 7.0 - single physical index for primary key and any foreign keys it referenced Architecture could lead to performance bottlenecks 7.0 - index organization separates these indexes AM31 - ASA Internals Performance and Tuning Provides in-depth architectural indexing overview Performance Improvements

  9. Enhanced dynamic cache sizing Expands on work done in 6.0.3 How it works Cache resizes as required Controlled by engine switches Server evaluates cache and OS statistics Available on Windows NT and Unix only Default limits and sizes Monitoring cache size Performance Improvements

  10. Separate storage for long values Long values now stored on separate database pages Affects long binary, long varchar, text, and image datatypes New database page sizes Added page sizes of 8K, 16K, and 32K Performance improvements but additional memory requirements (evaluate costs/benefits before using) Performance Improvements

  11. Optimizer Enhancements OPTIMIZATION_GOAL option - either: Optimize for time to return first row of query Optimize overall time to return ALL rows Default: first-row (change for apps such as PB) Enhancements to assist with performance of queries that use internal temporary tables and primary/foreign key indexes MC422 - Good Application Development with SA Performance Improvements

  12. Store and automatically execute scheduled actions within a database, for example: Backups Reports Store and execute a series of actions when a specific event occurs, for example: Connection Database Start Low disk space Scheduling and Event Handling

  13. Defining events Sybase Central (wizard) CREATE EVENT statement eg. CREATE EVENT DailyBackup SCHEDULE daily_backup START TIME '1:00AM‘ HANDLER BEGIN BACKUP DATABASE TO '\\\\.\\tape0‘ ATTENDED OFF END Scheduling and Event Handling

  14. Working with events Event parameters Triggering events At scheduled time (once, or every ? <time> period) System-defined event has occurred BackupEnd, Connect, ConnectFailed, DatabaseStart, DBDiskSpace, Disconnect, GrowDB, GrowLog, GrowTemp, LogDiskSpace, RAISERROR, ServerIdle, TempDiskSpace TRIGGER EVENT statement Debugging events Scheduling and Event Handling

  15. Limit transaction log size to 10MB: CREATE EVENT LogLimitTYPE GrowLogWHERE event_condition( 'LogSize' ) > 10HANDLERBEGIN backup database directory 'c:\\logs‘ transaction log only transaction log rename matchEND Event Examples

  16. Notify admin when disk space falls below 10%, do not execute more than once every 5 minutes CREATE EVENT LowDBSpaceTYPE DBDiskSpaceWHERE event_condition( 'DBFreePercent' ) < 10 and event_condition( 'Interval' ) >= 300HANDLERBEGIN call xp_sendmail( recipient='DBAdmin', subject='Low disk space', "message"='Database free disk space ‘ || event_parameter( 'DBFreeSpace' ) );END Event Examples

  17. Run process when server has been idle for ten minutes, do not execute more than once per hour CREATE EVENT SoakTYPE ServerIdleWHERE event_condition( 'IdleTime' ) >= 600 and event_condition( 'Interval' ) >= 3600HANDLERBEGIN message ‘Insert your code here …’END Event Examples

  18. Native OLE DB Provider Pre 7.0 - only access was OLE DB/ODBC bridge Benefits Principal data access method for Windows CE 3.0 Richer functionality ODBC not required in deployment Using OLE DB via ADO MC423 - OLE DB Support in ASA OLE DB Provider

  19. Distributed transactions include operations on more than one server in a single transaction Commit and rollback behavior of distributed transactions controlled by transaction server ASA 7.0 can participate in distributed transactions coordinated by the Microsoft Distributed Transaction Coordinator (DTC) Two-phase commit ASA acts as a resource manager Use with MTS or Sybase EAServer MS DTC Support

  20. Java connectivity - can now take advantage of features previously available only to ODBC and ESQL apps: “Autostarting” database servers Network communication parameters TCP/IP Connectivity Simpler dblocate - command-line utility to display all ASA servers running TCP/IP SPX Connectivity Connectivity Improvements

  21. New Engine Commands START DATABASE, STOP DATABASE, and STOP ENGINE statements available from all applications New interface for external functions Expressions in Transact-SQL outer joins: Miscellaneous Enhancements • SELECT *FROM customer, sales_orderWHERE substr( customer.id, 1, 1 ) *= substr( sales_order.cust_id, 1, 1)

  22. Additional database and server properties PageSize, AppInfo, IsRunTimeServer Referential integrity checks before commit System procedure sa_check_commit SQL function enhancements replace, list New Embedded SQL function - db_string_ping_server Last default timestamp global variable - @@dbts Miscellaneous Enhancements

  23. Troubleshooting enhancements -zr command line switch (request level debugging) sa_server_option system procedure Load/unload table - bcp format support Faster table truncation Suppressing event log messages Used when running server as NT service Miscellaneous Enhancements

  24. Updated Sybase Central Now on any Java-enabled machine ASA and MobiLink providers Includes support for new 7.0 features Native Windows (C++) version still provided For use with other plug-ins New 7.0 features not included C++ version executable is scview.exe Administration Tools

  25. Updated Interactive SQL Now on any Java-enabled machine New features Multiple windows Excel import/export Standard key strokes Enhanced Debugger SQL Stored Procedures/Triggers Java classes Administration Tools

  26. Requirements JRE 1.2 or above (included) ASA Connectivity: JDBC via jConnect JDBC/ODBC bridge Administration Tools

  27. Performance improvements BLOB support Call-level API Flexibility for language of choice New platforms - DOS, WindRiver VxWorks Additional CodeWarrior support Version 6 UltraLite plug-in UltraLite 7.0 Enhancements

  28. Applications written in Java using a subset of JDBC Analyzer generates Java code to implement a custom JDBC driver specific to your application Standard Java VM Watching KVM developments closely MC413 - Engineering Overview of UltraLite MC411 - UltraLite: Moving Java Applications Back to the Client Java UltraLite

  29. HTTP synchronization stream Assist with synchronization through firewalls Riverbed Scout Conduit New Palm HotSync Conduit Proxy to running MobiLink server Improved error handling Secure communications - Certicom Script versioning MobiLink 7.0 Enhancements

  30. MobiLink originally supported UltraLite clients only ASA client added in 7.0 Session based synchronization Only data changes are synchronized ODBC backend connectivity Script based consolidated database programming Heterogeneous support Oracle, DB/2, MS SQL Server, ASE, ASA MobiLink for ASA

  31. Synchronization components Remote ASA transaction log keeps track of changes to data MobiLink for ASA (DBMLSYNC.EXE) Scans log and creates upload stream Receives download stream and executes changes in remote ASA MobiLink Synchronization Server Provides interface between consolidated database and remote server MobiLink for ASA

  32. Upload stream For each table - only records that have changed are uploaded Download stream MobiLink uses synchronization scripts to retrieve changed data from consolidated database Confirmation MobiLink for ASA

  33. MobiLink for ASA 1. Upload MobiLink Client MobiLink 2. Download 3. Ack Download ODBC Remote ASA Database Consolidated (Uniquely identified by a unique user name) DB

  34. MC402 - Overview of MobiLink Synchronization MC403 - Performance of MobiLink Replication Technology MC408 - Advanced MobiLink Techniques MC424 - Choosing the Correct Data Movement Technology AM32 - MobiLink Synchronization (course) MobiLink - Relevant Talks

  35. Decommissioned Operating Systems Any OS no long supported by vendor Includes Windows 3.x, Netware 3.12, AIX 4.2 Communication protocols IPX deprecated (SPX started by default) DDE no longer supported Deprecated parameters (Broadcast, CommAutoStop) No dbclient compatibility executable Behavior Changes

  36. ISQL Changes - Input / Output format changes Server name space change No separate network ports library Shared memory link connection behavior change ANSI_UPDATE_CONSTRAINTS option ODBC changes SQLDescribeCol - returns SQL_INTEGER Autocommit uses CHAINED option Behavior Changes

  37. Standard upgrade precautions Check behavior changes Test Backup Test upgrade procedure Upgrade Issues

  38. Servers work with older databases Features requiring no change No changes to database options, system tables, or database storage eg. dynamic cache sizing Features requiring upgrade Rely on new database options or system table changes eg. scheduling and event handling Features requiring upgrade and unload/reload Rely on changed file format for database eg. variable hash size indexes Upgrade Issues

  39. Upgrading a database Adds new system tables and new database options dbupgrad -c “connection-string” (backup first) Unloading / reloading a database To change physical characteristics of database dbunload -ar -c “connection-string” (backup first) Make sure you run the right version of the utility! Check V7 is ahead of V6 in path Note - V7 Debugger only works with V7 databases Upgrade Issues

  40. Client / server compatibility 6.0 servers and above support connections from V7.0 clients 7.0 servers support connections from V6 or above clients Upgrading V5 applications Communication protocol changed between V5 and V6 Upgrade procedures vary by type of application Upgrade Issues

  41. Upgrading V5 Embedded SQL Applications Upgrade database server and interface library No need to upgrade database or client application Upgrade uses a compatibility library Upgrading V5 ODBC Applications Replace V5 ODBC datasource with V7 datasource V7 datasource will use V7 ODBC driver Alternatively, can use compatibility library (like ESQL) Other considerations (eg. Start-line parameters) Upgrade Issues

  42. ASA Enhancements Support for Windows CE 3.0 User installation creation program Windows CE x86 version of ASA Tools Enhancements Debugger integration into Sybase Central Usability improvements A Peek at 7.0.1

  43. UltraLite Enhancements New direct manipulation conduit for Palm Support for Windows CE 3.0 Persistent index support Added GNU compiler support for Palm Tools enablement (MobileBuilder) CE, DOS, Palm A Peek at 7.0.1

  44. MobiLink Enhancements User authentication Synchronization status information Ability to cancel synchronization in progress Added platforms for security More comprehensive debugging information Dbmlsync only User definable event hooks Scheduling synchronization A Peek at 7.0.1

  45. First total enterprise data synchronization solution Enhancements to the industry-leading mobile database Out-of-the-box performance Enhanced developer productivity Advanced administration features Enabling new platform opportunities Summary - ASA 7.0

  46. MC421Adaptive Server Anywhere 7.0New Feature Overview • Mike Paola • Engineering Product Management • iAnywhere Solutions • mpaola@sybase.com

More Related