Skip to main content

Skip over site navigation to main content

developerWorks  >   Information Management  >   Technical library  >  

Technical library view  RSS for Information Management

 developerWorks
 Related links:    Redbooks  |  Forums  |  Support knowledge base

Filter your search and/or enter a keyword. If you don't filter your search or enter a keyword, the search results will default to all results.
 
 
 
 
  1 - 100 of 1257 results    Next   Show All   Hide Summaries
Title   Type

Table that contains the results that meet the search criteria.

DB2 for Linux, UNIX and Windows
IBM DB2, IBM's relational database management system, provides the foundation of information on demand. developerWorks is the technical resource center for the IBM DB2, including technical articles, tutorials, documentation, downloads, and support information.
 
Open source development for Information Management
Use PHP and other open source tools to develop applications for IBM Information Management servers.
 
DB2 family
The IBM DB2 family provides the foundation of information on demand. It's designed to meet your business needs whether large or small.
 
DBA Central
developerWorks DBA Central page is the technical resource center for the IBM Information Management database administrator and includes technical articles, tutorials, downloads, tools, code samples, and more.
 
Create an alerts system using XMPP, SMS, pureXML, and PHP
Thanks to the native XML support that pureXML offers IBM DB2 database developers, you can load XML data directly into your database, freeing up development time to add functionality to your application. Follow along in this tutorial to import an XML file with Euro foreign exchange rates into an IBM DB2 database and use special XQuery and SQL/XML functions to split this XML into separate database rows. You will also create a PHP script that pulls down new rates from the European Central Bank (ECB) Web site each day. Then you will extend the script to send update alerts to a Google Talk user using the XMPP protocol, and to a cell phone by SMS text message using the Clickatell SMS gateway service. Finally, you will create a PHP script that generates a PNG (Portable Network Graphics) graph of this data. 		Tutorial
 
Gauge SQE use in DB2 for i 6.1
This article explains how to collect a SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE. SQE is the strategic query engine on DB2 for i, with better performance, scaling and tooling such as the SQL Plan Cache. 		Articles
 
Information Management and XML technology
Support for XML in IBM Information Management products fosters the dynamic representation of data in a format that can be easily shared across databases and across platforms. developerWorks is the technical resource center for using XML technology with DB2, Informix, U2, and all the IBM Information Management products.
 
Build a Support Knowledge Base using DB2 pureXML and PHP
Creating applications that use a hybrid of relational data and XML data is easy thanks to the pureXML feature of IBM DB2 database servers. In this tutorial, you use PHP to create a Web application that connects to an IBM DB2 Express-C database and stores some of its data in traditional relational database columns, and some of it in native XML columns. You also learn how to use SQL/XML queries to retrieve, insert, update, and delete data from this database. Beyond the hands-on, project-based training, the tutorial equips you with the skills and conceptual knowledge you need to develop your own hybrid applications. 		Tutorial
 
DB2 for z/OS
DB2 on the mainframe allows you to run powerful enterprise applications and make e-commerce a reality. developerWorks is the technical resource center for DB2 for z/OS and OS/390.
 
Data warehousing
IBM's warehousing solutions provide you with all of the capabilities necessary to glean maximum return from your information.
 
DB2 Everyplace
IBM DB2 Everyplace is a relational database and synchronization server that extends enterprise applications and data to mobile devices such as personal digital assistants (PDAs) and smart phones. developerWorks is the technical resource center for DB2 Everyplace, including articles, documentation, support, downloads, redbooks and more.
 
Use Technology Explorer for IBM DB2 to manage user and group authentication for DB2 for Linux, UNIX, and Windows
Learn how to use the Technology Explorer (TE) for IBM DB2(R) to control user and group authentication to DB2 through the use of a security plug-in called db2auth. The plug-in uses a DB2 database for storing authentication information instead of an external authentication repository, such as an operating system or Kerberos. The plug-in allows for a smoother migration from other database software such as MySQL, which also stores authentication information within the database. This article also describes how the support in TE for the db2auth plug-in was implemented. [2009 Nov 13: Updated to show Linux support. --Ed.] 		Articles
 
Copy your SAP ERP system across platforms using DB2 redirected restore
With DB2 Version 8 or later you can use redirected restore operation to copy an SAP system from one platform to another. This article provides you with the step-by-step instructions on how to do this and describes the resources you need before you start. 		Articles
 
Information Management and SOA
Learn how you can use SOA and Web services technology with IBM Information Management products.
 
Build a pureXML and JSON application, Part 3: Create OpenSocial gadgets for pureXML
With the Web 2.0 technology of OpenSocial gadgets, developers can easily include their applications in popular Web sites, such as iGoogle, MySpace, Hi5, LinkedIn, and others. In this article, explore OpenSocial gadgets through hands-on construction of an application that leverages the pureXML capability of DB2. This article is the last in a series of three that illustrates how to build a pureXML application whose user interface is a gadget that you can deploy in any OpenSocial compliant Web site. Follow the steps in this article to build a user interface that stores and retrieves the JSON data described in the first article through JSON Universal Services created in the second article. 		Articles
 
