DB2 SQL6048N 在 START 或 STOP DATABASE MANAGER 处理期间发生通讯错误 问题解决办法记录
按照下面方法处理解决
引用官方文档
How to solve db2start error SQL6048N
Technote (troubleshooting)
Problem(Abstract)
SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
Symptom
When trying to start an instance using the db2start
command, the following error is received.
SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
Cause
The examples are shown below :
1. Your system might have a different hostname than the hostname listed in <INSTANCE_HOME>/sqllib/db2nodes.cfg
2.Your system might have a problem with rsh daemon.
Environment
DB2® V9.1, V9.5 and V9.7 on Linux™ or UNIX™ environments
Diagnosing the problem
1. Execute the hostname
command and compare the output with the hostname listed in <
INSTANCE_HOME>/sqllib/db2nodes.cfg
2. Login as a instance user and run the following command.
$ db2_all "echo OK"
rshd: 0826-813 Permission is denied.
rshd: 0826-813 Permission is denied.
Run the the following command to display related information:
db2 ? SQL6048N
Resolving the problem
Resolve the problem using one of these solutions:
- If the hostname displayed by the
hostname
command is different than the hostname from<INSTANCE_HOME>/sqllib/db2nodes.cfg
, then you must modify the db2nodes.cfg record to match the hostname of the system.
- If the hostname of the system is a Fully Qualified Domain Name (FQDN) then you must use the FQDN in db2nodes.cfg.
chmod 400 .rhosts
Step 2 : Run the following command to confirm if the rsh daemon is set properly or not.
$ db2_all "echo OK"
OK
coralpib135: echo OK completed ok
OK
coralpib137: echo OK completed ok
Step 3: Run the
db2stop
or db2start
command. $ db2stop
11/29/2011 01:45:13 0 0 SQL1064N DB2STOP processing was successful.
11/29/2011 01:45:13 1 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
This is one of the method to solve the MPP start problem. If user runs the
db2 ?
command, SQL6048N will display related information.
相关推荐
SQL1032N No start database manager command was issued. SQLSTATE=57019 [db2inst1@localhost ~]$ db2start SQL5043N Support for one or more communications protocols failed to start successfully. However, ...
SQL1063N DB2START processing was successful. ``` 2. **关闭数据库实例** 关闭数据库实例时,首先需要确保所有应用程序已关闭,防止数据丢失。使用`db2 force application all`命令强制关闭所有应用程序: ``...
- **DB2实例的启动与管理**:在不同的操作系统下,DB2实例的启动和管理方式有所不同,如在AIX环境中,可以通过配置`db2start`和`db2stop`脚本来实现自动启动和停止。 ### 其他系统与DB2的交互 - 在与其他系统交互...
22. **START或STOP DATABASE MANAGER失败**:此问题可能与注册表配置有关,需要检查`HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Tcpip\Parameters\DataBasePath`的类型是否正确,如果是字符串类型问题,应...
- **db2sql92**:转换SQL语句。 - **db2sqljbind/db2sqljcustomize/db2sqljprint**:SQLJ相关操作。 - **db2start/db2stop**:启动和停止DB2。 - **db2support**:支持包创建。 - **db2swtch**:切换数据库镜像。 - ...
在数据库管理领域,DB2(Database 2)作为IBM推出的一款关系型数据库管理系统,在企业和组织中有着广泛的应用。相较于图形用户界面(GUI),通过命令行进行操作不仅能够节省系统资源,还能提供更为灵活、高效的数据...
DB2是IBM开发的一款关系型数据库管理系统,广泛应用于企业级数据存储和管理。...在实际工作中,还需要结合其他高级功能和工具,如SQL查询、性能调优、备份恢复等,来确保DB2数据库系统的稳定运行。
4. **读取数据库管理程序配置**:`db2 get dbm cfg` 用于查看DBM(Database Manager Configuration)配置,这些配置影响整个DB2实例。 5. **写入数据库管理程序配置**:`db2 update dbm cfg using <参数名> <参数值...
**START DATABASE MANAGER** - **功能描述**:启动数据库管理器。 - **应用场景**:当系统启动或数据库管理器异常关闭后,需要通过此命令重新启动数据库管理器。 - **注意事项**:启动前确认所有依赖服务已就绪...
1. **终止数据库服务**:使用`db2terminate`或`db2stop force`命令来停止当前运行的数据库服务。 2. **启动数据库服务**:通过执行`db2start`命令来启动数据库服务。 3. **激活数据库**:使用`db2activate dbtp1`...
负载量在100人内,比如比如在负载日访问量负载可以处理海量数据板,信息系信息留言统。 5000-15000 库 sybase<oracle<db2 成本低 成本在万元内 大型数据库的安全性能 安全性要求不高 比如商务网站 高,价格也很...