IBM Support

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

Question & Answer


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 <new value>

Restart the instance for the change to take effect.
db2stop

dbstart

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Connectivity - Other","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21395982

Page Feedback