I think that every Database Administrator needs to read the article “Opinion: No more excuses for SQL injection attacks” and send it out to every application developer they know. I hate SPAM as much as the next guy but I think it is justified in this case. I am dead serious. We, the database people of all walks of life (DB2, Oracle, SQL Server …), have been talking about the benefits of using parameters in the queries instead of literal values for years. The main message has been “performance”. Most DBMS will perform much better and will use less server [...]
Read …
We are in the process of refreshing free DB2 Express-C to the new level i.e. v9.5.2. There are lots of enhancements that you will get as a result of this refresh. Customers that had DB2 Express-C subscription did have these enhancements delivered as part of FixPack 1 and FixPack 2. Now those of you that are using the free version of DB2 Express-C can also take advantage of all the goodness that the latest version of DB2 Express-C has to offer. This post is about a very small but sometimes very useful new feature in v9.5.2. At one point in [...]
Read …
When a database person mentions storage, images of cabinets full of disk drives and cables come to mind. But, since in my recent post I promised to talk about cloud computing I figured I’d talk about a different kind of storage. I am talking about storage that you can’t see or touch; I am talking about storage in the cloud. When Amazon (the people that sell us books and CDs) launched their web services AWS, S3 was one of the first services to go online. S3 stands for “Simple Storage Service”. Amazon built out a very significant IT infrastructure to [...]
Read …
DB2 Express-C comes with XML and Web Services support already backed. There is a free e-book from the experts in all things DB2 that supposedly helps you get the most out of these functions. The author of the section on automatic maintenance and utility throttling, Roger Sanders has written enough books on DB2 to fill a small library. If you ever decide to prepare yourself for a DB2 certification, you will most likely be using one of Roger’s books. Robert Catterall contributed the chapter on SOA performance. Robert has been working with DB2 since the dinosaurs roamed the earth (or [...]
Read …
Since table objects (or just tables) are so fundamental to your ability to store and retrieve data there comes a time when you want to get some information on a particular table in your database. For example, you may want to know how much disk space has been allocated for a particular table, or what state it is in. Should it be reorganized? Has the last load job finished loading data in to it and so on. If you were using MySQL, you may have just looked at the file that represents a table and were able to figure out disk usage that way. There is a better way to do this in DB2 Express-C (and every other DB2 for Linux, Unix and Windows v9.5). Since DB2 speaks SQL, it makes sense to query information about its tables using SQL. DB2 provides not one but 2 ways of getting cornucopia of information about tables via SQL. One way is to use a SYSIBMADM.ADMINTABINFO view. [...]
Read …
|
|
|
Follow Me!