By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,264 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,264 IT Pros & Developers. It's quick & easy.

-911 on online incremental or delta backup db2 luw 8.2 on AIX

P: n/a
I am getting -911 on online incremental or delta backup , anybody have
any explanation, backups go to tsm.
thanks

Jun 9 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
ma*****@gmail.com wrote:
I am getting -911 on online incremental or delta backup , anybody have
any explanation, backups go to tsm.


Well, this is an online backup. So it is competing with all other
transactions to access the data being backed up. And if some other
transaction doesn't commit and holds locks, you may simply run into a lock
timeout. (This is just a guess, because you didn't give us the complete
error message.)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jun 9 '06 #2

P: n/a
Hello,
I do not have any snapshots, but these are some more info from
list history

SQLCA Information

sqlcaid : SQLCA sqlcabc: 136 sqlcode: -911 sqlerrml: 2

sqlerrmc: 68
sqlerrp : sqlubrea
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Knut Stolze wrote:
ma*****@gmail.com wrote:
I am getting -911 on online incremental or delta backup , anybody have
any explanation, backups go to tsm.


Well, this is an online backup. So it is competing with all other
transactions to access the data being backed up. And if some other
transaction doesn't commit and holds locks, you may simply run into a lock
timeout. (This is just a guess, because you didn't give us the complete
error message.)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany


Jun 9 '06 #3

P: n/a
I had the impression that we can do online backup while other
transcations are running.
the error message,
SQL0911N The current transaction has been rolled back because of a
deadlock or timeout. Reason code "68". SQLSTATE=40001

ma*****@gmail.com wrote:
Hello,
I do not have any snapshots, but these are some more info from
list history

SQLCA Information

sqlcaid : SQLCA sqlcabc: 136 sqlcode: -911 sqlerrml: 2

sqlerrmc: 68
sqlerrp : sqlubrea
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Knut Stolze wrote:
ma*****@gmail.com wrote:
I am getting -911 on online incremental or delta backup , anybody have
any explanation, backups go to tsm.


Well, this is an online backup. So it is competing with all other
transactions to access the data being backed up. And if some other
transaction doesn't commit and holds locks, you may simply run into a lock
timeout. (This is just a guess, because you didn't give us the complete
error message.)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany


Jun 9 '06 #4

P: n/a
ma*****@gmail.com wrote:
I had the impression that we can do online backup while other
transcations are running.
the error message,
SQL0911N The current transaction has been rolled back because of a
deadlock or timeout. Reason code "68". SQLSTATE=40001


Yes, of course you can do that. But the backup is doing the same thing as a
transaction: it reads the data that is to be backed up. And to prevent
this data from being changed during the backup, a lock has to be acquired.
So if you have long running transactions that don't commit and free the
locks, then the backup has to wait for those locks - or it would read
potentially incorrect data.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jun 9 '06 #5

P: n/a
<ma*****@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
I am getting -911 on online incremental or delta backup , anybody have
any explanation, backups go to tsm.
thanks


Did you build an index while you try to do the backup?
Jun 12 '06 #6

P: n/a

Hello,
No, there was no structure change during backup.

Jun 12 '06 #7

P: n/a

<ma*****@gmail.com> wrote in message
news:11**********************@j55g2000cwa.googlegr oups.com...

Hello,
No, there was no structure change during backup.


Hi,

ok, the reason is that I know that the backup needs to lock some tablespace
objects during online backup. In those cases we have trubble to create
indexes during full online backups. But I'm not familiar with incremental
backups and the locks involved. If Knut is write I would say that this is a
bug in the implementation of the backup, but I wouldn't accept that this is
still in the current release. Could you dump a lock snapshot to a file and
look what resources were locked. After that I would may be open a PMR at
IBM.

Regards
Ralph
Jun 12 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.