DB2 - Problembeschreibung
Problem IT27298 | Status: Geschlossen |
ON PURESCALE SYSTEMS WITH A LARGE NUMBER OF MEMBERS OR FILESYSTEMS, DB2CLUSTER -CFS -ENTER -MAINTENANCE -ALL MAY HANG | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
On Purescale systems with a large number of file systems or cluster nodes, the output of underlying Spectrum Scale command mmshutdown can output more than default system pipe buffer capacity. This causes the mmshutdown command to block and causing the db2cluster command to hang. When encountering this error, you may see a procstack and proctree on the db2cluster command similar to the following: procstack: waitpid(??, ??, ??) + 0x200 GPFSCommandAdaptor::executeCommand(const char*,const char*,const unsigned int)(0x8, 0x11006a1b0, 0xffffffffffc3040, 0x0) + 0xc4c GPFSCommandAdaptor::executeCommandV2(const char*,const char*,const unsigned int)(??, ??, ??, ??) + 0x5c GPFSCluster::stop(int,char(*)[255])(??, ??, ??) + 0x258 db2haCFSEnterMaintenanceMode(0x18a8800018a88, 0x110031da0) + 0x54c sqlhaCFSCallFunctionDirect(0x1a0000001a, 0x110171050) + 0x438 sqlhaCFSCallFunction(??, ??, ??) + 0xc00 sqlhaCFSEnterMaintenanceMode(??, ??) + 0x3c sqlhaUIEnterMaintenanceModeForCFSAll(sqlhaUICB*)(??) + 0xcac main(??, ??) + 0x4820 __start() + 0x70 proctree: 3932170 /usr/sbin/srcmstr 7077918 /usr/sbin/sshd 22937706 sshd: db2inst [priv] 2496318 sshd: db2inst@pts/2 24772836 -ksh 22741122 -ksh 24117288 ./db2cluster -cfs -enter -maintenance -all 21692660 /usr/lpp/mmfs/bin/mmksh /usr/lpp/mmfs/bin/mmshutdown -a 25296900 /usr/lpp/mmfs/bin/mmksh /usr/lpp/mmfs/bin/mmcommon onall /var/mmfs/tmp/nodefile 20185254 /usr/bin/perl /usr/lpp/mmfs/bin/mmdsh -vF /var/mmfs/tmp/cmdTmpDir.mmcommon.2529 22544406 The output of mmshutdown command will also exceed 32k. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local-Fix: | |
Redirect STDOUT and STDERR of mmshutdown command. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.12.2018 16.01.2020 16.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |