IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]

Document Information

Modified date:
18 March 2021