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



Reply
LinkBack (3) Thread Tools Display Modes
KB18252 - How to prepare BES for IBM Lotus Domino to support DST changes in 2009
 
  3 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 05-26-2009, 02:26 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,252
Blog Entries: 147
Default KB18252 - How to prepare BES for IBM Lotus Domino to support DST changes in 2009

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
File Type: zip TimeZoneUpdateSpring2009-BES4.1%2B.zip (240.5 KB, 11 views)
File Type: zip TimeZoneUpdateSpring2009-BES5.0.zip (240.0 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


LinkBacks (?)
LinkBack to this Thread: http://www.port3101.org/featured-blackberry-kb-articles/1184-kb18252-how-prepare-bes-ibm-lotus-domino-support-dst-changes-2009-a.html
Posted By For Type Date
The Fashion Secrets in High Heeled Pumps. This thread Trackback 02-01-2011 02:25 AM
Re: How to prepare BlackBerry Enterprise Server to support DST changes in 2008 - BlackBerry® Enterprise Solution - BlackBerry Support Community Forums This thread Refback 09-25-2009 02:25 PM
BlackBerry Support Community Forums - How to prepare BlackBerry Enterprise Server to support DST changes in 2008 - BlackBerry® Enterprise Solution - BlackBerry Support Community Forums This thread Refback 06-04-2009 03:55 PM


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


 

SEO by vBSEO 3.3.2 PL2