Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    68

    Unanswered: Health Indicator error - what does this mean?

    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?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2004
    Posts
    1

    backup in progress

    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,

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I suspect that the backup has finished by now.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •