Results 1 to 5 of 5
  1. #1
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default Filespace on nodes

    Is there a way to query the filespace dates on all my nodes? I few months ago I started going through all the nodes, one at a time, to see if there were any old (2008, 2006 etc.. ) filespaces that could be deleted from my nodes to free up some space. Today I was deleting a node and found some filespaces from 2005 (I didn't make it down that far on my list).

    Thanks.

  2. #2
    Senior Member
    Join Date
    Dec 2009
    Location
    Sydney, Australia
    Posts
    384
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Try this - its formatted as a script with a single parameter ($1) which is the number of days since a backup completed. Note that a partial backup of a filespace doesn't update this timestamp, so the data you get back isn't completely authoritative.

    Code:
    select -
         filespaces.node_name as "Node", -
         contact as "Team", -
         filespace_name as "Filespace", -
         filespace_type as "Type", -
         date(backup_end) as "Last Backup" -
    from -
        filespaces, nodes -
    where -
        backup_end<current_timestamp-$1 days and -
        filespaces.node_name = nodes.node_name -
    order by 2,1,5
    I've a v6 version if thats more useful:

    Code:
    select -
        char(n.node_name, 16) as "Node", -
        char(contact, 32) as "Team", -
        char(filespace_name, 16) as "Filespace Name", -
        char(filespace_type, 12) as "Type", -
        date(backup_end) as "Last Backup" -
    from -
        filespaces f -
    right outer join nodes n on f.node_name=n.node_name -
    where -
        (backup_end<current_timestamp-0 days  or backup_end is null) -
    order by -
        2,1,5
    hth,

    Tony

  3. #3
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default

    Thanks Tony.

  4. #4
    Newcomer
    Join Date
    Jun 2006
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default

    I tried the v5 code on my 5.5..0.3 server and come up with error, "unexpected SQL literal token - '5.'. when i ran it at the command line.
    also got this error when I ran it as a script:
    ANR1464E RUN: Command script FILESPACE, line 1, parameter 1 was not specified

    I'm not sql person so any help would be helpful. would love to get this query to work and add to my tool kit.

  5. #5
    Senior Member
    Join Date
    Dec 2009
    Location
    Sydney, Australia
    Posts
    384
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    When you invoke the script you need to specify an argument (parameter), e.g.

    Code:
     run blah 7

Similar Threads

  1. query filespace for nodes understanding
    By toddz2000 in forum Backup / Archive Discussion
    Replies: 4
    Last Post: 03-02-2010, 10:17 AM
  2. One time backup of a nodes filespace
    By JustinCM in forum Backup / Archive Discussion
    Replies: 7
    Last Post: 09-14-2009, 09:55 AM
  3. filespace
    By treds in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 04-28-2008, 07:21 AM
  4. q filespace of selected nodes
    By tommy13v in forum Scripting
    Replies: 2
    Last Post: 02-08-2008, 11:31 AM
  5. Delete filespace of a specific Filespace
    By Dango in forum TSM Server
    Replies: 3
    Last Post: 11-22-2007, 05:38 AM

Posting Permissions

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