Daylight Saving Time (DST) will change for the following time zones:
Country Time Zone DST Start DST End
Adelaide
Canberra, Sydney
Australia Hobart 1st Sunday in October at 2:00 AM 1st Sunday in April at 3:00 AM
Brazil
- States of Mato Grosso do Sul and Mato Grosso only Manaus 2nd Sunday in October at 12:00 AM 3rd Sunday of February at 12:00 AM
Israel no change 1st Sunday of October at 2:00 AM
Argentina Buenos_Aires 1st Sunday in October at 1:00 AM 3rd Sunday in March at 12:00 AM
Note: Guyana's time zone of Buenos_Aires has been renamed Georgetown.
Complete the following to support the DST 2008 changes to the BlackBerry Enterprise Server for IBM Lotus Domino.
BlackBerry Enterprise Server for IBM Lotus Domino
1. To support the time zone changes, the Windows® operating system needs to have a time zone update applied. If the Windows time zone update is not applied, the TimeZoneUpdate20080207.zip script will not function as intended. For more information, search for article 942763 on the Microsoft Support web site.
2. Review the documention 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 software version 4.0 and later, upgrade to BlackBerry Enterprise Server software version 4.0 Service Pack 7 Maintenance Release 1.
OR
If you are running BlackBerry Enterprise Server software version 4.1 and later, upgrade to BlackBerry Enterprise Server software version 4.1 Service Pack 4 and later.
4. Download and run the attached script, TimeZoneUpdate20080207.zip, on the BlackBerry Enterprise Server. For instructions, see the Additional Info section in this document.
BlackBerry smartphones
Warning: If you apply the DST 2008 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 4.1MR4+_Patch.zip and 4.2+_Patch.zip patches resolve the DST 2008 issue if you are running one of the following BlackBerry® Device Software versions:
BlackBerry Device Software 4.1.0.344 through 4.1.0.365, (except for BlackBerry Device Software 4.1.0.347)
BlackBerry Device Software 4.1.0.379 through 4.1.0.381
BlackBerry Device Software 4.1.0.383 through 4.1.0.385
For BlackBerry smartphones running BlackBerry Device Software 4.1.0, download the 4.1MR4+_Patch.zip. There are two ways to download the patch:
For administrators, or for installing the patch using the Application Loader in BlackBerry® Desktop Manager, to download the 4.1MR4+_Patch.zip, click here. For instructions on installing the patch using the application loader tool, see KB15172.
To download the patch wirelessly from a BlackBerry smartphone, click here.
For BlackBerry smartphones running BlackBerry Device Software 4.2 or later, download the 4.2+_Patch.zip. There are two ways to download the patch:
For administrators or for installing the patch using the Application Loader in BlackBerry Desktop Manager, to download the 4.2+_Patch.zip, click here. For instructions on installing the patch using the Application Loader, see KB15172.
To download the patch wirelessly from a BlackBerry smartphone, click here.
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.
Additional Info
Running the Script against the BlackBerry Configuration Database
When running the LoadSyncDeviceConfig.sql script (located in the attached TimeZoneUpdate20080207.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 Microsoft SQL Server and IBM DB2 Universal Database. The attached TimeZoneUpdate20080207.zip contains two scripts, one for Microsoft SQL Server and one for IBM DB2 Universal Database.
Optional Switches
Switches Description
-dbms Use this switch to specify if 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 TimeZoneUpdate20080207.zip Update
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 TimeZoneUpdate20080207.zip and extract it on the BlackBerry Enterprise Server.
Important: Do not modify the file structure if the TimeZoneUpdate20080207.zip.
2. On the BlackBerry Enterprise Server, open a command prompt and navigate into the root folder where the LoadSyncDeviceConfig.sql script is contained. Enter the appropriate command for your environment. The following is a 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
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 using Microsoft SQL Server
Schema name, if you are using 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 using Microsoft SQL Server
The location of the LoadSyncDeviceConfig.sql script, if you are using IBM DB2 Universal Database
1 comment:
Scenario :
Two instances of SQL Database on the Same SQL2005 Server.
Applying the procedure updates the Default BEsmgmt instance.
Need to run this procedure against both instances on the Server.
You can cut and paste the screipt into the SQL2006 Script runner and select the right instance and it updates like a charm.
Post a Comment