March 2010 Daylight Savings Time Update

Article ID: KB20676

Type: Support Content

Last Modified: 12-14-2011

 

Product(s) Affected:

  • BlackBerry Enterprise Server for Novell GroupWise
  • BlackBerry Enterprise Server for Microsoft Exchange
  • BlackBerry Enterprise Server for IBM Domino
CollapseEnvironment
  • BlackBerry® Enterprise Server
  • BlackBerry® Device Software version 4.1.0.344 to 4.1.0.385 (excluding version 4.1.0.347) and 4.2.0.74 and later (including 5.0)
CollapseOverview

The March 2010 Daylight Savings Time (DST) update is cumulative and includes updates to the following Time Zones:

Country Time Zone DST Start DST End
Azores Azores (GMT -1) March 28, 2010 October 31, 2010
Israel Jerusalem (GMT +2) March 26, 2010 September 12, 2010
Egypt Cairo (GMT +2) April 30, 2010 September 24, 2010
Georgia Tbilisi (GMT +4) No DST No DST
Fiji Fiji (GMT +12) November 29, 2009 April 25, 2010
Mongolia Ulaan Baater (GMT +9) No DST No DST
Bangladesh Dhaka (GMT +6) March 31, 2010 October 31, 2010


Prerequisites for installing the March 2010 DST update

To install the March 2010 DST update, the BlackBerry smartphone must be running one of the following BlackBerry Device Software versions.

  • BlackBerry Device Software version 4.1.0.344 to 4.1.0.385 (except for BlackBerry Device Software version 4.1.0.347)
  • BlackBerry Device Software version 4.2.0.35 to 4.2.0.92
  • BlackBerry Device Software version 4.2.0.92 and higher (including 5.0)

If the version of BlackBerry Device Software that is currently installed is not in the above list, the BlackBerry smartphone must first be upgraded to a supported version before the updates can be applied successfully. To determine what version of BlackBerry Device Software is currently installed go to Options->About. To upgrade the BlackBerry smartphone to a newer version of BlackBerry Device Software see KB13427 or visit www.blackberry.com/upgrades on your computer.


Installing the March 2010 DST update for individual BlackBerry smartphone users

Individual BlackBerry smartphone users who are not on a BlackBerry Enterprise Server can download the March 2010 DST update using one of the following links.

BlackBerry Device Software version 4.1.0.344 to 4.1.0.385 (except 4.1.0.347)

http://www.blackberry.com/dst2010/patches/carrier/4.1/Spring10/net_rim_bb_timezoneupdater.jad

BlackBerry Device Software version 4.2 and later (including BlackBerry Device Software versions 4.3, 4.5, 4.6, , and 5.0)

http://www.blackberry.com/dst2010/patches/carrier/4.2/Spring10/net_rim_bb_timezoneupdater.jad

Note: The links above can be accessed directly from the BlackBerry® Browser to download the patch over the wireless network. The BlackBerry Smartphone may prompt to be reset after the patch has been downloaded and installed.


Installing the March 2010 DST update for Administrators

In order to fully support DST changes a Windows® update will need to be applied to the BlackBerry Enterprise Server. This requirement is applicable for all mail platforms. The most recent update and information can be obtained from Microsoft KB979306, or visit the Microsoft Support site and search for "February 2010 time zone update".  For additional information about DST, Windows, and TZEdit.exe please see Microsoft KB914387, or visit the Microsoft Support site and search for "configure daylight saving time for Microsoft Windows".

Important note for BlackBerry Enterprise Server for Microsoft Exchange

Early version of cdo.dll maintained separate internal time zone tables which required an update when a time zone changed. However, in more recent versions of cdo.dll Microsoft has designed cdo.dll to read DST information from the Windows registry. To support this feature cdo.dll, on the BlackBerry Enterprise Server, must be at version 6.5.7654.1 or higher; or 6.5.8067.0 or higher. DST changes that require the creation of a NEW time zone will require an update to cdo.dll. It is recommended that the most recent Microsoft Daylight Savings Time update be applied to the BlackBerry Enterprise Server. For information about these updates please see Microsoft KB977720, or the latest Microsoft Exchange Server MAPI Client and Collaboration Data Objects 1.2.1 Download (6.5.8153.0)

