IBM Support

How to assign reports using Hive datasources to specific queues on Hadoop

Troubleshooting


Problem

By default reports which were built against HIVE datasources will be sent to a default processing queue on Hadoop. It turns out that during peak time this queue is over used and over loaded due to high processing user/system demand so how to assign Cognos reports which use a particular HIVE datasource to different and not over loaded queues ?

Symptom

Reports based on HIVE datasource connections run with good performance during off peak periods however the same report(s) will take much longer to get completed - sometimes hours.

When checking where on the server this(these ) reports are sent to, it is noticed they are being sent and put on a default queue for which use seems to be over capacity ( for example, it shows 200% usage while other queues shows less usage - please refer to screenshot )

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Administration and Configuration v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.7;11.0.6","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
13 January 2026

UID

swg22008289

Page Feedback