问题:
如何查看某个DB2数据库的创建时间?
解决:
两种办法,第一个查看任何一个系统表的创建时间,比如SYSIBM.SYSTABLES。第二个是查询表SYSIBM.SYSVERSIONS的VERSION_TIMESTAMP字段
$ db2 "select create_time from syscat.tables where tabname='SYSTABLES'"
CREATE_TIME
--------------------------
2017-03-02-09.41.37.240948
1 record(s) selected.
$ db2 "select VERSION_TIMESTAMP from sysibm.sysversions"
VERSION_TIMESTAMP
--------------------------
2017-03-02-09.41.37.240948
1 record(s) selected.