In a DPF env, a user with appropriate authorities (but not root
or the instance owner) receives error SQL6048N Communication
error on update dbm cfg if the hostname is not used in the
db2nodes.cfg. (example: db2nodes.cfg uses virtual IP addresses
instead)
Sample db2diag.log messages:
2016-09-07-10.45.27.857851-240 E2159E628 LEVEL:
Error (OS)
PID : 8798 TID : 140737353963296 PROC :
db2bp
INSTANCE: db2inst1 NODE : 001
HOSTNAME: DB2TEST
FUNCTION: DB2 UDB, oper system services, sqloSetREuid, probe:15
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating
system return code
was "".
CALLED : OS, -, setreuid OSERR: EPERM
(1)
DATA #1 : User id, 4 bytes
197310
DATA #2 : unsigned integer, 4 bytes
2
DATA #3 : User id, 4 bytes
14546
DATA #4 : User id, 4 bytes
13456
2016-09-07-10.45.27.858589-240 I2788E615 LEVEL:
Error
PID : 8798 TID : 140737353963296 PROC :
db2bp
INSTANCE: db2inst1 NODE : 001
HOSTNAME: DB2TEST
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitiateRemoteConnection, probe:100
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating
system return code
was "".
DATA #1 : String, 49 bytes
Unable to switch effective uid to instance owner.
DATA #2 : User id, 4 bytes
197310
DATA #3 : User id, 4 bytes
14546
DATA #4 : User id, 4 bytes
13456
2016-09-07-10.45.27.858968-240 I3404E1565 LEVEL:
Severe
PID : 8798 TID : 140737353963296 PROC :
db2bp
INSTANCE: db2inst1 NODE : 001
HOSTNAME: DB2TEST
FUNCTION: DB2 UDB, bsu security, sqlexRemoteUpdaterFlacc,
probe:2307
DATA #1 : String, 18 bytes
Remote flacc error
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -6048 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL11010
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000001
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #3 : signed integer, 4 bytes
-2079391743
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007FFFF58034A6
_Z23sqlexRemoteUpdaterFlacciPvP5sqlcaP13sqlo_nodeline + 0x336
[1] 0x00007FFFF58066FB
_Z20sqlex_update_dbm_cfgP6db2CfgP5sqlcacPb + 0x59B
[2] 0x00007FFFF5850156 _Z16sqlfusys_backendP12SQLE_DB2RA_T +
0x5E6
[3] 0x00007FFFF584F65D _Z16sqlf_dbm_backendP12SQLE_DB2RA_T +
0x5D
[4] 0x00007FFFF56BA12B _Z8sqleriarP12SQLE_DB2RA_T + 0x96B
[5] 0x00007FFFF5819FEE _Z10db2CfgCalljPvP5sqlcaj + 0x90E
[6] 0x00000000004689F6 _Z18clpbp_exe_sqlfusysv + 0x16D6
[7] 0x00000000004A3750 _Z10clp_bp_conv + 0xA00
[8] 0x00000000004A2D0F main + 0x23F
[9] 0x00007FFFF23E2D1D __libc_start_main + 0xFD
[10] 0x0000000000413889 /var/ibmdb2/nytxt960/sqllib/bin/db2bp
+ 0x13889
2016-09-07-10.45.27.913774-240 E4970E628 LEVEL:
Error (OS)
PID : 8798 TID : 140737353963296 PROC :
db2bp
INSTANCE: db2inst1 NODE : 001
HOSTNAME: DB2TEST
FUNCTION: DB2 UDB, oper system services, sqloSetREuid, probe:15
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating
system return code
was "".
CALLED : OS, -, setreuid OSERR: EPERM
(1)
DATA #1 : User id, 4 bytes
197310
DATA #2 : unsigned integer, 4 bytes
2
DATA #3 : User id, 4 bytes
14546
DATA #4 : User id, 4 bytes
13456
2016-09-07-10.45.27.857851-240 E2159E628 LEVEL:
Error (OS)
PID : 8798 TID : 140737353963296 PROC :
db2bp
INSTANCE: db2inst1 NODE : 001
HOSTNAME: DB2TEST
FUNCTION: DB2 UDB, oper system services, sqloSetREuid, probe:15
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating
system return code
was "".
CALLED : OS, -, setreuid OSERR: EPERM
(1)
DATA #1 : User id, 4 bytes
197310
DATA #2 : unsigned integer, 4 bytes
2
DATA #3 : User id, 4 bytes
14546
DATA #4 : User id, 4 bytes
13456 |
