奇怪的58004错误。

oada

恢复一个库后，怎么也创建不了TRIGGER了。可是别的库中就可以正常创建TRIGGER。
错误信息如下：
=================================================================
SQL 状态：58004
供应商代码：-901
消息：[SQL0901] SQL system error. Cause . . . . . :   An SQL system error has occurred.  The current SQL statement cannot be completed successfully.  The error will not prevent other SQL statements from being processed. Previous messages may indicate that there is a problem with the SQL statement and SQL did not correctly diagnose the error. The previous message identifier was *N. Internal error type 4083 has occurred. If precompiling, processing will not continue beyond this statement. Recovery  . . . :   See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB command to view the output of a precompile.  An application program receiving this return code may attempt further SQL statements.  Correct any errors and try the request again.
因为突出显示的语句未能成功完成，所以处理结束
=================================================================

oada

自己顶！

oada

自己再顶！

seouldeng

是不是因为你恢复的库和以前的库的结构不一样呢？

oada

原帖由 seouldeng 于 2009-2-19 11:31 发表
是不是因为你恢复的库和以前的库的结构不一样呢？

应该不是。我自己从新使用SQL生成了表结构。结果还是一样的错误。

fxf_china

Recovery  . . . :   See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB command to view the output of a precompile.

oada

原帖由 fxf_china 于 2009-2-19 12:15 发表
Recovery  . . . :   See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB co ...

下面是详细的信息。不知道怎样使用ANZPRB命令  
Message . . . . :   The trigger operation failed.                        
Cause . . . . . :   The trigger operation for file SYS_P00002 in library  
  XXXXX, for trigger SYS_PEISONG_IO_TU in library XXXXX, failed because of
  errors. The operation was 1.  The reason code is 6.                     
    The operation codes and their meanings are as follows:               
        1 - Add a trigger
        ...
    The reason codes and their meanings are:
        ...
        06 - Cross Reference failed with return code X'10A1' and diagnostic code 0.
        ...
    Recovery  . . . :   Do one of the following based on the reason code shown,
  and then try the request again.
        ...
        06 - Report this problem using the Analyze Problem (ANZPRB) command.
        ...

oada

自己再再再顶！

chts

Message . . . . :   The trigger operation failed.     这里的message ID 是什么？

oada

原帖由 chts 于 2009-2-20 15:56 发表
Message . . . . :   The trigger operation failed.     这里的message ID 是什么？

Message ID . . . . . . :   CPD32E7       Severity . . . . . . . :   20      
Message type . . . . . :   Diagnostic                                       
Date sent  . . . . . . :   02/23/09      Time sent  . . . . . . :   10:02:44