Learning Visually with Examples [Electronic resources]

Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow

نسخه متنی -صفحه : 312/ 245
نمايش فراداده

Chapter 17

A1:

The

? is the help command that can be issued from the CLP. It provides a description of the error.

A2:

You use the command

db2 ? sql0805n to get more information.

A3:

FFDC stands for first failure data capture.

A4:

There is no administration notification file in Windows. Administration notification logs are provided as part of the Windows Event Viewer.

A5:

The administration notification file in Linux/UNIX is

instance_name .nfy.

A6:

To capture the most information possible, set the DIAGLEVEL Database Manager Configuration parameter to 4.

A7:

The db2support tool captures all the necessary information that DB2 Technical Support needs to research a problem.

A8:

The command

db2trc is used to capture DB2 traces.

A9:

db2diag.log is located in the directory

$HOME /sqllib/db2dump, where

$HOME is the home directory of the instance owner.

A10:

To receive e-mail notification messages, you must use NOTIFYLEVEL 2 at least.

A11:

C . All FFDC information, including the administration notification log, is kept in the path specified by the Database Manager Configuration parameter DIAGPATH.

A12:

A . NOTIFYME is not a database manager configuration parameter.

A13:

B . NOTIFYLEVEL = 1 only logs fatal and unrecoverable errors.

A14:

C . SMTP hostname is defined in the database manager configuration file.

A15:

D . Trap files are normally reviewed only by DB2 Technical Support.

A16:

C . Application log file is not collected with the db2support tool.

A17:

D . 3 is the default DIAGLEVEL.

A18:

D . DIAGLEVEL 3 is the recommended value which is also the default value for DIAGLEVEL.

A19:

D . DIAGPATH is set to NULL by default.

A20:

D . CONTACT_LIST_GROUP is not a DAS parameter.