Dirk,
node_name is not recognized.
ANR2940E The reference 'NODE' is an unknown SQL column name.
|
.............................V.................................
_name from volumeusage where node-name=ABC order by volume_name
ANS8001I Return code 3.
-----Original Message-----
From: Dirk Kastens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 5:01 PM
To: [EMAIL PROTECTED]
Subject: Re: restore asking for offsite copy instead of primary
Hi,
> I had a user trying to restore a database and found data
> unavailable to
> server. The restore was asking for a volume that was offsite.
> Why wouldn't
> it ask for the primary copy and how do I know what primary
> volume the data
> is on?
You can use an SQL statement, like
select distinct volume_name,stgpool_name from volumeusage -
where node_name='YOUR_CLIENT_NODE_NAME' -
order by volume_name
Maybe the volume has been disabled or changed to readonly due
to a write or read error.
Dirk
CAUTION - This message may contain privileged and confidential information intended
only for the use of the addressee named above. If you are not the intended recipient
of this message you are hereby notified that any use, dissemination, distribution or
reproduction of this message is prohibited. If you have received this message in error
please notify AMCOR immediately. Any views expressed in this message are those of the
individual sender and may not necessarily reflect the views of AMCOR.
