证件照片怎么换底色:SQL1036C SQLSTATE=58030 An I/O error occurred while accessing the database.

来源:百度文库 编辑:九乡新闻网 时间:2024/03/29 14:00:07
因为误删了DB2部分日志文件,导致数据库无法启动。$db2 "connect to dwods"
SQL1036C  An I/O error occurred while accessing the database.  SQLSTATE=58030解决方法如下:$db2 RESTORE DATABASE DWODS FROM /db2/backup/total TAKEN AT 20110218165517
SQL2539W  Warning!  Restoring to an existing database that is the same as the
backup image database.  The database files will be deleted.
Do you want to continue ? (y/n) y
DB20000I  The RESTORE DATABASE command completed successfully.

$db2start
03/01/2011 13:23:29     0   0   SQL1026N  The database manager is already active.
SQL1026N  The database manager is already active.
$db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 ADCL 9.1.0You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bndFor general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
  CATALOG DATABASE for help on the CATALOG DATABASE command
  CATALOG          for help on all of the CATALOG commands.To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.For more detailed help, refer to the Online Reference Manual.db2 => connect to dwods
SQL1117N  A connection to or activation of database "DWODS" cannot be made
because of ROLL-FORWARD PENDING.  SQLSTATE=57019
db2 => quit
DB20000I  The QUIT command completed successfully.
$db2 rollforward db DWODS to end of logs and complete                                 Rollforward Status Input database alias                   = DWODS
 Number of nodes have returned status   = 1 Node number                            = 0
 Rollforward status                     = not pending
 Next log file to be read               =
 Log files processed                    =  -
 Last committed transaction             = 2011-02-18-12.21.38.000000 UTCDB20000I  The ROLLFORWARD command completed successfully.
$db2 "connect to dwods"   Database Connection Information Database server        = DB2/AIX64 9.1.0
 SQL authorization ID   = DWODS
 Local database alias   = DWODS