1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

How to get the scratch volumes after reclamation

Discussion in 'Scripting' started by disig, Mar 30, 2009.

  1. disig

    disig New Member

    Joined:
    Mar 15, 2009
    Messages:
    26
    Likes Received:
    0
    Occupation:
    Linux/TSM admin
    Location:
    Bangalore,India
    Dear friends,

    I am trying to the volume names which became scratch after reclamation.Is there any command for that....???

    Regards,
    Vijo.
     
  2.  
  3. inestler

    inestler Member

    Joined:
    Mar 12, 2007
    Messages:
    151
    Likes Received:
    7
    Location:
    switzerland
    search for this message after a successful reclamation

    ANR1341I
    Scratch volume B02152 has been deleted from
    storage pool 3592POOL. (SESSION: 42747, PROCESS: 506)
     
  4. Stephan

    Stephan Senior Member

    Joined:
    Jun 7, 2004
    Messages:
    648
    Likes Received:
    1
    Occupation:
    Storage / System Administrator (UNIX)
    Location:
    Great White North
    Those volumes will show as pending...They will be pending for as long as you configured the reuse delay option, which by then they will return as scratch...

    select volume_name,stgpool_name,est_capacity_mb,pct_utilized, status,access,access,location,devclass_name,last_write_date from volumes where status='PENDING'
     
  5. rore

    rore Senior Member

    Joined:
    Nov 27, 2005
    Messages:
    637
    Likes Received:
    15
    Occupation:
    SysAdmin
    Location:
    Montreal, CA

    Hi,
    If your reusedelay=0, then use the inestler's query:

    q act begint=-24 search='ANR1341I Scratch volume'

    you can also query your volhistory.

    Rudy
     
  6. disig

    disig New Member

    Joined:
    Mar 15, 2009
    Messages:
    26
    Likes Received:
    0
    Occupation:
    Linux/TSM admin
    Location:
    Bangalore,India
    Dear Stephan,

    I tried the command but it gave error

    tsm: TSM>select volume_name,stgpool_name,est_capacity_mb,pct_utilized,status,access,access,location,devclass_name,last_write_date from volumes where status='PENDING'
    ANR2034E SELECT: No match found using this criteria.
    ANS8001I Return code 11.


    And when I tried Q ACTLOG BEGIND=-<no of days> search=ANR1341I
    gave the scratch tape....

    Thanks and regards,
    VIJO.
     
  7. Stephan

    Stephan Senior Member

    Joined:
    Jun 7, 2004
    Messages:
    648
    Likes Received:
    1
    Occupation:
    Storage / System Administrator (UNIX)
    Location:
    Great White North
    It is not an error. It just mentions that you have no tapes in Pending mode...They problably all returned to scratch mode already. If your reuse delay is set to 0, then it would be normal not to have pending tapes. If your reuse delay is set to 3, that would mean that a tape, after being reclaimed would "sit" in pending mode until the 3 days expired before returning to scratch...
     
  8. raj2989

    raj2989 New Member

    Joined:
    Jun 21, 2006
    Messages:
    34
    Likes Received:
    0
    Hi

    try this.

    SELECT substr(char(start_time),1,19) AS START_TIME,substr(char(end_time - start_time),1,10) AS "ELAPTIME (D HHMMSS)",activity, number, entity,mediaw, successful FROM summary WHERE activity='RECLAMATION' AND end_time>current_timestamp-48 hours
     

Share This Page