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 IC76387 Status: Geschlossen

REDUCE SEVERITY OF DB2DIAG.LOG MESSAGES DURING REDIRECTED RESTORE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
During a redirected restore from one database to a new database 
on the same server, the db2diag.log reports error messages  as: 
 
 
 
 
2011-04-21-09.17.01.788780-240 I612227A646        LEVEL: Severe 
 
PID    : 594064              TID  : 19824      PROC : db2sysc 0 
 
INSTANCE: db2inst1            NODE : 000        DB  : SAMPLE 
 
APPHDL  : 0-6894              APPID: 
*LOCAL.db2inst1.110421131629 
AUTHID  : DB2INST1 
 
EDUID  : 19824                EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, 
probe:844 
MESSAGE : ZRC=0x80020039=-2147352519=SQLB_CONTAINER_IN_USE 
 
          "Container is already being used" 
 
DATA #1 : <preformatted> 
 
Skipping removal of a container which is currently in use: 
 
 
 
Database name: SAMPLE1 
 
Instance: db2inst1 
 
 
 
 
 
2011-04-21-09.17.01.789036-240 I612874A645        LEVEL: Error 
 
PID    : 594064              TID  : 19824      PROC : db2sysc 0 
 
INSTANCE: db2inst1            NODE : 000        DB  : SAMPLE 
 
APPHDL  : 0-6894              APPID: 
*LOCAL.db2inst1.110421131629 
AUTHID  : DB2INST1 
 
EDUID  : 19824                EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, 
probe:844 
MESSAGE : ZRC=0x80020039=-2147352519=SQLB_CONTAINER_IN_USE 
 
          "Container is already being used" 
 
DATA #1 : <preformatted> 
 
Error releasing container 3 
 
(/db/data1/SAMPLE1) for tbsp 5. Rc = 80020039 
 
 
 
These messages are information type messages and can be safely 
ignored.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on V9.7 Fix Pack 4 and below                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* During a redirected restore from one database to a new       * 
* database on the same server, the db2diag.log reports error   * 
* messages  as:                                                * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2011-04-21-09.17.01.788780-240 I612227A646        LEVEL:     * 
* Severe                                                       * 
* PID    : 594064              TID  : 19824      PROC :        * 
* db2sysc 0                                                    * 
* INSTANCE: db2inst1            NODE : 000        DB  : SAMPLE * 
*                                                              * 
* APPHDL  : 0-6894                                             * 
* APPID:*LOCAL.db2inst1.110421131629                           * 
* AUTHID  : DB2INST1                                           * 
*                                                              * 
* EDUID  : 19824                EDUNAME: db2agent (SAMPLE) 0   * 
*                                                              * 
* FUNCTION: DB2 UDB, buffer pool services,                     * 
* sqlbDMSDoContainerOp, probe:844                              * 
* MESSAGE : ZRC=0x80020039=-2147352519=SQLB_CONTAINER_IN_USE   * 
*                                                              * 
* "Container is already being used"                            * 
*                                                              * 
* DATA #1 : <preformatted>                                     * 
*                                                              * 
* Skipping removal of a container which is currently in use:   * 
*                                                              * 
*                                                              * 
*                                                              * 
* Database name: SAMPLE1                                       * 
*                                                              * 
* Instance: db2inst1                                           * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2011-04-21-09.17.01.789036-240 I612874A645        LEVEL:     * 
* Error                                                        * 
* PID    : 594064              TID  : 19824      PROC :        * 
* db2sysc 0                                                    * 
* INSTANCE: db2inst1            NODE : 000        DB  : SAMPLE * 
*                                                              * 
* APPHDL  : 0-6894                                             * 
* APPID:*LOCAL.db2inst1.110421131629                           * 
* AUTHID  : DB2INST1                                           * 
*                                                              * 
* EDUID  : 19824                EDUNAME: db2agent (SAMPLE) 0   * 
*                                                              * 
* FUNCTION: DB2 UDB, buffer pool services,                     * 
* sqlbDMSDoContainerOp, probe:844                              * 
* MESSAGE : ZRC=0x80020039=-2147352519=SQLB_CONTAINER_IN_USE   * 
*                                                              * 
* "Container is already being used"                            * 
*                                                              * 
* DATA #1 : <preformatted>                                     * 
*                                                              * 
* Error releasing container 3                                  * 
*                                                              * 
* (/db/data1/SAMPLE1) for tbsp 5. Rc = 80020039                * 
*                                                              * 
*                                                              * 
*                                                              * 
* These messages are information type messages and can be      * 
* safely ignored.                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.7 FP5 or higher.                        * 
****************************************************************
Local-Fix:
na
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
First fixed in V9.7 FP5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.05.2011
21.12.2011
24.04.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList