开发者

How to reduce log file size in Sybase Anywhere 11 during a Load statement

I've got a LOAD statement in a Sybase Anywhere 11 DB that I fire off. The problem is that it's an 开发者_JS百科insert of about 500k records. In my transaction log, I see tons of inserts (in addition to my load) that look this: SET n1 = n1 || [SOME LARGE HEX VALUES].

I know LOAD statements are just inserts, but is there anyway for me to just log a LOAD, instead of taking up > 100MB for one LOAD?


It looks like the issue was not having this in the LOAD table statement: WITH FILE NAME LOGGING. According to the docs, it's the default. I believe it was because I was calling it from a client file. Regardless, it now shows only a LOAD table statement in the log file.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