启用归档日志记录时报错,AIX环境,命令如下:$ db2 update db cfg for sample using logarchmeth1 /home/db2inst1/archSQL5099N The value "/HOME/DB2INST1/ARCH" indicated by the database configuration parameter "LOGARCHMETH1" is not valid, reason code "...(more)
linux8 + db2 V8.2 归档模式logarchmeth1和db2的活动日志文件放在不同的目录下。插入大量的数据后再查看logarchmeth1的路径,看到的最后一个归档日志文件为S0000043.log ,通过db2 get db cfg|grep -i log后,查看到first active log file=S0000043.log为何first active log ...(more)
在db2中,如何清除归档日志?当然,如果归档日志和活动日志是放在同一个目录下的话,是可以用db2 "prune logfile prior to '$path'但如果没有放在同一个目录下的话用db2 "prune logfile prior to '$path'就不起作用了我看了网上的,说要用db2 "prune history timestamp ...."这个...(more)
db2 backup db testdb online incremental to $HOME/bak/inc include logsdrop db testdb这样一来,把归档日志及日志都删除了,如何恢复?---------------------------------------------------------------------------[1]:db2 restore db testdb incremental au...(more)