Online backup fails with sql0911

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andrejf - 25 Oct 2007 03:58 GMT

Occasionally, regular online backup fails with sql0911 reason 68,
"lock-timeout" seconds after the command is issued.
Normally a second try is successfull. The database is always in use.

Can someone technically explain why this happens, which locks (type,
scope) prevent a backup to start, and maybe, is there a workaround
(not affecting the applications).

db is on a 8.2 fp11 level, userexit on, i am backuping online to tsm.

Regards,
AF

Reply to this Message

shenanwei@gmail.com - 25 Oct 2007 15:06 GMT

> Occasionally, regular online backup fails with sql0911 reason 68,
> "lock-timeout" seconds after the command is issued.
[quoted text clipped - 8 lines]
> Regards,
> AF

You must have somebody exclusive locked some table/row, backup wait
until itself timeout.
try set the LOCKTIMEOUT higher, so that backup will wait longer for
your other application to finish its work.

Reply to this Message

dotyet - 25 Oct 2007 20:56 GMT

but that value is set at DB CFG level. It will be applicable across
application, or am I missing something?

rgds,
dotyet

On Oct 25, 10:06 am, shenan...@gmail.com wrote:

> > Occasionally, regular online backup fails with sql0911 reason 68,
> > "lock-timeout" seconds after the command is issued.
[quoted text clipped - 13 lines]
> try set the LOCKTIMEOUT higher, so that backup will wait longer for
> your other application to finish its work.

Reply to this Message

dean.cochrane@gmail.com - 27 Oct 2007 04:46 GMT

> Occasionally, regular online backup fails with sql0911 reason 68,
> "lock-timeout" seconds after the command is issued.
> Normally a second try is successfull. The database is always in use.

Does the table have xLOBs in it?

Reply to this Message

andrejf - 29 Oct 2007 13:04 GMT

On 27 okt., 04:46, "dean.cochr...@gmail.com" <dean.cochr...@gmail.com>
wrote:

> > Occasionally, regular online backup fails with sql0911 reason 68,
> > "lock-timeout" seconds after the command is issued.
> > Normally a second try is successfull. The database is always in use.
>
> Does the table have xLOBs in it?

Not in user tables (there are some in sysibm.*). But we use some long
varchars...

Reply to this Message

deangc - 29 Oct 2007 15:52 GMT

> > Does the table have xLOBs in it?
>
> Not in user tables (there are some in sysibm.*). But we use some long
> varchars...

I don't think it's the same issue, then, sadly. We had a number of
clients with this issue. There are cases where locks will be held in
tables with LOBs in them in SMS tablespaces, and these can cause
online backups to fail. I understand that this has been fixed in 9.x,
but is still an issue in 8.x. This is not an issue if you are using
DMS tablespaces.

Reply to this Message