------------------------------ Command Entered ------------------------------ connect to TEST2 ----------------------------------------------------------------------------- Database Connection Information Database server = DB2/NT 7.2.6 SQL authorization ID = ADMINIST... Local database alias = TEST2 ------------------------------ Command Entered ------------------------------ DUMP TRANSACTION wiwi.test2 WITH NO_LOG ----------------------------------------------------------------------------- DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0104N An unexpected token "wiwi" was found following "DUMP TRANSACTION ". Expected tokens may include: "JOIN". SQLSTATE=42601 ------------------------------ Command Entered ------------------------------ DUMP TRANSACTION wiwi.test2 WITH NO_LOG DBCC SHRINKFILE( log,2G)----------------------------------------------------------------------------- DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0104N An unexpected token "wiwi" was found following "DUMP TRANSACTION ". Expected tokens may include: "JOIN". SQLSTATE=42601 ------------------------------ Command Entered ------------------------------ DUMP TRANSACTION wiwi.test2 WITH NO_LOG----------------------------------------------------------------------------- DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0104N An unexpected token "wiwi" was found following "DUMP TRANSACTION ". Expected tokens may include: "JOIN". SQLSTATE=42601 帮我看看,还是有问题啊,呵呵
然后把语句拷贝到方框中,
把
@DataBaseName 改成'库名'
@LogoFileName 改成'日志文件名'
@NewSize 新的大小值,单位为MB。
DUMP TRANSACTION @DataBaseName WITH NO_LOG
DBCC SHRINKFILE( @LogoFileName,@NewSize)
这两句在查询器中执行清空日志因为错误信息提到文件已满
------------------------------ Command Entered ------------------------------
connect to TEST2 -----------------------------------------------------------------------------
Database Connection Information Database server = DB2/NT 7.2.6 SQL authorization ID = ADMINIST... Local database alias = TEST2
------------------------------ Command Entered ------------------------------
DUMP TRANSACTION wiwi.test2 WITH NO_LOG -----------------------------------------------------------------------------
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0104N An unexpected token "wiwi" was found following "DUMP TRANSACTION ". Expected tokens may include: "JOIN". SQLSTATE=42601
------------------------------ Command Entered ------------------------------
DUMP TRANSACTION wiwi.test2 WITH NO_LOG DBCC SHRINKFILE( log,2G)-----------------------------------------------------------------------------
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0104N An unexpected token "wiwi" was found following "DUMP TRANSACTION ". Expected tokens may include: "JOIN". SQLSTATE=42601
------------------------------ Command Entered ------------------------------
DUMP TRANSACTION wiwi.test2 WITH NO_LOG-----------------------------------------------------------------------------
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0104N An unexpected token "wiwi" was found following "DUMP TRANSACTION ". Expected tokens may include: "JOIN". SQLSTATE=42601
帮我看看,还是有问题啊,呵呵
DB2 就不知道有没有类似的系统存储过程
你用过工具Rapid sql 吗?
支持Sql Server , DB2,Oracle的