SybasePhone Number

Abstract: This white paper provides information about using Sybase Adaptive Server Enterprise (ASE) version 15.7 as the IBM Cognos software Content Store, which is the repository for the Cognos Report Server and Modeling software environments. IBM supports Sybase ASE as a Content Store with JDBC connectivity using the Sybase jConnect 6.05 JDBC driver.

Audience: The intended audience is system administrators responsible for configuring the Content Store in a Cognos software environment.

Author: Jeannette Smith, Sybase Application Engineering Team

Revisions:

Revision Description Author Date
1.0 First version white paper. J. Smith August 2012

Contents


Overview

IBM Cognos Business Intelligence is a multiple-tier, enteprise reporting software environment. It provides both data modeling and reporting capabilities. The Cognos Content Store is the content management repository for this environment. Cognos supports several databases as its Content Store, including Sybase Adaptive Server Enterprise (ASE). Sybase ASE is supported using JDBC connectivity with the Sybase jConnect JDBC driver. The IBM Cognos product documentation provides information about this option. This white paper is intended as a supplement to the IBM documentation to provide additional, specific information about using Sybase ASE and jConnect for the Cognos Content Store.

Installing and configuring Sybase ASE to be the Content Store with jConnect JDBC connectivity consists of the following tasks:

  1. Configuring ASE to run with required settings
  2. Creating a database device, database, login, and user within ASE
  3. Installing jConnect
  4. Configuring the Cognos software to use jConnect
  5. Configuing Cognos to use the Content Store in Sybase ASE

The information contained herein is based on using Sybase ASE version 15.7 ESD #1 with the Sybase jConnect JDBC driver version 6.05 as the Content Store for the Cognos 10.1.1 Business Intelligence software. The server component configuration was tested on two platforms: 64-bit Microsoft Windows 2008 R2 and 64-bit SUSE Linux 11.0 machines. This information should apply to other supported operating systems as well.


Configure Sybase ASE to be the Content Store

This section describes how to configure a Sybase ASE data server to host a Cognos Content Store. Before you perform the tasks described here, read the information provided in the IBM Cognos Business Intelligence version 10.1.1 Installation and Configuration Guide. See the References section at the end of this paper for a list of relevant sections. To summarize the Cognos guide in terms of requirements and recommendations for a Sybase ASE content store, you need to perform the following tasks.

  • Configure the ASE data server with a page size of 8K
  • Configure the ASE data server with the UTF-8 character set and a UTF-8, case-insensitive sort order
  • Configure the ASE data server to start automatically. To ensure optimal reliability as the Cognos Content Store, you need to configure ASE to start before the Cognos service. Configuring ASE to start automatically when its host machine reboots, helps to ensure this happens. Note that on Microsoft Windows the Sybase installation program creates Windows services for the ASE servers, but configures them to start manually. You need to configure them to start automatically.
  • Set the select into/bulkcopy/pll sort option on the database. This is required by Cognos. Sybase also recommends setting the trunc log on checkpoint option, which trunctes the Cognos Content Store database log when a database checkpoint occurs. Setting these options is described in a following section, Creating the ASE objects for the Content Store.

You can perform the required tasks using the Sybase Server Config configuration tool in an existing ASE installation or during the data server configuration stage of the ASE installation, by selecting the "Custom" server configuration option. Both methods are described in this paper.

Configuring the data server during ASE installation

