达梦数据库超长SQL查看

1. 备份当前sqllog文件

cp sqllog.ini sqllog.ini.bak

2.更改sqllog配置

BUF_TOTAL_SIZE= 10240

BUF_SIZE_= 1024

BUF_KEEP_CNT= 6

[SLOG_ALL]

FILE_PATH=..\log

PART_STOR=0

SWITCH_MODE = 0

SWITCH_LIMIT = 0

ASYNC_FLUSH = 1

FILE_NUM = 0

ITEMS = 0

SQL_TRACE_MASK = 2:3:22:25:28

MIN_EXEC_TIME = 0

USER_MODE = 0

USERS =

3. 按顺序执行以下两条命令

SP_SET_PARA_VALUE(1,'SVR_LOG',0);

SP_SET_PARA_VALUE(1,'SVR_LOG',1);

4.查看的日志文件

more 对应路径/dmdbms/log/dmsql_实例名.log