Jumat, 20 Maret 2015
Troubleshooting - ILMT 9.0 database for server creation
Selamat bertemu kembali Sobat semua !, saya harap Sobat semua masih dalam keaadaan sehat dan bahagia. Dalam kesempatan ini kita akan mengupas tentang Troubleshooting - ILMT 9.0 database for server creation."
Quick post regarding IBM License Metric Tool version 9.0 installation that may help some of you... To be more precise, regarding database creation and configuration for ILMT server.
In case you cannot pass through the Create and configure the application database panel because of error:
Authentication incorrect user name or password.�
Please double check if your User Name* has no more than 8 characters (DB2 limitation I believe). I spent some time figuring out what is wrong and finally when I shrank the length of the user from 9 characters to 8, everything went smoothly.
Some extracts from /opt/IBM/LMT/wlp/usr/servers/server1/logs/tema.log:
I: Servlet Message - [tema]:.[ERROR] com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.64.104] The application server rejected establishment of the connection.�
An attempt was made to access a database, ILMTDB, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
Acquiring connection has failed after 0.022 sec, login_timeout was not set
[4/14/14 9:50:31:111 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[ERROR] Database validation error: #<#: NativeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.64.104] The application server rejected establishment of the connection.
An attempt was made to access a database, ILMTDB, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004>
[4/14/14 9:50:31:111 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] Database connection error when testing connection: NativeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.64.104] The application server rejected establishment of the connection.
An attempt was made to access a database, ILMTDB, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
[4/14/14 9:50:31:111 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] The database will be automatically created on localhost...
[4/14/14 9:50:31:112 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] The parameters are: {"is_localhost"=>"1", "port"=>"50000", "database"=>"ILMTDB", "username"=>"UserName1", "password"=>"********", "db2_instance_owner"=>"db2inst1"}
[4/14/14 9:50:31:118 UTC] 00000052 SystemErr��������������������������������������������������� R chmod 700 /tmp/createdb_20140414_095031.sh
[4/14/14 9:50:31:121 UTC] 00000052 SystemErr��������������������������������������������������� R chown db2inst1 /tmp/createdb_20140414_095031.sh
[4/14/14 9:50:31:122 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] cmd: su - db2inst1 -c "export LANG=C;. ./sqllib/db2profile;ksh -c \"/tmp/createdb_20140414_095031.sh\""
"In case you cannot pass through the Create and configure the application database panel because of error:
Authentication incorrect user name or password.�
Please double check if your User Name* has no more than 8 characters (DB2 limitation I believe). I spent some time figuring out what is wrong and finally when I shrank the length of the user from 9 characters to 8, everything went smoothly.
Some extracts from /opt/IBM/LMT/wlp/usr/servers/server1/logs/tema.log:
I: Servlet Message - [tema]:.[ERROR] com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.64.104] The application server rejected establishment of the connection.�
An attempt was made to access a database, ILMTDB, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
Acquiring connection has failed after 0.022 sec, login_timeout was not set
[4/14/14 9:50:31:111 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[ERROR] Database validation error: #<#
An attempt was made to access a database, ILMTDB, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004>
[4/14/14 9:50:31:111 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] Database connection error when testing connection: NativeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.64.104] The application server rejected establishment of the connection.
An attempt was made to access a database, ILMTDB, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
[4/14/14 9:50:31:111 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] The database will be automatically created on localhost...
[4/14/14 9:50:31:112 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] The parameters are: {"is_localhost"=>"1", "port"=>"50000", "database"=>"ILMTDB", "username"=>"UserName1", "password"=>"********", "db2_instance_owner"=>"db2inst1"}
[4/14/14 9:50:31:118 UTC] 00000052 SystemErr��������������������������������������������������� R chmod 700 /tmp/createdb_20140414_095031.sh
[4/14/14 9:50:31:121 UTC] 00000052 SystemErr��������������������������������������������������� R chown db2inst1 /tmp/createdb_20140414_095031.sh
[4/14/14 9:50:31:122 UTC] 00000052 com.ibm.ws.webcontainer.webapp������������������������������ I SRVE0292I: Servlet Message - [tema]:.[INFO] cmd: su - db2inst1 -c "export LANG=C;. ./sqllib/db2profile;ksh -c \"/tmp/createdb_20140414_095031.sh\""
Source : http://lmt-tad4d.blogspot.com/2014/04/troubleshooting-ilmt-90-database-for.html
Akhirnya tiada kata yang paling indah kecuali puji syukur alhamdulillah pada Allah atas berjuta nikmat yang tercurah pada kami. Semoga dengan kupasan tentang bahasan ini bisa memberikan nilai dan kesungguhan dalam belajar. Mungkin cukup sekian yang dapat saya sampaikan mengenai Troubleshooting - ILMT 9.0 database for server creation, ada kurang lebihnya serta kesalahan ucap baik yang saya sengaja atau tidak, saya mohon maaf.
Tags:
Langganan:
Posting Komentar (Atom)
0 Responses to “Troubleshooting - ILMT 9.0 database for server creation”
Posting Komentar