IBM Support

IT17367: IN DPF ENV, USER WITH APPROPRIATE AUTHORITIES RECIEVES ERROR SQL6048N COMMUNICATION ERROR ON UPDATE DBM CFG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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
    

Local fix

  • Run the "update dbm cfg" command on the instance owner's id
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT17367

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-05

  • Closed date

    2017-06-23

  • Last modified date

    2017-06-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020