home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC80721 Status: Geschlossen

IMPROVE DIAGNOSTIC MESSAGE DURING TABLE SPACE ROLLFORWARD

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When the user issues a table space rollforward while another 
table space rollforward is already in progress, error SQL4908N 
will be returned, and the following message will be written into 
the DB2 diagnostic log: 
 
FUNCTION: DB2 UDB, recovery manager, sqlpInitTblRecovery, 
probe:2770 
DATA #1 : <preformatted> 
A table space rollforward is already in progress. 
One or more of the table spaces specified in the list to be 
rolled forward is not in rollforward in progress state. 
Use the LIST TABLESPACES SHOW DETAIL command to get a list 
of table spaces in rollforward in progress or rollforward 
pending state. 
There are two ways to proceed. 
1. Complete the table space rollforward that is already in 
progress. 
This will not be possible if rolling forward to a point in time 
and 
either a table space is not in rollforward in progress state on 
all nodes or 
the table spaces are interdependent and all table spaces are not 
in 
rollforward in progress state on all nodes. 
Submit the rollforward command again with a list containing the 
table spaces that are in rollforward in progress state. You can 
submit 
a different rollforward command for each node or subset of nodes 
if 
required, but any table space in rollforward in progress state 
that is 
not included in the list will be put into restore pending state. 
Restore any table spaces place in restore pending state and then 
submit the new table space rollforward command. 
2. Cancel the table space rollforward that is in progress and 
start another table space rollforward. 
Submit the rollforward command again with the CANCEL option. 
A list of table spaces that are in rollforward in progress state 
and a node list are required only if rolling forward to end of 
logs. 
These table spaces will be put into restore pending state. 
Restore the table spaces and submit the rollforward command 
again. 
 
The purpose of this APAR is to improve suggestion 2. The current 
text is ambiguous, and some users may understand it in the way 
that they can cancel the running rollforward and submit another 
rollforward. However, this interpretation is incorrect. 
Canceling a running rollforward means that the table space will 
be put into restore pending state, which is a serious 
consequence. Only after restoring the table space again, the 
user will then be able to issue another rollforward. 
 
The new text for suggestion 2 will be made consistent with our 
manuals: 
 
2. Cancel the table space rollforward that is in progress 
(submit the rollforward command again with the CANCEL option) to 
put one or more table spaces on all database partitions on which 
forward recovery has been started in restore pending state. Use 
this option with caution, and only if the rollforward operation 
that is in progress cannot be completed because some of the 
table spaces have been put in restore pending state.
Problem-Zusammenfassung:
See APAR Description
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem first fixed in DB2 for Linux, UNIX, and Windows 9.7 Fix 
Pack 6
Workaround
See APAR Description
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC80828 IC84281 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.01.2012
06.06.2012
06.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.6 FixList