Environment

• BlackBerry® Enterprise Server versions 4.1 SP3 and later for IBM® Lotus® Domino®

---

Overview

BlackBerry Enterprise Server for IBM Lotus Domino
To support the DST Spring 2009 changes to the BlackBerry Enterprise Server for IBM Lotus Domino, complete the following steps:

1. To support the time zone changes, the Windows® operating system must have a time zone update applied. If the Windows time zone update is not applied, the TimeZoneUpdate[DATE].zip script will not function as intended. For more information, search for article 970084 on the Microsoft Support web site.
2. Review the documentation for your time zone by searching the IBM Lotus Domino Support web site for your time zone.
3. If you are running BlackBerry Enterprise Server version 4.1 and later, upgrade to BlackBerry Enterprise Server version 4.1 SP4 and later.
4. Download and run the attached script, TimeZoneUpdate[DATE].zip, on the BlackBerry Enterprise Server. For instructions, see the Additional Info section of this document.

---

BlackBerry smartphones
Warning: If you apply the DST 2009 time zone change below to a BlackBerry smartphone that is already patched, or activate a new BlackBerry smartphone with the correct DST values against a BlackBerry Enterprise Server that does not have the newest time zone table, the BlackBerry Enterprise Server will override the values on the BlackBerry smartphone.
The patch can also be deployed to BlackBerry smartphones from the BlackBerry Enterprise Server. See KB03748 for detailed instructions on preparing a software configuration for wireless deployment.

---

Downloads and recent DST updates
To find downloads and recent DST information, see KB18250.

---

Additional Information

Running the Script against the BlackBerry Configuration Database
When running the LoadSyncDeviceConfig.sql script (located in the attached TimeZoneUpdate[DATE].zip), you can customize how the LoadSyncDeviceConfig.sql script is executed by using various switches. The following tables list the required and optional switches to run the LoadSyncDeviceConfig.sql script.
Required Switches

Switches	Description
-db	Use this switch to specify the BlackBerry Configuration Database name. The default name is BESMgmt.
-n	Use this switch to specify the location of the Microsoft® SQL Server® or IBM® DB2® Universal Database.
-input	Specifies which LoadSyncDeviceConfig.sql script to run. The BlackBerry Configuration Database is compatible with both the Microsoft SQL Server and IBM DB2 Universal Database. The attached TimeZoneUpdateSpring2009-BES4.1+.zip and TimeZoneUpdateSpring2009-BES5.0.zip contains two scripts, one for the Microsoft SQL Server and one for the IBM DB2 Universal Database.

Optional Switches

Switches	Description
-dbms	Use this switch to specify whether you are using a Microsoft SQL Server or IBM DB2 Universal Database to host the BlackBerry Configuration Database. The default option is SQL.
-dbauth	Use this switch to enable IBM DB2 Universal Database or Microsoft SQL Server authentication. If this switch is not used, Windows authentication is used.
-dbuser	Use this switch to specify the user name to be used with the IBM DB2 Universal Database or Microsoft SQL Server authentication. This switch is required if the -dbauth switch is used.
-dbpass	Use this switch to specify the password to be used with the IBM DB2 Universal Database or Microsoft SQL Server authentication. This switch is required if the -dbauth switch is used.

Running the TimeZoneUpdateSpring2009-BES4.1+.zip or TimeZoneUpdateSpring2009-BES5.0.zipUpdate
Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.

1. Download the attached TimeZoneUpdate[DATE].zip and extract it on the BlackBerry Enterprise Server. Important: Do not modify the file structure of TimeZoneUpdate[DATE].zip.
2. On the BlackBerry Enterprise Server, open a command prompt and navigate to the root folder where the LoadSyncDeviceConfig.sql script is located.
3. Type the appropriate command for your environment. The following is an example command if you are using a default database name and a remote Microsoft SQL Server: BBDBUpdate.exe -db BESMgmt -n SQL.domain.com -input .\SQLServer\LoadSyncDeviceConfig.sql
   The full command syntax is as follows:
   BBDBUpdate.exe -db -dbms -n -dbauth -dbuser -dbpass -input <.\SQLServer\LoadSyncDeviceConfig.sql|.\DS2\LoadSyncDeviceConfig.sql>

Variable	Description
Database Name	The name of the BlackBerry Configuration Database.
SQL or DB2	SQL, if you are running a Microsoft SQL Server in your environment DB2, if you are running IBM DB2 Universal Database in your environment
SQL Server Name or Schema Name	Microsoft SQL Server name, if you are running a Microsoft SQL Server Schema name, if you are running IBM DB2 Universal Database
User Name	Appropriate user name for Microsoft SQL Server or IBM DB2 Universal Database authentication
Password	Appropriate password for Microsoft SQL Server or IBM DB2 Universal Database authentication
.\SQLServer\LoadSyncDeviceConfig.sql or .\DB2\LoadSyncDeviceConfig.sql	The location of the LoadSyncDeviceConfig.sql script, if you are running a Microsoft SQL Server The location of the LoadSyncDeviceConfig.sql script, if you are running IBM DB2 Universal Database

Attached Files

	TimeZoneUpdateSpring2009-BES4.1%2B.zip (240.5 KB, 7 views)
	TimeZoneUpdateSpring2009-BES5.0.zip (240.0 KB, 5 views)

__________________
http://blog.port3101.org/hdawg/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.