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 879 results    Next   Show All   Hide Summaries
Title   Date  

Table that contains the results that meet the search criteria.

Gauge SQE use in DB2 for i 6.1
This article explains how to collect an 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.
22 Nov 2009  
 
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.]
13 Nov 2009  
 
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.
12 Nov 2009  
 
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.
10 Nov 2009  
 
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.
10 Nov 2009  
 
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.
10 Nov 2009  
 
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.
05 Nov 2009  
 
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.
03 Nov 2009  
 
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.
03 Nov 2009  
 
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.
03 Nov 2009  
 
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.
03 Nov 2009  
 
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.
29 Oct 2009  
 
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.
29 Oct 2009  
 
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.
29 Oct 2009  
 
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.
29 Oct 2009  
 
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.
29 Oct 2009  
 
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.
28 Oct 2009  
 
Customizing XML storage in DB2
A review of best practices for when and how to customize your XML storage
19 Oct 2009  
 
Top Performance Features in DB2 9 for z/OS
A look at indexing on expressions and index compression in DB2 9 for z/OS
19 Oct 2009  
 
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
19 Oct 2009  
 
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.
13 Oct 2009  
 
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
12 Oct 2009  
 
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.
08 Oct 2009  
 
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.
08 Oct 2009  
 
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.
17 Sep 2009  
 
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.
10 Sep 2009  
 
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.
03 Sep 2009  
 
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.
03 Sep 2009  
 
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.
27 Aug 2009  
 
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.
27 Aug 2009  
 
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.
20 Aug 2009  
 
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.
13 Aug 2009  
 
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.
30 Jul 2009  
 
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.
30 Jul 2009  
 
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.
30 Jul 2009  
 
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.]
29 Jul 2009  
 
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.
23 Jul 2009  
 
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.
09 Jul 2009  
 
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.
09 Jul 2009  
 
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.
02 Jul 2009  
 
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.
30 Jun 2009  
 
DB2 Data Warehouse Performance
Recommendations for SQL statement-level performance tuning.
30 Jun 2009  
 
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.
30 Jun 2009  
 
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
30 Jun 2009  
 
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).
29 Jun 2009  
 
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.
26 Jun 2009  
 
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.
04 Jun 2009  
 
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.]
26 May 2009  
 
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.
21 May 2009  
 
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.
21 May 2009  
 
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.
20 May 2009  
 
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.
14 May 2009  
 
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.
14 May 2009  
 
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.
14 May 2009  
 
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.
07 May 2009  
 
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.
07 May 2009  
 
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.
30 Apr 2009  
 
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.
30 Apr 2009  
 
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.
23 Apr 2009  
 
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.
23 Apr 2009  
 
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.]
17 Apr 2009  
 
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.]
17 Apr 2009  
 
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.
09 Apr 2009  
 
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.
09 Apr 2009  
 
Distributed DBA: Storage, I/O, and DB2
In my previous column, I introduced you to some basic DB2 storage concepts and pointed out that network storage provisioning can have a significant effect on database performance. In this installment, I'll show you how to set an important storage I/O-related registry variable and how to fine-tune table-space characteristics, such as extent size, prefetch size, overhead, and transfer rate, when a DB2 database is deployed in a network-attached storage (NAS) or storage-area network (SAN) environment.article abstract goes here. Put the main points and key phrases at the beginning of the abstract, because it may be truncated in search results.
27 Mar 2009  
 
Taming a Terabyte of XML Data
26 Mar 2009  
 
Debugging stored procedures on DB2 z/OS with Data Studio Developer, Part 2: Configure the stored procedure debug session manager on z/OS
Learn step-by-step how to configure the Unified Debugger session manager for use on a z/OS(R) system, and learn how to use routines to manage the session manager. Proper setup of the session manager on z/OS can facilitate using IBM Data Studio Developer to debug stored procedures on DB2(R) for z/OS servers.
19 Mar 2009  
 
