Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    2

    Unanswered: To check the status of Tablespace

    Hi all,
    Is there any way i can check the status (Check Pending, Copy Pending etc) of the DB2 table space directly using BMC.

    My jobs are abending 'coz some of my tables are in Check/Copy pending status. As of now, i'm just trying to load the table using DSNUTILB, and the sysout of the job says the status of the table space.
    Instead i want to see directly using BMC, the state of the table space.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Some statuses (including check pending) can be seen in the STATUS column of SYSIBM.SYSTABLESPACE, but the copy pending and some other restricted states are more complicated than looking at any one column in the catalog.

    You can issue the

    -DISPLAY DATABASE (*) SPACENAM(*) RESTRICT

    command to see any tablespace in any database that is in restricted mode. Check the Command Reference manual for command abbreviations and other options of this command.

  3. #3
    Join Date
    May 2003
    Posts
    2

    Thumbs up

    Thatz excellent. Thank You very much

Posting Permissions

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