IBM Exam C2090-623 Topic 1 Question 67 Discussion

Actual exam question for IBM's C2090-623 exam

Question #: 67
Topic #: 1

[All C2090-623 Questions]

An administrator must troubleshoot query execution related issues in a DQM executed report.

How is this achieved?

ABy default, settings to trace DQM Query execution are enabled in the system.

BOpen IBM Cognos Configuration, under IBM Cognos Services/IBM Cognos, select QueryService and check Enable Query execution trace and view logs in /logs/XQE

COpen IBM Cognos Administration portal, on the Configuration tab, select Dispatchers and locate QueryService and check Enable Query execution trace and view logs in /logs/XQE

DEdit the install_location/configuration/qfs_config.xml.sample file and set , save as qfs_config.xml, restart services.

Show Suggested Answer

Suggested Answer: C

A query execution trace (run tree trace) shows queries that run against a data source. You use the trace to troubleshoot query-related issues.

You can find execution trace logs in the following location:

c10_location/logs/XQE/reportName/runtreeLog.xml.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.0/com.ibm.swg.ba.cognos.ug_cog_rlp.10.2.0.doc/t_configsettings.html

by Ardella at Jul 17, 2024, 07:28 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ashton

10 months ago

I don't know about you, but I always feel like a secret agent when I'm digging around in the Cognos config files. Option D for the win!

upvoted 0 times

...

Elliott

10 months ago

Wait, did they just say 'DQM' report? I thought we were done with that dinosaur of a system. Oh well, I guess option B is the way to go.

upvoted 0 times

Darrel

9 months ago

Make sure to check the logs in /logs/XQE after enabling the query execution trace.

upvoted 0 times

...

Scarlet

9 months ago

That's right. By enabling query execution trace, you can troubleshoot any issues with DQM reports.

upvoted 0 times

...

Stephen

9 months ago

Option B seems like the way to go. Enable Query execution trace in IBM Cognos Configuration.

upvoted 0 times

...

Shannon

9 months ago

Yeah, they mentioned troubleshooting DQM reports. It's still around, I guess.

upvoted 0 times

...

Johna

10 months ago

Ah, the old qfs_config.xml trick! Option D is my pick. You can never go wrong with a good ol' config file edit.

upvoted 0 times

Brynn

9 months ago

Definitely, editing the qfs_config.xml file is a reliable method.

upvoted 0 times

...

Dortha

9 months ago

I agree, option D is the way to go.

upvoted 0 times

...

Essie

10 months ago

Option C seems like the way to go. I always prefer to handle these things through the admin portal, it just feels more... official, you know?

upvoted 0 times

Barb

9 months ago

Definitely. It's important to have a centralized location for managing system configurations.

upvoted 0 times

...

Skye

10 months ago

Yeah, I agree. It's easier to manage settings in the admin portal. Plus, it's all in one place.

upvoted 0 times

...

Hollis

10 months ago

Option C seems like the way to go. I always prefer to handle these things through the admin portal, it just feels more... official, you know?

upvoted 0 times

...

Ivan

10 months ago

I'm not sure, but D sounds like a plausible option as well.

upvoted 0 times

...

Cherelle

10 months ago

I believe it's C, because that's where you can enable query execution trace.

upvoted 0 times

...

Sharen

10 months ago

Hmm, looks like we need to enable the query execution trace to troubleshoot DQM report issues. I'd go with option B - that seems the most straightforward approach.

upvoted 0 times