The following steps describe how to install and configure the ASE data server to be the Cognos Content Store during installation. The GUI installation programs for all platforms should be similar enough that these steps will apply.

  1. Always read the Sybase ASE Installation and Configuration Guide and Release Bulletin for your platform and version before installing Sybase ASE. The Release Bulletin provides the latest information about installing and using ASE.
  2. Run the ASE installation program.
  3. Proceed through the installation program. The test installation selections consisted of a Typical installation type with an Enterprise Edition and Server License (SR) and, on Windows, with the option to create Windows services. Your selection will depend on your license type. The ASE installation guide provides information about licensing selection.
    ASE install license types
  4. Continue through the installation program until you reach the panel prompting you about configuring the ASE servers.
  5. Select the option to perform a Custom configuration and click Next. The Configure New Adaptive Server panel opens. The first server you configure is the data server. It is the server that will host the Cognos Content Store.
    Configure ASE with requirements
  6. Select 8k from the Page Size drop-down list. The installation program displays the following warning: "...You have selected '8192' as the logical page size for the Adaptive Server. If you plan to load dump from another database, make sure this logical page size matches the size of the source database. The default logical page size in previous Adaptive Server versions was 2KB." You can ignore this message when you are creating a data server to host a Cognos Content Store for the first time. For information about loading a database dump from a previous version, refer to the Sybase ASE product documentation.
  7. Select a UTF-8 character set and appropriate sort order. The tested sort order was utf8_nocase: Caseinsensitive ordering, for use with any utf8-based 8-bit environment.
  8. Specify any other configuration settings you want. The default values for the other options and servers were used in testing. The ASE servers are named with the host machine name in all-capital letters by default. For example, the ASE data server is named with just the host machine name in all capital letters (MACHINENAME), the Backup Server and Monitor Server are named with the host machine name, an underscore and then "BS" (MACHINENAME_BS) or "MS." Refer to the ASE product documentation for information about configuring ASE servers.
  9. Proceed to configure the other servers, such as Backup, Monitor or XP server. The default values for all these were also accepted in the test environment.
  10. When you finish, click Next. The installer displays the Configure New Servers Summary showing the configuration selections you made.
  11. Verify the Page Size, Character Set and Sort order are set as required for Cognos. Click Previous and go back to change them if they are not.
  12. Click Next to finish the configuration. When the installation program finishes, it reports the success or failure of the installation and configuration. On Windows, you may be prompted to reboot the machine.
  13. After installation, you can configure ASE to start automatically as appropriate for your operating system. If you are installing on Microsoft Windows, you can configure the Windows services to start automatically. See Note 2 for information about how to do this.

You are now ready to create the database objects in ASE that are required for the Cognos Content Store. Proceed to the section Creating the ASE objects for the Content Store.


Configuring a new ASE data server in an existing ASE installation

To configure a Sybase ASE data server to be the Cognos Content Store in an existing ASE installation, you use the Sybase Server Config tool. On Windows, the application is available on the Start menu. On UNIX and Linux, it is called asecfg and is available in the ...ASE-15_0/bin directory. The following instructions describe how to use Sybase Server Config to create and configure ASE with the settings required for the Cognos Content Store. Note that the sample screens shown are for the Windows version of the tool. The UNIX/Linux version is similar.

  1. Run Server Config by choosing Start | Programs | Sybase Adaptive Server Enterprise | Server Config on Windows, or by running asecfg from the $SYBASE/ASE-15_0/bin directory on UNIX/Linux. On the UNIX/Linux platforms, you must set the Sybase variables with the SYBASE.(c)sh variable script before you use asecfg. You may also need to set the $LANG variable on Linux. The Server Config tool opens with the Configure Sybase Servers panel.
    Server Config Configure Sybase Servers
  1. Under Products on the left, you select Adaptive Server, which is the data server option. Then indicate if you want to create a new one or re-configure an existing one by choosing the appropriate button. If you have an existing data server that uses the 8k page size, you may be able to use it to host your Cognos Content Store. If not, you will have to create a new data server. Regardless of which you choose, the Enter the System Administrator Password dialog box opens. Note that the Server Config tool loses focus easily and may be hidden behind other applications.
    Server Config login
  1. Log in with an administrator user and password. For example, the sa user, which does not have a password set initially by default. If you are creating a new data server, the Adaptive Server Name panel opens. If you are configuring an existing server, proceed to step 9.
    Create ASE
  2. Enter the name of the new data server and click Continue.The Server Page Size panel opens.
    Select the 8k page size option
  3. Select 8k from the Server page size drop-down menu and click Continue. Server Config will display the following warning: "...You have selected '8192' as the logical page size for the Adaptive Server. If you plan to load dump from another database, make sure this logical page size matches the size of the source database. The default logical page size in previous Adaptive Server versions was 2KB." You can safely ignore this message when you are creating a data server to host a Cognos Content Store for the first time. For information about loading a database dump from a previous version, refer to the Sybase ASE product documentation.
  4. Dismiss the warning and continue through the Server Config panels to create the data server. This will include setting the path, device and database file size for the ASE system databases (master, sybprocs, two-phase commit and tempdb), as well as the error log path, network addresses, command line parameters, and others. If you are not familiar with this process, refer to the Sybase ASE product documentation or your Technical Support contact.
  5. When you finish providing all the information necessary to create the new server, Server Config will display a task bar showing you the progress of the server creation. At the end, it will report the status of the creation. When it succeeds, continue to the next step to configure it. If it fails, troubleshoot the problem based on the error and try again.
  6. Display the Configure Sybase Servers panel again, which may mean opening Server Config again.
  7. With Adaptive Server selected under Products, click the Configure Adaptive Server option this time. The Configure Adaptive Server panel opens.
    Server Config - configure ASE
  8. When the Configure Adaptive Server panel opens, configure the required UTF-8 character set and sort order by clicking Language. The Language Options dialog opens with the Current Defaults (for example on Windows, Language = us_english, Character Set = cp850 and Sort Order = binary shown below) grayed out..
    Server Config Language Options
  9. Specify you want to add a character set by clicking the Add/Remove button under Character Set in the Change Options area of the panel and then click OK. The Install Character Sets panel opens.
    Server Config Install Character Sets
  10. From the Available window at the top of the panel, you scroll down to select Unicode 3.1 UTF-8 Character Set and then click the Add button to add it as a character set for this machine. The Unicode character set will be listed in the Selected window at the bottom of the screen as shown above. Click OK. Caution! Do not remove any of the other character sets listed in the Selected window. Doing so may damage your ASE servers. The Language Options panel opens again.
  11. Under Character Set again, click Set Default. The Change Default Character Set panel opens showing a list of installed character sets.
  12. Select the Unicode 3.1 UTF-8 Character set to set it as the default character set for the data server and click OK. It will be highlighted. The Language Options panel opens again.
    Server Config Set Default Charset UTF-8
  13. Set the default sort order by clicking Set Default under Sort Order and clicking OK. The Select Default Sort Order panel opens.
    Set default sort order
  14. Choose a sort order approriate for the UTF-8 character set and click OK. In the test environment, the Case insensitive order, for use with any utf8-based 8-bit environment.
  15. Click OK and the Configure Adaptive Server panel displays again.
  16. Perform any additional configuration you want and then click Save. After you click Save, Server Config displays a dialog box reporting the configuration status: “Executing Task To: default charcter set....This may take awhile.” It will stop and restart ASE. If it encounters any errors during this process, you need to note the error, check the ASE log, and troubleshoot accordingly. When it finishes, the Configure Sybase Server panel should re-open.
  17. Click Exit to exit the Server Config utility.

With the ASE server installed and configured, you are ready to set it up to host the Cognos Content Store.


Creating the ASE objects for the Content Store

This section describes how to create within ASE the objects required for the content store. The "Suggested Settings for Creating the Content Store in Sybase" section in Chapter 4 of the Cognos Installation and Configuration Guide instructs you to create an ASE database device, database and user for the Content Store. Addtitionally, Sybase recommends creating two devices and a login as described here.

This section describes how to use Sybase Central, the Sybase system administration utility, to create objects in ASE for the Cognos Content Store. Note that you can use another method, such as SQL statements submitted through an Interactive SQL utility, instead. This section is divided into the following tasks, which should be performed in the order presented:

  1. Create the database devices
  2. Create the database and log
  3. Set the required database options
  4. Create a login and user to be the Cognos Content Store administrator
  5. Grant required privileges to the database user

1. Create the database devices

The database device is the physical location to which the logical database and database logs are written. These steps describe creating the device as a file system file. Sybase recommends creating a database and its log on separate devices for disaster recovery reasons. Thus, these instructions describe creating two devices. If you are setting up a test environment, you can may want to create one device for now.

  1. Open Sybase Central by choosing Start | Programs | Sybase | Sybase Central and connecting to the Sybase ASE data server with an administrative user. For example, use the default user 'sa' without a password. Refer to the Sybase ASE System Admininstration Guide for information about performing any of the tasks described in this section. When you are connected to the server, you will see a list of objects on the left.
  2. Create the first of two database devices for the Cognos Content Store.
    1. Locate and select the Database Devices folder on the left, right-click and choose New... | Database Device. A list of existing devices open in the right pane and The Add Database Device wizard opens with the "Add Database Device - Specify the Name and Path" panel. Create Device
    2. In the Device path field, specify the location and file name you want for the device. This step shows how to create the device as a file system file in the Sybase ASE installation data directory (C:\Sybase\data by default on Windows), which is where the master database device is created by default during ASE installation. In the Device path field, be sure to include the .dat extension with the device name. The first part of the device name is arbitrary but a meaningful name is recommended. The "Specify the name of the database device field" fills in with the file name you specified in the Device Path but without the .dat extension.
    3. Click Next. The Add Database Device - Advanced Options panel opens.
      Create device advanced options
    4. In the Specify the size of the device field, enter the size you want for the device. For the test device, we set the device size to 500 MB. The sample screen shows 200 MB. But this is merely an example and neither are recommendations. The Cognos documentation does not recommend a size. If you are unsure, you may want to consult with Sybase or Cognos Technical Support about what is appropriate for your situation.
    5. Click Next. The "Add Database Device - Specify a Write Option" panel opens. It provides options for how data are transferred to the device: data sync, Direct IO or Cached IO (data sync off). Make your selection based on the performance and integrity you want. See the ASE product documentation for more information about these options. In testing the default Data sync option, which guarantees writes to disk take place, was used. However, this may not be the most performant option.
    6. Click Next to proceed through the wizard to finish creating the device. The Cognos Installation and Configuration Guide instructs you to "Set the new database device as the default." The meaning of this is unclear. It is common practice, however, to set a default database, not device, for a login or user. This ensures that the user connects to a specific database by default. More information about this is provided later in section 4. Create a login and user to be the Cognos Content Store administrator.
  3. Repeat the previous steps to create a second device. When you are finished creating the devices, you are ready to create the database. Note that Cognos documentation recommends keeping a backup of the database device for recovery purposes. Refer to the Sybase ASE system administration documentation for information about recommended back-up procedures.

2. Create the database and log

Create the database that will host the Cognos Content Store as follows:

  1. Still within Sybase Central, select the Databases folder on the left, double-click and choose New... | Database from the pop-up menu. The list of existing databases opens in the right pane and the Add Database wizard opens with The Add Database - Specify a name panel.
  2. Enter a name appropriate for the Cognos Content Store and click Next. The Add Database - Device Information panel opens prompting you to choose the devices on which you want to allocate space for the data and log. The Cognos Installation and Configuration Guide provides only one suggestion in relation to the database creation and that it is to set the log segement to be a minumum of 10 MB. Again, you may want to consult IBM Technical Support about what would be appropriate.
  3. Click Add. The Specify Device and Size dialog box opens prompting you to select a device and then allocate space on it for the database data or log.
    Create database allocate space
  4. Select the device you created for the database, select the Data radio button under "The contents of this device will be:," allocate space for the database data in the Size field, and click OK.
  5. Click Add again and this time select the device you created for the log, select the Transaction Log radio button, allocate space for it, and click OK. The sample screens show 75 MB allocated for data and log. This is just shown for example and is not a recommendation.
    Database and log allocations
  6. Click Next to proceed through the wizard. The "Specify Database Options" panel opens next. It provides the With override option. If you have the recommended separate devices, it will be selected and grayed out by default. If you are testing and chose to just create one device, you need to select this option. In our test environment, we left the For Load option deselected.
  7. Click Next to proceed through the Create Database wizard. In the test environment, the remaining defaults were accepted with the exception that we chose to create a Guest User. Accept the remaining database creation default values and finish the wizard.

3. Set the required database options

Enable the following two database options on the Content Store database: select into/bulkcopy/pllsort and trunc log on chkpt. The first is required by Cognos; the second is recommended by Sybase. The options are available as options in the Sybase Central Database Properties.

  1. Display the options for the database you just created, by right-clicking it and choosing Properties from the pop-up menu. The Properties dialog box opens.
  2. Display the Options tab, scroll through the list of options, and select select into/bulkcopy/pllsort and trunc log on chkpt.
    Set Cognos DB options
  3. Click OK to save them.

4. Create a login and user to be the Cognos Content Store administrator

Perform the following steps to create a login and user with the required privileges for the Cognos database in Sybase ASE. This includes specifying the Cognos database as the default database for the login. This will ensure that the user is in the correct database context for Cognos.

Note that in situations where one Sybase ASE server may host more than one Cognos Content Store, the Cognos Installation and Configuration Guide recommends creating a separate user to manage each Content Store. In this case, Sybase recommends creating a separate login and user for each as follows.

  1. Still within Sybase Central, locate the Logins folder and double-click to open it. The list of existing logins and Add Login wizard open in the right-pane.
  2. Double-click Add Login to open the wizard.
  3. Proceed through the wizard. Give the login a meaningful name, like CognosAdmin, and specify the Content Store database you just created to be the login's default database.
  4. When you reach the panel that provides the option to create users with the same name based on the login, specify that you want a user created in the Content Store database you just created. The users created for the login are added to the "public group."
  5. When you reach the summary panel, review the information about the login and users and click Finish to save the login and exit the wizard.
  6. Assign a role with administrative privileges to the login through the Sybase Central Login Properties by right-clicking the role and choosing Properties.
  7. Display the Roles tab and click Add. A list of available roles opens. Note that earlier versions of the Cognos installation guide required that the SA_ROLE be assigned. Thus, it was selected in the test environment.
  8. Scroll down and select SA_ROLE with Active By Default and click OK. The SA_ROLE will be listed as active by default in the "Roles granted to this login" window.
  9. Click Set Default, and then Apply and OK.
  10. Verify the user was created in the database by displaying the database users. It may not initially be listed. Refresh the Sybase Central view if necessary.

5. Grant required privilges to the database user

Finally, grant the Cognos required privileges to the database user. This allows the configuration program to use this user to create and populate the Content Store tables.

  1. Still within Sybase Central and connected to Sybase ASE, display the Users folder under the database you created to be the Content Store.
  2. Right-click the user you created and choose Properties from the pop-up menu. If it does not initially display, refresh Sybase Central.
  3. Display the Commands tab. The Cognos Installation and Configuration Guide says to ensure the user has the following privileges: CREATE DEFAULT, CREATE PROCEDURE, CREATE RULE, CREATE and DROP TABLE, and CREATE VIEW. Note that DROP table is not an option on the Commands tab, so you may need to grant it through interactive SQL.
  4. Click the status field to the right of the command to grant a privilege. Be careful doing so. If you click more than once, the privileges change and may be revoked.
  5. With the Commands granted, click OK to save the changes.
  6. Finish the wizard, exit Sybase Central, and reboot the machine to restart all the ASE servers.

Sybase ASE is now configured to host the Cognos Content Store. You are now ready to install the Sybase jConnect 6.05 driver to provide the JDBC connectivity between the Cognos software and the Sybase ASE Content Store.


Set up Sybase jConnect JDBC connectivity for the ASE Content Store

Setting up the Sybase jConnect 6.05 driver for JDBC connectivity between the Cognos software and the Sybase ASE that will host the Content Store consists of the following tasks:

  1. Installing the Sybase jConnect JDBC driver
  2. Configuring the Cognos software to use the jConnect driver

Installing the Sybase jConnect JDBC driver

IBM Cognos 10.1.1 supports Sybase jConnect 6.05 for connectivity to Sybase ASE. The version of jConnect installed with ASE 15.7 is 7.0. Thus, you must install jConnect 6.05 as a separate product. See Note 1 for more information about jConnect version support. The Sybase White Paper: Basic JDBC Connectivity for Sybase Databases describes how to install and configure jConnect.

  1. Install jConnect 6.0.5. You can download jConnect from the jConnect web page (http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect) on the SAP/Sybase website. This installation is simply a .zip file that you extract into a directory on the machine that will host the Cognos server components.
  2. Set the environment variables required for jConnect: JDBC_HOME, JAVA_HOME and CLASSPATH. The aforementioned Sybase JDBC white paper describes how.

Configuring the Cognos software to use the jConnect driver

Instructions for configuring Cognos to use the Sybase jConnect 6.05 driver for JDBC connectivity to the ASE Content Store are included in the "Set up Database Connectivity for the Content Store Database," which has a "Steps for Sybase" section in the Cognos Installation and Configuration Guide. Configuring Cognos to use the Sybase jConnect 6.05 driver for JDBC connectivity to the ASE Content Store involves the following tasks:

  1. Locating the Sybase jConnect JDBC driver file, jconn3.jar, in the Sybase jConnect-6_0/classes directory.
  2. Copying the jconn3.jar file from the Sybase installation to the Cognos installation /webapps/P2pd/WEB-INF/lib directory.

You are now ready to configure Cognos to create and use the Content Store in Sybase ASE as described in the following section.


Configure Cognos to use the ASE Content Store

Use the Cognos Configuration application to configure Cognos to use the Sybase ASE database as its Content Store as follows:

  1. Install the Cognos BI Server software according to the IBM documentation. IBM recommends that you close any other applications or services running on the machine before doing so.
  2. After you install the Cognos software, you need to restart anything you stopped, especially the Sybase ASE data server that hosts the database you created to be the Cognos Content Store.
  3. Launch Cognos Configuration by choosing Start | All Programs | IBM Cognos 10.1.1 | IBM Cognos Configuration. On UNIX/Linux, you launch Cognos Configuration using the cogconfig.sh script in the Cognos ...c10_64/bin64 directory. The Cognos Configuration application opens.
  4. In the Explorer pane on the left, configure Cognos to connect to the Content Store by choosing Content Store under Data Access and Content Manager. The properties for the default Content Store database resource, which is DB2, display in the right pane.

Default Content Store

  1. In the Explorer pane, select Content Store, right-click and select Delete. This deletes the default database resource.
  2. Right-click Content Manager again, and select New Resource and Database from the pop-up menu. The New Resource - Database dialog box opens prompting you to provide a name and specify the type of database. Note that the name is arbitrary.

New resource Database

  1. Provide a name for the Content Store, select Sybase database from the Type drop-down list, and click OK. The <Resource Name>-Database-Resource Properties open in the right window, for example, "SybaseASEContentStore-Database-Resource Properties" shown below.
  2. Provide the database server, port and database name for the ASE server you configured to be the Content Store. Remember that Cognos uses JDBC connectivity here. Thus, it is building the JDBC connection string for jConnect with this information.
  3. In the User ID and Password field, click the Edit button, which will open a dialog box in which you can enter the user and password you created to be the Cognos Content Store administrator. Note that it does not distinguish between the host machine name or ASE server name. For Content Stores in Microsoft SQL Server, the documentation says the server name has to be formatted as the JDBC connection string. But this is not the case for Sybase ASE.

Content Store in ASE

  1. Choose File | Save from the toolbar. Cognos Configuration displays a dialog box reporting the status of the saving tasks it performs. A green check next to the task indicates success. If any of the tasks report failures, the Details button will become available for you to click and see more information.

Cognos Configuration tasks

  1. Click Close to dismiss the dialog box. You will see the named Content Store listed under Data Access | Content Manager in the Explorer window.
  2. Test the connection between Cognos and the Content Store by selecting the Content Store and either right-clicking and choosing Test from the pop-up menu or selecting Test from the Actions menu in the toolbar. Cognos Configuration again displays a task dialog box. In this case, it includes a task called "Testing Content Manager database connection." Note that you must select the Content Store first or the Test option will not be available. See Note 3 for information about possible problems with the connection test.
  3. Click Close to dismiss the tasks dialog box.
  4. Locate Cognos service in the Explorer window, select the service beneath it (named, for example, IBM Cognos8), right-click, and choose Start from the pop-up menu. The IBM Cognos Configuration tasks dialog box opens reporting the status of the start. For example, it may list two tasks: "Checking upgrade status" and "Starting the service 'IBM Cognos 8'."

The Sybase ASE Content Store and Cognos environment are now configured and ready for use.


Notes

This section contains notes from setting up Sybase ASE 15.7 and the Sybase jConnect for JDBC driver 6.05 as the Cognos Content Store:


Note 1: Cognos supported Sybase products for the Content Store

At the time this paper was written, the IBM Cognos Business Intelligence 10.1.1 Software Environments page showed that the latest version of ASE supported as the Cognos Content Store was supported on Sybase ASE 15.5 with the Sybase jConnect 6.0 JDBC driver (jconn3.jar file). The testing for this paper was performed with Sybase ASE 15.7 and jConnect 6.05. See the Cognos BI 10.1.1 Software Environments page for the latest information at http://www-01.ibm.com/support/docview.wss?uid=swg27021368).

The Sybase ASE 15.7 product installation includes the option to install jConnect 7.0, not jConnect 6.x. The jConnect 7.0 jar file is jconn4.jar. The Cognos 10.1.1 software only supports the use of the jconn3.jar file. Attempts to jConnect 7.0 resulted in a "driver could not be loaded" error as documented in Note 4. Thus, the jConnect 6.05 version, which includes the jconn3.jar file, was used for this testing.You can download jConnect from the jConnect web page (http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect).

Note 2: Steps to configure the Sybase ASE Windows service control to start automatically

IBM recommends configuring the database that will host the Cognos Content Store to start automatically after its host machine restarts. This can help ensure continuity of the Cognos reporting software environment. For Sybase ASE, you can do this as appropriate for the ASE host machine. For Windows, you can configure the Microsoft Windows service controls for the Sybase ASE services to start automatically. The ASE installation program provides the option to create the services but it sets them to start manually. The following steps describe how to set the service controls to start automatically.

  1. Open the Windows Services application and choosing Start | Control Panel | Administrative Tools | Services. The Services application opens.
  2. Scroll down through the list of services to locate the Sybase servers (for example, depending on what servers you installed and configured you may see Sybase BCKServer, MONServer and SQLServer). The ASE servers are named with the host machine name by default. For example, the ASE data server is named with just the host machine name in all capital letters (MACHINENAME), the Backup Server and Monitor Server are named with the host machine name, an underscore and then "BS" or "MS" (MACHINENAME_BS). =
  3. Select Sybase SQLServer, right-click and choose Properties from the pop-up menu. The Properties dialog box opens.
  4. Locate the Startup type field on the General tab and select Automatic from the drop-down list.
  5. Repeat this step for the other Sybase servers.
  6. When you finish, exit the services control. These settings will take effect when the machine reboots.
  7. When the machine restarts, re-open the Services application. You should see the Status "Started" and the Startup Type "Automatic" as shown above. If the ASE server is not started, check the log for possible issues. The log is located in the directory ASE-15_0\install sub-directory of the directory in which you installed ASE (C:\Sybase by default). It is named with the ASE server name and the .log extension (MACHINENAME.log). Commonly, initial start-up failures are the result of licensing problems.

