When you replicate tables from Microsoft SQL Server 2000 or Microsoft SQL Server 7 to DB2/400 on an IBM AS/400 system through the Microsoft OLE DB Provider for DB2, you may need to qualify the table name to ensure that the table is placed in the right location. The qualified table name syntax is:

(Paola Bari, Pierre Cassier, Annamaria Defendi, John Hutchinson, Alain Maneville, Gianfranco Membrini and Caleb Ong) This IBM Redbook gives a broad understanding of the Workload Manager component of the z/OS system. It covers basic aspects of Workload Manager (WLM) together with the new functions a

(Elizabeth Millard) As companies come to rely more heavily on databases, major vendors are duking it out to outsell each other. In one corner is IBM’s DB2, a database management system that allows companies to build on-demand business applications. DB2 includes support for open standards and deve

(Roman Melnyk) A structured data type is a user-defined data type with elements that are not atomic; rather, they are divisible and can be used either separately or as a single unit, as appropriate. This article introduces you to the concept of structured data types and shows you, by way of working

(Roger Miller) Bonnie Baker is taking some time off from her writing duties, which gives me the opportunity to expand on the BIND saga she covered in her “Say What?” series of columns. These three valuable columns appeared in Q4 2003, Q1 2004, and Q2 2004 issues of DB2 Magazine and are still availab

(Qiang Lin) Enterprises realize that sole reliance on generic security mechanisms does not provide the protection they need for their business operations. More than just their employees need access to data in the database. Their partners and customers have access to these data as well. Therefore, th

To better protect the authentication information stored in the SYSIBM.USERNAMES table, a new DB2-supplied stored procedure, SYSPROC.DSNLEUSR is introduced in Version 8. This stored procedure stores the authorization ID and password in encrypted form in the SYSIBM.USERNAMES table. After this info

(Dana Morris) Organizations can use WebSphere Information Integrator OmniFind Edition to develop highly customized search applications to best fit their unique needs, requirements and mix of information sources. This article provides a technical overview of the WebSphere Information Integrator O

(Kameron Cole) In the book/movie The Princess Bride, Inigo Montoya says, “You keep using that word. I do not think it means what you think it means.” Whenever I hear the phrase “On Demand,” I am haunted by Montoya’s words.

(Gary Girard) With more than 20,000 employees and more than $1 billion in annual revenue, American Electric Power (AEP) is the nation’s largest electricity generator, a leading wholesale marketer of energy commodities and a major U.S. electric utility.