Hi,
how can I fix lock-waits during an online backup? Is an online backup
in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux.
The command to perform the backup is: db2 backup db BPEDB online to /
var/tmp
During the backup the application hangs on just one table
(variable_instance_b_t) which is a central table of the application
and which will be used a lot. But the table is not realy large, there
are about 50.000 rows in the table.
Here's an output of the locks hold by the backup session:
List Of Locks
Lock Name = 0x02006C00000000000000000074
Lock Attributes = 0x00000000
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 108
Object Type = Internal Table Alter Lock
Tablespace Name = USERSPACE1
Table Schema = DB2INST1
Table Name = VARIABLE_INSTANCE_B_T
Mode = S
Lock Name = 0x02006C0000000000000000006F
Lock Attributes = 0x00000000
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 2
Object Type = Internal Online Backup Lock
Tablespace Name = USERSPACE1
Table Schema = DB2INST1
Table Name = VARIABLE_INSTANCE_B_T
Mode = X
Lock Name = 0x02006C00000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 108
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = DB2INST1
Table Name = VARIABLE_INSTANCE_B_T
Mode = S
+ about 8 internal locks
Do you have any tipps to fix this issue?
Thanks
Michael