Database Connection Information Database server = DB2/LINUXX8664 9.5.7 SQL authorization ID = DB2INST1 Local database alias = SOURCE[db2inst1@localhost SQLOGDIR]$ ls -ltotal 12036-rw-------...
显示全部Database Connection Information
Database server = DB2/LINUXX8664 9.5.7
SQL authorization ID = DB2INST1
Local database alias = SOURCE
[db2inst1@localhost SQLOGDIR]$ ls -l
total 12036
-rw------- 1 db2inst1 dbadmin 4104192 Mar 14 15:36 S0000000.LOG
-rw------- 1 db2inst1 dbadmin 4104192 Mar 14 15:36 S0000001.LOG
-rw------- 1 db2inst1 dbadmin 4104192 Mar 14 15:36 S0000002.LOG
[db2inst1@localhost SQLOGDIR]$ db2 "select * from test"
ID
-----------
1
1
3
4
5
5 record(s) selected.
[db2inst1@localhost SQLOGDIR]$ rm *.LOG
[db2inst1@localhost SQLOGDIR]$ db2pd -db source -logs
Database Partition 0 -- Database SOURCE -- Active -- Up 0 days 00:04:01 -- Date 03/14/2012 15:40:13
Logs:
Current Log Number 0
Pages Written 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 0
Current LSN 0x00000271000C
Address StartLSN State Size Pages Filename
0x00002B8E68FA2918 0x000002710000 0x00000000 1000 1000 S0000000.LOG
0x00002B8E68FA29D8 0x000002AF8000 0x00000000 1000 1000 S0000001.LOG
0x00002B8E68FA2858 0x000002EE0000 0x00000000 1000 1000 S0000002.LOG
[db2inst1@localhost SQLOGDIR]$ db2 +c "insert into test values(6)"
DB20000I The SQL command completed successfully.
[db2inst1@localhost SQLOGDIR]$ db2pd -db source -logs
Database Partition 0 -- Database SOURCE -- Active -- Up 0 days 00:04:28 -- Date 03/14/2012 15:40:40
Logs:
Current Log Number 0
Pages Written 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 0
Current LSN 0x000002710041
Address StartLSN State Size Pages Filename
0x00002B8E68FA2918 0x000002710000 0x00000000 1000 1000 S0000000.LOG
0x00002B8E68FA29D8 0x000002AF8000 0x00000000 1000 1000 S0000001.LOG
0x00002B8E68FA2858 0x000002EE0000 0x00000000 1000 1000 S0000002.LOG
[db2inst1@localhost SQLOGDIR]$ ls -l
total 0
[db2inst1@localhost SQLOGDIR]$ db2 commit
SQL1034C The database is damaged. All applications processing the database
have been stopped. SQLSTATE=58031
[db2inst1@localhost SQLOGDIR]$ ls -l
total 0
[db2inst1@localhost SQLOGDIR]$
我的试验没遇到你所说的情况
收起