db2有没有类似于oracle中v$log_history这样的视图？

db2 list history archive log all for db_name

不知道这个满足你要求不

db2pd -db dbname -logs

SYSIBMADM.DB_HISTORY

db2 list history archive log since 20151010 for dbname

Try something similar below:

[db2inst1@s0 ~]$ db2 \"select start_time, char(firstlog,12) from SYSIBMADM.db_history where operation=\'X\'\"

START_TIME     2           

-------------- ------------

20150411054745 S0000000.LOG

20150411055203 S0000001.LOG

20150411055749 S0000002.LOG

20150411055758 S0000003.LOG

20150411140420 S0000004.LOG

20150512172418 S0000005.LOG

20150512173048 S0000006.LOG

谢谢，这个好像只能有日志信息，没有像ORACLE那样可以用sql统计出一定时间段的归档量等相关信息。