1 / 48

INT413 ECDA 12.6 Optimization

INT413 ECDA 12.6 Optimization. Jerry Kauffman Software Development Manager jerry.kauffman@sybase.com 7/19/2004. The Enterprise. Unwired. Manage Information. Unwire Information. Unwire People. Information Management Core. Capture. Publish. Enrich. Deliver.

lefty
Download Presentation

INT413 ECDA 12.6 Optimization

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. INT413 ECDA 12.6 Optimization Jerry Kauffman Software Development Manager jerry.kauffman@sybase.com 7/19/2004

  2. The Enterprise. Unwired. Manage Information Unwire Information Unwire People Information Management Core Capture Publish Enrich Deliver

  3. The Enterprise. Unwired. Industry and Cross Platform Solutions Manage Information Unwire Information Unwire People • Adaptive Server Enterprise • Sybase IQ • Dynamic Archive • Dynamic ODS • Real Time Data Services • Replication Server • OpenSwitch • Mirror Activator • PowerDesigner • Connectivity Options • Enterprise Application Server • PowerBuilder Family • Unwired Accelerator • Unwired Orchestrator • Unwired Toolkit • SQL Anywhere Studio • Mobile Email & Applications • Enterprise Portal • XcelleNet Frontline Solutions • PocketBuilder • AvantGo Sybase Workspace

  4. DirectConnect 12.6 (Where it fits) Any mainframe data Mainframe Connect ASE/CIS Oracle MS SQL Server Sybase DB2 UDB for OS/390, NT/UNIX AS/400 Informix ODBC-enabled databases Documents/Files Any Client Or Browser DirectConnect Specialty Data Store Toolkit Custom Specialty Data Stores Proxy Tables Make all your enterprise data look like one database

  5. DirectConnect 12.6 • First major release in 3 years. • Major redesign of several products.

  6. All DirectConnect 12.6 Products Updated • Enterprise Connect Data Access IPS • DirectConnect for Microsoft SQL Server • DirectConnect for DB2 UDB • DirectConnect for Informix • DirectConnect for ODBC • DirectConnect for Oracle • MainframeConnect IPS • DirectConnect for OS/390 • DirectConnect for AS400 • Migration to DB2 UDB

  7. 12.6 Themes • Performance, Scalability • Peaceful Coexistence • New Features • DCManager Update

  8. 12.6 Themes • Performance, Scalability • Peaceful Coexistence • New Features • DCManager Update

  9. Performance, Scalability • New Product Architecture • DirectConnect for Microsoft SQL Server • DirectConnect for DB2 UDB • DirectConnect for Informix • DirectConnect for ODBC • SMP Open Server Conversion • All DirectConnects

  10. New Product Architecture - Background • Predecessor Product Architecture • Multiple processes • New process for each connection • Interprocess communications • Excess data conversions • 12.6 Product Architecture • Single Process • New thread for each connect • Data sharing between main thread and connection threads • Simplified data conversions

  11. 12.5 Product Architecture Main Process O P E N S E R V E R S E R V E R M G R ASE/CIS Rep. Server Open Server Based Event Handler, Service Manager

  12. 12.5 Product Architecture Main Process with Service Library Loaded O P E N S E R V E R S E R V E R M G R C O N N H A N D L R D B T O O L S D T Y P E C O N V T D S L I B R A R Y ASE/CIS Rep. Server Service Library (dcany.so) Open Server Based Event Handler, Service Manager

  13. 12.5 Product Architecture Dc2any process (one per connection) Main process O P E N S E R V E R S E R V E R M G R C O N N H A N D L R D B T O O L S D A T A C O N V T D S L I B R A R Y T D S S E R V E R D A T A C O N V S Y B O D B C O D B C M G R ODBC DRIVERS MSSS INFX DB2 UDB ASE/CIS Rep. Srvr Target DB pipe Open Server Based Event Handler, Service Manager (direct) Service Library, DB Operations, Data Conversions (dcany.so) ODBC Drivers (MVMSSS19.so) (MVINFX19.so) (MVDB219.so) TDS Event Hdler, Data conversions, DB operations (dc2any)

  14. New Product Architecture • Predecessor Product Architecture • Multiple processes • New process for each connection • Interprocess communications • Excess data conversions • 12.6 Product Architecture • Single Process • New thread for each connection • Data sharing between main thread and connection threads • Simplified data conversions

  15. 12.6 Product Architecture Main process O P E N S E R V E R S E R V E R M G R ASE/CIS Rep. Server Open Server Based Event Handler, Service Manager (direct)

  16. 12.6 Product Architecture Main process O P E N S E R V E R S E R V E R M G R C O N N H A N D L R D A T A C O N V S Y B O D B C O D B C M G R ASE/CIS Rep. Server Open Server Based Event Handler, Service Manager (direct) Service Library, DB Operations, Data Conversions (dcany.so)

  17. 12.6 Product Architecture Main process O P E N S E R V E R S E R V E R M G R C O N N H A N D L R D A T A C O N V S Y B O D B C O D B C M G R ODBC DRIVERS MSSS INFX DB2 UDB (one thread per connection) ASE/CIS Rep. Server Target Database Open Server Based Event Handler, Service Manager (direct) Service Library, DB Operations, Data Conversions (dcany.so) ODBC Drivers (MVMSSS19.so) (MVINFX19.so) (MVDB219.so)

  18. 12.5 Software Layers Removed Dc2any process (one per connection) Main process D B T O O L S D A T A C O N V T D S L I B R A R Y T D S S E R V E R pipe

  19. 12.5 vs. 12.6 Executable Size Disk Space (KB)

  20. 12.5 vs. 12.6 Memory – 1 Connection Memory Utilized (MB)

  21. 12.5 vs. 12.6 Memory – 10 Connections Memory Utilized (MB)

  22. 12.5 vs. 12.6 Memory – 10 Connections

  23. Performance, Scalability • New Product Architecture • DirectConnect for Microsoft SQL Server • DirectConnect for DB2 UDB • DirectConnect for Informix • DirectConnect for ODBC • SMP Open Server Conversion • All DirectConnects

  24. SMP Open Server Conversion • SMP Open Server Conversion • DirectConnect for Microsoft SQL Server • DirectConnect for DB2 UDB • DirectConnect for Informix • DirectConnect for ODBC • DirectConnect for Oracle ( available since 12.5) • DirectConnect for OS/390 • db2 access service • trstcp access service • trslu62 access service

  25. SMP Open Server Conversion of DirectConnect • All DirectConnects are based on Sybase's Open Server SDK. The SDK can be used to build TDS based, database event handling servers. • Open Server can be configured to manage event threads in many ways. • Open Server release 12.5 introduced the SMPOS option, which provides reentrant libraries for preemptive event handling with native threads.

  26. SMP Open Server Conversion (cont) • DirectConnect 12.5 operated in non-preemptive mode using Open Server threads. DirectConnect controlled context switches, usually after all work for the thread was completed. Results in: • Fewer context switches • Poor CPU utilization • Lower throughput

  27. SMP Open Server Conversion • DirectConnect 12.6 uses Open Server preemptive scheduling which utilizes native operating system threads. The operating system controls context switching. Results in: • Frequent context switches for improved time slicing • Efficient CPU utilization (including SMP) • Higher throughput • Scales to handle more users • Synchronized access to shared resources, ensure reentrancy and thread safety

  28. 12.5 vs. 12.6 Performance Comparison • ~25% performance increase

  29. 12.6 Themes • Performance, Scalability • Peaceful Coexistence • New Features • DCManager Update

  30. Peaceful Coexistence • Definition: Internal initiative to improve ability of Sybase products to peacefully coexist when installed together. Minimize/eliminate interference between Sybase applications running on the same machine and within the same directory structure. • Achieved by product and installation changes • Verified by departmental peaceful coexistence testing and independent Sybase quality assurance teams

  31. Peaceful Coexistence Changes (cont) • Isolation of common libraries • InstallShield • Minimize dependency on system environment • New start and add server scripts

  32. DirectConnect 12.6 Themes • Performance, Scalability • Peaceful Coexistence • New Features • DCManager Update

  33. New Features • Windows Service Execution (All) • Date and Time datatype support (Oracle) • LINUX • DC/Oracle • DCManager • Express Transfer • Microsoft SQL Server, DB2 UDB, Informix, and ODBC • UNIX and Windows Platforms

  34. DirectConnect for AS400 Migration • DirectConnect for DB2 UDB • Has been available for access to AS400 since 12.5.3 • ECDA IPS 12.6 (and beyond) will no longer include the AS400 option • TCP/IP Access Only • SNA is not supported • Migrate AS400.cfg files to dcany.cfg file • Reconfigure connectivity and character set translation • Migrate Sybase AS400 SQL stored procedures to native AS400 SQL stored procedures • Native stored procedures utilize extensive IBM SQL programming language

  35. DirectConnect for AS400 Migration (cont) • Benefits of using DirectConnect for DB2 UDB • Express Transfer to/from AS400 targets • More powerful SQL stored procedures • TCP/IP access • Login name and password encryption • Keeping pace of DB2 UDB AS400 updates and new features • Uses new architecture and the SMPOS

  36. DirectConnect 12.6 Themes • Performance, Scalability • Peaceful Coexistence • New Features • DCManager Update

  37. DCManager Update • Enhanced Usability • Support for DirectConnect for Oracle • Multiple Platform support • Enhanced Compatibility with other Sybase Central Plug-ins

  38. Enhanced Usability – More Informative

  39. Enhanced Usability – Verbose Mode

  40. Enhanced Usability – Bottom Panel

  41. Enhanced Usability – Limited Field Help

  42. Enhanced Usability – Other • 508 Compliant • Sybase Central v4.3 Support • Up to date JConnect Support

  43. DCM - Direct Connect for Oracle Support • All the administrative features DirectConnect for Oracle provides are now supported by DCManager.

  44. DCM - Multiple Platform support • Windows NT, 2000, 2003 • Linux • Solaris • HP-UX • AIX

  45. DCM - Enhanced Compatibility • DCManager has been designed to work on the latest version of Sybase Central (Version 4.3) along with the other major Sybase products (ASE and Rep-Server) to enhance compatibility across multiple product plug-ins.

  46. DC 12.6 Availability • Beta Q4 2004 Beta Period - November 23, 2004 through January 18, 2005 For more Info Visit http://www.sybase.com/ecda_mfc126beta • GA Q1 2005

  47. DC 12.6 What’s Next • Port the remaining DirectConnects to Linux platform • Add support for the Unicode datatype • Add support for the new data types “Date” and “Time”

  48. INT413 ECDA 12.6 Optimization Questions? Jerry Kauffman Software Development Manager jerry.kauffman@sybase.com 7/19/2004

More Related