开发者

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

开发者 https://www.devze.com 2022-12-29 07:44 出处:网络
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

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

精彩评论

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