| 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?- path
- adminpath
- diagpath
- notifypath
|
| 12: | Which of the following is not a Database Manager Configuration parameter used for FFDC?- NOTIFYME
- NOTIFYLEVEL
- DIAGLEVEL
- DIAGPATH
|
| 13: | Which of the following levels for NOTIFYLEVEL only logs fatal and unrecoverable errors?- 0
- 1
- 2
- 3
|
| 14: | Which of the following commands can be used to update the parameter to indicate the host name of the SMTP server?- update admin cfg using SMTP hostname
- update dbm cfg using SMTP hostname
- update admin cfg using SMTP_SERVER hostname
- 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?- db2diag.log
- Adminstration notification file
- The DB2 manuals
- Trap files
|
| 16: | Which of the following is not collected with the db2support tool?- db2diag.log
- Adminstration notification file
- Application log file
- Trap files
|
| 17: | Which is the default value for DIAGLEVEL?- 0
- 1
- 2
- 3
|
| 18: | Which is the recommended value for DIAGLEVEL?- 0
- 1
- 2
- 3
|
| 19: | Which is the default value for DIAGPATH?- SQLLIB
- DB2DUMP
- DUMP
- NULL
|
| 20: | Which of the following is not needed to enable e-mail notification?- Add contact information using the ADD CONTACT command.
- Update the health notification contact list.
- Update the CONTACT_HOST DAS parameter.
- Update the CONTACT_LIST_GROUP DAS parameter.
|