Results 1 to 5 of 5
  1. #1
    Newcomer
    Join Date
    Apr 2010
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Pulling Archive Date via a script.

    Currently, I run the following script to find out about my backups:

    select node_name, date(backup_end)as BkupDate, filespace_name from filespaces order by BkupDate asc

    But I want to add the date for each archive job to this command. However, I don't know the code to plug in to do this. I have tried using my existing script as a guide, but my attempts fail:

    upd script checkbackup line=1 "select node_name, date(backup_end)as BkupDate, Archive_Date, filespace_name from filespaces order by BkupDate asc" ANR2004E Missing value for keyword parameter - select node_name, date(backup_end)as BkupDate, Archive_Date, filespace_name from filespaces order by
    BkupDate asc.
    ANS8001I Return code 3.

    Where should I be looking? The administrative reference guide doesn't seem to have what I want.

    Thanks,
    Pasta Fazole

  2. #2
    Senior Member
    Join Date
    Nov 2009
    Location
    India
    Posts
    316
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    Filespace table do not have "Archive_Date" column.

  3. #3
    Newcomer
    Join Date
    Apr 2010
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks for that information. Can you tell me how to see for myself what the filespace table has and doesn't have. I believe what you say is true, but I'm trying to learn more about scripting and TSM.

  4. #4
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,935
    Thanks
    4
    Thanked 233 Times in 228 Posts

    Default

    Here are the fields for filespaces:

    NODE_NAME
    FILESPACE_NAME
    FILESPACE_ID
    FILESPACE_TYPE
    CAPACITY
    PCT_UTIL
    BACKUP_START
    BACKUP_END
    DELETE_OCCURRED
    UNICODE_FILESPACE
    FILESPACE_HEXNAME:
    Ed

  5. #5
    Moderator
    Join Date
    Dec 2007
    Location
    Brisbane, Australia
    Posts
    322
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    To find the columns in a table you can run this select:

    select * from syscat.columns where tabname='<table_name>' order by colno

    eg: select * from syscat.columns where tabname='FILESPACES' order by colno

    The 'order by' part isn't required. To just get the column names, replace the '*' with 'colname'
    -Chris

Similar Threads

  1. Script for number of files backed up in a date range
    By StuartClark in forum Scripting
    Replies: 2
    Last Post: 09-16-2009, 02:03 PM
  2. How to find out the Archive date using this details?
    By radhar in forum Backup / Archive Discussion
    Replies: 5
    Last Post: 09-23-2008, 12:56 PM
  3. Archive Based on date of file
    By tucker77 in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 05-07-2007, 10:33 AM
  4. Last archive date
    By blies in forum Scripting
    Replies: 5
    Last Post: 12-16-2005, 11:35 AM
  5. Automated archive description with date
    By robbenleaf in forum Backup / Archive Discussion
    Replies: 2
    Last Post: 03-19-2003, 09:08 AM

Tags for this Thread

Posting Permissions

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