I see this error in db2adm.nfy:

ADM10502W Health indicator "Table Space Operational State" ("ts.ts_op_status") is in state "2048" on "table space" "db2adm.MPP .USERSPACE1".

2004-11-19-07.31.18.485865 Instance:db2adm Node:000
PID:9672(db2hmon) TID:8192 Appid:none
Health Monitor HealthIndicator::update Probe:500

ADM10502W Health indicator "Table Space Operational State" ("ts.ts_op_status") is in state "2048" on "table space" "db2adm.MPP .SYSCATSPACE".


What does this mean? How do I resolve it?

The tablespace operational states are listed in the Command Reference under the LIST TABLESPACES command. They are listed in hex values.

0x0 Normal
0x1 Quiesced: SHARE
0x2 Quiesced: UPDATE
0x4 Quiesced: EXCLUSIVE
0x8 Load pending
0x10 Delete pending
0x20 Backup pending
0x40 Roll forward in progress
0x80 Roll forward pending
0x100 Restore pending
0x100 Recovery pending (not used)
0x200 Disable pending
0x400 Reorg in progress
0x800 Backup in progress
0x1000 Storage must be defined
0x2000 Restore in progress
0x4000 Offline and not accessible
0x8000 Drop pending
0x2000000 Storage may be defined
0x4000000 StorDef is in ’final’ state
0x8000000 StorDef was changed prior to rollforward
0x10000000 DMS rebalancer is active
0x20000000 TBS deletion in progress
0x40000000 TBS creation in progress
0x8 For service use only

A hex value of 0x800 is 2048 in decimal.

hi,
have you got fixed that problem of 2048, if yes how can you share that info please or reply back to me at maacherla@yahoo.com

thanks,

I suspect that the backup has finished by now.