Pulling Archive Date via a script.

[PastaFazole]

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

 

[tariq.kaifi]

Filespace table do not have "Archive_Date" column.

 

[PastaFazole]

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.

 

[moon-buddy]

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:

 

[cjhood]

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'