Learning Visually with Examples [Electronic resources]

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

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

17.11. Review Questions

1:

What does the

? command do?

2:

An application developer tells you that he received an SQLCODE of -805. What command can you use to obtain more information?

3:

What does FFDC stand for?

4:

What is the name of the administration notification file in Windows?

5:

What is the name of the administration notification file in Linux/UNIX?

6:

How can you ensure the file db2diag.log captures the most information possible?

7:

What does the db2support tool do?

8:

What command is used to create a DB2 trace?

9:

Where is the db2diag.log file placed by default for Linux and UNIX platforms?

10:

What is the minimum NOTIFYLEVEL value required to receive e-mail messages?

11:

Which of the following is used to determine where the administration notification log file will reside on UNIX?

  1. path

  2. adminpath

  3. diagpath

  4. notifypath

12:

Which of the following is

not a Database Manager Configuration parameter used for FFDC?

  1. NOTIFYME

  2. NOTIFYLEVEL

  3. DIAGLEVEL

  4. DIAGPATH

13:

Which of the following levels for NOTIFYLEVEL only logs fatal and unrecoverable errors?

  1. 0

  2. 1

  3. 2

  4. 3

14:

Which of the following commands can be used to update the parameter to indicate the host name of the SMTP server?

  1. update admin cfg using SMTP

    hostname

  2. update dbm cfg using SMTP

    hostname

  3. update admin cfg using SMTP_SERVER

    hostname

  4. update admin cfg using SMTP_SRV

    hostname

15:

Which of the following files is not something a DBA would normally review to resolve a problem with DB2?

  1. db2diag.log

  2. Adminstration notification file

  3. The DB2 manuals

  4. Trap files

16:

Which of the following is not collected with the db2support tool?

  1. db2diag.log

  2. Adminstration notification file

  3. Application log file

  4. Trap files

17:

Which is the default value for DIAGLEVEL?

  1. 0

  2. 1

  3. 2

  4. 3

18:

Which is the recommended value for DIAGLEVEL?

  1. 0

  2. 1

  3. 2

  4. 3

19:

Which is the default value for DIAGPATH?

  1. SQLLIB

  2. DB2DUMP

  3. DUMP

  4. NULL

20:

Which of the following is not needed to enable e-mail notification?

  1. Add contact information using the ADD CONTACT command.

  2. Update the health notification contact list.

  3. Update the CONTACT_HOST DAS parameter.

  4. Update the CONTACT_LIST_GROUP DAS parameter.