db2 连接的时候报错，SQL1391N
连接数据库的时候报错db2 connect to itsystmSQL1391N The database is already in use by another instance of the database manager. SQLSTATE=51023db2版本：DB21085I Instance "itadmin" uses "64" bits and DB2 code release "SQL0...显示全部
连接数据库的时候报错
db2 connect to itsystm
SQL1391N The database is already in use by another instance of the database
manager. SQLSTATE=51023
db2版本：
DB21085I Instance "itadmin" 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: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-36922 APPID: *LOCAL.itadmin.120307003002
AUTHID : ITADMIN
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/db1/ita
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: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
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: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-00.00.01.459809+480 I5709281A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
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 "".
2012-03-08-00.00.01.460041+480 I5709845A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-00.30.01.972342+480 I5710524A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
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.30.01.972630+480 I5711086A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-00.30.01.972800+480 I5711558A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
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 "".
2012-03-08-00.30.01.973017+480 I5712122A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-04.30.01.573690+480 I5712801A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
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-04.30.01.574240+480 I5713363A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-04.30.01.574410+480 I5713835A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
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 "".
2012-03-08-04.30.01.574642+480 I5714399A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-04.45.02.123409+480 I5715078A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
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-04.45.02.123696+480 I5715640A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-04.45.02.123864+480 I5716112A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
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 "".
2012-03-08-04.45.02.124081+480 I5716676A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-05.00.01.560706+480 I5717355A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
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-05.00.01.561001+480 I5717917A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-05.00.01.561188+480 I5718389A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
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 "".
2012-03-08-05.00.01.561406+480 I5718953A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-05.00.01.561817+480 E5719632A399 LEVEL: Severe
PID : 458786 TID : 1 PROC : db2bp
INSTANCE: itadmin NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1258
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-1391
DATA #2 : Hexdump, 4 bytes
0x00000001100D0278 : FFFF FA91 ....
2012-03-08-05.00.01.562142+480 E5720032A779 LEVEL: Severe
PID : 458786 TID : 1 PROC : db2bp
INSTANCE: itadmin NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1258
MESSAGE : SQL1391N The database is already in use by another instance of the
database manager.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1391 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubCon
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 51023
2012-03-08-08.30.01.250699+480 I5720812A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37504 APPID: *LOCAL.itadmin.120308003001
AUTHID : ITADMIN
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-08.30.01.257970+480 I5721374A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37504 APPID: *LOCAL.itadmin.120308003001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-08.30.01.258162+480 I5721846A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37504 APPID: *LOCAL.itadmin.120308003001
AUTHID : ITADMIN
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 "".收起
db2 connect to itsystm
SQL1391N The database is already in use by another instance of the database
manager. SQLSTATE=51023
db2版本：
DB21085I Instance "itadmin" 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: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-36922 APPID: *LOCAL.itadmin.120307003002
AUTHID : ITADMIN
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/db1/ita
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: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
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: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-00.00.01.459809+480 I5709281A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
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 "".
2012-03-08-00.00.01.460041+480 I5709845A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37295 APPID: *LOCAL.itadmin.120307160001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-00.30.01.972342+480 I5710524A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
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.30.01.972630+480 I5711086A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-00.30.01.972800+480 I5711558A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
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 "".
2012-03-08-00.30.01.973017+480 I5712122A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37308 APPID: *LOCAL.itadmin.120307163001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-04.30.01.573690+480 I5712801A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
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-04.30.01.574240+480 I5713363A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-04.30.01.574410+480 I5713835A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
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 "".
2012-03-08-04.30.01.574642+480 I5714399A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37405 APPID: *LOCAL.itadmin.120307203001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-04.45.02.123409+480 I5715078A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
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-04.45.02.123696+480 I5715640A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-04.45.02.123864+480 I5716112A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
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 "".
2012-03-08-04.45.02.124081+480 I5716676A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37412 APPID: *LOCAL.itadmin.120307204502
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-05.00.01.560706+480 I5717355A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
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-05.00.01.561001+480 I5717917A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-05.00.01.561188+480 I5718389A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
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 "".
2012-03-08-05.00.01.561406+480 I5718953A678 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37419 APPID: *LOCAL.itadmin.120307210001
AUTHID : ITADMIN
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/db1/ita
0x07000000057FE1F6 : 646D 696E 2F4E 4F44 4530 3030 302F 5351 dmin/NODE0000/SQ
0x07000000057FE206 : 4C30 3030 3031 2F00 L00001/.
2012-03-08-05.00.01.561817+480 E5719632A399 LEVEL: Severe
PID : 458786 TID : 1 PROC : db2bp
INSTANCE: itadmin NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1258
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-1391
DATA #2 : Hexdump, 4 bytes
0x00000001100D0278 : FFFF FA91 ....
2012-03-08-05.00.01.562142+480 E5720032A779 LEVEL: Severe
PID : 458786 TID : 1 PROC : db2bp
INSTANCE: itadmin NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1258
MESSAGE : SQL1391N The database is already in use by another instance of the
database manager.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1391 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubCon
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 51023
2012-03-08-08.30.01.250699+480 I5720812A561 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37504 APPID: *LOCAL.itadmin.120308003001
AUTHID : ITADMIN
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-08.30.01.257970+480 I5721374A471 LEVEL: Error
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37504 APPID: *LOCAL.itadmin.120308003001
AUTHID : ITADMIN
EDUID : 2033 EDUNAME: db2agent (ITSYSTM) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_GetRelDBLockForInstance, probe:25
MESSAGE : /db2data/db1/itadmin/NODE0000/SQL00001/SQLINSLK
2012-03-08-08.30.01.258162+480 I5721846A563 LEVEL: Severe
PID : 520294 TID : 2033 PROC : db2sysc 0
INSTANCE: itadmin NODE : 000 DB : ITSYSTM
APPHDL : 0-37504 APPID: *LOCAL.itadmin.120308003001
AUTHID : ITADMIN
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 "".收起
查看其它 16 个回答zss0109211的回答
从报错来看,比较明显是SQLINSLK文件被另一个instance使用.
比较奇怪的是fuser并未看到其他进程使用情况.
LZ是否做了DB2 HA,或者是LZ停库的时候未停干净,残留的db2sysc进程hold 住SQLINSLK,
可以用db2stop force, db2_kill ,ipclean试一下再启动.
(db2start
03/09/2012 18:17:03 0 0 SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully)
FYI:
https://www-304.ibm.com/support/docview.wss?uid=swg21304871
CAUSE
It may be possible that another instance from another system also access the database. However, only one instance can access one database at a time. On AIX, you could use the "fuser -u SQLINSLK" to see if any local processes hold a lock on the database. Analysis and code walk through suggests that error messages from this function refer to the SQLINSLK file, which is used to ensure that a database is only used by one instance of the database manager.
SOLUTION
You can avoid this error by first restarting or stopping the instance. Then rename the file SQLINSLK to SQLINSLK.old, start the instance, and connect to the database. This should create a new SQLINSLK file and the problem should be resolved.
互联网服务 · 2012-03-09比较奇怪的是fuser并未看到其他进程使用情况.
LZ是否做了DB2 HA,或者是LZ停库的时候未停干净,残留的db2sysc进程hold 住SQLINSLK,
可以用db2stop force, db2_kill ,ipclean试一下再启动.
(db2start
03/09/2012 18:17:03 0 0 SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully)
FYI:
https://www-304.ibm.com/support/docview.wss?uid=swg21304871
CAUSE
It may be possible that another instance from another system also access the database. However, only one instance can access one database at a time. On AIX, you could use the "fuser -u SQLINSLK" to see if any local processes hold a lock on the database. Analysis and code walk through suggests that error messages from this function refer to the SQLINSLK file, which is used to ensure that a database is only used by one instance of the database manager.
SOLUTION
You can avoid this error by first restarting or stopping the instance. Then rename the file SQLINSLK to SQLINSLK.old, start the instance, and connect to the database. This should create a new SQLINSLK file and the problem should be resolved.