每天一条DB2命令-014

每天一条DB2命令-014
#查看log使用情况
db2pd -d dbname -logs

 

Database Member 0 -- Database SAMPLE -- Active -- Up 1 days 21:33:38 -- Date 2021-10-13-00.53.06.183522

Logs:
Current Log Number 97
Pages Written 183
Cur Commit Disk Log Reads 0
Cur Commit Total Log Reads 0
Method 1 Archive Status n/a
Method 1 Next Log to Archive n/a
Method 1 First Failure n/a
Method 2 Archive Status n/a
Method 2 Next Log to Archive n/a
Method 2 First Failure n/a
Log Chain ID 10
Current LSO 436878244
Current LSN 0x000000000013591D

Address StartLSN StartLSO State Size Pages Filename
0x0A000200111DFF58 00000000001350DE 436132001 0x00000000 1000 1000 S0000097.LOG
0x0A0002001820EF58 0000000000000000 440208001 0x00000000 1000 1000 S0000098.LOG
0x0A000200111DF5F8 0000000000000000 444284001 0x00000000 1000 1000 S0000099.LOG