环境:db2 10.5 purescale
问题描述:
db2start报错SQL1677N
db2inst1@node01:~/sqllib> db2start
SQL1677N DB2START or DB2STOP processing failed due to a DB2 cluster services error.
原因分析与解决:
db2diag.log如下,显示是因为缺少TSAMP license:
2019-10-13-22.50.26.305882+480 I515363E385 LEVEL: Event
PID : 23950 TID : 139929313036064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: node01
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:15220
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
2019-10-13-22.50.26.320766+480 E515749E1651 LEVEL: Severe
PID : 23950 TID : 139929313036064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: node01
FUNCTION: DB2 UDB, high avail services, sqlhaExecuteCommandLocal, probe:1260
DATA #1 : String, 26 bytes
/usr/sbin/rsct/bin/samlicm
DATA #2 : String, 2 bytes
-s
DATA #3 : signed integer, 8 bytes
6
DATA #4 : unsigned integer, 4 bytes
23952
DATA #5 : Boolean, 1 bytes
true
DATA #6 : unsigned integer, 8 bytes
33
DATA #7 : SQLHA Remote Command Output, PD_TYPE_SQLHA_COMMAND_RESPONSE, 3508 bytes
commandResponse->callRC: 0x00000000
commandResponse->output: Try and Buy license has expired.
DATA #8 : Hex integer, 4 bytes
0x00000000
DATA #9 : Hex integer, 4 bytes
0x00000001
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F43CA769801 _Z24sqlhaExecuteCommandLocalPcS_P22SQLHA_COMMAND_RESPONSEmb + 0x511
[1] 0x00007F43CA769125 sqlhaExecuteCommand + 0xF5
[2] 0x00007F43CA76828B _Z22sqlhaExecuteCommandSetP17SQLHA_COMMAND_SET + 0x11B
[3] 0x00007F43CE2E8C4C _Z33sqlhaGetLicenseStatusFromEachHostR24cmHostAndLicenseStatusesP19SQLHA_CONTROL_BLOCK + 0x30C
[4] 0x00007F43CE2DD0A3 _Z23sqlhaVerifyHostLicensesRbP19SQLHA_CONTROL_BLOCK + 0x153
[5] 0x00007F43CC81A188 _Z18sqleIssueStartStopiPvPcS0_P9sqlf_kcfdP18SQLE_INTERNAL_ARGSjjP5sqlca + 0x5948
[6] 0x00007F43CC81319D _Z20sqleProcessStartStopiPvP18SQLE_INTERNAL_ARGSP9sqlf_kcfdPcjjP5sqlca + 0x45D
[7] 0x00000000004061F7 main + 0x2AE7
[8] 0x00007F43C79A8C36 __libc_start_main + 0xE6
[9] 0x0000000000403679 __gxx_personality_v0 + 0x1A1
2019-10-13-22.50.26.354421+480 I517401E746 LEVEL: Error
PID : 23950 TID : 139929313036064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: node01
FUNCTION: DB2 UDB, high avail services, sqlhaGetLicenseStatusFromEachHost, probe:24101
MESSAGE : Problem running command on the host.
DATA #1 : SQLHA Remote Command Set, PD_TYPE_SQLHA_COMMAND_SET, 292120 bytes
commandSet->numCommands: 1
commandSet->options: NO THREAD
commandSet->options: LOCAL
commandSet->previousDb2RshCmd:
DATA #2 : SQLHA Remote Command Output, PD_TYPE_SQLHA_COMMAND_RESPONSE, 8 bytes
commandResponse->callRC: 0x0063BD10
commandResponse->output: NOT_POPULATED
DATA #3 : unsigned integer, 8 bytes
0
DATA #4 : String, 6 bytes
node01
2019-10-13-22.50.26.354805+480 I518148E465 LEVEL: Error
PID : 23950 TID : 139929313036064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: node01
FUNCTION: DB2 UDB, high avail services, sqlhaVerifyHostLicenses, probe:18358
MESSAGE : The cluster manager license for the host is not ok:
DATA #1 : String, 6 bytes
node01
DATA #2 : SQLHA_LICENSE_STATUS, PD_TYPE_SQLHA_LICENSE_STATUS, 4 bytes
SQLHA_LICENSE_STATUS_UNKNOWN
2019-10-13-22.50.26.355134+480 I518614E333 LEVEL: Severe
PID : 23950 TID : 139929313036064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: node01
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:5980
DATA #1 : String, 8 bytes
db2inst1
DATA #2 : Boolean, 1 bytes
false
2019-10-13-22.50.26.362310+480 I518948E1263 LEVEL: Event
PID : 23950 TID : 139929313036064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: node01
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:5980
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10058
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:
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1677 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLESSCM
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:
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
false
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Boolean, 1 bytes
false
DATA #7 : Boolean, 1 bytes
false
2019-10-13-22.50.26.363557+480 I520212E376 LEVEL: Warning
PID : 23950 TID : 139929313036064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: node01
FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:14933
MESSAGE : Released lock on the file:
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
查看TSAMP license状态:
node01:~ # /usr/bin/samlicm -s
Try and Buy license has expired.
查看TSAMP版本,如果是4.1的,则需要license文件sam41.lic, 如果是3.2版本的,则需要sam32.lic:
node01:~ # /usr/sbin/rsct/bin/samversion
rsa41svcs003b 4.1.0.3 Apr 13 2016 09:24:39
注册license,并查看
node01:~ # /usr/bin/samlicm -i sam41.lic
node01:~ # /usr/bin/samlicm -s
Product: IBM Tivoli System Automation for Multiplatforms 4.1.0.0
Creation date: Fri Aug 16 00:00:01 2013
Expiration date: Thu Dec 31 00:00:01 2037
参考资料:
https://www.ibm.com/support/pages/checking-tsamp-and-rsct-versions
https://www.ibm.com/support/pages/trybuy-invalid-or-expired-license-what-do