Portal Corporativo de Input Ouput Soluciones Informáticas, SL

Noticias del sector
developerWorks : DB2 : Technical library : Articles
The latest content from IBM developerWorks

Troubleshooting locking problems in WebSphere Commerce with DB2 This article explains techniques for identifying and solving database locking problems in a WebSphere Commerce environment running DB2. How multithreaded architecture works in DB2 9.5 Learn how the new capabilities in DB2 9.5 affect you if you regularly monitor processes or threads, if you need to understand how much memory your database is using, or if you want to simplify mission-critical tasks such as backup, restore, and roll forward. Optimize the cursor in Informix Dynamic Server with ESQL/C IBM Informix ESQL/C has many features to reduce the network traffic between server and client thereby, increasing the performance of the application. Understand these features and see you how to use them to achieve maximum performance. Running Informix Dynamic Server on Linux in Xen hypervisor Can Informix Dynamic Server (IDS) run on Linux in Xen hypervisor virtual machines (VM)? Is all OS-specific functionality of IDS usable in a Xen VM? This article is a detailed summary of first experiences with running IDS for Linux in a Xen managed virtual machine. In this article, learn more about the benefits of Xen hypervisor and see how it works. Follow step-by-step guidelines to set up an actual test system, including the Xen virtualization layer. Finally, learn about the results of tests that the authors ran on their IDS environments. Manage your Informix database with the IDS OpenAdmin Tool, Part 3: Performance analysis of Informix Dynamic Server made easy through the OpenAdmin Tool Learn how to analyze IBM Informix Dynamic Server (IDS) performance using the IDS OpenAdmin Tool (OAT). OAT is an open source, Web-based interface to IDS and is supported on version 11.10 and later. Parts 1 and 2 of this series introduced the tool and showed you how to migrate from the Informix Server Administrator. Now, see how easily you can monitor performance through statistical data and charts that give you a quick way to comprehend the information. Use Hungarian notation to improve database design and application implementation Hungarian notation is a naming convention that can be used in code and design artifacts. In this article, learn a simple technique of Hungarian notation that you can apply during data modeling and implementation to improve the quality of your applications. Manage your Informix database with the IDS OpenAdmin Tool, Part 2: Migrate from Informix Server Administrator to the IDS OpenAdmin Tool Migrate from the Informix Server Administrator (ISA) to the OpenAdmin Tool. Also, learn about the basic capabilities of ISA that are made available on OAT, along with enhanced functionalities and greater ease-of-use. Migrate from EJB 2 container-managed persistence to pureQuery for IBM Master Data Management Server, Part 2: Proving the pureQuery technology If you've been curious about the new release of WebSphere Customer Center (now named IBM InfoSphere Master Data Management Server), then this series is for you! This series describes how and why pureQuery technology was used in the new release, the implementation and migration to pureQuery, and the results of performance and capability testing to validate this critical decision. Part 2 focuses on our productivity and performance measurements in making the decision to user pureQuery and also provides some hints and tips for working with pureQuery. Manage your Informix database with the IDS OpenAdmin Tool, Part 1: Configuring and using the OpenAdmin Tool with IDS IBM Informix Dynamic Server (IDS) is well known for ease of administration. To make server administration more user friendly, a new open source, platform-independent tool called OpenAdmin Tool (OAT) is now available to IDS users The OpenAdmin Tool provides graphical interface for administrative tasks and performance analysis tools. Introduced with IBM Informix Dynamic Server version 11.10, it is a PHP-based, Web browser administration tool that gives you the ability to administer multiple database server instances from a single location. This article highlights some of the most useful features of OAT and helps you get started. Customize the eClient, Part 4: Customize the Content Manager eClient search results window Examine some of the customization techniques with sample code to better understand of what and how you can customize eClient to meet your business needs. IBM Mashup Center and the InfoSphere MashupHub, Part 2: In-depth look at Feed Mashup Editor within IBM Mashup Center's InfoSphere MashupHub In Part 2 of this series, explore the InfoSphere MashupHub more deeply and extend the use-case scenario to showcase the different components and illustrate the advantages of using Web 2.0 concepts, such as data feeds and feed mashups in an enterprise. IBM Data Studio software: The big picture A relative newcomer to the IBM software portfolio, IBM Data Studio software is a revolutionary approach to managing data and data-centric applications throughout the lifecycle, from requirements to retirement. This overview article explains both the vision and reality of Data Studio and how you -- whether a data architect, developer or tester, DBA, or data steward -- can use Data Studio today to improve productivity, increase quality of service, and encourage greater alignment across IT roles. IBM Migration Toolkit support for migrating data from MySQL to DB2 and Informix Dynamic Server The IBM Migration Toolkit has been enhanced to include new capabilities for migrating from MySQL to DB2 or Informix. In this article, you'll learn how the toolkit can help you migrate DDL and DML statements, and see how to map data types. Migrate from EJB 2 container-managed persistence to pureQuery for IBM Master Data Management Server, Part 1: Evaluating pureQuery technology If you've been curious or confused about the new release of WebSphere Customer Center (now named IBM InfoSphere Master Data Management Server), then this series is for you! This series describes how and why pureQuery technology was used in the new release, the implementation and migration to pureQuery, and the results of performance and capability testing to validate this critical decision. Part 1 focuses on the evaluation of persistence mechanisms and our plan to validate the technology. Replication technologies in Informix Dynamic Server IBM Informix Dynamic Server (IDS) has long been a database with powerful replication technologies. Enterprise Replication (ER) and High-Availability Data Replication (HDR) have been faithfully serving customers for years. Recent versions of IDS, 11.1 and now 11.5, add some new technologies to these stalwarts: the Remote Standalone secondary and the Shared-Disk secondary servers. In this article, get a brief characterization of each replication technology and details on the basics of using each. Shrink your DB2 for Linux, UNIX, and Windows database using value compression Since Version 8.1, IBM DB2 for Linux, UNIX, and Windows has had a compression feature called value compression. This feature is not well-known, but it provides a cost-efficient way to reduce the size of your database with almost no impact on performance. In this article, find background information on value compression, and learn about a script-based method to easily find tables that benefit from value compression. IBM Mashup Center and the InfoSphere MashupHub, Part 1: Get started with InfoSphere MashupHub Learn about the architecture, tools, and utilities of InfoSphere MashupHub, part of the IBM Mashup Center product. Then, explore a simple use case scenario that showcases the different components and illustrates the advantages of using Web 2.0 concepts. This article is the first in a two-part series. IBM Cognos 8 BI tips and techniques: Change the name of a PowerPlay report in Cognos Connection as it appears in Upfront Download a Java sample that gives you a way to rename Cognos PowerPlay Enterprise Server views and reports so that they are the same as they appear in Cognos Upfront. Get step-by-step instructions for implementing this code sample. WebSphere DataPower and DB2 pureXML, Part 2: DB2 pureXML as an audit log for WebSphere DataPower An important aspect of structure and content validation of XML document instances is the ability to track validation failures. Part 1 of this series illustrated structure and content validation of XML document instances through XML schema and Schematron. The validation was performed through the IBM WebSphere DataPower SOA appliance. In this article, see how IBM DB2 pureXML can further complement the WebSphere DataPower SOA appliance by providing an easily accessed and queried audit log. The scenario illustrated in this article is applicable to any situation where XML document instances are being exchanged. Using IBM Lotus Domino and IBM DB2 integration features to enhance the functionality and performance of Lotus Domino applications Learn how to use IBM® DB2® as a data store for IBM Lotus® Domino® data. This article uses a sample application to describe four possible usage scenarios for the Lotus Domino and DB2 integration features in pure Lotus Domino applications. Compare the Informix Dynamic Server Version 11 editions Get an introduction to the various editions of IBM Informix Dynamic Server, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, IDS brings you legendary ease-of-use, reliability, stability, and access to extensibility features. IBM DB2 for i 6.1 -- Sophistication simplified The IBM DB2 for i 6.1 enhancements provide a great foundation for taking your business solutions to new levels. In this article, discover how IBM has delivered the new, sophisticated technology while still maintaining the easy-to-use nature of DB2 for i that has spoiled developers and administrators through the years. Dynamic SQL support in Informix Dynamic Server Stored Procedure Language Review the SPL and the capabilities uniquely available with dynamic SQL, and then explore many examples that help you get started with implementing this feature in your own databases. Also, take a look at security issues and see how to avoid pitfalls. Recovering from a failed LOAD operation in DB2 for Linux, UNIX, and Windows Learn how to recover a table to its normal state after a LOAD operation has failed. This article presents the alternatives, terminating the load or restarting it from last consistency point, and has been updated for DB2 9. Configure aliasing for transactions in WebSphere Customer Center Explore how to use customer terminology in WebSphere Customer Center using the transaction aliasing feature. Concepts of WPARs and configuring DB2 WPAR (Workload Partition) is a licensed program product shipped with IBM AIX 610. Tthis article teaches WPAR concepts and configurations. By following the examples in this article, you will be able to install and configure DB2 on a system and application WPAR. XForms and Ruby on Rails at the doctor's office, Part 4: Implementing the doctor and patient lookup XForms This is the fourth article in a four-part series about using XForms, DB2 pureXML, and Ruby together to more easily create Web applications. In this series you will develop a hypothetical application for managing patient information at a doctor's office. You will get a taste of the individual strengths of each technology, but you will also see how to integrate them together. In Part 4 of the series, you continue to develop XForms for the doctor's office including an all new form to look up patients by last name. XML Performance: A Surprising Ace in the Hole Relational database storage brings RDBMS strengths t o XML data. But older clumsier storage methods left application performance an open quesiton. Two years after IBM introduced pureXML in DB2 9, that question h as been answered. What's new in the Data Server Migration Toolkit 2.0? The IBM Migration Toolkit smooths the path for your migration from other relational database management systems (RDBMS) to IBM data servers. In Version 2.0 of the toolkit, you'll find new migration paths for migrating from Microsoft SQL Server to Informix Dynamic Server, Sybase Adaptive Enterprise Server to DB2 for z/OS, and MySQL to DB2 and Informix Dynamic Server. And that's not all. There are Oracle-to-DB2 migration enhancements, command line interface enhancements, and other enhancements that make your migrations easier. Customize the eClient, Part 3: Customize the Content Manager eClient Edit Attributes window Better understand what and how you can customize eClient for your business needs using sample codes. XForms and Ruby on Rails at the doctor's office, Part 2: Implementing the patient information XForm This is the second article in a four-part series about using XForms, DB2 pureXML, and Ruby together to more easily create Web applications. In this series you will develop a hypothetical application for managing patient information at a doctor's office. You will get a taste of the individual strengths of each technology, but you will also see how to integrate them together. In Part 2 of the series, you will begin implementing the application. XForms and Ruby on Rails at the doctor's office, Part 1: Setting up IBM DB2 9 pureXML This is the first article in a four-part series about using XForms, DB2 pureXML, and Ruby together to more easily create Web applications. In this series you will develop a hypothetical application for managing patient information at a doctor's office. You will get a taste of the individual strengths of each technology, but you will also see how to integrate them together. In this first part of the series, you will examine how XForms, DB2 pureXML, and Ruby on Rails can all help more rapidly build XML-centric Web applications. XForms and Ruby on Rails at the doctor's office, Part 3: Implementing the nurse and doctor XForm This is the third article in a four-part series about using XForms, DB2 pureXML, and Ruby together to more easily create Web applications. In this series you will develop a hypothetical application for managing patient information at a doctor's office. You will get a taste of the individual strengths of each technology, but you will also see how to integrate them together. In Part 3 of the series, you will develop a form for nurses to go back and edit patient data, and you'll also learn what you need to do in Ruby to make this happen. WebSphere DataPower and DB2 pureXML, Part 1: XML schema and content validation using WebSphere DataPower and DB2 pureXML Understand how IBM DB2 pureXML and the IBM WebSphere DataPower SOA Appliance can complement each other to realize powerful applications, and provide flexible and speedy access to validated XML documents. The WebSphere DataPower Appliance performs XML validation, and the DB2 pureXML database manages XML storage, indexing, and querying. Integrate FileNet BPM with IBM Content Manager, Part 4: Create an Auto Insurance Claim Process using FileNet Workplace This is the last in a series of four articles that describe how to integrate FileNet BPM with IBM Content Manager. In this article, learn to create a business process to use the newly created component queue. You'll create a business process definition using the work performer created in Part 3 to meet ABC Company's business requirements. You will also execute the business process to validate your solution. Understanding the WebSphere Federation Server system catalogs The federated system catalog supplies a wealth of metadata about all the objects you work with in a federated system. This article takes you through a scenario that shows you how to create federated objects, find the information you need about those objects in the federated system catalog, and use the productivity tool db2look when you need to recreate federated objects. Track the data manipulation language operations in your DB2 database Protecting data against any failure is a huge challenge for the DBA at any organization. In production and 24x7 environments where databases are mission-critical, any data loss is unacceptable. To successfully perform point-in-time recovery, you must have sufficient information about all the Data Manipulation Language (DML) operations that have taken place. This article shows you how to keep track of all DML operations that occur against a database, even down to a specific table. Using the DB2 Recovery Expert (RE) tool and the db2la command, you can track DML operations along with the time that they occurred. The information perspective of SOA design, Part 8: Use of IBM WebSphere Information Analyzer in SOA design Learn to use the IBM WebSphere Information Analyzer to support the data quality analysis pattern. This is the eighth paper in "The information perspective of SOA design" series. This article demonstrates to an architect community how tools from IBM -- in particular IBM WebSphere Information Analyzer and the unified metadata management of IBM Information Server -- can be used to address the Data Quality Assessment Patter in an SOA engagement. It describes the key features of the products that support the data quality analysis pattern presented in Part 6 of this series. Information architecture essentials, Part 8: Packaging and reselling information Whether you find the concept interesting or annoying, information architecture designs can be used to package and sell information to third parties. In this article, learn about these opportunities so you can determine whether or not your organization should jump into the game. Which distributed edition of DB2 9.5 is right for you? Learn the details on what makes each edition of DB2 9.5 for Linux, UNIX, and Windows unique. The author lays out the specifications for each edition, licensing considerations, historical changes from DB2 9, and references to some interesting things customers are doing with DB2. This popular article has been rewritten for the DB2 9.5 release. DB2 and IBM's Processor Value Unit pricing In the third quarter of 2006, IBM software group announced a new methodology for processor-based pricing and introduced the concept of the Processor Value Unit (VU) as a way to determine the processor rating of a server. This article describes how DB2 for Linux, UNIX, and Windows is licensed with the new PVU methodology for unlimited users. Compare the distributed DB2 9.5 data servers In a side-by-side comparison table, author Paul Zikopoulos makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 9.5 data server family. DB2 9 certification: Everything you need to know Certification has arrived, no question. But as a DB2 professional, should you certify? Will it increase your abilities or help your career? How can you do it quickly and inexpensively? That last thought is key -- knowing the inside story on DB2 certification before you proceed will save you a ton of time, stress and money. This article tells you what you need to know to decide if DB2 certification is for you, and if so, the secrets to doing it successfully, quickly and inexpensively. This article has been updated for DB2 9. Licensing distributed DB2 9.5 data servers in a high availability environment Are you trying to ensure you're licensing your DB2 servers correctly in a high availability environment? Don't have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? Author Paul Zikopoulos explains it all in plain English and covers some important changes in DB2 9.5 too! Basic text indexing with DB2 index extensions All major vendors of database systems provide extensions for text indexing and text search. If the full power of those products is not needed, IBM DB2 index extensions are a powerful mechanism to implement light-weight text indexes using user-defined index structures. In this article, learn how to use index extensions to implement two index structures, where one creates a hash value for strings and the other indexes strings based on the words in them. Both can be used for many purposes. Information architecture essentials, Part 7: Data-store design Valuable business information should never be left sitting around. It should be organized and saved into a permanent data store. A legacy database tends to become the final resting place for useful business information -- and this information is essentially lost, because it can't be accessed in a meaningful way. Data-store design can help you establish an efficient mechanism to store and retrieve valuable business information. XForms and DB2 pureXML Understand the end-to-end exchange of XML data from an XForms-based browser to an IBM DB2 database with full XML support. Learn how easy it is to create XForms and have them communicate with a DB2 database, where XML data can be stored, retrieved, or deleted. Learn, also, how to create the XForms that access the DB2 pureXML through Universal Services. The information perspective of SOA design, Part 7: The execution approach for the data quality analysis pattern in SOA This is the seventh paper in a series called the â€œThe Information Aspect of SOA Design." The purpose of this article is to demonstrate to an architect community the execution approach of detailed data quality analysis in the context of an SOA environment. This article focuses on the implementation of data quality analysis regardless of the specific technology in use, and will be followed by a related article that describes in more detail how the related IBM products (WebSphere Information Analyzer) can be used in this context. Making DB2 Case-Insensitive Read these tips on how you can easily allow your users to search data in a way that is natural for them-with no worries about case sensitivity. Integrate FileNet BPM with IBM Content Manager, Part 3: Implement the Component Integrator-based work performers This is the third in a series of four articles that describe how to integrate FileNet Business Process Manager with IBM Content Manger. You will see, step-by-step, how to implement the Component Integrator-based work performers. Also, learn how to register the created Java business entities object into the FileNet P8 Component Integrator to create a component queue, and make this component queue available for business processes. This article continues with the "ABC Company" scenario described in Parts 1 and 2.