(Keith McDonald) Continuing with the command line options from the last post, we have the -n option that takes one argument which is the node name or instance name. This becomes useful when you want to pass to the -d option the name of a database that exists under a different node than the default n
Tag: IBM
Deploy your database applications and projects on the cloud
(Rav Ahuja and Bradley Steinfeld) Cloud computing is an increasingly popular paradigm that can significantly accelerate development and prototyping cycles. In this tutorial you will learn how you can easily deploy your database applications and projects on the cloud in just minutes using IBM DB2 dat
DB2 LUW Security — Revoking DBADM (REALLY)
(Rebecca Bond) It’s always a good idea to verify that revokes did what you wanted them to do. With DB2 9.7, when revoking DBADM, you may leave behind ACCESSCTRL and/or DATAACCESS without realizing it.
pureQuery performance results for DB2 for Linux, UNIX and Windows!
(Simon Harris) I’m the performance architect for, among other things, the pureQuery platform. My team has the responsibility for not just ensuring that our products perform well, but also to help produce verifiable performance numbers that we can share with confidence.
Introducing entity subtypes in IBM InfoSphere Master Information Hub
(Stephanie J. Hazlewood and Lin Qiao) In this tutorial, learn how to implement entity subtypes and supporting services for IBM InfoSphere Master Data Management Server and InfoSphere Master Information Hub. Using an entity subtyping framework allows you to introduce new entities that may be process
Some Basic Information About SQL in DB2-Accessing Programs
(Robert Catterall) DB2 has been around for a long time (more than 25 years), and a lot of people who work with DB2 have been doing so for a long time (myself included). Many of the younger folks I meet who are professionally engaged in DB2-related activity are developers. Some of these who came to D
db2top Feature of the Day – Command Line Options (-h and -d)
Today, I’m going to start writing about db2top command line options. There are many. I’ll start with -h (help) and -d (database). The -h option gives you the key to all the others:
WebSphere DataPower SOA Appliance performance tuning
(Karim Ouda) This article provides performance tuning approaches, guidelines and tips for IBM WebSphere DataPower SOA Appliance, since performance is a key attribute for WebSphere DataPower it is very important to be able to tune the device to achieve expected performance results.
Performance features in DB2 V9 for z/OS – Part 17
(Dave Beulke) Some of the new tablespace partitioning choices and features in DB2 Version 8 and now DB2 Version 9 for z/OS that I talked about last week are getting extra enhancements. During the recent IBM System Z Summit road show that was in Washington DC last week, a number of other tablespace
Upgrading DB2 Express 9.5.4 to DB2 Express C 9.7.1
(Radim Kolar) Another DB2 upgrade mini-guide. I was asked to upgrade DB2 Express 9.5.4 to DB2 Express 9.7. Reason for this was that old DB2 Express 9.5.4 was 90-day demo version and demo key expired. Upgrading DB2 will generate new 90-day key and allows to use DB2 for some more time which would be e
