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.
 +
 +
 +