Build a pureXML and JSON application, Part 2: Create Universal Services for pureXML that expose JSON
The pureXML Universal Services for JSON (abbreviated to JSON Universal Services in this article) are a set of database operations, including insert, update, delete, and query, exposed as Web services. These services enable an application to persist JSON in pureXML and to query it easily through HTTP with WebSphere Application Server. Get started with configuring and testing JSON Universal Services in this article. 		Articles
 
Build a pureXML and JSON application, Part 1: Store and query JSON with DB2 pureXML
JavaScript Object Notation (JSON), a popular textual notation in Web 2.0, is used to represent objects (or data structures) as serialized text when clients and servers exchange information. Some applications benefit from persisting JSON objects to maintain state across sessions. In this article, learn how DB2 pureXML can store, manage, and query JSON when you adopt a simple JSON-to-XML mapping. 		Articles
 
Oracle to DB2 Conversion Guide: Compatibility Made Easy
This Oracle to DB2 migration guide describes new technology, best practices for moving to DB2, and how to handle some common scenarios. It is now dramatically easier than ever to move to DB2 and experience the benefits of the IBM industry leading database, which offers a lower cost of ownership, ease of use, storage savings, industry leading performance, and superior customer support. 		Redbooks
 
Detect resource leaks using IBM DB2 tracing and the Eclipse Modeling Framework
Using the IBM DB2 tracing mechanism to detect database resource leaks can be challenging. However, with the Eclipse Modeling Framework (EMF), you can easily design and implement an intuitive tool that you can use to quickly detects leaks. 		Articles
 
Creating an XML electronic forms solution with an Adobe PDF form and IBM DB2 pureXML
The eForms solution described in this article involves three components: an electronic form, a web service, and a database. Because all three speak XML, there is no need for complex data mapping or conversion steps between components. The XML data format used in this example implementation is a very simple structure but you can easily expand the format to meet specific needs or even base the format on one of the many XML-based industry standards for data exchange such as NIEM for government, ACORD for insurance, or FIXML for financial markets. This solution places the collected data into the XML business format at collection time and keeps that format throughout submission and storage for a streamlined process that culminates in the business format being stored in a database where it is available for downstream processes or business analysis. You can follow the steps in this article to build and run the three components needed for this efficient XML electronic forms data collection solution. 		Articles
 
Leveraging pureXML in a Flex microblogging application, Part 3: Using pureXML Web services to publish microblog entries to an HTML page
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter. In Part 1 of the series, you learned about Web Services and how they are enabled using DB2 pureXML as you created the microblog database and tested it. Part 2 tapped into Adobe Flex and ActionScript to create the user interface of your application. In this article, the final part of the series, you will learn how to use your pureXML Web Services to publish your microblog entries to an HTML page. 		Articles
 
Leveraging pureXML in a Flex microblogging application, Part 1: Enabling Web services with DB2 pureXML
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter. 		Articles
 
Leveraging pureXML in a Flex microblogging application, Part 2: Building the application user interface with Flex
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter. In Part 1 of the series, you learned about Web Services and how they are enabled using DB2 pureXML as you created the microblog database and tested it. In this article, Part 2 of the series, you will tap into Adobe Flex and ActionScript to create the user interface of the application. 		Articles
 
Licensing distributed DB2 9.7 servers in a high availability (HA) 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 for the DB2 9.7 release that became generally available on June 17th, 2009. 		Articles
 
Information Management and Rational application development
The Rational tool set provides an array of capabilities for developing your database applications. Quickly design, develop, analyze, test, and deploy Web, Web services, Java, J2EE, and portal applications using this comprehensive IDE. This site contains technical articles, tutorials, documentation, redbooks, forums, and more.
 
Which distributed edition of DB2 9.7 is right for you? (With a dash of DB2 9.8 pureScale)
Learn the details on what makes each edition of DB2 9.7 for Linux, UNIX, and Windows unique. The author lays out the specifications for each edition, licensing considerations, historical changes throughout the DB2 9.7 release cycle, and references to some interesting things customers are doing with DB2. This popular article is updated during the release for any intra-version licensing changes announced in a Fix Pack as well. This article also discusses some details of the DB2 9.8 release that's the shipment vehicle for the new DB2 pureScale feature. 		Articles
 
Using DB2 incremental backup
Incremental backup is one of the key high availability features in DB2 9.5 for Linux, UNIX, and Windows in a data warehouse environment. This article describes how incremental backup works, when you might want to use it, and strategies for ensuring smooth recoveries. This article has been updated for DB2 9.5. 		Articles
 
DB2 and IBM's Processor Value Unit pricing
A number of years ago (3Q06), IBM Software Group (SWG) announced a new methodology for processor-based pricing and introduced the concept of the Processor Value Unit (PVU) as a way to determine the processor rating of a server. This article describes how DB2 for Linux, UNIX, and Windows (DB2) is licensed with the new PVU methodology for unlimited users. 		Articles
 
Compare the distributed DB2 9.7 database 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.7 server family as of its general availability date of June 19th, 2009. 		Articles
 
Best practices for DB2 for Linux, UNIX, and Windows: Cost reduction strategies with DB2
Learn how to use the Configuration Advisor, the Design Advisor, and autonomic features, such as the self-tuning memory manager, to reduce the human costs associated with DB2 maintenance. Help your organization develop a holistic view of reducing costs across hardware, software, and maintenance over time as part of the lost-cost evolution. 		Articles
 
