注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

mylotustips的博客

IBM Lotus协作产品家族经验分享

 
 
 

日志

 
 
关于我

欢迎大家使用SR向IBM800提交问题http://www.ibm.com/support/servicerequest 可以随时查看问题状态,上传文件

网易考拉推荐

如何将 DB2 安装在 Connections 以外的其他服务器  

2012-03-28 15:56:18|  分类: SocialBusiness |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

Connections 3.0.1 文档提到可以在不同的服务器上分别安装 DB2 和 Connections,
仅需将 .sql 脚本拷贝到 DB2 的服务器上运行即可.

标题:Creating IBM DB2 databases manually
链接:http://www-10.lotus.com/ldd/lcwiki.nsf/dx/Creating_IBM_DB2_databases_manually_ic301

Before you begin
Use this procedure if you do not want to use the database wizard to create your databases.

The SQL scripts are located in a compressed file called connections.sql.zip|tar, located in the Lotus_Connections_install/LotusConnections/connections.sql directory of the IBM Connections set-up directory or installation media. Extract this file before proceeding. When extracted, the SQL scripts are located in the LotusConnections/connections.sql/<application_subdirectory> directory of the IBM Connections set-up directory or installation media, where <application_subdirectory> is the directory that contains the SQL scripts for each application. If you are using AIX?, see the note in the Preparing the database wizard topic about decompressing TAR files.

Note:
  • If you are using Linux? on IBM System z? with the DASD driver, the SQL scripts are located in the Lotus_Connections_Install_s390/LotusConnections/connections.s390.sql directory.
  • If you are using Linux on IBM System z with the SCSI driver, back up the connections.s390.sql directory and rename the connections.sql directory to connections.s390.sql.
If the database server and IBM Connections are installed on different systems, copy the SQL scripts to the system that hosts the database server.

(AIX only) Configure the AIX system that hosts the DB2 databases to use the enhanced journaled file system (JFS2), which supports file sizes larger than 2 GB. To enable large files in the JFS system, perform the following steps:

1.        In the SMIT tool, select System Storage Management
 


File System>Add/Change/Show/Delete File Systems
2.        Select the file system type you want to use and specify other characteristics as wanted. If you use a Journaled File System, set the Large File Enabled setting to true.
See the AIX documentation如何将 DB2 安装在 Connections 以外的其他服务器 - mylotustips - mylotustips的博客 for more options.

Notes:

When you are creating a database either with the database wizard or SQL scripts, you must log into the system where the database is hosted with the database administrator account. The default values for DB2 are db2admin on Microsoft? Windows? and db2inst1 on Linux and AIX. For Oracle, the default value is oracle on AIX or Linux, and system administrator on Windows . For SQL Server, the default value is the system administrator

DB2 only. If you are hosting IBM DB2 on a single 32-bit system, you should create multiple DB2 instances. A single DB2 instance on a 32-bit system can manage a maximum of 2 GB of data in memory and this can become a constraint when you install multiple IBM Connections applications. At a minimum, create two DB2 instances when you are installing all the applications, but also consider creating separate instances for the Activities and Communities databases because they are usually the most memory-intensive databases. Ideally, you would install one DB2 instance per IBM Connections application. If you are hosting DB2 on a 64-bit system, you do not need to create multiple instances, provided the system has sufficient RAM.

About this task
You must perform this task for each IBM Connections application that you are installing.
Note: To capture the output of each command to a log file, append the following parameter to each command: >> /<file_path>/db_<application>.log

where <file_path> is the full path to the log file and <application> is the name of the log file. For example:

db2 -tvf createDb.sql >> /home/db2inst1/db_activities.log

Ensure that you have write permissions for the directories and log files.

To create the application databases, complete the following steps:

Procedure
1.        Optional:  (Only required if the database server and IBM Connections are installed on different systems.) Copy the IBM Connections SQL scripts to the DB2 database system. Authorize a user ID that can create the databases.
2.        Log in to the DB2 database system with the user ID of the owner of the database instance. The user ID must have privileges to create a database, a tablespace, tables, and indexes.
Notes:
  • If you created multiple database instances, specify the user ID for the first instance.
  • The default administrative ID for Microsoft Windows is db2admin.
3.        Start the DB2 command line processor in command mode and enter the following command:
db2start
4.        For Home page and Profiles, change to the directory where the SQL scripts for each application are stored, and then enter the following command to run the script:
db2 -tvf createDb.sql
5.        For Home page, run the following script:
db2 -tvf initData.sql
6.        For Activities, Communities, Blogs, Bookmarks, Files, Forums, and Wikis, change to the directory where the SQL scripts for each application are stored, and then enter the following command to run the script:
db2 -td@ -vf createDb.sql

Note:
The SQL scripts for Bookmarks are stored in the dogear directory.

7.        Run the following command to grant access privileges to the lcuser account for the Home page and Profiles databases:
db2 -tvf <application_subdirectory>/appGrants.sql
8.        Run the following command to grant access privileges to the lcuser account for the Activities, Communities, Blogs, Bookmarks, Files, Forums, and Wikis databases:
db2 -td@ -vf <application_subdirectory>/appGrants.sql
9.        Run the following commands to generate statistics for the Home page database:
db2 -tvf <application_subdirectory>/reorg.sql

db2 -tvf <application_subdirectory>/updateStats.sql

10.        Close the DB2 command line processor.
11.        Optional: When you install IBM Connections, the JDBC configuration page of the installation wizard asks you to provide a user ID and password for the Application User. The user ID that you specify on that page must have read and write access to the database. You can provide the user ID of an administrative user or you can create a dedicated user ID with fewer privileges. See the Creating a dedicated DB2 user topic for more information.


  评论这张
 
阅读(532)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017