05-26-2009, 02:32 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,246
|
|
KB18253 - How to prepare BES for Novell GroupWise to support DST 2009 changes
KB18253 - How to prepare BES for Novell GroupWise to support DST 2009 changes
Environment
- BlackBerry® Enterprise Server version 4.1 Service Pack 3 (4.1.3) and later for Novell® GroupWise®
Overview
BlackBerry Enterprise Server software versions 4.1 Service Pack 3 (4.1.3) and later
BlackBerry Enterprise Server for Novell GroupWise
To support the DST Spring 2009 changes to the BlackBerry Enterprise Server for Novell GroupWise, complete the following steps:
- Review the documentation for your time zone by searching the Novell GroupWise Support web site for your time zone.
- 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.
- 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.
- Download and run the attached script, TimeZoneUpdate[DATE].zip, on the BlackBerry Enterprise Server. For instructions, see the Additional Info section in this document.
Note: After applying the BlackBerry Enterprise Server for Novell GroupWise script, calendar appointments created in the email application on a computer that are synchronized to the BlackBerry smartphone appear one hour ahead during the old and new time zone changes. Calendar appointments created on the BlackBerry smartphone display the correct time.
BlackBerry smartphones
Warning: If you apply the DST 2009 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 most recent DST updates
To find the most up-to-date downloads and 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
| -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®. | | -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 TimeZoneUpdate[DATE].zip contains two scripts, one for Microsoft SQL Server and one for IBM DB2 Universal Database. |
Optional Switches
-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 Microsoft SQL Server.
| -dbauth
| Use this switch to enable 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 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. |
Running the TimeZoneUpdate[DATE].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.
- Download the attached TimeZoneUpdate[DATE].zip and extract it on the BlackBerry Enterprise Server. Important: Do not modify the file structure if the TimeZoneUpdate[DATE].zip.
- On the BlackBerry Enterprise Server, open a command prompt and navigate to the root folder where the LoadSyncDeviceConfig.sql script is located.
- Type 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 following is the full command syntax:
BBDBUpdate.exe –db -dbms -n -dbauth –dbuser -dbpass -input <.\SQLServer\LoadSyncDeviceConfig.sql> Where
- is the name of the BlackBerry Configuration Database
- is selected if you are running a Microsoft SQL Server in your environment
- is the Microsoft SQL Server name
- is the appropriate user name for Microsoft SQL Server authentication
- is the appropriate password for Microsoft SQL Server authentication
- <\SQLServer\LoadSyncDeviceConfig.sql> is the Microsoft SQL Server Location for the LoadSyncDeviceConfig.sql script when using a Microsoft SQL Server
__________________
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.
|
Linear Mode