Customizing XML storage in DB2
A review of best practices for when and how to customize your XML storage 		Articles
 
Top Performance Features in DB2 9 for z/OS
A look at indexing on expressions and index compression in DB2 9 for z/OS 		Articles
 
Programmers Only: Reducing Conversations with DB2 for z/OS: Part 1
A look at SQL that's unnecessary and should be eliminated, SQL that is executed more times than necessary, and SQL that should be replaced 		Articles
 
Sharing Knowledge, Driven by Passion
The IBM Information Champion program recognizes dedicated IBM product advocates who share their opinions and years of experience with others in the same field. Meet two of the newest (and youngest) recipients. 		Articles
 
System z Rocks (Again)
Why IBM System z and DB2 are not only a popular combination for BI, but the primo platform for data warehousing 		Articles
 
DB2 pureScale
DB2 pureScale reduces the risk and cost of business growth by providing unlimited capacity, continuous availability, and application transparency. DB2 pureScale on IBM Power Systems incorporates PowerHA pureScale technology to deliver levels of database scalability and availability unmatched on UNIX or x86 systems. This complements DB2 for z/OS and System z, the undisputed leader in total system availability, scalability, security and reliability.
 
How to identify unused indexes in DB2 for Linux, UNIX, and Windows
During database application development, developers tend to define a large number of indexes on tables to guarantee that each and every query performs well. After application development has been finished and a database has gone into production, the existence of too many indexes turns out to be a cause for decreased database performance. Many indexes mean more work for the database system when executing UPDATE, INSERT, and DELETE (UID) operations. In addition, regular maintenance activities like RUNSTATS and REORG also run considerably longer in cases where many indexes are present. Therefore, to achieve the best database performance, it is critical to be able to determine which indexes are necessary for query execution and which indexes you can safely drop without impacting query runtimes. This article explains several methods that a DB2 for Linux, UNIX, and Windows (DB2 LUW) database administrator (DBA) can use to identify unused and seldom used indexes. 		Articles
 
Using collaborative technologies for healthcare in the home
The number of people in the U.S. diagnosed with diabetes is now reaching 24 million. Diabetes requires monitoring. In this article, get an introduction to the concept of continuing care, particularly in the home. This article describes how diabetes monitoring can be improved through collaborative technologies. See how software from MyCareTeam, IBM, and other organizations are used in an example in support of diabetes monitoring. Understand information and Web-based technologies, such as XML storage and services (for example, through IBM DB2 pureXML) in the context of continuing care, as well as related initiatives, such as the Continua Health Alliance's role in selecting appropriate standards. This article summarizes the impact of these technologies on the building of agile and collaborative systems for healthcare, and highlights the significant benefits of collaborative continuing care that include cost reduction and increased quality of healthcare. 		Articles
 
New to IBM Information Management
At the core of IBM's software solution for information management is a powerful family of relational database management system (RDBMS) servers. In addition, IBM has built information management software for purposes that include data warehousing, data analysis, data mining, media asset management, enterprise content management and information integration.
 
DB2 9.7 on Amazon Elastic Compute Cloud (EC2)
DB2 9 is an innovative database server for managing relational and XML data and is ideally suited for Cloud deployments. DB2 Workgroup is the data server for deployment in a departmental, workgroup, or medium-sized business environment, and exploits up to 16GB of memory. 		Trial Downloads
 
DB2 Express-C 9.7 on Amazon Elastic Compute Cloud (EC2)
Use IBM DB2 Express-C on Amazon Elastic Compute Cloud (EC2). IBM DB2 Express-C, the no-charge edition of the relational and XML hybrid DB2 data server, is ideally suited for use in Cloud environments and delivering Data-as-a-Service (DAAS). 		Trial Downloads
 
Multi-row fetch support with type 2 connectivity in DB2 V9 for z/OS
Multi-row FETCH (MRF) can provide you with better performance than retrieving one row with each FETCH statement. This article explains what MRF is and how to use it. The article also includes a sample Java program that illustrates how to set MRF in an application. For IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS, multi-row FETCH can be used for forward-only cursors and scrollable cursors. For other types of connectivity, multi-row FETCH can be used only for scrollable cursors. 		Articles
 
Using virtual cubes in IBM InfoSphere Warehouse 9.7 to combine business scenarios and to improve performance
Virtual cubes are one of the new Cubing Services features in IBM InfoSphere(TM) Warehouse 9.7. A virtual cube provides a way to merge different cubes together to allow a single query destination that returns merged results from the cubes that compose it. Virtual cubes can be used to drastically improve the response time of the cube server queries by using efficient data partitioning for optimum cache utilization (in some cases, over 100 times better response times). Virtual cubes also offer a solution for combining results by merging different regional cubes into a country cube. They also enable merging sales numbers with currency exchange rates to provide a global view of the business. This article explains how virtual cubes are created, how they work, and how to use them for InfoSphere Warehouse Cubing Services 9.7. 		Articles
 