Note: Updates may also be required to other computers in the organization. Please see the individual mail platform vendors for details and instructions.

To apply DST updates to the BlackBerry smartphone use one or more of the following options.

Option 1: SQL Script Update

This process involves executing a Structured Query Language (SQL) query against the BlackBerry Enterprise Server. Once executed the BlackBerry Synchronization service will automatically send the updates time zone information to the BlackBerry smartphone.

In order to leverage this method the BlackBerry Enterprise Server and BlackBerry smartphone must meet the following requirements:

  • BlackBerry Enterprise Server version 4.0 SP7

OR

  • BlackBerry Enterprise Server version 4.1 SP3 and higher

OR

  • BlackBerry Enterprise Server version 5.0

AND

  • BlackBerry Device Software version 4.2.0 and higher (including 5.0)

If the BlackBerry Enterprise Server and/or BlackBerry Device Software do not meet the prerequisites please proceed to Option 2.

For instructions on applying the update please see the Additional Information section and the end of the article.

Option 2: Using the TimeZoneUpdate application

This is not required for BlackBerry smartphones running BlackBerry Device Software version 4.2.0 or later if the script update (Option 1) has been applied to the BlackBerry Enterprise Server.

Administrators have five options for deploying the TimeZoneUpdater application to their end users.

  1. BlackBerry Desktop Software.
  2. BlackBerry Application Web Loader.
  3. Standalone Application Loader.
  4. BlackBerry Browser.
  5. Wireless Application Push.

For information and instructions about any of these options please review the Deploying Java Applications  guide.

To verify which BlackBerry smartphone users have the TimeZoneUpdater application use the BlackBerry Application Reporting Tool from the BlackBerry Resource Kit. For more information visit http://na.blackberry.com/eng/support/server_resourcekit.jsp .

If a BlackBerry smartphone user installs the TimeZoneUpdater application in addition to receiving the updates from the database script the settings from the SQL script will take precedence.


Additional Information

Warning: The process modifies the BlackBerry Configuration Database. It is recommended that a full backup be taken prior to the execution of the script.

This process can be completed from any workstation or server.

  1. Download TimeZoneUpdateMarch2010.zip and extract the contents.

    Important: Do not modify the directory and file structure of the extracted files.

  2. Open a command prompt and navigate to the folder that contains BBDBUpdate.exe.
  3. Type BBDBUpdate.exe and add the switches applicable to the BlackBerry Enterprise Server environment. The full command syntax is as follows:

BBDBUpdate.exe -db <Database Name> -dbms <SQL> -n <SQL Server Name> -dbauth -dbuser <User Name> -dbpass <Password> -input <.\<folder>\LoadSyncDeviceConfig.sql>

Examples:

For BlackBerry Enterprise Server version 4.1 SP3 or later using Microsoft SQL Server with Windows Authentication, type the following:

BBDBUpdate.exe -db BESMgmt -n SQL1 -input .\MSSQL\LoadSyncDeviceConfig412.sql

For BlackBerry Enterprise Server version 4.1 SP3 or later using Microsoft SQL Server with SQL Authentication, type the following:

BBDBUpdate.exe -db BESMgmt -n SQL1 -dbauth -dbuser sa -dbpass password -input .\MSSQL\LoadSyncDeviceConfig412.sql

Required Switches

Switch Description
-db Use this switch to specify the name of the BlackBerry Configuration Database you are updating. The default value is BESMgmt
-n Use this switch to specify the hostname or instance of the database server.
-input Specifies the path and file name of the script to execute. Ensure that you are select the script for your applicable database server type.




Optional Switches

Switch Description
-dbms Use this switch to specify if you are using Microsoft SQL Server or IBM DB2 Universal Server. If this switch is not used Microsoft SQL Server is assumed.
-dbauth Use this switch if you are using SQL Authentication. If this switch is not used Windows Authentication is used.
-dpuser Use this switch to specify the user name to be used with the 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 Microsoft SQL Server authentication. This switch is required if the -dbauth switch is used.




Note: If the error Unable to read input file check that the name and path of the LoadSyncDeviceConfig.sql is correct.

CollapseAttachments

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.