600字范文,内容丰富有趣,生活中的好帮手!
600字范文 > DB2 create database报错SQL1036C Could not init GLFH lock file

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

时间:2021-09-23 11:50:18

相关推荐

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如下:

-06-09-15.38.11.262629+480 I2647E2967 LEVEL: SeverePID : 19135 TID : 140365076096768 PROC : db2sysc 0INSTANCE: db2inst1 NODE : 000 DB :APPHDL : 0-9 APPID: *LOCAL.db2inst1.220609073807AUTHID : DB2INST1 HOSTNAME: HOST01EDUID : 18 EDUNAME: db2agent (instance) 0FUNCTION: DB2 UDB, oper system services, sqloNLCKInitInstanceWideNamedLock, probe:40MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIEDAccess deniedDATA #1 : Codepath, 8 bytes1:11:13:27DATA #2 : String, 58 bytes/ceshi/TESTDB/db2inst1/NODE0000/SQL00001/SQLOGCTL.GLFH.LCKDATA #3 : unsigned integer, 8 bytes4CALLSTCK: (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-06-09-15.38.11.280911+480 I5615E682 LEVEL: ErrorPID : 19135 TID : 140365076096768 PROC : db2sysc 0INSTANCE: db2inst1 NODE : 000 DB :APPHDL : 0-9 APPID: *LOCAL.db2inst1.220609073807AUTHID : DB2INST1 HOSTNAME: HOST01EDUID : 18 EDUNAME: db2agent (instance) 0FUNCTION: DB2 UDB, data protection services, SQLP_GLFH_CB::initLock, probe:20MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIEDAccess deniedDATA #1 : String, 29 bytesCould not init GLFH lock fileDATA #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之后就可以了

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。