Designing and deploying a security model using IBM InfoSphere Warehouse Cubing Services
In IBM InfoSphere(TM) Warehouse V9.7, Cubing Services modify the way you secure your cubes and provide a way for you to secure your dimensions. You might need to limit access to your OLAP data at the level of the cube or at the more granular level of the dimension, depending on your security requirements. In this article, you will learn how to define security on cubes and dimensions by creating roles, policies, and authorizations in the Design Studio. This article describes how to export the security model to a file and how to use the Administration Console to import the security model to the InfoSphere Warehouse control database. After importing the security model, you will learn how to instruct the Cube Server to enforce the rules in the security model. 		Articles
 
Data warehousing
IBM data warehousing and business intelligence software gathers, manages, and analyzes data, generating powerful business insight.
 
IBM InfoSphere DataStage and DB2 pureXML, Part 2: Building an XML-enabled data warehouse
Learn how to integrate business-critical XML data into your data warehouse using IBM InfoSphere DataStage 8.1 and DB2 9.5 pureXML. This two-part article series provides step-by-step instructions for using pureXML as both a source and target data source for InfoSphere DataStage jobs. 		Articles
 
New options for XML data integrity and validation in DB2 V9.5
DB2 introduced pureXML technology in Version 9. This technology allows you to store XML data in its native form, maintaining the hierarchical structure and permitting you to query it using SQL/XML and XQuery. Just as with relational data, the ability to ensure the integrity of XML data stored in DB2 is mandatory. The methods and mechanisms for ensuring the integrity of XML data, however, are a bit different than the methods for traditional relational data integrity. In this article, you'll learn about XML data integrity in the context of DB2, and explore the various options you have to guarantee integrity in different scenarios. 		Articles
 
DB2 9.7: Using PL/SQL anonymous blocks in DB2 9.7
IBM DB2(R) for Linux(R), UNIX(R), and Windows(R) 9.7 introduces support for PL/SQL anonymous blocks: a feature that enables PL/SQL application developers to test, troubleshoot, and prototype new procedural code, simulate application runs, and dynamically build complex ad-hoc queries and reports. This article describes the concept of anonymous blocks in DB2 9.7 and illustrates the use of this feature using common database scenarios. 		Articles
 
DB2 Optimization Techniques for SAP Database Migration and Unicode Conversion
This book provides in-depth information about the best practices and recommendations for the source system database export, the advanced migration techniques, database layout and configuration, database import recommendations, SAP NetWeaver Business Warehouse, as well as background information about Unicode. We summarize our recommendations in one chapter that can be used as a quick reference for experienced migration consultants. 		Redbooks
 
IBM InfoSphere DataStage and DB2 pureXML, Part 1: Integrate XML operational data into a data warehouse
Learn how to integrate business-critical XML data into your data warehouse using IBM InfoSphere DataStage 8.1 and DB2 9.5 pureXML. This two-part article series provides step-by-step instructions for using pureXML as both a source and target data source for InfoSphere DataStage jobs. 		Articles
 
DB2 9.7: Using new Workload Manager features
This tutorial provides a series of exercises using IBM DB2 Workload Manager (WLM). By following these exercises, you should become familiar with the DB2 WLM feature and start to see the immediate value you can obtain from its use. For those new to WLM, the tutorial serves as an easy starting point for you to begin using WLM right out of the box. For experienced WLM users, the tutorial gives you a hands-on introduction to new WLM functions introduced in DB2 9.7. 		Tutorial
 
Automated cluster controlled HADR configuration setup using the IBM DB2 high availability instance configuration utility
Learn how to configure a failover solution for DB2 for Linux, UNIX, and Windows, using the DB2 high availability disaster recovery (HADR) feature and the the DB2 high availability instance configuration utility (db2haicu). This article walks you through the concepts and then shows how to set up two distinct configurations for automated failover. 		Articles
 
IBM DB2 for i
IBM DB2 for i5/OS is an advanced, 64-bit Relational Database Management System (RDBMS) that supports a broad range of applications at a lower cost of ownership due to its unique autonomic, self-managing features. developerWorks is the technical resource center for the IBM DB2, including technical articles, tutorials, documentation, downloads, and support information.
 
Trial: IBM DB2 for Linux, UNIX, and Windows
Download a free trial version of IBM DB2 9.7 for Linux, UNIX, and Windows. DB2 9.7 takes the cost savings, ease of use, and security of DB2 9.5 to the next level. For example, the industry-leading deep compression technology introduced in DB2 9.5 has been enhanced and extended in DB2 9.7. The result is even lower storage costs in DB2 9.7 compared with DB2 9.5. Beyond the concrete storage cost savings deep compression offered, it also simplified administration of large databases and lead to welcome performance gains for many clients. DB2 9.7 Express Edition or DB2 Workgroup Server Edition 9.7 is also available in the Amazon EC2 environment. 		Trial Downloads
 
DB2 9 for z/OS: Distributed Functions
In this IBM Redbooks publication we describe how to set up your DDF environment, and how to deploy the DDF capabilities in different configurations, including how to develop applications that access distributed databases. We also describe a set of more advanced features, such as thread pooling and high availability distributed configurations, in a DB2 data sharing environment, as well as the traces available to you to do performance monitoring and problem determination. In summary, we show how a high-volume, highly available transactional application can be successfully implemented with a DB2 for z/OS data server accessed by all types of application servers or clients running on the same or different platform. 		Redbooks
 
