Presentation Transcript

1. A Graphical Exploration of 11.70Part 1

   Erika Von Bargen Session: C04 IBM Monday 5/16 2:30pm
2. Session Breakdown A Graphical Exploration of 11.70 A Graphical Exploration of Informix 11.70 using OpenAdmin Tool Part 1 (now): Replication & Security Informix Flexible Grid Connection Manager and Quality of Data Mapped Users Trusted Context Part 2 (at 3:50): Hands-Free Administration & Performance Storage Provisioning Defragmenter Storage Optimization Policies Interval Fragmentation Strategy Fragment Level Statistics & AUS Forest of Trees Star Join & Multi-index scan 5/16/2011 2
3. Agenda A Graphical Exploration of 11.70 Intro: Informix 11.70 and OAT What’s new in Replication in 11.70? Informix Flexible Grid Connection Manager for Grid Quality of Data What’s new in Security in 11.70? Mapped Users Trusted Context 5/16/2011 3
4. Intro Themes Business IntelligenceBIWeb 2.0Embedded integratedsecureInformixSOAFlexible Gridhighly scalableOLTPApplication Development Blazing Performance fastOATUINear ZeroAdministration Informix Flexible Grid Enhanced Data Warehouse capabilities Simplified Ease of Use and Administration Empowering Application Development Enhanced Security Improved Performance and Reliability – Faster than Ever A Graphical Exploration of 11.70 Informix 11.70 Delivers grid and enhanced embed capabilities for industry-leading flexibility, reliability, speed and efficiency 5/16/2011 4
5. Intro Why use OAT? Free Remote administration Easy-to-use, graphical interface Support for all of the newest Informix 11.70 features Lowers the learning curve for new and existing Informix features Customizable with plug-ins What is OAT? Open source, web-based administration tool for Informix Monitor and administer one or more Informix server instances Automated installers available for Windows, Linux, and Mac OS Independent of Informix installation Interface available in multiple languages A Graphical Exploration of 11.70 OpenAdmin Tool for Informix 5/16/2011 5
6. What’s new in Replication in 11.70? A Graphical Exploration of 11.70 5/16/2011 6
7. Informix Flexible Grid &Connection Manager Enhanced Availability Create a grid with 2 servers or 1000s of servers Centralized, simultaneous administration for all servers in the grid from a single location Mix hardware, operating systems, and versions of Informix in the grid Easily replicate all or part of your database objects or data Eliminate planned downtime using rolling upgrade Enhanced workload management Actively balance workload across the grid with the Connection Manager A Graphical Exploration of 11.70 5/16/2011 7
8. Grid & Connection Manager DEMO: Using OAT to set up a Grid and Connection Manager SLAs A Graphical Exploration of 11.70 5/16/2011 8
9. Grid & Connection Manager DEMO: Using OAT to manage grid commands and rerun failures A Graphical Exploration of 11.70 5/16/2011 9
10. Quality of Data Monitor the quality of data replicated in a grid. Statistics collected for FAILURE & LATENCY Connection Manager used Quality of Data statistics to make better decisions on where to route client connections Connection Manager can be setup to use a combination of WORKLOAD, FAILURE, and LATENCY to determine where to redirect clients in the grid. A Graphical Exploration of 11.70 5/16/2011 10
11. Quality of Data DEMO: Using OAT to setup and manage Quality of Data A Graphical Exploration of 11.70 5/16/2011 11
12. What’s new in Security in 11.70? A Graphical Exploration of 11.70 5/16/2011 12
13. Mapped Users Users no longer required to have a login on the machine that Informix is running on The DBSA can grant database server access to externally authenticated users by mapping them to the appropriate user and group privileges, regardless of whether these users have operating system accounts on the IBM Informix host computer. Benefits: Reduce admin work by removing the dependency on a local host OS account for database server access A Graphical Exploration of 11.70 5/16/2011 13
14. Mapped Users A Graphical Exploration of 11.70 5/16/2011 14
15. Mapped Users DEMO: Setting up Mapped Users in OAT A Graphical Exploration of 11.70 5/16/2011 15
16. Trusted Context Trusted context for n-tier web applications accessing Informix User 1 User 2 User 3 Application Server Benefit: No need to drop the connection and reconnect with each new user in order to maintain security Security is maintained without a hit in performance Informix trusts the Application Server to authenticate the user It then sends a message to Informix when a new user sends a query No need to drop and reconnect with each user Each user maintains their own identity A Graphical Exploration of 11.70 5/16/2011 16
17. Trusted Context DEMO: Setting up Trusted Contexts in OAT A Graphical Exploration of 11.70 5/16/2011 17
18. Resources – Informix 11.70 A Graphical Exploration of 11.70 Download and try out the Informix 11.70 Developer edition today! http://www-01.ibm.com/software/data/informix/developer-edition/ Articles on Informix 11.70 features http://www.ibm.com/developerworks/data/products/informix/index.html Informix 11.70 Info Center http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp IBM Informix http://www-01.ibm.com/software/data/informix/ 5/16/2011 18
19. Resources – OAT A Graphical Exploration of 11.70 Informix Free Product Downloads https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-informixfpd Download OAT Informix Virtual Appliance: includes Informix 11.70 and OAT OpenAdmin Tool Website www.openadmintool.org Includes download link, product information, demos and more Demos of OAT and 11.70 features: www.youtube.com/OpenAdminToolChannel OAT Forum www.iiug.org/forums/oat 5/16/2011 19
20. Questions ?!? A Graphical Exploration of 11.70

21. A Graphical Exploration of 11.70Part 1

    Session: C04 Erika Von Bargen vonbarg@us.ibm.com