连接数据库的时候报错
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 "".
收起