Accelerate access to critical data using IBM solidDB Universal Cache
IBM solidDB Universal Cache is in-memory caching software for use with traditional disk-based relational databases. It promises extreme speed, adaptability, and robustness. Explore these promises and follow a sample use case for the first - extreme speed.
12 Mar 2009  
 
Selected common SQL features for developers of portable DB2 applications
This summary of the common SQL application features is a quick reference for application developers who need to understand the frequently used features and functions across platforms.
09 Mar 2009  
 
Selected common SQL features for developers of portable DB2 applications
This summary of the common SQL application features is a quick reference for application developers who need to understand the frequently used features and functions across platforms.
09 Mar 2009  
 
The SQL Reference for Cross-Platform Development
Great news for people who want to write portable applications! This reference makes it easy for you to develop applications using SQL that is portable across the DB2 database family, including DB2 for z/OS Version 9, DB2 for i Version 6.1, and DB2 for Linux, UNIX, and Windows Version 9.5.
09 Mar 2009  
 
Lotus Sametime and DB2 pureXML supporting healthcare collaboration
This article introduces a healthcare scenario based on an end-to-end XML architecture that allows information encoded in Health Level 7 (HL7) Clinical Document Architecture (CDA) XML documents to be stored in the same format in an IBM DB2 pureXML database, exchanged in the same format utilizing Web services, and visualized in the same format using IBM Lotus Sametime Connect Client. See how a prototype Sametime plug-in for instant messaging clients can be used to access and display XML patient data stored in a database. Learn, also, how to install and configure the plug-in, and re-configure the plug-in for another scenario.
19 Feb 2009  
 
Connectivity Cheat Sheet for DB2 Universal Database Part 2 - DB2 for z/OS
Part 1 of the DB2 UDB Connectivity Cheat Sheet gave you everything you need to know for connecting DB2 UDB on Linux, UNIX and Windows to clients or to other platforms. Now part 2 takes you further, and gives you all the details for connecting DB2 UDB for z/OS clients to DB2 UDB for z/OS servers or servers on other platforms. [02/19/2009: Changed code sample in "Scenario 3, Part II. Bind SPUFI" to reflect MEXICO instead of SAMPLE. --Ed.]
19 Feb 2009  
 
Introduction to IBM solidDB Universal Cache 6.3, Part 1: Get started with solidDB Universal Cache 6.3
In Part 1 of this two-part series, get an introduction to the IBM solidDB Universal Cache solution and its component parts, and learn about the basic system requirements and the architecture of a solution. Get started with the IBM solidDB Universal Cache solution and an IBM DB2 for Linux, UNIX, and Windows back-end database. Part 2 of this series provides you with the basic knowledge to install and set up IBM solidDB with DB2 for LUW.
12 Feb 2009  
 
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 server family as of the interim release packaging changes announced on February 10th, 2009.
10 Feb 2009  
 
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 throughout the DB2 9 release cycle, and references to some interesting things customers are doing with DB2. This popular article has been updated for the intra-version licensing changes announced on February 10th, 2009 where some significant changes were announced.
10 Feb 2009  
 
Licensing distributed DB2 9.5 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 and covers some important changes to DB2 9.5 as of February 10th, 2009!
10 Feb 2009  
 
XML: Powering Next-Generation Business Applications
Students and professionals are honing their XML skills to tackle the requirements of enterprise 2.0 and Web 3.0. With a new contest underway around the world, they can now win prizes and recognition along the way.
05 Feb 2009  
 
Recommended reading list: DB2 for Linux, UNIX, and Windows application development
Learn about DB2 for Linux, UNIX, and Windows with this reading list, compiled especially for the database developer community. This popular article is updated to include the latest content that has been published for DB2 9.5.
05 Feb 2009  
 
Create IBM Data Web Services using IBM Database Add-Ins for Visual Studio
Learn how the IBM Database Add-Ins for Microsoft Visual Studio tool set supports IBM data server Web services development. Walk through the creation of a data Web service, and see how it can be deployed to easily access IBM DB2 or IBM Informix from your Web applications.
02 Feb 2009  
 
Integration between XML Forms Generator and Data Studio, Part 2: DB2 pureXML support in XFG
The pureXML feature of IBM DB2 9 has revolutionized support for XML data -- handling XML as a new data type that is stored in a natural hierarchy -- different from relational data. IBM Data Studio can create Data Web Services with multiple pureXML parameters to manipulate pureXML instances in the database. With the pureXML support in XML Forms Generator (XFG), you can visualize pureXML into XHTML/XForm for user to interact. Also XFG can retrieve the registered related XML Schemas of pureXML instances and generate type information, validation constraints into the target pureXML XHTML/XForm. So pureXML support in XFG makes it easy to build forms interfaces for XML instances stored in pureXML.
20 Jan 2009  
 
Create business reports for XML data using IBM DataQuant and DB2 pureXML
Use IBM's DataQuant all-purpose business intelligence tool for reporting on XML data stored in DB2 pureXML. Follow steps to use DataQuant to access the XML data stored in DB2 and make the individual data elements available in reports, charts, and dashboards for business insight and analysis.
15 Jan 2009  
 
Work with GPX XML in DB2 9.5 using JDBC
Many XML capabilities were introduced in IBM DB2 9 and 9.5 through the pureXML feature. In this article, see how you can exercise administrative functions, such as XML metadata management, and application development functions, such as XML manipulation and storage, through JDBC.
15 Jan 2009  
 
Fast and easy data movement using DB2's LOAD FROM CURSOR feature
Ease the process of DB2 for Linux, UNIX, and Windows data movement using the DB2 LOAD utility's FROM CURSOR option. This article introduces the LOAD FROM CURSOR feature and provides usage samples for two interfaces, the Command Line Processor and the ADMIN_CMD stored procedure.
08 Jan 2009  
 
Handle pureXML data in Java applications with pureQuery
pureQuery and DB2 pureXML are revolutionary database technologies in their fields. pureQuery is a high-performance Java data access platform focused on simplifying the tasks of developing and managing applications that access data from a database. pureXML is the native XML data management technology introduced in DB2 9. It consists of a hierarchical storage technology, XML querying languages (XQuery and SQL/XML), XML indexing technology and other XML-related features. This article brings them together by showing how you can develop pureQuery applications that handle pureXML data so you can get the best performance and manageability from your DB2 application.
08 Jan 2009  
 
Integration between XML Forms Generator and Data Studio, Part 1: Get started with the integration by creating an application
The XML Forms Generator (XFG) provides a jump-start for form development. It can quickly and automatically produce valid and functional forms containing XForms markup embedded within an XHTML document. The input to form generation can be an XML data instance with or without a backing XML Schema, or a WSDL document. Data Web Services, which is based on SQL scripts and Store Procedures, is a database related application of traditional Web Services. IBM Data Studio is a client tool for generating Data Web Services visually with the help of direct connection to database. The integration between XFG and Data Studio can enable to generate XForms/XHTMLs from Data Web Services generated by Data Studio. This integration provides advantages such as joining the development of UI pages and Data access seamlessly, reducing the workload of UI development from Data Web Services, visualizing the pureXML UI development with full-support of validation, etc.
19 Dec 2008  
 
Generate data-bound Extensible Application Markup Language using IBM Database Add-ins for Visual Studio
Create Windows Presentation Foundation XAML applications with ease utilizing IBM Database Add-ins for Visual Studio, without having knowledge of XAML or a deep understanding of IBM databases.
18 Dec 2008  
 
Discover new features in DB2 Express-C 9.5.2
IBM DB2 Express-C has been enhanced with several important features and improvements that were previously available only with fee-based versions of DB2 for Linux, UNIX, and Windows. Learn how you can take advantage of new capabilities such as DB2 Text Search, the administrative task scheduler, locale-sensitive UCA-based collations, and more.
18 Dec 2008  
 
Smoothly Blending Java and SQL with pureQuery
Discover how IBM's pureQuery data access platform to blend the use of Java and SQL.
17 Dec 2008  
 
