DB2 create database报错SQL1036C,Could not init GLFH lock file

问题:

DB2 create database报错SQL1036C,db2diag.log中报错:Could not init GLFH lock file

db2inst1@HOST01:~> db2 "create db db02 on /ceshi/TESTDB/data dbpath on /ceshi/TESTDB"
SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030

部分db2diag.log如下:

2022-06-09-15.38.11.262629+480 I2647E2967 LEVEL: Severe
PID : 19135 TID : 140365076096768 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-9 APPID: *LOCAL.db2inst1.220609073807
AUTHID : DB2INST1 HOSTNAME: HOST01
EDUID : 18 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, oper system services, sqloNLCKInitInstanceWideNamedLock, probe:40
MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED
Access denied
DATA #1 : Codepath, 8 bytes
1:11:13:27
DATA #2 : String, 58 bytes
/ceshi/TESTDB/db2inst1/NODE0000/SQL00001/SQLOGCTL.GLFH.LCK
DATA #3 : unsigned integer, 8 bytes
4
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007FA95AE55107 /db2/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x4119107
[1] 0x00007FA95AE549FC sqloNLCKInit + 0x17C
[2] 0x00007FA95AEF7938 _ZN12SQLP_GLFH_CB8initLockEPKc + 0x68
[3] 0x00007FA95AEF774A _ZN12SQLP_GLFH_CB4lockEPKc + 0x3A
[4] 0x00007FA95AEEC252 _Z13sqlpgOpenGLFHPKcS0_S0_P9SQLP_GLFHP12SQLP_GLFH_CBm + 0x112
[5] 0x00007FA95AEEBA64 _Z13sqlpgOpenGLFHPKcP9SQLP_GLFHP12SQLP_GLFH_CBm + 0x114
[6] 0x00007FA95AEEB70F _Z21sqlpgReadGLFHFromDiskPKcP9SQLP_GLFHm + 0xAF
[7] 0x00007FA95AF3F72F _Z23sqlpCreateDatabaseFilesPcS_S_jPK10sqlf_dbcfdms + 0x1CF
[8] 0x00007FA959E84017 _Z11sqleInitLogP8SQLE_BWAP8sqeAgentss + 0x117
[9] 0x00007FA959E81402 _Z12sqleCreateDbsP8SQLE_BWAP10sqledbdescP13sqledbdescextPcS5_sS5_S5_S0_isiP13SQLE_CFG_RECSP26sqleCreateDBEncryptOptionsP5sqlca + 0xBF2
[10] 0x00007FA959E7E601 /db2/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x3142601
[11] 0x00007FA959E7C4B7 _Z17sqleCreateEntriesP8SQLE_BWAS0_PcP10sqledbdescP13sqledbdescextS1_S1_P16SQLEX_AUTHINFO_TccS1_S1_sS1_isiP13SQLE_CFG_RECSP26sql + 0x7C7
[12] 0x00007FA959E78896 _Z14sqlecrea_agentP5sqldaP5sqlca + 0x14F6
[13] 0x00007FA95A0FC1F3 _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgentP5sqlca + 0x693
[14] 0x00007FA95A0FDC76 _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x796
[15] 0x00007FA95DECA17E _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x9BE
[16] 0x00007FA95DEC920E _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x7E
[17] 0x00007FA95A1E5EC3 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x353
[18] 0x00007FA95A1E0498 /db2/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x34A4498
[19] 0x00007FA95A1DE96C /db2/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x34A296C
[20] 0x00007FA95A1DB9C9 /db2/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x349F9C9
[21] 0x00007FA95A1DB5BB _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xEB
[22] 0x00007FA959ED3A67 _ZN8sqeAgent6RunEDUEv + 0xAD7
[23] 0x00007FA95B739EC7 _ZN9sqzEDUObj9EDUDriverEv + 0xF7
[24] 0x00007FA95AED8F73 sqloEDUEntry + 0x303
[25] 0x00007FA962DEA74A /lib64/libpthread.so.0 + 0x874A
[26] 0x00007FA955A66F6D clone + 0x6D


2022-06-09-15.38.11.280911+480 I5615E682 LEVEL: Error
PID : 19135 TID : 140365076096768 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-9 APPID: *LOCAL.db2inst1.220609073807
AUTHID : DB2INST1 HOSTNAME: HOST01
EDUID : 18 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, data protection services, SQLP_GLFH_CB::initLock, probe:20
MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED
Access denied
DATA #1 : String, 29 bytes
Could not init GLFH lock file
DATA #2 : String, 58 bytes
/ceshi/TESTDB/db2inst1/NODE0000/SQL00001/SQLOGCTL.GLFH.LCK
​

原因分析:

根据链接:Access denied error in SQLOGCTL.GLFH.LCK when creating a Database.

将/dev/shm目录权限修改为777之后就可以了

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值