Db2

 View Only

 Having trouble creating Instance on DB2LUW v11.5.9 Community Edition

Matthew Shalberg's profile image
Matthew Shalberg posted Thu April 24, 2025 11:46 AM

Doesn't like 'ese' ???  Any thoughts?

root[DEV]@vx12b1 dddb007]# /software/ddb/db2/v11.5.9/instance/db2icrt -a SERVER -p dddb007 -u ddlf001 dddb007
DBI1446I  The db2icrt command is running.

 

 

DB2 installation is being initialized.

 

Components selected or installed are not valid for the instance type  "ese".

 

A major error occurred during the execution that caused this program to
terminate prematurely. If the problem persists, contact your technical service
representative.

 

For more information see the DB2 installation log at
"/tmp/db2icrt.log.1536967".
DBI1264E  This program failed. Errors encountered during execution were
      written to the installation log file. Program name:
      db2icrt. Log file name: /tmp/db2icrt.log.1536967.

 

Explanation:

 

This message is returned when some processes and operations have failed.
Detailed information about the error was written to the log file.

 

User response:

 

Contact IBM support to get assistance in resolving this issue. Keep the
log file intact as this file is an important reference for IBM support.

 

 

   Related information:
   Contacting IBM Software Support

Paul J Pearon Jr's profile image
Paul J Pearon Jr

Although it is 12.1, here is the syntax I used on my most recent successful CE db2icrt:

[root ~]# date ; /opt/ibm/db2/V12.1/instance/db2icrt -p 50000 -u db2fenc1 db2inst1 ; date

Thu Apr 17 08:18:23 PM UTC 2025

DBI1446I  The db2icrt command is running.

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.1560".

DBI1070I  Program db2icrt completed successfully.

Thu Apr 17 08:18:48 PM UTC 2025

[root ~]#

EDIT:  I should have added this earlier:


db2licm -l

Product name:                     "DB2 Community Edition"
License type:                     "Community"
Expiry date:                      "Permanent"
Product identifier:               "db2dec"
Version information:              "12.1"
Max amount of memory (GB):        "8"
Max number of cores:              "4"
Enforcement policy:               "Hard Stop"
Features:
IBM DB2 Performance Management Offering:              "Not licensed"

Jan Nelken's profile image
Jan Nelken IBM Champion

Hi,

Oot of curiosity, what this log says:

/tmp/db2icrt.log.1536967

Jan Nelken's profile image
Jan Nelken IBM Champion

But - docs are saying:

-s InstType     Specifies the type of instance to create. Use the -s option only when you are creating an instance other than the default associated with the installed product from which you are running db2icrt.