IBM Support

IT31531: THE DB2CLUSTER -CM -CLEAR -ALERT COMMAND FAILS WHEN RUN AS NON INSTANCE OWNER PART OF SYSADM, SYSMAINT, OR SYSADM GROUP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The "db2cluster -cm -clear -alert" command fails when run as a
    non-instance owner user that is part of the SYSADM, SYSMAINT, or
    SYSADM group. This is due to incorrect permissions being set on
    the following pgrp files:
    
    [db2inst1@coralpib257 /home/db2inst1/sqllib/ctrl]: ls -al | grep
    pgrp
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .cfpgrp.128
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .cfpgrp.129
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:21
    .db2pgrp.000
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:21
    .db2pgrp.001
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .idlpgrp.coralpib257.997
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .idlpgrp.coralpib257.998
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .idlpgrp.coralpib257.999
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .idlpgrp.coralpib258.997
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .idlpgrp.coralpib258.998
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:20
    .idlpgrp.coralpib258.999
    -rw-r--r--    1 db2inst1   pdxdb2          290 Jan 15 16:21
    .primarypgrp.900
    
    The permissions on these files should instead be:
    -rw-rw-r--
    
    As a result of this issue, we can see the below error in the
    db2diag.log:
    
    2019-12-22-11.30.47.646036+540 I18908653A1011     LEVEL: Error
    (OS)
    PID     : 49545660             TID : 1
    FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
    CALLED  : OS, -, open                             OSERR: EACCES
    (13)
    DATA #1 : String, 136 bytes
    A total of 2 analysis will be performed :
     - User info
     - Path access permission
     Target file = /home/db2inst1/sqllib/ctrl/.db2pgrp.000
    DATA #2 : String, 188 bytes
      Real user ID of current process       = 3602
      Effective user ID of current process  = 3602
      Real group ID of current process      = 3600
      Effective group ID of current process = 3600
    DATA #3 : String, 41 bytes
    current sbrk(0) value: 0x00000001106d17a0
    DATA #4 : String, 297 bytes
    Information of each subdirectory leading up to the first
    inaccessible one is shown in the format below :
       <UID>:<GID>:<permissions> (subdirectories)
       2:two:755 (home)
       3601:3600:755 (db2inst1)
       3601:3600:3775 (sqllib)
       0:3600:777 (ctrl is a link)
       3601:3600:644 (.db2pgrp.000 is a link)
    

Local fix

  • Run "db2cluster -cm -clear -alert" as the instance owner or
    change the permissions of the pgrp files to -rw-rw-r--.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Purescale User                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Run "db2cluster -cm -clear -alert" as the instance owner or  *
    * change the permissions of the pgrp files to -rw-rw-r--.      *
    ****************************************************************
    

Problem conclusion

  • See description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31531

  • 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

    2020-01-15

  • Closed date

    2021-03-16

  • Last modified date

    2021-03-16

  • 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

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
04 May 2022