IBM Support

Installing IBM License Metric Tool v9.2 failed during the database creation task with "SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030" message.

Question & Answer


Question

Installing IBM License Metric Tool v9.2 failed during the database creation task with "SQL1036C An I/O error occurred during database access. SQLSTATE=58030" message.

Cause

Environment:

IBM License Metric Tool v9.2 using Db2 on a Linux Red Hat server.


As part of the IBM License Metric Tool installation process that uses All-In-One installer, it installed the Db2 successfully.
But it is failing to create BF database with the following error in the installation log:


BESAdminDebug.out

 
Wed, 17 Jun 2015 10:49:24 -0400 -- Entering LinuxAdminTool::DoPreinstall
Wed, 17 Jun 2015 10:49:24 -0400 -- [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 (58031:4294966265)
Wed, 17 Jun 2015 10:49:27 -0400 -- db2 returned 0x00000004:
SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030

SQL1013N The database alias name or database name "BFENT" could not be
found. SQLSTATE=42705


BESInstall.log

  
Starting db2inst1 instance ...
06/17/2015 10:49:24 0 0 SQL1026N The database manager is already active.
SQL1026N The database manager is already active.
Info: Creating the database for the server component, please wait ...
./repos/BESAdmin -preinstall -dbbesserver -dbname:"BFENT" -dbUsername:"db2inst1" -dbPassword:"********" -dbPort:"50000"
SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030

SQL1013N The database alias name or database name "BFENT" could not be
found. SQLSTATE=42705


db2diag.log

DATA #1 : <preformatted>
There was an error opening global LFH files:
/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGCTL.GLFH.1
/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGCTL.GLFH.2

2015-06-17-10.49.25.918407-240 I31512E675 LEVEL: Error
PID : 16782 TID : 139907779520256 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-7 APPID: *LOCAL.db2inst1.150617144925
AUTHID : DB2INST1 HOSTNAME: xxxxxxxxxxxxxxxxxxxx
EDUID : 22 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, data protection services, sqlpgReadGLFHFromDisk,
probe:3750
MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED
Access denied
DATA #1 : String, 42 bytes
/home/db2inst1/db2inst1/NODE0000/SQL00001/
DATA #2 : Hex integer, 8 bytes
0x0000000000000000

2015-06-17-10.49.25.918810-240 I32188E556 LEVEL: Error
PID : 16782 TID : 139907779520256 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-7 APPID: *LOCAL.db2inst1.150617144925
AUTHID : DB2INST1 HOSTNAME: xxxxxxxxxxxxxxxxxxxx
EDUID : 22 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, data protection services, sqlpCreateDatabaseFiles,
probe:200
MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED
Access denied

2015-06-17-10.49.25.919110-240 I32745E998 LEVEL: Error
PID : 16782 TID : 139907779520256 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-7 APPID: *LOCAL.db2inst1.150617144925
AUTHID : DB2INST1 HOSTNAME: xxxxxxxxxxxxxxxxxxxx
EDUID : 22 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, base sys utilities, sqleInitLog, probe:4576
MESSAGE : SQL1036C An I/O error occurred while accessing the database.

It seems that is something to do with the /home/db2inst1 file system.
Preventing the database to be created with Access Denied error.

Running command:
db2 create database sample
with db2inst1 user ID also fails with the same error.
The root cause of the problem is that the directory
/dev/shm
Does not have permissions set to 777

Answer

An "Access denied" error in SQLOGCTL.GLFH.LCK during database creation is a known issue as described in this technote.

Access denied error in SQLOGCTL.GLFH.LCK when creating a Database.


Resolving the problem:

Grant 777 permission to the directory
/dev/shm
Then, try to create a test database again running command:
db2 create database sample
Then, rerun the IBM License Metric Tool installation steps again.

[{"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 July 2021

UID

swg21960961

Page Feedback