IBM Support

Slow performance when Windows Task Scheduler used to build a cube in Transformer

Troubleshooting


Problem

A batch file is used to build a cube in Transformer by command line options. When the batch file is scheduled using the Windows integrated 'Scheduled Tasks' scheduler it takes e.g. 3 to 4 times the time to build the cube compared to building the cube by double clicking the batch file. This can also be seen when starting the cube building process from the Windows task scheduler by right click and choosing 'run'.

Cause

The task had a low priority in Windows Scheduler (e.g. because it was scheduled to run as a background process).

Environment

Windows

Resolving The Problem

Make sure the task scheduling the cube build has a higher priority. For details contact the system administrator of the Windows Server or even the vendor of the scheduler used. Regarding Windows 'Scheduled Task' scheduler it might help to detect the current priority of a task, to export the task to a *.xml file. When this file is opened in an editor the priority tag may look like:

<Priority>7</Priority>

you could change it to a higher setting for example:


<Priority>3</Priority>

and import it again.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4.1;8.4;8.3;10.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21579012