SAP Knowledge Base Article - Preview

3301781 - Orphaned extents in tablespace(s).

Symptom

You observe the following extent movement errors in the db2diag.log.  This error may also be accompanied by dumps reported in ST22 and/or database crash.

2022-09-23-16.34.15.146961+120 E3940286E515          LEVEL: Info
PID     : 20463                TID : 140724972545792 PROC : db2sysc 0
INSTANCE: db2whd               NODE : 000            DB   : WHD
APPHDL  : 0-117                APPID: *LOCAL.DB2.220923143427
AUTHID  : DB2WHD               HOSTNAME: wid046
EDUID   : 175                  EDUNAME: db2agent (WHD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbExtentMovementEntryPoint, probe:6902
DATA #1 : <preformatted>
Extent Movement started on table space 22
 
2022-09-23-16.34.15.424752+120 I3940802E2081         LEVEL: Severe
PID     : 20463                TID : 140724972545792 PROC : db2sysc 0
INSTANCE: db2whd               NODE : 000            DB   : WHD
APPHDL  : 0-117                APPID: *LOCAL.DB2.220923143427
AUTHID  : DB2WHD               HOSTNAME: wid046
EDUID   : 175                  EDUNAME: db2agent (WHD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbFindEMPMappingMovedExtent, probe:2964
MESSAGE : ZRC=0x8002045B=-2147351461=SQLB_EM_SCAN_ERROR
          "Error occurred during extent movement."
                    
You then run the 'db2dart' utility to check database integrity which reports orphaned extents for one or more tablespaces.

Error: Extent number 14894413 in tablespace 22 is orphaned
Error: Extent number 14894414 in tablespace 22 is orphaned
Error: Extent number 14894415 in tablespace 22 is orphaned 
Error: Extent number 14894416 in tablespace 22 is orphaned 
Error: Extent number 14894417 in tablespace 22 is orphaned 
Error: Extent number 14894418 in tablespace 22 is orphaned 
Error: Extent number 14894419 in tablespace 22 is orphaned 
Error: Extent number 14894420 in tablespace 22 is orphaned 
Error: Extent number 14894421 in tablespace 22 is orphaned 

Tablespace with tablespace Id 22 is damaged.  Your tablespace Id may and probably will be different.


Read more...

Environment

  • IBM DB2 LUW (DB6) any release

Product

SAP NetWeaver Application Server all versions

Keywords

SQL1034C , extent , orphan , sqlbFindEMPMappingMovedExtent , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.