Increasing the SQL Server timeout

Complete the following steps to increase the SQL Server timeout setting that is used by Tealeaf® and complete the upgrade.

Procedure

  1. Log in to the Tealeaf Portal as an administrator.
  2. From the Portal menu, select Tealeaf > TMS.
  3. The Tealeaf Management System is displayed. See "Tealeaf Management System" in the IBM® Tealeaf cxImpact Administration Manual.
  4. In Server view, click the Tealeaf node.
  5. Select Shared configuration information.
  6. In the Config Actions pane, click View/Edit.
  7. The Tealeaf Report Configuration dialog is displayed. Click the Database tab.
  8. Click Connection Timeout.
    • By default, this value is set to 600 (seconds), which is 10 minutes.
  9. Enter a higher value and click Apply.
  10. Click Save.
  11. In the Update Servers dialog, select Add Tasks and Submit.
  12. After the job runs, all Tealeaf servers in your environment are updated with the new database connection timeout setting.
    • See "TMS Jobs Tab" in the IBM Tealeaf cxImpact Administration Manual.
    • For more information about the database connection timeout, see "Shared configuration information" in the IBM Tealeaf cxImpact Administration Manual.
  13. Upgrade the TL_SYSTEM database in Individual Database mode through the Tealeaf Database Manager.