The database fields are case-sensitive, so the statement
"LL_NAME='TEST.BACKUP'" will not match if the file is named
"test.backup".
-- Tom
On Mon, 13 Mar 2000, Gerrit van Zyl wrote:
>Christo,
>
>I've ran the select command:
>
>adsm> select ll_name, state, backup_date, deactivate_date from adsm.backups wh
> e NODE_NAME='F01N05SW-N05' and LL_NAME='TEST.BACKUP'
>ANR2963W This SQL query may produce a very large result table, or may require
>significant amount of time to compute.
>
>Do you wish to proceed? (Yes/No) y
>ANR2034E SELECT: No match found using this criteria.
>ANS8001I Return code 11.
>
>I can however do a query content on the tape and the file TEST.BACKUP is
>actualy on the tape.
>
>Regards
>Gerrit
>
>Christo Heuër wrote:
>
>> Hi Gerrit,
>>
>> Did you do the backup and restore with the same Unix userid?
>>
>> The only time I've seen this is with permissions.
>> You can run the following SQL query on your ADSM server to see if the file
>> is
>> actually in the ADSM database - this will pinpoint where the
>> problem is - on the client or the server:
>> select ll_name, state, backup_date, deactivate_date from adsm.backups where
>> NODE_NAME='YOURNODENAME' and LL_NAME='TEST.BACKUP'
>>
>> Remember to put your nodename and filename in uppercase.
>>
>> Let me know if something is not clear.
>>
>> Regards
>> Christo Heuer
>> ABSA Bank
>> Johannesburg
>> SOUTH AFRICA
>>
>> > Hi All,
>> >
>> > I stumble accross this problem:
>> >
>> > ADSM Server 3.1.2.50
>> > ADSM Client 3.1.20.7
>> > AIX 4.3.2.0
>> >
>> > When I do a backup off a test file (test.backup) in the / filesystem the
>> > backup goes through fine. But when I query the file, ADSM does not know
>> > about the file, and you also cannot restore the file.
>> >
>> > Can you please test this on your system.
>> >
>> > f01n05sw / # dsmc sel test.backup
>> > ADSTAR Distributed Storage Manager
>> > Command Line Backup Client Interface - Version 3, Release 1, Level 0.7
>> > (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.
>> >
>> > Selective Backup function invoked.
>> >
>> > Node Name: F01N05SW-N05
>> > Session established with server ADSM: AIX-RS/6000
>> > Server Version 3, Release 1, Level 2.50
>> > Server date/time: 03/13/00 10:31:28 Last access: 03/13/00
>> > 10:30:47
>> >
>> > Directory--> 2,560 / [Sent]
>> > Normal File--> 39 /test.backup [Sent]
>> > Selective Backup processing of 'test.backup' finished without failure.
>> >
>> >
>> > Total number of objects inspected: 2
>> > Total number of objects backed up: 2
>> > Total number of objects updated: 0
>> > Total number of objects rebound: 0
>> > Total number of objects deleted: 0
>> > Total number of objects failed: 0
>> > Total number of bytes transferred: 62
>> > Data transfer time: 0.00 sec
>> > Network data transfer rate: 1,552.48 KB/sec
>> > Aggregate data transfer rate: 0.10 KB/sec
>> > Objects compressed by: 0%
>> > Elapsed processing time: 00:00:00
>> >
>> >
>> > f01n05sw / # dsmc q b test.backup
>> > ADSTAR Distributed Storage Manager
>> > Command Line Backup Client Interface - Version 3, Release 1, Level 0.7
>> > (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.
>> >
>> > Node Name: F01N05SW-N05
>> > Session established with server ADSM: AIX-RS/6000
>> > Server Version 3, Release 1, Level 2.50
>> > Server date/time: 03/13/00 10:31:37 Last access: 03/13/00
>> > 10:31:28
>> >
>> > ANS1092E No files matching search criteria were found
>> >
>> >
>> > f01n05sw / # dsmc restore test.backup
>> > ADSTAR Distributed Storage Manager
>> > Command Line Backup Client Interface - Version 3, Release 1, Level 0.7
>> > (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.
>> >
>> > Restore function invoked.
>> >
>> > Node Name: F01N05SW-N05
>> > Session established with server ADSM: AIX-RS/6000
>> > Server Version 3, Release 1, Level 2.50
>> > Server date/time: 03/13/00 10:31:51 Last access: 03/13/00
>> > 10:31:37
>> >
>> > ANS1092E No files matching search criteria were found
>> >
>> > Thanks and regards
>> > Gerrit van Zyl
>> >
>> >
>
|
