SAP Knowledge Base Article - Preview

3261685 - db2pd -db <SID> -tablespaces - Explanation of TrackModState indicators for tablespaces (Dirty, Clean, Inincremental, Readfull, ReadIncremental, N/A)

Symptom

You are running db2pd -db <SID> tablespaces to get the tablespace configuration and statistics to check the TrackModeState of a table space with respect to the last or next backup.
This parameter requires the trackmod configuration parameter to be set to Yes.

The output will look like this example with focus on TrackModeState in this case.

Tablespace Configuration:
Address            Id    Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe  LastConsecPg RSE  Name

Tablespace Statistics:
Address            Id    TotalPgs   UsablePgs  UsedPgs    PndFreePgs FreePgs  HWM   Max HWM  State  MinRecTime NQuiescers PathsDropped TrackmodState    
      


Read more...

Environment

Db2 LUW IBM

Keywords

backup, aborts,  xfs_fsr,  , KBA , BC-DB-DB6-DBA , Database Administration , How To

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.