资讯详情

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后即可

标签: 06丝印z19三极管

锐单商城拥有海量元器件数据手册IC替代型号,打造 电子元器件IC百科大全!

锐单商城 - 一站式电子元器件采购平台