DB2 - Problembeschreibung
Problem IT27443 | Status: Geschlossen |
HIGH MEMORY CONSUPTION WITH CDC IF BACKUPS WITH MULTIPLE SEQUENCES(TARGET LOCATIONS) | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
User found the memory of process db2sysc kept increasing,and until run out of system memory,they must rebooting machine to free it. The symptom is the total size of pool dbheap kept increasing quickly when enabling CDC replication. $db2pd -memblocks sort -alldbp Memory blocks sorted by size for dbh pool: (PoolID: 2, SecondID: 0, PoolAddr: 0x0A000200000004B0) PoolID PoolName TotalSize(Bytes) TotalCount LOC File 2 dbh 15382967040 42730464 1541 1615387857 This problem affects users of readlog API and also affect the RECOVERY command. You can use LIST HISTORY to check whether your backup pointed to mutiple sequences: $ db2 backup db sample to /home/backup/dir1,/home/backup/dir2,/home/backup/dir3 Backup successful. The timestamp for this backup image is : 20181218213458 $ db2 list history backup all for db sample List History File for sample Number of matching file entries = 3 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID -- --- ------------------ ---- --- ------------ ------------ -------------- B D 20181218213458001 F D S0000000.LOG S0000000.LOG ---------------------------------------------------------------- ------------ Contains 5 tablespace(s): 00001 SYSCATSPACE 00002 USERSPACE1 00003 IBMDB2SAMPLEREL 00004 IBMDB2SAMPLEXML 00005 SYSTOOLSPACE ---------------------------------------------------------------- ------------ Comment: DB2 BACKUP SAMPLE OFFLINE Start Time: 20181218213458 End Time: 20181218213503 Status: A ---------------------------------------------------------------- ------------ EID: 4 Location: /home/backup/dir1 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID -- --- ------------------ ---- --- ------------ ------------ -------------- B D 20181218213458002 F D S0000000.LOG S0000000.LOG ---------------------------------------------------------------- ------------ Contains 5 tablespace(s): 00001 SYSCATSPACE 00002 USERSPACE1 00003 IBMDB2SAMPLEREL 00004 IBMDB2SAMPLEXML 00005 SYSTOOLSPACE ---------------------------------------------------------------- ------------ Comment: DB2 BACKUP SAMPLE OFFLINE Start Time: 20181218213458 End Time: 20181218213503 Status: A ---------------------------------------------------------------- ------------ EID: 5 Location: /home/backup/dir2 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID -- --- ------------------ ---- --- ------------ ------------ -------------- B D 20181218213458003 F D S0000000.LOG S0000000.LOG ---------------------------------------------------------------- ------------ Contains 5 tablespace(s): 00001 SYSCATSPACE 00002 USERSPACE1 00003 IBMDB2SAMPLEREL 00004 IBMDB2SAMPLEXML 00005 SYSTOOLSPACE ---------------------------------------------------------------- ------------ Comment: DB2 BACKUP SAMPLE OFFLINE Start Time: 20181218213458 End Time: 20181218213503 Status: A ---------------------------------------------------------------- ------------ EID: 6 Location: /home/backup/dir3 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local-Fix: | |
Prune the history file and only take backups with 1 target location. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.12.2018 16.01.2020 16.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |