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

最新推荐文章于 2025-10-21 22:09:11 发布

原创最新推荐文章于 2025-10-21 22:09:11 发布 · 331 阅读

CC 4.0 BY-SA版权

文章标签：

3 篇文章

订阅专栏

2 篇文章

订阅专栏

本文介绍了DB2中实例静默操作的概念及其应用场景，并详细解释了不同SQLCODE的意义，包括信息性、警告性和负面性的代码含义。此外还概述了DB2配置管理的不同层面，以及DB2管理服务器的角色。

By Grant Allen

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.

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.

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).

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.