Note 3: Cognos documentation instructs you to "Set the new database device as the default"

The Cognos Installation and Configuration Guide instructs you to "Set the new database device as the default." The meaning of this is is unclear. It is common practice, however, to set a default database, not device, for the login and user who will administer the Content Store database. Setting a default database for a user ensures the user will be put in the context of that database automatically when it is used to connect to Sybase ASE. The 10.1.1 version of the Cognos Configuration tool provides a field for you to specify the database name. This should ensure that Cognos connects to the specified database. See the section Configuring Cognos to use the ASE Content Store for information about this configuration.

Note 4: Cognos Configuration fails Content Store connection test with "Content Manager failed ...to start because it could not load the driver..." or "...to connect to the content store..."

The Cognos Content Store connection test may fail with the following error:

Content store connection test fails

There are two known reasons as to why this occurs:

  • The wrong version of the driver is being used. During testing, we attempted to use the Sybase jConnect 7.0 JDBC driver (jconn4.jar) because it is the later version of jConnect and it ships with ASE 15.7. Cognos 10.1.1 supports the 6.05 driver, the file name for which is jconn3.jar. Note that jconn2.jar, the 5.5 version of jConnect will not work either.
  • The jConnect 6.05 driver has not been copied to the Cognos directory.

Workaround: Use the jConnect 6.05 driver as documented in Note 1 above and the section Configuring the Cognos software to use the jConnect driver in this paper until the jConnect 7.0 driver is supported by Cognos.


References

Following is a list of documents relevant to configuring Sybase ASE to be the Cognos Content Store.

  • IBM Cognos Business Intelligence 10.1.1 information center, http://publib.boulder.ibm.com/infocenter/cbi/v10r1m1/index.jsp, the IBM Web site for the Cognos 10.1.1 product. It contains links to the latest release notes and product documentation, including the Installing and Configuring Guide, which is referenced throughout this paper. This guide contains the following sections relevant content store installation and configuration:
    • Chapter 4, "Preparing to Install," provides general information about setting up the Content Store and information about setting up Sybase ASE to be the content store. It contains the following relevant sub-sections:
      • "Verify System Requirements"
      • "Guidelines for Creating the Content Store"
      • "Suggested Settings for Creating the Content Store in Sybase"
      • "Set Up Database Connectivity for the Content Store"
      • "Update the Java Environment."
    • Chapter 6, "Installing and Configuring IBM Cognos BI Components on One Computer," and Chapter 7, "Installing and Configuring IBM Cognos BI Components on Different Computers" provide the same sections based on your installation situation:
      • "Set Up Database Connectivity for the Content Store," with the specific section "Steps for Sybase"
      • "Set Database Connection Properties for the Content Store"
  • Cognos Business Intelligence 10.1.1 Software Environments, including those for Content Stores, http://www-01.ibm.com/support/docview.wss?uid=swg27021368
  • Sybase certification report Cognos 10.1.1 Reporting and Modeling Software with Sybase IQ 15.4.
  • Sybase certification report Cognos 8.4.1 Reporting and Modeling Software with Sybase IQ 15.2.
  • Sybase White Paper: Cognos Content Store in Sybase ASE, provides information about a Cognos version 8.4.1 Content Store in ASE 15.0.2 with jConnect 5.5 connectivity.
© Copyright 2014, Sybase Inc. - v 7.6