Db2 (On Premises and Cloud)

docker on windows

  • 1.  docker on windows

    Posted Tue July 06, 2021 12:21 PM
    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
    ------------------------------