Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB18253 - How to prepare BES for Novell GroupWise to support DST 2009 changes
 
  #1 (permalink)  
Old 05-26-2009, 02:32 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,252
Blog Entries: 147
Default 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:
  1. Review the documentation for your time zone by searching the Novell GroupWise Support web site for your time zone.
  2. To support the time zone changes, the Windows® operating system must have a time zone update applied.
  3. 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.
  4. 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.
  5. 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

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®.
-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

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 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.
  1. 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.
  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 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
Attached Files
File Type: zip TimeZoneUpdateSpring2009-BES4.1%2B.zip (240.5 KB, 6 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.
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 06:53 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2