Use the Control Center to manage systems, DB2 Universal Database instances, DB2 for OS/390 subsystems, databases, and database objects, such as tables and views. In the Control Center, you can display all of your systems, databases, and database objects and perform administration tasks on them. From
Other News
SQL Server 2000 DTS Part 6 – DTS Designer Tasks and Package Workflow
(Marcin Policht) As we indicated in our previous article, we are going to continue discussing various ways of utilizing global variables in DTS Designer tasks. In particular, we will look into their role in exchanging data between packages, using features built into the Execute Package task. As part
Visual Studio.NET Database Projects
(Jeffrey P. McManus and Jack Goldstein) The database project is a special type of Visual Studio.NET project. Its purpose is to create and manage SQL database scripts. If you’re developing database applications with Visual Studio.NET, you will want to know about the tools available for making your wo
Introduction to XML Technologies
(Michael Palermo) In this chapter, we’ll look at current and upcoming Extensible Markup Language (XML). We’ll begin by describing what XML is and then talk about where it can help us, some related standards, and focus on some important design considerations when writing an XML application.
SQLWays – IBM DB2 Functions and Expressions
This chapter describes functions and expressions that can be used in IBM DB2 SQL statements.
Bulletproofing, Backups, and Disaster Recovery Scenarios
(Stephen Rea) Yes, you really can bulletproof your database so that it is always up and available and you never lose any data from almost any disaster scenario – for a price. You can run parallel servers in separate locations, have hot standby databases for quick switchovers, and implement replicate
Presenting Time Difference in the Form of Years, Months, and Days Using SQL
(Bertram Moshier) People traditionally think of differences between two dates in the form of years, months, and days instead of simply days or months with fractional portions. While Oracle provides easy to use methods to compute the differences between two dates (e.g. subtraction of dates or the ont
Announcing the New MODEL
(Jonathan Gennick) You’re writing a query that returns computed column values. As input to your calculations, you need values from multiple rows. What do you do? This is actually a fairly common problem. Solutions to it often involve inscrutable combinations of self-joins and subqueries. Oracle
Building a Security Infrastructure
(Rich Salz) In my previous column I offered a rationale for XKMS as an important web service, and I looked at reducing the problem of implementing such a service to a reasonable size. This time we’ll build the infrastructure necessary to develop and deploy an XKMS registration server that can issue
Atom Authentication
(Mark Pilgrim) I wish I didn’t need to write this article. My life would be much simpler if Atom could just use existing HTTP authentication, as-is. But it can’t; I’m going to tell you why and then I’m going to tell you what we’re doing instead. Let’s back up. Atom, in case you missed it, is a ne