Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2833883
  • 博文数量: 599
  • 博客积分: 16398
  • 博客等级: 上将
  • 技术积分: 6875
  • 用 户 组: 普通用户
  • 注册时间: 2009-11-30 12:04
个人简介

WINDOWS下的程序员出身,偶尔也写一些linux平台下小程序, 后转行数据库行业,专注于ORACLE和DB2的运维和优化。 同时也是ios移动开发者。欢迎志同道合的朋友一起研究技术。 数据库技术交流群:58308065,23618606

文章分类

全部博文(599)

文章存档

2014年(12)

2013年(56)

2012年(199)

2011年(105)

2010年(128)

2009年(99)

分类: DB2/Informix

2012-09-24 16:06:24

Question

How do I resolve the following connection error?

SQL30070N "Unsupported function for SPMDB connect". Command is not supported.
SQLSTATE=58014

Cause

The SPM_NAME is set to the same name as the database being connected to.

Answer

The database name cannot have the same name as the dbm cfg parameter value for 'SPM_NAME'. If you need to set the SPM_NAME to identify the name of the sync point manager (SPM) instance to the database manager, then SPM name should be the unique name for your network. Usually this is derived from the TCP⁄IP hostname.

You can update the dbm cfg parameter SPM_NAME to a new value.
If you do not need to use the sync point manager set the spm_name to null using the following command:


db2 update dbm cfg using SPM_NAME NULL

or
Use the following command if you need to use the sync point manager.
Set the spm_name to the TCP/IP host name by using the following command:

db2 update dbm cfg using SPM_NAME

Restart the instance for the change to take effect.
db2stop

dbstart

阅读(4159) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~