Database version control with IBM Optim Database Administrator V2.2
Have you ever wondered when the database was changed? With Optim Database Administrator (previously known as DB2 Change Management Expert), wonder no more! IBM Optim Database Administrator (ODA) helps you keep track of changes, work seamlessly with other team members, reverse or undo changes, and audit any changes that were made to your database. This article describes a scenario where the DBA organization uses ODA along with the Eclipse Team project to enhance their collaboration and ensure a consistent audit path. Learn about connecting to a library control system and saving change management projects, models, and scripts in library control, as well as auditing the changes. Also, discover how to retrieve from library control, and use a change management script to undo the change. 		Articles
 
DB2 9.7: Online schema change
DB2 9.7 introduces enhancements that allow you to make changes to the database objects while keeping these objects fully accessible to the database users during the modification. These enhancements allow database administrators to make vital changes to the database schema on the fly without any disruption to users. This article includes examples that demonstrate how to rename columns, change column data types, and move tables with the ADMIN_MOVE_TABLE routine. This article includes examples that demonstrate how to use the ALTER TABLE command to rename columns and change column data types. Other examples demonstrate how to use the ADMIN_MOVE_TABLE routine to move and modify tables while keeping them accessible. 		Articles
 
DB2 9.7: Autonomous transactions
Learn about autonomous transactions, a feature introduced in DB2 Version 9.7 for Linux, UNIX, and Windows. You will get an overview and example of what an autonomous transaction is and how to create one. 		Articles
 
Exploit XML indexes for XML query performance in DB2 9
DB2(R) 9 provides pureXML storage and offers XQuery and SQL/XML as query languages. XML indexes are essential for high query performance, but their usage for query evaluation depends on how query predicates are formulated. This article presents a set of guidelines for writing XML queries and creating XML indexes in a consistent manner so that indexes speed up your queries as expected. Also learn what to look for in XML query execution plans to detect performance issues, and find out how to fix them. A downloadable "cheat sheet" summarizes the most important guidelines. This article has been updated for DB2 9.5 and 9.7. [2009 Jul 30: This article has been updated for DB2 9.5 and 9.7, including additional SQL/XML sample queries.--Ed.] 		Articles
 
DB2 9.7: Run Oracle applications on DB2 9.7 for Linux, UNIX, and Windows
DB2 9.7 for Linux, UNIX, and Windows has out-of-the-box support for Oracle's SQL and PL/SQL dialects. This allows many applications written against Oracle to execute against DB2. In this article, get a high-level overview of what Oracle compatibility means in DB2. Whether you want to switch your custom application to DB2 or extend your DBMS vendor support to DB2, now is your time. 		Articles
 
Text analysis in InfoSphere Warehouse, Part 2: Dictionary-based information extraction combined with IBM Cognos reporting
Unstructured information represents the largest, most current, and fastest growing source of information that is available today. This information exists in many different sources such as call center records, repair reports, product reviews, e-mails, and many others. The text analysis features of IBM InfoSphere(TM) Warehouse can help you uncover the hidden value in this unstructured data. This series of articles covers the general architecture and business opportunities of analyzing unstructured data with the text analysis capabilities of InfoSphere Warehouse. The integration of this capability with IBM Cognos(R) reporting enables people across the company to exploit the text analysis results. The first article of this series gave an overview of the text analysis capabilities in InfoSphere Warehouse and showed how to use regular expressions to extract concepts from free-form text. This second article shows you how to use dictionaries for concept extraction and how you can use taxonomies to structure them. It also explains how you can present the results in an interactive Cognos report. 		Articles
 
Data Web Services on DB2 for z/OS, Part 2: Integrate z/OS data sets using user-defined functions
Learn by example how to create an external user-defined function (UDF) on DB2 for z/OS that can read z/OS Unix System Services (USS) files and z/OS data sets. You can then use existing SQL built-in functions and your own UDFs to perform data manipulation on the information stored in the data sets and files. You can also expose these "file-reading" SQL statements as IBM Data Web Services, which results in the data sets and files being available to Web service operations. 		Articles
 
Migrating from Oracle 10g to IBM Informix Dynamic Server on Linux, Unix, and Windows
We discuss considerations, and describe a methodology, for migrating from Oracle 10g to the Informix Dynamic Server (IDS). We focus primarily on the basic topic areas of data, applications, and administration, providing information about the differences in features and functionality in areas such as data types, DML, DDL, and Stored Procedures. Understanding the features and functionality of the two products will better enable your decisions as you develop your migration plan. We provide a migration methodology and discuss the processes for installing and using the IBM Migration Toolkit (MTK) to migrate the database objects and data from Oracle to IDS. We also illustrate, with examples, how to convert stored procedures, functions, and triggers. Application programming and conversion considerations are also discussed. The laboratory examples are performed under Oracle 10g and IDS Version 11.5. However, the processes and examples can also be applied to Oracle 7, 8, and 9i. 		Redbooks
 
Using IBM Database Encryption Expert to protect your sensitive data
IBM Database Encryption Expert provides features to encrypt and control access to data written to file systems and database backup images. Beginning with Version 1.1 Fix Pack 3, the product supports both DB2 and Informix Dynamic Server (IDS). This article describes some of the key features and mechanisms of Encryption Expert and shows you how to use them. 		Articles
 
