IBM Exam C2090-318 Topic 2 Question 23 Discussion

Actual exam question for IBM's C2090-318 exam

Question #: 23
Topic #: 2

[All C2090-318 Questions]

Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?

A-STOP DATABASE

B-START DATABASE

C-DISPLAY DATABASE

D-ACCESS DATABASE

Show Suggested Answer

Suggested Answer: D

TheDb2command ACCESS DATABASE forces a physical open of a table space, index space, or partition, or removes the GBP-dependent status for a table space, index space, or partition, or externalizes the real-time statistics and optimizer statistics recommendations from in-memory blocks to the appropriate catalog tables. The MODE keyword specifies the desired action.

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/comref/src/tpc/db2z_cmd_accessdatabase.html

by Brett at May 04, 2022, 09:10 AM

Limited Time Offer

25%

Off

Get Premium C2090-318 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!