IBM C2090-623 Exam Dumps

Question

When testing a JDBC connection to Microsoft SQL Server 2005 / 2008 / 2012 you receive the error XQE-JDB-0004 A problem occurred finding the driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.

Cause

The JDBC connector is missing or not properly installed for Cognos Answer

You may need to download the .JAR files from Microsoft download center site:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

or search for 'Microsoft JDBC Driver for SQL Server' via your favorite search engine.

Follow the Microsoft instructions to download and install.

References: http://www-01.ibm.com/support/docview.wss?uid=swg21623909

Specify if Configuration Objects and Children are Part of Deployment.

You can specify if configuration objects and their children are included as part of deployment. By default, they are not included.

You can change the default setting using the advanced setting

CM.DEPLOYMENTINCLUDECONFIGURATION.

By default, it is set to False (do not include configuration objects in deployments).

To change the default to include configuration objects and their children, set it to True.

References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 384

Access Manager provides a centralized environment to define, store, and maintain security information for IBM Cognos business information applications.

In one central location, you can set up and maintain secure user access to data, such as cubes and reports, that are created in other IBM Cognos applications. With Access Manager, you can also set up and maintain user signon information and auto-access privileges for the data sources and servers that contain the required data.

References: http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/accman/7.4mr4/accessadm.pdf

You can use logs to diagnose a problem that is occurring for one or more specific users.

You enable and disable logging for specific users by using the Remote Process service for Java Management Extensions (JMX), a technology that supplies tools to manage and monitor applications and service-oriented networks. You connect to the JMX Remote Process service using the jconsole executable that is provided with the Java JDK.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_disableipfuser.html

If your installation includes more than one dispatcher, you can specify the proportion of requests that each dispatcher handles by changing their processing capacity. This is commonly referred to as load balancing. You typically set the capacity for a dispatcher based on the CPU speed of the computer where it is installed.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.crn_arch.10.2.1.doc/c_arch_dispatcher.html