SQL Compatibility in DB2 9.7
From triggers to object enhancements, this article provides a demonstration of the new Oracle compatibility features in DB2 9.7. 		Articles
 
DB2 Data Warehouse Performance
Recommendations for SQL statement-level performance tuning. 		Articles
 
Healthcare's XML Heartbeat
An in-depth look at how DB2 pureXML technology anchors the patient-oriented document system of a multi-hospital healthcare provider. 		Articles
 
How to get certified for DB2
A look at DB2 certification, including what you need to know about signup details, process information, and exam formats 		Articles
 
IBM Lotus Forms 3.0.1 integration with IBM DB2 9, part 2
This article is the second in a series that explores the XML capabilities of IBM® DB2 9 and integrates those capabilities with IBM Lotus® Forms by looking at retrieving the Lotus Form document in its XML native format from the database and embedding it in Java™ Server Pages (JSPs). 		Articles
 
DB2 9.7: IBM Data Movement Tool
Here we present a very simple and powerful tool to enable applications from Oracle and other DBMS to DB2. 		Articles
 
Get started with DB2 Performance Expert Extended Insight Feature
IBM DB2 Performance Expert Extended Insight Feature extends the capabilities provided in DB2 Performance Expert by providing end-to-end database monitoring for Java technology applications, with even more capabilities for those running in IBM WebSphere Application Server. This feature gives you the capability to address performance issues, regardless of where they occur in the software stack. This tutorial will help you get started with DB2 Performance Expert Extended Insight Feature. Learn how to install, configure, and validate DB2 Performance Expert Extended Insight Feature. 		Tutorial
 
Download: IBM DB2 Express-C
Download a no-charge version of DB2 Express and access support resources here. DB2 Express-C is a no-charge version of DB2 Universal Database Express Edition for the community. Use this data server for application development and deployment 		Trial Downloads
 
Build a pureXML application in DB2 for z/OS, Part 3: Develop stored procedures with Rational Developer for System z
In this tutorial, the third installment in a series, learn how to use IBM Rational Developer for System z to develop COBOL stored procedures that manipulate XML data. This tutorial illustrates the XML schema support offered, and provides step-by-step instructions for creating and testing stored procedures. 		Tutorial
 
Comparing IBM DB2 and IBM solidDB SQL procedures, Part 2: Compare conditional statements, looping statements, error handling, and returning results sets in SQL procedures
Have you ever wondered how IBM DB2(R) and IBM solidDB(R) procedures differ? This article series of comparisons spells out the differences very clearly. In this Part 2, learn the differences between conditional statements, looping statements, error handling, returning results sets, and miscellaneous other functions. Many examples and side-by-side comparisons help you to understand the differences. 		Articles
 
Build a pureXML application in DB2 for z/OS, Part 2: Web enablement through Universal Services
In this tutorial, set up Web access to your pureXML data through simple insert, update, delete, select, and query operations known as the Universal Services. Use the included download bundle with ready-to-install services to explore the concepts of this tutorial, and learn how to quickly build application prototypes with the Universal Services. 		Tutorial
 
Create an electronic form solution with DB2 pureXML and Lotus Forms
Electronic forms are an attractive way to automate paper-based processes and reduce material and personnel costs. This demo shows how to create an XML-based electronic form solution in three steps using Lotus Forms to capture and send the data, and DB2 pureXML to receive and store the data. The two are linked by a simple Web service that takes only minutes to create with Data Studio. This demo shows how to create the DB2 database and table to store the XML, how to create the Web service, and how to create the simple data capture and transmission form. It then shows you the running application, including how to query the data stored in DB2 pureXML and a Cognos report built from the data. 		Demos
 
15 best practices for pureXML performance in DB2
DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchical format. To query XML data, DB2 offers two languages, SQL/XML and XQuery. Additionally, DB2 9 has sophisticated XML indexing capabilities and support for XML Schema validation. While most existing performance guidelines for DB2 also apply to XML data, this article provides additional XML-specific performance tips. This article has been updated for DB2 9.5. [2009 May 26: Corrected code in Listings 12 and 13.--Ed.] 		Articles
 
Using DB2 XQuery to extract data mining results stored as PMML
Data mining is the process of finding rules and patterns in structured data. DB2(R) data mining uses Intelligent Miner, which is part of InfoSphere(R) Warehouse. Intelligent Miner(R) stores those results in Predictive Model Markup Language (PMML) format, which is based on XML. Since the launch of DB2 9, information stored in XML can be processed efficiently using XQuery. Find out how easily you can use DB2 XQuery to create your own access methods based on your data mining results. 		Articles
 
Comparing IBM DB2 and IBM solidDB SQL procedures, Part 1: Compare structures, parameters, variables, assignments, procedure bodies, cursors, and dynamic SQL statements
Have you ever wondered how IBM DB2(R) and IBM solidDB(R) procedures differ? This article series of comparisons spells out the differences very clearly. In this Part 1, learn the differences between the structures, parameters, variables, assignments, procedure bodies, cursors, and dynamic SQL. Many examples and side-by-side comparisons help you to understand the differences. 		Articles
 
