Reading Notes: Beginning.DB2.From.Novice.to.Professional.Aug.2008

By Grant Allen

 

 

1. Why Expedia do not buy DB2 Data Warehouse edition

 

1. For those unfamiliar with the concept, quiescing something is the act of placing it out of the bounds of normal operation and restricting access or use to a specific purpose or user. In the case of DB2, quiescent an instance is akin to placing the whole instance into a special administrative mode, in which only the system administrators can then perform work. This is usually the precursor to some restrictive or intrusive maintenance.

 

1. A SQLCODE that ends in the letter I (Informative)

is for information purposes only and is usually an indication of normal operation. A SQLCODE that ends in the

letter W (Warning) is a warning of some kind that is worth reading but usually doesn’t need remedial action. A

SQLCODE that ends in the letter N (Negative) means an error of some kind has occurred, and you might then

need to investigate that problem in more detail.

 

1. The instance-level configuration is formally known as the Database Manager Configuration (DBM), and the database-level for each database is known as the Database Configuration (DB).

 

1. You’ll recall that the DB2 Administration Server (DAS) is a special “lightweight” instance of DB2 that doesn’t actually directly manage any databases. Instead, its job is to allow various tasks such as remote administration.