|
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 |