Cloud computing for the enterprise: Part 2: WebSphere sMash and DB2 Express-C on the Amazon EC2 public cloud
Part 1 of this article series discussed cloud computing in general, including cloud layers and the different cloud types, along with their benefits and drawbacks, and explained why this movement is important for enterprise developers. This article looks specifically at the public cloud and how you can use the IBM WebSphere sMash and IBM DB2 Express-C Amazon Machine Images (AMI) to deliver Web applications hosted on the EC2 public cloud infrastructure. 		Articles
 
Information Management community
Connect to the IBM Information Management community. You'll find forums, blogs, user groups, experts, newletters, events, and more.
 
Install and configure InfoSphere Warehouse on System z
This article takes you through the installation of InfoSphere Warehouse on a Linux partition on System z. Learn about pre-installation requirements, then walk through the steps for a successful installation. 		Articles
 
Build a pureXML application in DB2 for z/OS, Part 1: Use COBOL stored procedures to store and manipulate data
In this article, set up and populate a small XML database, and implement COBOL stored procedures for basic operations on the data. Use the included download bundle with ready-to-install samples to explore the concepts of this article, and apply the concepts to other industry or custom XML formats. The XML documents that conform to the UBL (Universal Business Language) format from OASIS are stored and manipulated in the samples. 		Articles
 
Using Data Studio Administrator and DB2 High Performance Unload for fast and efficient data and schema migration
As a database administrator (DBA), you might need to upgrade your database server when faster and more efficient hardware is made available to you. And you probably need to do this with as little impact to production performance as possible. In this article, you will follow two scenarios step-by-step to see how Erik, a DBA at a fictional company, uses Data Studio Administrator 2.1 and DB2(R) High Performance Unload 4.1 together to accomplish fast and efficient data migration. These scenarios describe how to efficiently combine the ease of use of Data Studio Administrator with the high-speed unload capabilities of DB2(R) High Performance Unload. 		Articles
 
Data Web Services on DB2 for z/OS, Part 1: Unlock business functions using DB2 for z/OS stored procedures and Data Web Services
Is your organization using or planning to use DB2 for z/OS stored procedures to provide business functions? Have you ever wondered how to reuse stored procedures without programming effort in Web services? If so, this article will be of interest to you. 		Articles
 
The top 6 tips for a successful DB2 Performance Expert deployment for DB2 for Linux, UNIX, and Windows, Part 2: Taking performance baselines, using DB2 Workload Manager, and monitoring in a partitioned environment
Performance monitoring and tuning are critical tasks for a database administrator (DBA). DB2(R) Performance Expert helps DBAs tackle immediate performance problems, as well as avoid problems in the future. This article is the second of two in a series that describes the top 6 things you can do to get the most out of DB2 Performance Expert. Learn how to take performance baselines, take advantage of DB2 Workload Manager, and configure monitoring in a large DPF environment. 		Articles
 
Application logging using solidDB, WebSphere Message Broker, and DB2 pureXML
Because of its flexibility and its presence in many application environments, XML is becoming the preferred log format. In this article, you'll learn how to easily set up an application logging environment by bringing the XML features of WebSphere and DB2 together. We first introduce a simple application logging scenario, then show how to use solidDB for caching and decoupling the application from the logging infrastructure. WebSphere Message Queue and WebSphere Message Broker will be used to reliably move the log messages from the application to DB2, where they can be stored and queried using the pureXML functionality. To normalize different message formats, WebSphere Message Broker will also be used to transform log files to other XML formats prior to storing them into DB2. 		Tutorial
 
Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services
In this IBM Redbooks publication, we discuss and describe a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner. The focus of this infrastructure is the InfoSphere Warehouse Cubing Services Feature. With this feature, DB2 becomes the data store for large volumes of data that you can use to perform multidimensional analysis, which enables viewing complex problems from multiple perspectives, which provides more information for management business decision making. This feature supports analytic tool interfaces from powerful data analysis tools, such as Cognos 8 BI, Microsoft Excel, and Alphablox. This is a significant capability that supports and enhances the analytics that clients use as they work to resolve problems with an ever growing scope, dimension, and complexity. Analyzing problems by performing more detailed queries on the data and viewing the results from multiple perspectives yields significantly more information and insight. Building multidimensional cubes based on underlying DB2 relational tables, without having to move or replicate the data, enables significantly more powerful data analysis with less work and leads to faster problem resolution with the capability for more informed management decision making. This capability is known as No Copy Analytics and is made possible with InfoSphere Warehouse Cubing Services. 		Redbooks
 
Introduction to IBM solidDB Universal Cache 6.3, Part 2: IBM solidDB Universal Cache setup
In Part 2 of this two-part series, set up IBM solidDB Universal Cache with DB2 for Linux, Unix and Windows to accelerate access to data. Learn about system and environment requirements, as well as the ways to acquire IBM solidDB Universal Cache code. Learn also how to install, configure, and use the IBM solidDB Universal Cache solution. 		Tutorial
 
Build an intelligent eForms solution based on DB2 pureXML, Lotus Forms, and Web services
Form processing is one of the major daily tasks in many public and private businesses. Processes based on paper forms are resource intensive, time consuming, and often result in inaccurate or incomplete data. This article describes how you can build an efficient electronic solution for form data capture, submission, and management. The article guides you through three steps to build an efficient XML electronic forms data collection solution with Lotus Forms for data capture, DB2 pureXML for data storage and query, and a connection between the two via a simple Web service that you can create with Data Studio Developer. In three steps you can have an operational electronic forms application that can be the basis for efficient, quick, and accurate data collection and management. 		Articles
 
The top 6 tips for a successful DB2 Performance Expert deployment for DB2 for Linux, UNIX, and Windows, Part 1: Modifying settings, setting up alerts, and using System Health data views
Performance monitoring and tuning are critical tasks for a database administrator (DBA). DB2(R) Performance Expert helps DBAs tackle immediate performance problems, as well as avoid problems in the future. This article is the first of two in a series that describes the top 6 things you can do to get the most out of DB2 Performance Expert. 		Articles
 
Archive and maintain DB2 message logs and diagnostic data with db2back
Do you ever find yourself wishing you had a better way to manage your diagnostic files on your IBM DB2 for Linux or AIX servers? If so, then help is on the way. Here's a script that helps you archive and maintain these files. And you can further ease the management process by compressing and removing them as they age. 		Articles
 
Enhance business insight and scalability of XML data with new DB2 9.7 pureXML features
New database design, administration, and development features for pureXML are available in IBM DB2(R) for Linux(R), UNIX(R), and Windows(R), Version 9.7 (announced April 22, 2009). Find out more about how these technologies can help companies integrate XML data more effectively into business intelligence environments and how companies can cope with growing XML data volumes. This article summarizes the new pureXML capabilities, explains how they can be used, and discusses sample application scenarios. 		Articles
 
IBM DB2
Have questions? Start here to find answers to commonly asked questions related to the IBM DB2 AMI on Amazon Web Services (AWS). 		Product documentation
 
Data Studio Administrator, Part 1: Integrating Data Studio Administrator and Rational Data Architect
This article highlights the integration between Data Studio Administrator (previously known as DB2 Change Management Expert) and Rational Data Architect. You'll learn about the common look and feel, the strengths of each product, and the benefits of combining them together. It includes step-by-step instructions and a sample that illustrates the touch points between these two tools. [2009 Apr 17: Added note about Rational Data Architect changing product name to InfoSphere Data Architect. --Ed.] 		Articles
 
Integrating Rational Software Architect with Rational Data Architect
Model-driven software development generally starts with either application modeling or data modeling. Application modeling and data modeling, however, are closely related to, and complement, one another. IBM has recognized the importance of integrating application modeling with data modeling in model-driven software development, and has developed the Unified Modeling Language (UML)-to-Logical Data Model (LDM) and the LDM-to-UML transformations. These transformations integrate application modeling using Rational Software Architect (RSA) and data modeling using Rational Data Architect (RDA). This article provides a quick overview of RSA and RDA, outlines the high-level steps in three RSA-RDA integration scenarios, and discusses the UML-to-LDM and the LDM-to-UML transformations and the UML Logical Data Model Profile. [2009 Apr 17: Added note about Rational Data Architect changing product name to InfoSphere Data Architect. --Ed.] 		Articles
 
SAP on DB2 9 for z/OS: Implementing Application Servers on Linux for System z
The power of the IBM System z, combined with the flexibility of Linux on System z, provides the ideal platform on which to implement SAP application servers. System z provides the benefits of continuous availability, high performance, scalability, and ease of management; these qualities support and complement mission-critical SAP business applications. This IBM Redbooks publication focuses on the implementation of SAP application servers on Linux on System z to leverage the synergy of this combination of products. It provides detailed information to guide you through the planning process, including resource sharing considerations, hardware and software requirements, support and maintenance. This book takes you through the steps to prepare the system environment, describing system and network configurations, and demonstrates the procedures for installing and customizing your system. It describes in detail how to install SAP application servers in z/VM Linux images, including the installation of SAP and Java and hipersockets. Finally, it provides guidance for performance tuning and introduces some useful monitoring tools. 		Redbooks
 
Solution development using DB2 and InfoSphere MashupHub
The popularity of Web applications has given rise to mashups, which allow creation of consolidated information through information aggregation. While mashups are not a new concept, IBM InfoSphere MashupHub provides a single integration tool to combine data from multiple sources. In this article, get an introduction to the use of IBM DB2 with InfoSphere MashupHub, and learn to create both pureXML feeds and Relational Database Query feeds for use with the DB2 database. 		Articles
 
Processing SEPA payments using DB2 pureXML and WebSphere Transformation Extender
WebSphere Transformation Extender and the WTX Pack for SEPA provide all of the transformation and validation processes necessary for interaction with the European Payments Council implementation for SEPA payments. This article shows how to use DB2 pureXML to implement a complete solution for the storage of valid SEPA payments, and also shows how validation of the original document can be performed when a payment rejection or return is processed. 		Articles
 
DB2 early access program
This DB2 technology sandbox page gives you the opportunity to preview technologies that are still in the lab.
 
  1 - 100 of 1257 results    Next   Show All   Hide Summaries
Not finding what you're looking for? Suggest Content