`
hain
  • 浏览: 454544 次
  • 来自: ...
社区版块
存档分类
最新评论

DB Name specified matches the SPM Name. Please use a different name SQLSTATE

 
阅读更多

 

在创建数据库或者恢复的时候出现下面语句:

SQL0901N The SQL statement failed because of a non-severe system error. 
Subsequent SQL statements can be processed. (Reason "DB Name specified 
matches the SPM Name. Please use a different name".) SQLSTATE=58004

 

SQL0901N  SQL 语句因为不严重的系统错误而失败。可以处理后续 SQL 语句。(原因为

"DB Name specified matches the SPM Name. Please use a different name"。)

SQLSTATE=58004


  ------------------------------------------------------


解决方法如下:

db2 update dbm cfg using SPM_NAME NULL
db2 update dbm cfg using SPM_NAME newname

db2stop
db2start

分享到:
评论

相关推荐

    关于IllegalStateException: The specified child already has a parent.

    IllegalStateException: The specified child already has a parent.我的博客中有文章讲解

    VMWare (specified virtual disk needs repair...)修复

    specified virtual disk needs repair。附修复工具和使用方法。 分数不够的可以到VM官方下载修复工具,如果找不到就贡献1分下载我上传的吧:) =====================================================================...

    查看进程工具tlist.exe

    If it matches more than one process name, TList displays only the PID of the first matching process. PID Displays detailed information about the process specified by the PID. For information ...

    解决Mysql Error-The user specified as a definer (‘mysql.infoschema’

    在MySQL数据库操作中,"The user specified as a definer (‘mysql.infoschema’@’localhost’) does not exist" 是一个常见的错误提示,这通常发生在尝试执行存储过程、触发器或者视图等对象时,这些对象的定义者...

    Xcode自动化打包

    iOS 自动化打包脚本,并上传*ipa*文件至蒲公英。... Build the scheme specified by schemename. Required if building a workspace. -m description, --desc=description Pgyer update description.

    google api php client

    The method used is a matter of preference, but *it will be very difficult to use this library without first understanding the JSON syntax for the API*, so it is recommended to look at the [APIs ...

    2009 达内Unix学习笔记

    [] 匹配中括号里的内容[a-z][A-Z][0-9]。 ! 事件。 $ 取环境变量的值。 | 管道。把前一命令的输出作为后一命令的输入,把几个命令连接起来。 |经常跟tee连用,tee 把内容保存到文档并显示出来。 三、通用后...

    sql例子:导出/导入数据到exel

    例如,Python的DB-API或者ORM框架(如SQLAlchemy)可以用于执行SQL语句插入数据。 5. Excel插件:某些数据库管理系统提供专门的Excel插件,如Microsoft SQL Server的SSIS(SQL Server Integration Services),可以...

    http-ping工具

    Please specify the full path, and use quotes if the file name contains spaces. -ua user-agent Set the User-Agent value to 'user-agent'. Please use quotes if the value contains spaces. -h header-...

    'FrontEnd Plus' The GUI for the fast JAva Decompiler.

    your own output file name use the output redirection: jad -p example1.class > myexm1.java Option -d allows you to specify another directory for output files, which are created, by default, in the ...

    BURNINTEST--硬件检测工具

    number of Network Addresses specified in Preferences->Network will be the number of NICs tested. This will error faulty NICs that are not detected by the BurnInTest auto NIC detection mechanism. ...

    servlet2.4doc

    Returns the object bound with the specified name in this session, or null if no object is bound under the name. getAttributeNames() - Method in interface javax.servlet.ServletContext Returns an ...

    cesiumlab依赖库.zip

    Error: The specified module could not be found. 1\?C:\Program Files\cesiumlab2\tools\LabNative.node 请下载此依赖底(包含vcruntime140_1.dll和msvcp140_1.dll),解压到C:\Windows\System32下

    ASP.NET The system cannot find the file specified解决办法

    ASP.NET The system cannot find the file specified解决办法 Server Error in ‘/’ Application. The system cannot find the file specified Description: An unhandled exception occurred during the execution...

    计算机网络第六版答案

    Hence, it becomes possible for the attacker to issue a command to all the nodes, that target a single node (for example, all nodes in the botnet might be commanded by the attacker to send a TCP SYN ...

    IGCSE Additional Maths

    Give non-exact numerical answers correct to 3 significant figures, or 1 decimal place in the case of angles in degrees, unless a different level of accuracy is specified in the question. The use of an...

    Change Color of Component in Specific Display State Example

    Preconditions: Verify that the specified assembly and part exist. Postconditions: 1. Opens the specified assembly document. 2. Examine the graphics area, then press F5. 3. Changes the selected ...

    微软内部资料-SQL性能优化5

    A clustered index is like a telephone directory in which all of the rows for customers with the same last name are clustered together in the same part of the book. Just as the organization of a ...

    vs常见编译错误集锦

    vs常见编译错误集锦 vs常见编译错误集锦 vs常见编译错误集锦

    greenplum-db-6.2.1-rhel7-x86_64.rpm

    The PXF JDBC Connector now supports pushdown of OR and NOT logical filter operators when specified in a JDBC named query or in an external table query filter condition. PXF supports writing Avro-...

Global site tag (gtag.js) - Google Analytics