DB2 - Problem description
| Problem IT05112 | Status: Closed |
DB2START FAILS WITH SQL6048N WHEN USING HOSTNAME ALIAS IN DB2NODES.CFG | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
db2start using an alias in db2nodes.cfg will reports below
error :
$ db2start
SQL6048N A communication error
occurred during START or STOP DATABASE MANAGER processing.
SQL1032N No start database manager command was issued.
SQLSTATE=5701
db2diag.log entries :
2014-05-28-15.48.34.247523-300 E86136E426 LEVEL:
Error (OS)
PID : XXXX TID : XXXX PROC : db2start
INSTANCE: testdb NODE : 000
HOSTNAME: testdb
FUNCTION: DB2 UDB, oper system services, sqloRemoteShell,
probe:50
CALLED : OS, -, execvp OSERR: ENOENT
(2)
MESSAGE : Error invoking remote shell program.
DATA #1 : String, 12 bytes
/usr/bin/rsh
2014-05-28-15.48.35.249777-300 E86563E774 LEVEL:
Warning
PID : XXX TID : XXX PROC : db2start
INSTANCE: testdb NODE : 000
HOSTNAME: testdb
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:110
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR
"Communication error"
DATA #1 : String, 348 bytes
The remote shell program terminated prematurely. The most
likely
causes are either that the DB2RSHCMD registry variable is set to
an
invalid setting, or the remote command program failed to
authenticate.
It can also be the remote daemon is not completely started up
yet to
handle the request. This attempt will retry a few times before
giving
up.
DATA #2 : String, 12 bytes
/usr/bin/rsh
2014-05-28-15.48.35.250119-300 E87338E507 LEVEL:
Error
PID : XXX TID : XXX PROC : db2start
INSTANCE: testdb NODE : 000
HOSTNAME: testdb
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:200
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR
"Communication error"
DATA #1 : String, 11 bytes
testdb
DATA #2 : String, 7 bytes
db2host
DATA #3 : String, 51 bytes
No diagnostics available from remote shell program.
2014-05-28-15.48.35.250330-300 I87846E1157 LEVEL:
Event
PID : XXXXX TID : XXXX PROC : db2start
INSTANCE:testdb NODE : 000
HOSTNAME: testdb
FUNCTION: DB2 UDB, oper system services, sqloPdbOpenConnection,
probe:10
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR
"Communication error"
DATA #1 : String, 27 bytes
Retry the connection again.
DATA #2 : unsigned integer, 8 bytes
30
DATA #3 : unsigned integer, 8 bytes
30
CALLSTCK: (Static functions may not be resolved correctly, as
they are
resolved to the nearest symbol) Page 15 of 44
[0] 0x00007FFFF048B2A1 sqloPdbOpenConnection + 0x2D1
[1] 0x00007FFFF048AE68 sqloPdbStartStopNode + 0x138
[2] 0x00007FFFEF6B6D00
_Z20sqlePdbStartStopNodeiP13sqlo_nodelinePcS1_tS1_mP25sqlo_start
_stop_no
de_infom + 0x280
[3] 0x00007FFFEF6A7A72
_Z18sqleIssueStartStopiPvPcS0_P9sqlf_kcfdP18SQLE_INTERNAL_ARGSjj
P5sqlca
+ 0x2512
[4] 0x00007FFFEF6A3FDC
_Z20sqleProcessStartStopiPvP18SQLE_INTERNAL_ARGSP9sqlf_kcfdPcjjP
5sqlca
+ 0x52C
[5] 0x0000000000405CEC main + 0x268C
[6] 0x000000384D81ED1D __libc_start_main + 0xFD
[7] 0x00000000004035C9 __gxx_personality_v0 + 0x1A1
2014-05-28-15.48.36.252882-300 I89004E1202 LEVEL:
Error
PID : XXXX TID : XXX PROC : db2start
INSTANCE: testdb NODE : 000
HOSTNAME: testdb
FUNCTION: DB2 UDB, oper system services, sqloPdbOpenConnection,
probe:15
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR
"Communication error"
DATA #1 : Codepath, 8 bytes
1:3:5:11
DATA #2 : String, 35 bytes
Give up the remote command attempt.
DATA #3 : unsigned integer, 8 bytes
30
DATA #4 : unsigned integer, 8 bytes
30
CALLSTCK: (Static functions may not be resolved correctly, as
they are
resolved to the nearest symbol)
[0] 0x00007FFFF048B34B sqloPdbOpenConnection + 0x37B
[1] 0x00007FFFF048AE68 sqloPdbStartStopNode + 0x138
[2] 0x00007FFFEF6B6D00
_Z20sqlePdbStartStopNodeiP13sqlo_nodelinePcS1_tS1_mP25sqlo_start
_stop_no
de_infom + 0x280
[3] 0x00007FFFEF6A7A72
_Z18sqleIssueStartStopiPvPcS0_P9sqlf_kcfdP18SQLE_INTERNAL_ARGSjj
P5sqlca
+ 0x2512
[4] 0x00007FFFEF6A3FDC
_Z20sqleProcessStartStopiPvP18SQLE_INTERNAL_ARGSP9sqlf_kcfdPcjjP
5sqlca
+ 0x52C
[5] 0x0000000000405CEC main + 0x268C
[6] 0x000000384D81ED1D __libc_start_main + 0xFD
[7] 0x00000000004035C9 __gxx_personality_v0 + 0x1A1
2014-05-28-15.48.36.255432-300 I90207E309 LEVEL:
Event
PID : XXXXX TID : XXXXX PROC : db2start
INSTANCE: testdb NODE : 000
HOSTNAME: testdb
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop,
probe:8338
DATA #1 : signed integer, 4 bytes
-6048
2014-05-28-15.48.36.275852-300 I90517E1273 LEVEL:
Event
PID : XXXX TID : XXX PROC : db2start
INSTANCE: testdb NODE : 000
HOSTNAME: testdb
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop,
probe:10120
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -6048 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEOCON
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEPFIN
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11) | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 FP 7 * **************************************************************** | |
| Local Fix: | |
The workaround is to configure and use rsh or ssh for the connection. | |
| Solution | |
First Fixed in DB2 Version 10.5 FP 7 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.10.2014 01.02.2016 01.02.2016 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|