您好,登录后才能下订单哦!
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
要设置DB2数据库日志保留期限,请按照以下步骤操作:
打开DB2命令行工具(DB2 Command Line Processor,DB2 CLP)或者使用DB2图形界面工具(如DB2 Workbench/J)。
使用ONSPACE
命令创建一个新的表空间,并设置日志保留期限。例如,要将日志保留期限为7天,请执行以下命令:
ONSPACE NEW TABLESPACE log_tspace
DATAFILE 'log_tspace.dat' SIZE 100M
AUTOEXTEND ON MAXSIZE UNLIMITED
LOGFILE GROUP log_group
LOGFILE 'log_tspace.log' SIZE 50M
AUTOEXTEND ON MAXSIZE UNLIMITED
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log2.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log3.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log4.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log5.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log6.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log7.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log8.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log9.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log10.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log11.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log12.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log13.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log14.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log15.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log16.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log17.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log18.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log19.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log20.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log21.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log22.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log23.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log24.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log25.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log26.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log27.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log28.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log29.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log30.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log31.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log32.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log33.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log34.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log35.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log36.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log37.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log38.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log39.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log40.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log41.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log42.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log43.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log44.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log45.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log46.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log47.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log48.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log49.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log50.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log51.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log52.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log53.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log54.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log55.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log56.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log57.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log58.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log59.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log60.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log61.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log62.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log63.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log64.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log65.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log66.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log67.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log68.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log69.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log70.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log71.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log72.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log73.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log74.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log75.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log76.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log77.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log78.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log79.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log80.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log81.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log82.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log83.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log84.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log85.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log86.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log87.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log88.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log89.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log90.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log91.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log92.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log93.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log94.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log95.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log96.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log97.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log98.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log99.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log100.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log101.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log102.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log103.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log104.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log105.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log106.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log107.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log108.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log109.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log110.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log111.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log112.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log113.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log114.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log115.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log116.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log117.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log118.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log119.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log120.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log121.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log122.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log123.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log124.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log125.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log126.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log127.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log128.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log129.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log130.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log131.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log132.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log133.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log134.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log135.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log136.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log137.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log138.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log139.log' SIZE 50M
LOGFILE GROUP log_group ADD LOGFILE 'log_tspace_log140.log' SIZE 50M
LOGFILE GROUP log_group
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。