db2 connect to itsystm
SQL1391N The database is already in use by another instance of the database
manager. SQLSTATE=51023
db2版本:
DB21085I Instance "dmin" uses "64" bits and DB2 code release "SQL09054"
with level identifier "06050107".
Informational tokens are "DB2 v9.5.0.4", "s090429", "U825478", and Fix Pack
"4".
Product is installed at "/opt/IBM/db2/V9.5".
os:aix 5300-07-01-0748
db2diag.log
2012-03-07-08.30.02.198571+480 I5707568A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: admin NODE : 000 DB : ITSYSTM
APPHDL : 0-36922 APPID: *LOCAL.admin.120307003002
AUTHID : ADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:6
DATA #1 : Hexdump, 40 bytes
0x07000000057FE1E6 : 2F64 6232 6461 7461 2F64 6231 2F69 7461 /db2data/a
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-00.00.01.459057+480 I5708247A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: admin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.admin.120307160001
AUTHID : ADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
RETCODE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
2012-03-08-00.00.01.459636+480 I5708809A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: admin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.admin.120307160001
AUTHID : ADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/admin/NODE0000/SQL00001/SQLINSLK
2012-03-08-00.00.01.459809+480 I5709281A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: admin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.admin.120307160001
AUTHID : ADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:5
RETCODE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
1.问题描述:3月9号,检查数据库的时候,在服务器端发现数据库异常,无法打开,无法进行任何操作;
从客户端可以打开数据库,可读,但也无法进行任何DBA管理操作。
对业务没有影响,只是无法管理数据库。
2.分析:
通过检查db2diag.log 日志,There is an error opening log control files:
/db2data/admin/NODE0000/SQL00001/SQLOGCTL.LFH.1
/db2data/admin/NODE0000/SQL00001/SQLOGCTL.LFH.2
fuser -u /db2data/admin/NODE0000/SQL00001/SQLOGCTL.LFH.1
db2pd -edu
发现占用着2个文件的进程不是目前正在启用的进程。
出现这个error ,是由于有DB2其他进程在占用这2个文件,没有正常的释放文件,造成后面的程序无法打开这2个文件。
所以就出现了这种现象,这是DB2的一个bug。
3.处理:重启db2实例,释放ipc资源,数据库恢复正常
这个问题也与下面这个问题有点类似
http://www-01.ibm.com/support/docview.wss?uid=swg21432619