Comparing XML database approaches
The increasing use of XML asks for systems that store semi-structured data without forcing it into inadequate data structures. These requirements are met by both native XML databases and relational databases with integrated XML support. The question is: Why should you prefer a native XML database over an XML-aware classic database or the other way around? This article compares the approaches for a number of varying solutions, including eXist, Mark Logic, and IBM DB2 Express-C. The differences are translated into practical advantages and disadvantages.
16 Dec 2008  
 
Build a DB2 pureXML application in a day
Build a complete DB2 application using an end-to-end XML architecture, for storing, viewing, and manipulating information. Being able to develop, augment, and modify applications through short iterations promotes an agile application development approach.
11 Dec 2008  
 
Configure high availability DB2 for Linux, UNIX, and Windows clusters on virtual machines using Xen and Heartbeat
IBM DB2 clusters on virtual machines (Xen) enable you to reap the benefits of utility computing and high availability. Virtual machines have become a key requirement for many enterprises. They help reduce the total cost of ownership and can be leveraged for development, testing, dynamic provisioning, high availability, no-downtime maintenance, and load balancing. In this article, learn all about how to configure and deploy IBM DB2 high availability on Xen with Heartbeat.
11 Dec 2008  
 
Integrating JPA and pureQuery: Leveraging DB2 static execution for the Java Persistence API
IBM WebSphere Application Server V7 delivers an enhancement to its implementation of the Java Persistence API (JPA) to enable optimization of data access to DB2 data servers for enhanced security, and the potential to significantly reduce overhead for data access. The optimization is achieved by using a built-in integration between the WebSphere JPA and IBM Data Studio pureQuery Runtime to enable static SQL access -- all without changing application code or running extensive test cases. This article uses a sample JPA application and takes you through the steps of enabling static SQL using the JPA/pureQuery integration. It also includes the optional follow-on step of using pureQuery client optimization to capture additional queries during run time.
10 Dec 2008  
 
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.
04 Dec 2008  
 
DB2 problem determination using db2top utility
Get the best possible performance in complex DB2 for Linux and UNIX environments with the db2top utility. Also, learn about the advantages this tool offers, and see how to use it for monitoring and troubleshooting.
04 Dec 2008  
 
What’s new and exciting in IBM Data Studio Developer 2.1
Discover how IBM Data Studio Developer 2.1 will give you a better understanding of your database application. See how the new implementation of Data Studio Developer can improve your productivity and enable better collaboration between developers and DBAs. Follow along with the scenarios in this article and experience how you can get more done, with greater ease and with greater insights, using Data Studio Developer 2.1.
03 Dec 2008  
 
Integrate IBM InfoSphere Warehouse data mining with IBM Cognos reporting, Part 2: Deviation detection with InfoSphere Warehouse and Cognos
Learn advanced techniques, such as drill-down and the extraction of structured information from data mining models with Cognos. Using the included business scenario and running example, understand the data mining task of deviation detection, that is, the task of identifying unnatural data records. See how to find such records with IBM InfoSphere Warehouse data mining, and create interactive reports that allow interactive exploration.
26 Nov 2008  
 
Create business reports for XML data with Cognos 8 BI and DB2 pureXML
Learn how creating relational views of hierarchical XML data as well as writing SQL-based queries over XML data can enable you to extract important information from XML documents and messages, integrate this information with existing relational data, and create reports for business analysts and executives.
26 Nov 2008  
 
Understanding IBM InfoSphere MDM Server security, Part 3: Using LDAP to implement transaction authorization
IBM InfoSphere Master Data Management Server allows you to plug in your transaction authorization provider. In this article, learn about the default transaction authorization provider and explore an example showing how to implement a transaction authorization provider using an LDAP server.
20 Nov 2008  
 
Recommended reading list: DB2 for Linux, UNIX, and Windows database administration
Learn about IBM DB2 for Linux, UNIX, and Windows with this reading list, compiled especially for the database administrator community. This popular article is updated to include the latest content that has been published for DB2 9
20 Nov 2008  
 
  1 - 100 of 879 results    Next   Show All   Hide Summaries
Not finding what you're looking for? Suggest Content