DB2 SQL1042C错误，请大神解决下

这个错误号一般要开trace看下OS的具体报错，有时候db2diag里也会有一些信息收起

    咱们是装完之后第一次用就出这错呢，还是之前用的好好的然后出错的？
如果是刚装完，那可能是安装过程有问题，特别是环境相关的，检查一下安装步骤有啥遗漏的。如果是之前用得好好的，那就想想最近有什么改动。
分析db2diag.log应该是一个好的开始。收起

    版主这个步骤是哪儿抄来的啊。。。收起

哦，windows上db2diag.log默认藏在C盘document and setting某个地方了。。
可以用db2 get dbm cfg 然后找   DIAGPATH，就能找到了。

对于SQL1042C， 还是要根据情况来看。

->db2 "? SQL1042C"


SQL1042C  An unexpected system error occurred.

Explanation:

A system error occurred. Some possible reasons for this error are:

*  The database manager is not installed correctly or the environment is
   not set up correctly.
*  On UNIX-based systems, db2iupdt may need to be run in order to update
   the DB2 instance to enable acquisition of a new system configuration
   or access to function associated with the installation or removal of
   certain product options, FixPaks, or modification levels.
*  You might get this message if you are not using the correct DB2
   Administration Server password.

The command cannot be processed.

User response:

*  To update the instance to acquire a configuration or access to
   function run DB2IUPDT .
*  If the error occurred while trying to connect to a database, get a
   trace (instructions below) and call IBM support.

If the problem falls outside of these suggestions, ensure that the
system time and date is correctly set, and make sure your system has
enough memory and swapping/paging space available.

Resubmit the current command.

If the error continues, stop the database manager and restart it.

If the error still continues, reinstall the database manager.

If trace was active, invoke the Independent Trace Facility at the
operating system command prompt. Contact your technical service
representative with the following information:

Required information:

*  Problem description
*  SQLCODE or message number
*  SQLCA contents if possible
*  Trace file if possible.

Federated system users: if necessary isolate the problem to the data
source rejecting the request. If the problem is with a data source
follow the problem determination procedures for that data source.

sqlcode: -1042

sqlstate: 58004


   Related information:
   Troubleshooting data source connection errors收起

你好：
    这个报错是由系统环境改变引起的，我们可以执行系统实例更新来解决：DB2IUPDT ，如果更新实例失败的话，可以查看日志:
1.db2ilist
2.db2trc on -t -f db2trc.dmp
3.db2 connect to
4.db2 select * from ....
5.db2trc off
6.db2trc flw -t db2trc.dmp db2trc.flw
7.db2trc fmt db2trc.dmp db2trc.fmt
8.db2 get db cfg for dbname|more
9.db2 update db cfg for test using para_name para_value
10.db2stop
11.db2start收起

回复 2# haoqingyun 我全局搜索也没搜到 db2diag.log  这个日志文件啊，我们公司的 DB2装在WINDOWS SERVER下面的，启动db2 resource manager的时候报的 SQL1042C错误 ；

  请问有什么常规的解决办法吗收起

呃。。。。 就一个错误代码，你让大家怎么帮忙啊。。。。

至少告诉一下是什么场景什么操作返回这个错误，以及db2diag.log里面有啥相关的错误信息。收起