证件照片怎么换底色: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
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
SQL1036C SQLSTATE=58030 An I/O error occurred while accessing the database.
The DBMS returned an unspecified error错误解决方案
Isolation (database systems) - Wikipedia, the...
a,an,the
rac安装过程中 error while loading shared libraries...
Leaders of the error management
启动电脑时,出现“ A disk read error occurred” 不能进入系统了...
configure: error: I couldn't find ....
I made a 'moral error', Strauss
i/o端口
HBase I/O: HFile
What Kind of Father Am I?: an article by James McConkey about parenting and being parented by sons | The American Scholar
I FIND THE WAY
I am a rock, I am an island. ? 关于Kindle
定冠词the和不定冠词a/an
The daily cup becoming an expensive habit
An authentic tale of the city
db2 ERRORCODE=-4499, SQLSTATE=08001,解决办法
分布式、远程I/O模块
I/O接口和I/O端口有区别? I/O 接口的作用是什么?
i talk to the wind
I could be the one
Senior managers do not pay attention to an error in communication
magento 1.4 There has been an error processing your request 错误