[dba_udb]

UDB V8.1 FP5
OS : Solaris.


I am seeing some connections going to Lock-waits while an online backup is being performed.

While the online backup is going on a few connections are trying to accesses a table in IX mode . And these connections are getting timed off after some time with 911 error code with 68 reason code.

I have identified the table which theese connections are trying to access.
And the mode too.

How do i resolve this problem. So far i thought that while the online backup is perofrmed , applications can connect to the database and perform updates.

Isn't it correct.

thanks

[sathyaram_s]

When an online backup is performed, the first step is to backup the catalog tablespace. To ensure consistency, the backup application takes a share lock on all catalog tables.
There are certain operations, like LOAD, RUNSTATS, DDLs etc, that tend to take an X-lock on a row(s) of the system catalog tables. Naturally, such applications will timeout when the catalog is being backed up or the backup may fail if such operations are in progress ...

This is more a timing issue ... I have worked around this by having a retry logic in runstats and/or backup scripts and scheduling the conflicting operations to happen at different times ...

Does this explain your problem or are you seeing something different ???

Cheers

Sathyaran

[dba_udb]

The table which is being requested for IX mode by the applications is not system catalog table. It is an application table.

THe backup has a Share lock on this table. At that time the application(s) are requesting IX mode on that table.

And after a couple of minutes the applications are getting timed off.

How do i resolve this problem. How do i implement a retry logic.
I am thinking it is more of application code issue.

[sathyaram_s]

Any chance it is a table in SMS tablespace with LOB data ?

Sathyaram

[dba_udb]

yes.

It got a BLOB column.
BLOB(2097152) LOGGED NOT COMPACT .


But this table is in DMS tablespace . But i see that this table with BLOB column was created in regaular tablespace of page size 4k.

[dba_udb]

Any inputs ..from any one..


thanks