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.
相关推荐
在DB2连接时,客户端出现 SQL1032N的错误有可能是DB2的认证信息过期了,或者启动DB2启动不了、列出db2 list active database等等,有报错包里面有错误的解释、操作的文件和把DB2修改成永久的的文件
DB2数据库SQL注入手册1
DB2中出现的主要错误,操作数据库过程中,遇到许多问题,很多都与SQL CODE和SQL State相关,现在把一个完整的SQLCODE和SQLState错误信息和相关解释作以下说明,一来可以自己参考,对DB2错误自行找出原因
资源名称:DB2 SQL性能调优秘笈资源截图: 资源太大,传百度网盘了,链接在附件中,有需要的同学自取。
DB2 SQL 消息,非常方便管理员与操作者查找以便解决错误.比如SQL0440N 找不到具有兼容自变量的类型为 例程类型 的名为 例程名 的已授权例程。
DB2中几种遇到的SQL1032N出错的解决
DB2 SQL Reference,DB2 SQL参考手册
DB2中sql执行错误返回的sqlcode错误码,对应的sqlstate和错误信息描述字典表。
IBM DB2SQL信息
DB2报错:SQL10007N Message "-1390" could not be retrieved. Reason code
$ db2 restore database dbname ...SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-2071" with tokens "/usr/lib/libnsrdb2.o 1 " is returned.
db2 Sql手册,使用db2的TX必备资源。
DB2 SQL语句性能分析方法
IBM CF12 DB2 SQL Workshop原版教材,详细介绍了DB2 中各种标准和专门的SQL语句使用方法,一共7个单元。
一本很好的书,都是经验的积累,非常的实用
这是我的培训文档,我总结的很详细了,有sqlserver 也有db2 的,包括很多内容。对应搞BI或者语句开发的很有帮助。
DB2 SQL 数学函数 DB2 SQL 数学函数 DB2 SQL 数学函数 DB2 SQL 数学函数
DB2 SQL 通过函数(CONCAT/POSSTR/LOCATE)实现行转列,列转行 可以按照标点把多列转换为一行,多行转换为一列
便于db2的错误查询
DB2 SQL 语法 速查