Differences

This shows you the differences between two versions of the page.

Link to this comparison view

en:services:storage_services:backup:tsm:admin:fail302 [2020/11/24 07:46] (current)
bnachtw created
Line 1: Line 1:
 +====== DB2 initialization fails with Error 302 ======
 +===== Symptom =====
 +The database format and initialization fails with an Error 302, the /var/tivoli/tsm/dsmicfgx.trc shows something like this:
 +<code>
 +Tue Nov 24 07:27:03 CET 2020 com.tivoli.dsm.ServerConfig.ServerDB.createDb2Instance(): Stdout: DB2 installation is being initialized.
 +
 +The host name "h13-212" is invalid. Specify a valid host name.
 +
 +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.21316".
 +DBI1446I  The db2icrt command is running.
 +
 +DBI1446I  The db2icrt command is running.
 +
 +
 +DBI1264E  This program failed. Errors encountered during execution were
 +      written to the installation log file. Program name:
 +      db2icrt. Log file name: /tmp/db2icrt.log.21316.
 +
 +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.
 +
 +Tue Nov 24 07:27:03 CET 2020 com.tivoli.dsm.ServerConfig.ServerDB.createDb2Instance(): Stderr: 
 +Tue Nov 24 07:27:03 CET 2020 com.tivoli.dsm.ServerConfig.ServerDB.createDb2Instance(): exit, rc 302
 +Tue Nov 24 07:27:03 CET 2020 com.tivoli.dsm.ConfigWizard.DoFormatPanel.signalEvent(): enter, event=createInstanceDone, rc=302
 +Tue Nov 24 07:27:03 CET 2020 com.tivoli.dsm.ServerConfig.ServerDB$FormatThread.run(): exit
 +
 +</code>
 +===== Explanation =====
 +As well the user ID as the hostname must follow some special rules:
 +
 +Due to [[https://techiessite.com/error-occurred-creating-database-manager-instance-302-232/]]:
 +Check ID of database user:
 +  - User ID must be in lowercase(a-z)
 +  - User ID can contain 0-9 numbers
 +  - User ID can contain Underscores(_)
 +  - User ID must be 30 Characters or less
 +  - User ID should not start with ibm, sql, sys or numerals
 +  - User ID or group name should not be any of these names user, admin, guest, public, local or any sql reserved words
 +
 +Also check $hostname for the same rules, especially a hyphen ("-" ) is NOT allowed in the hostname!
 +
 +===== Workaround =====
 +Check Prerequisites mentioned above and change.
 +
 +
 +