IBM Certification IBM Db2 Database Administration 2

Question 1

What is the difference between 'BACKUP' and 'EXPORT' in IBM Db2?

Accepted Answer

BACKUP creates an offline copy of the entire database; EXPORT writes table data to a file in a portable format

Answer

BACKUP creates a full binary copy of the entire Db2 database for recovery purposes, while EXPORT writes table data to an external file in formats like CSV or IXF.

Question 2

In IBM Db2, what is the purpose of the 'db2diag.log' file?

Accepted Answer

Recording diagnostic and error messages from the Db2 instance for troubleshooting

Answer

The db2diag.log file is Db2's primary diagnostic log, recording internal errors, warnings, and informational messages used for troubleshooting and support.

Question 3

What does the Db2 'EXPLAIN' facility provide to a DBA?

Accepted Answer

The query execution plan showing how the optimizer will access tables and indexes

Answer

The EXPLAIN facility captures the query access plan chosen by the Db2 optimizer, showing table scan vs. index access methods, join strategies, and estimated costs.

Question 4

Which Db2 command is used to list all active database connections on an instance?

Accepted Answer

LIST APPLICATIONS

Answer

The `LIST APPLICATIONS` command displays all applications currently connected to Db2 databases on the instance, including their agent IDs and connection details.

Question 5

What is IBM Db2's 'autonomic computing' feature known as 'Self-Tuning Memory Manager' (STMM)?

Accepted Answer

A feature that dynamically adjusts memory allocations between buffer pools and internal memory heaps based on workload

Answer

STMM dynamically reallocates memory between buffer pools, the sort heap, and other memory consumers based on real-time workload demands, optimizing memory usage automatically.

IBM Certification Practice Test

IBM Certification Practice Test

IBM Certification IBM Db2 Database Administration 2