I am not very familiar with docker installs
I did the setup of docker in a vm, created a db.. all went ok
a user is using docker on windows - no problems
now he retrieved the docker container/image for db2 and tries to create a database
this process is using 100% cpu and after 30min still hanging
he tried the create the db manually - same result
I publish some consoles of this - maybe someone has a hint..
Tried both, none Works.
Docker db2 log:
(*) Previous setup has not been detected. Creating the users...
(*) Creating users ...
(*) Creating instance ...
DB2 installation is being initialized.
Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)
Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end
Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end
Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/db2icrt.log.72".
DBI1446I The db2icrt command is running.
DBI1070I Program db2icrt completed successfully.
07/06/2021 13:39:04 0 0 SQL1032N No start database manager command was issued.
SQL1032N No start database manager command was issued. SQLSTATE=57019
(*) Cataloging existing databases
ls: cannot access /database/data/test/NODE0000: No such file or directory
(*) Applying Db2 license ...
LIC1402I License added successfully.
LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V11.5/license/en_US.iso88591"
(*) Saving the checksum of the current nodelock file ...
(*) Updating DBM CFG parameters ...
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
No Cgroup memory limit detected, instance memory will follow automatic tuning
(*) Remounting /database with suid...
(*) Nothing appears in the Db2 directory. will skip update/upgrade.
(*) Code level is the same. No update/upgrade needed.
DB2 State : Operable
DB2 has not been started
Starting DB2...
07/06/2021 13:39:14 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
(*) User chose to create IEEINT database
(*) Creating database IEEINT ...
----------------------------------------------------------------------------------------------------------------------------------
And here it is stuck. Any creation of database will just hang. Files are created but it is stuck.
If I stop the process and start it again, it will try to fix it and it will again hang in restart:
-------------------------------------------------------------------------------
(*) Previous setup has not been detected. Creating the users...
(*) Creating users ...
(*) Creating instance ...
DB2 installation is being initialized.
Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)
Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end
Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end
Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/db2icrt.log.70".
DBI1446I The db2icrt command is running.
DBI1070I Program db2icrt completed successfully.
07/06/2021 13:52:25 0 0 SQL1032N No start database manager command was issued.
SQL1032N No start database manager command was issued. SQLSTATE=57019
(*) Cataloging existing databases
(*) Cataloging database IEEINT on /database/data ...
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is
refreshed.
(*) Applying Db2 license ...
LIC1402I License added successfully.
chown: cannot access '/database/config/test/sqllib/adm/fencedid': No such file or directory
_________________________________________________________________________
_____ DB2 Service Tools _____
I B M
db2updv115
This tool is a service utility designed to update a DB2 Version 11.5
database to the current fix pack level.
_________________________________________________________________________
DB2 Universal Database Version 11.5, 5622-044 (c) Copyright IBM Corp. 2017
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool
LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V11.5/license/en_US.iso88591"
(*) Saving the checksum of the current nodelock file ...
(*) Updating DBM CFG parameters ...
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
No Cgroup memory limit detected, instance memory will follow automatic tuning
(*) Remounting /database with suid...
(*) Cannot retrieve db2 database configuration parameters. Calling an upgrade.
(*) Upgrading database IEEINT ...
07/06/2021 13:52:36 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
SQL1005N The database alias "IEEINT" already exists in either the local
database directory or system database directory.
SQL1103W The UPGRADE DATABASE command was completed successfully.
MESSAGE: Failed to fetch -433
MESSAGE: Error checking existence of system view : SYSIBM.SQLCOLUMNS
MESSAGE: Rolling back work due to sqlcode: -433 on line 2253.
MESSAGE: Error updating one system array so forcing to recreate everything..
db2updv115 completed successfully for database 'IEEINT'.
DB2 State : Available
DB2 has been started
(*) User chose to create IEEINT database
(*) Creating database IEEINT ...
SQL1005N The database alias "IEEINT" already exists in either the local
database directory or system database directory.
07/06/2021 13:53:08 0 0 SQL1026N The database manager is already active.
SQL1026N The database manager is already active.
### Enabling LOGARCHMETH1
Database Connection Information
Database server = DB2/LINUXX8664 11.5.5.1
SQL authorization ID = TEST
Local database alias = IEEINT
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
### Restarting DB2
Stopped it forcefully again.
Third time, it looks like it started but I cannot connect and it looks like it is broken:
(*) Previous setup has not been detected. Creating the users...
(*) Creating users ...
(*) Creating instance ...
DB2 installation is being initialized.
Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)
Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end
Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end
Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/db2icrt.log.71".
DBI1446I The db2icrt command is running.
DBI1070I Program db2icrt completed successfully.
chown: cannot access '/database/config/test/sqllib/adm/fencedid': No such file or directory
07/06/2021 13:56:27 0 0 SQL1032N No start database manager command was issued.
SQL1032N No start database manager command was issued. SQLSTATE=57019
(*) Cataloging existing databases
(*) Cataloging database IEEINT on /database/data ...
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is
refreshed.
(*) Applying Db2 license ...
LIC1402I License added successfully.
LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V11.5/license/en_US.iso88591"
(*) Saving the checksum of the current nodelock file ...
(*) Updating DBM CFG parameters ...
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
No Cgroup memory limit detected, instance memory will follow automatic tuning
(*) Remounting /database with suid...
(*) Cannot retrieve db2 database configuration parameters. Calling an upgrade.
(*) Upgrading database IEEINT ...
07/06/2021 13:56:38 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
SQL1005N The database alias "IEEINT" already exists in either the local
database directory or system database directory.
SQL1704N Database upgrade failed. Reason code "2".
_________________________________________________________________________
_____ DB2 Service Tools _____
I B M
db2updv115
This tool is a service utility designed to update a DB2 Version 11.5
database to the current fix pack level.
_________________________________________________________________________
DB2 Universal Database Version 11.5, 5622-044 (c) Copyright IBM Corp. 2017
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool
MESSAGE: Connect to database 'IEEINT' failed with sqlcode = -1116.
db2updv115 processing failed for database 'IEEINT'.
DB2 State : Available
DB2 has been started
(*) User chose to create IEEINT database
(*) Creating database IEEINT ...
SQL1005N The database alias "IEEINT" already exists in either the local
database directory or system database directory.
07/06/2021 13:56:42 0 0 SQL1026N The database manager is already active.
SQL1026N The database manager is already active.
### Enabling LOGARCHMETH1
SQL1116N A connection to or activation of database "IEEINT" failed because
the database is in BACKUP PENDING state. SQLSTATE=57019
SQL1024N A database connection does not exist. SQLSTATE=08003
### Restarting DB2
07/06/2021 13:56:44 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
07/06/2021 13:56:46 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
### Making backup directory and performing backup
Backup successful. The timestamp for this backup image is : 20210706135648
(*) Applying autoconfiguration for instance ...
Database Connection Information
Database server = DB2/LINUXX8664 11.5.5.1
SQL authorization ID = TEST
Local database alias = IEEINT
DB20000I The SQL command completed successfully.
07/06/2021 13:56:52 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
07/06/2021 13:56:53 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
ssh-keygen: generating new host keys: RSA1 RSA DSA ECDSA ED25519
(*) All databases are now active.
(*) Setup has completed.
false
2021-07-06-13.56.53.530783+000 I165796E375 LEVEL: Warning
PID : 17761 TID : 140494639576960 PROC : db2start
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:16078
MESSAGE : Released lock on the file:
DATA #1 : String, 35 bytes
/home/test/sqllib/ctrl/db2strst.lck
2021-07-06-13.56.54.823217+000 I166172E472 LEVEL: Warning
PID : 17842 TID : 140659735324544 PROC : db2cfexp
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:1
MESSAGE : Header:
DATA #1 : Hexdump, 32 bytes
0x00007FFF42FE13B0 : 2A2A 2A2A 2045 5850 4F52 5420 2A2A 2A2A **** EXPORT ****
0x00007FFF42FE13C0 : 2A20 2020 2020 5354 4152 5420 2020 202A * START *
2021-07-06-13.56.54.823325+000 I166645E367 LEVEL: Warning
PID : 17842 TID : 140659735324544 PROC : db2cfexp
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging function), probe:30
MESSAGE : ProfileName
DATA #1 : String, 25 bytes
/database/config/dbdbmcfg
2021-07-06-13.56.54.823368+000 E167013E959 LEVEL: Error (OS)
PID : 17842 TID : 140659735324544 PROC : db2cfexp
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, open OSERR: EACCES (13)
DATA #1 : Codepath, 8 bytes
2:11:15:40
DATA #2 : File name, 25 bytes
/database/config/dbdbmcfg
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_REPLACE, SQLO_READWRITE, SQLO_SHAREREAD
DATA #4 : Hex integer, 4 bytes
0x000001A0
DATA #5 : signed integer, 4 bytes
0
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2021-07-06-13.56.54.823527+000 I167973E1716 LEVEL: Error (OS)
PID : 17842 TID : 140659735324544 PROC : db2cfexp
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, open OSERR: EACCES (13)
DATA #1 : String, 123 bytes
A total of 2 analysis will be performed :
- User info
- Path access permission
Target file = /database/config/dbdbmcfg
DATA #2 : String, 188 bytes
Real user ID of current process = 1000
Effective user ID of current process = 1000
Real group ID of current process = 1000
Effective group ID of current process = 1000
DATA #3 : String, 41 bytes
current sbrk(0) value: 0x0000000001746000
DATA #4 : String, 251 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
<UID>:<GID>:<permissions> (subdirectories)
0:0:755 (database)
0:0:755 (config)
Cannot descend any further than the above subdirectory.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007FEDE88ADBA2 /home/test/sqllib/lib64/libdb2osse.so.1 + 0x24BBA2
[1] 0x00007FEDE88AEB5E ossLogSysRC + 0x8E
[2] 0x00007FEDE88A17A1 /home/test/sqllib/lib64/libdb2osse.so.1 + 0x23F7A1
[3] 0x00007FEDEA034725 sqloSystemErrorHandler + 0x455
[4] 0x00007FEDE9FAB0DA sqloopenp + 0x8EA
[5] 0x00007FEDEB555D52 _Z21cfgExportProfileItemsP8cfgIntCBP22CFG_EXPORT_PROFITEMS_TP5sqlca + 0x1A2
[6] 0x00007FEDEB5356C7 cfgica + 0x1157
[7] 0x00000000004019BF main + 0x64F
[8] 0x00007FEDE787A555 __libc_start_main + 0xF5
[9] 0x0000000000401B9F db2cfexp + 0x1B9F
2021-07-06-13.56.54.824887+000 I169690E392 LEVEL: Error
PID : 17842 TID : 140659735324544 PROC : db2cfexp
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:7
MESSAGE : Open file failed: rc =
DATA #1 : Hexdump, 4 bytes
0x00007FFF42FE1324 : 0100 0F84 ....
2021-07-06-13.56.54.824921+000 I170083E360 LEVEL: Error
PID : 17842 TID : 140659735324544 PROC : db2cfexp
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging function), probe:30
MESSAGE : File:
DATA #1 : String, 25 bytes
/database/config/dbdbmcfg
2021-07-06-13.56.54.824942+000 I170444E474 LEVEL: Warning
PID : 17842 TID : 140659735324544 PROC : db2cfexp
INSTANCE: test NODE : 000
HOSTNAME: db2server
FUNCTION: DB2 UDB, Client Config, cfgExportProfileItems, probe:253
MESSAGE : Header:
DATA #1 : Hexdump, 32 bytes
0x00007FFF42FE13B0 : 2A20 2020 2020 454E 4420 2020 2020 202A * END *
0x00007FFF42FE13C0 : 2A2A 2A2A 2045 5850 4F52 5420 2A2A 2A2A **** EXPORT ****
------------------------------
Thank for all update/help
Best Regards, Guy Przytula
------------------------------
#Db2