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
- Log in to the Tealeaf Portal as an administrator.
- From the Portal menu, select Tealeaf > TMS.
- The Tealeaf Management System is displayed. See "Tealeaf Management System" in the IBM® Tealeaf cxImpact Administration Manual.
- In Server view, click the Tealeaf node.
- Select Shared configuration information.
- In the Config Actions pane, click View/Edit.
- The Tealeaf Report Configuration dialog is displayed. Click the Database tab.
- Click Connection Timeout.
- By default, this value is set to 600 (seconds), which is 10 minutes.
- Enter a higher value and click Apply.
- Click Save.
- In the Update Servers dialog, select Add Tasks and Submit.
- 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.
- Upgrade the TL_SYSTEM database in Individual Database mode through the Tealeaf Database Manager.
Related reference: