一、问题
为了查看Sybase ASE的错误信息,想把它查询出来 保存到一个文件。 环境是Linux SUSE下的 .
二、解决办法
1. 创建文件 my.sql 并把下面红色的SQL语句Copy保存.
/sybase/WEN/ASE-16_0/install # vi my.sql
select severity,error,description from sysmessages where severity >= 19 group by severity,error,description order by severity desc
go
注释: 表 sysmessages是在master数据库下面,如果报错找不到对象,use master ..go..
错误级别在 Severity Levels 19 – 26 Fatal problems generate error messages with severity levels 19 and higher. They break the user’s connection to SAP ASE (some of the higher severity levels shut down SAP ASE). To continue working, the user must restart the client program.
2. 运行下列 sql script
isql64 -Usa -Pxxx -SWEN -w999 -i my.sql -X -o /sybase/WEN/ASE-16_0/install/err.log
3、 查询结果被保存到/sybase/WEN/ASE-16_0/install/err.log, 如结果:
26 1284
Used Lock Sleeptask Entry not in Chain.
26 1255
Unlinking a duplicate lock caused a task to be awakened.