Thanks for the input Andy, I am facing one problem with teh select commadn - in fact it i sproducing a file which is too huge. I know which HL_name is responsible for that numerous records & want to exclude it from the select command:
Th command I am using is as follows: select * from archives where node_name='BKUP_EXP' and filespace_name='/backup6' and HL_NAME not in ('/prdumps/other/audit/sr005','/prdumps/trc/msbep001/udump/', '/prdumps/trc/msbep001/udump/') > /backup/archives.out It is still producing the same size file output. I have also tried the following with still the same results : select * from archives where node_name='BKUP_EXP' and filespace_name='/backup6' and HL_NAME != '/prdumps/other/audit/sr005' > /backup6/archives.out select * from archives where node_name='BKUP_EXP' and filespace_name='/backup6' and HL_NAME <> '/prdumps/other/audit/sr005ocm' > /backup6/archives.out Any suggestions how I can exclude all contents from the above HL_name. Thanks & regards -----Original Message----- From: Andrew Raibeck [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 4:34 PM To: [EMAIL PROTECTED] Subject: Re: Missing files - urgent help required Well, outside of restoring your database (as you indicate that you have done) I can't think of any way to retrieve the data. The first thing to do is to determine whether the TSM server "thinks" the files are still available in the database: 1) From the Admin CLI, issue the command select * from archives where node_name='NNNNN' > archives.out where NNNNN is the node name, in all upper case. You can modify this command with a WHERE clause targets the file name more specifically (i.e. "where filespace_name='blah' and hl_name='blah' and ll_name='blah'", etc.) but it would probably be better to have all the archives so that you can see archive information for other files, for comparison purposes. Look through the resulting archives.out file. Do you see the missing files? If so, what does the output show for these files? Are they bound to the management class you *think* they are bound to? If the files are not there, then somehow they got deleted. Does the owning node have archive delete authority? If so, it is conceivable that someone manually deleted these versions. 2) From the Admin CLI, issue the command q co t=a f=d > qco.out In the qco.out file, locate the management class (in the active policy set) to which the archive versions are bound and check the time when the class was last updated. Is it fairly recent? Does it still show NOLIMIT for retention? Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. RAMNAWAZ NAVEEN <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 08/19/2003 23:54 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: Missing files - urgent help required Thanks for the feedback Andy, I have also tried the -pick option but the files are not displayed for those dates, but as I said when tried the same option using a TSM DB of a few days back, I can get the files both thru GUI & pick options. I will definitely open an incident log with IBM support, but can you think of something else I can try in the meantime.??? Thanks & regards -----Original Message----- From: Andrew Raibeck [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 11:38 PM To: [EMAIL PROTECTED] Subject: Re: Missing files - urgent help required Can you retrieve the files from the command line interface using the -pick option? If so, that would provide a circumvention. While you certainly need to get your code levels up to date, I can not think of any known bugs off the top of my head that are fixed in those levels. I would strongly recommend that you open a problem with IBM support on this. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. RAMNAWAZ NAVEEN <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 08/19/2003 00:05 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Missing files - urgent help required Hi, I am currently facing quite a strange problem and I can't find a clue or solution to it. Some .dbf files are archived on a daily basis and the expiry is set to NOLIMIT . The problem is that I was trying to do a retrieve for a specific date, I noticed that all files between 23/06/02 to 30/06/02 are "MISSING" i.e I cannot find them from the client GUI. The volume is not deleted or destroyed and it can still be si still be queried from the DB. But when I query the contents of the tape, the archived objects are still there. Furthermore, objects backed up to the same volume after the 30/06/02 are still accessible from the cleint interface. One more thing, the first two days files (23 & 24 ) are not on this volume but on another one but still not accessible. These files were accessible last week, as i restored last week's TSM DB and was able to retrieve the files from the same volumes. When I query the activity log with the search string bearing the volume name, there is nothing to indicate that the volume status was altered or whatsoever. All your sugestions and assistance to solve same will be highly appreciated. (Both TSM server version 5.1.11 & client 5.1.0.0 Help, Please. Thanks.