IBM
C2090-312 · Question #193
Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data…
The correct answer is D. ADMIN UPDATESYSPARM. See the full explanation below for the reasoning.
Question
Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data set or as a result set?
Options
- AADMIN_INFO_SQL
- BADMIN_JOB_QUERY
- CADMIN_INFO_SYSPARM
- DADMIN UPDATESYSPARM
How the community answered
(39 responses)- A3% (1)
- B13% (5)
- C8% (3)
- D77% (30)
Community Discussion
No community discussion yet for this question.