Avy,
If it is a case of having duplicates where one is Unicode and the other is
non-Unicode, it is likely that the non-Unicode file space is no longer
used. Use QUERY FILESPACE with F=D to see when each was last backed up.
You can either delete the old file space (if no longer needed -- check
with your user!) or you can rename it to something else, like
\\storman\c$_old
Best regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/29/2008
01:14:18 PM:
> Hi Andrew,
> Yes I found them, there are duplicate filespace on one node, at
least
> for now, there might be some more on others.
> What do you do to resolve this? If I delete the dups, the filespace that
> are empty, will that solve the problem?
>
> Avy Wong
> Business Continuity Administrator
> Mohegan Sun
> 1 Mohegan Sun Blvd
> Uncasville, CT 06382
> (860)862-8164
> (cell) (860)961-6976
>
>
>
>
> Andrew Raibeck
> <storman AT US DOT IBM.C
> OM> To
> Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
> Dist Stor cc
> Manager"
> <[email protected] Subject
> .EDU> Re: [ADSM-L] select statement
>
>
> 08/29/2008 03:12
> PM
>
>
> Please respond to
> "ADSM: Dist Stor
> Manager"
> <[email protected]
> .EDU>
>
>
>
>
>
>
> Hi Avy,
>
> We've seen this when the node has a duplicate file space name. For
> example, if a Windows client had a non-unicode file space that was not
> converted to Unicode, but instead created a new Unicode file space might
> cause this.
>
> While you could construct a SELECT statement to identify duplicate node
> names, I think it would probably run a long time if you have a lot of
file
> spaces. Easiest thing to try:
>
> select node_name, filespace_name from filespaces
> select distinct node_name, filespace_name from filespaces
>
> Redirect the output of each to a file. Then diff the files.
>
> If that doesn't identify the nodes with duplicate file space names, then
a
> PMR might be the best way to go.
>
> Best regards,
>
> Andy
>
> Andy Raibeck
> IBM Software Group
> Tivoli Storage Manager Client Product Development
> Level 3 Team Lead
> Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> Internet e-mail: storman AT us.ibm DOT com
>
> IBM Tivoli Storage Manager support web page:
> http://www.ibm.
> com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
>
>
> The only dumb question is the one that goes unasked.
> The command line is your friend.
> "Good enough" is the enemy of excellence.
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/29/2008
> 11:34:02 AM:
>
> > Hi Andrew,
> >
> > Thank you for pointing me to take a look at the act logs, there
> sure
> > is a lot more than the error ANR2956E. The following link does not
> exactly
> > tell me the problem as my server version is 5.4.3.0 and I am just
> running a
> > select statement. I might submit a PMR to look further into this.
> >
> > http://www-01.ibm.com/support/docview.wss?
> > rs=663&q1=ANR0102E&uid=swg1PQ85760&loc=en_US&cs=utf-8&lang=en
> >
> > 08/29/2008 13:46:33 ANR2017I Administrator WONGAV issued command:
> > select
> > vu.node_name, ao.total_mb, count(distinct
> > vu.volume_name)
> > as tapes, ao.total_mb/count(distinct
> > vu.volume_name) as
> > "AVG MB/tape" from volumeusage vu, auditocc
ao
> > where
> > vu.node_name=ao.node_name group by
> > vu.node_name,ao.total_mb order by 4
(SESSION:
> > 183619)
> > 08/29/2008 13:47:17 ANR0102E admfs.c(6035): Error 1 inserting row
> in
> > table
> > "Temp.SQL.VolumeUsage". (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR2032E SQL VOLUMEUSAGE: Command failed -
> > internal server
> > error detected. (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> issued message 2032
> from:
> > (SESSION:
> > 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x00000001000261cc
> outMsgf
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x0000000100643ca0
> > AdmVOLUSAGE_Reset (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x00000001001fec90
> > sqlBaseTable_Reset@AF54_41 (SESSION:
183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x0000000100201840
> > BaseTableIterator_Reset (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x0000000100207234)
> > JoinIterator_Reset (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x0000000100205158)
> > GroupIterator_Execute (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x0000000100206754)
> > SortIterator_Execute (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x00000001001f4464
> > sqlQuery_Open
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x0000000100612034
> > AdmSQLExecute
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x000000010015c77c
> > AdmCommandLocal
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x000000010015d5d8
> > admCommand
> > more... (<ENTER> to continue, 'C' to cancel)>
> >
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x00000001006e8d40
> > SmAdminCommandThread (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x000000010000fef4
> > StartThread
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR9999D ThreadId <22> 0x090000000044b440
> > _pthread_body
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR2956E Unable to access SQL base table
> > 'VOLUMEUSAGE'.
> > (SESSION: 183619)
> > 08/29/2008 13:47:17 ANR2017I Administrator WONGAV issued command:
> > ROLLBACK.
> > (SESSION: 183619)
> >
> >
> >
> > Avy Wong
> > Business Continuity Administrator
> > Mohegan Sun
> > 1 Mohegan Sun Blvd
> > Uncasville, CT 06382
> > (860)862-8164
> > (cell) (860)961-6976
> >
> >
> >
> >
> > Andrew Raibeck
> > <storman AT US DOT IBM.C
> > OM> To
> > Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
> > Dist Stor cc
> > Manager"
> > <[email protected] Subject
> > .EDU> Re: [ADSM-L] select statement
> >
> >
> > 08/29/2008 10:21
> > AM
> >
> >
> > Please respond to
> > "ADSM: Dist Stor
> > Manager"
> > <[email protected]
> > .EDU>
> >
> >
> >
> >
> >
> >
> > Hi Avy,
> >
> > If you look up message ANR2956E, you'll see it says the message might
be
> > preceded by other messages. If you didn't see anything else on your
> > console, check the activity log from when you ran the SELECT command
to
> > see if there are any other anomalous messages.
> >
> > Best regards,
> >
> > Andy
> >
> > Andy Raibeck
> > IBM Software Group
> > Tivoli Storage Manager Client Product Development
> > Level 3 Team Lead
> > Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> > Internet e-mail: storman AT us.ibm DOT com
> >
> > IBM Tivoli Storage Manager support web page:
> > http://www.ibm.
> > com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
> >
> >
> > The only dumb question is the one that goes unasked.
> > The command line is your friend.
> > "Good enough" is the enemy of excellence.
> >
> > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/29/2008
> > 05:46:37 AM:
> >
> > > Hmmm... I will take another look. Thanks for verifying it.
> > >
> > > Avy Wong
> > > Business Continuity Administrator
> > > Mohegan Sun
> > > 1 Mohegan Sun Blvd
> > > Uncasville, CT 06382
> > > (860)862-8164
> > > (cell) (860)961-6976
> > >
> > >
> > >
> > >
> > > "Patel, Ankur"
> > > <[email protected]
> > > ARVEYNORMAN.COM> To
> > > Sent by: "ADSM: ADSM-L AT VM.MARIST DOT EDU
> > > Dist Stor cc
> > > Manager"
> > > <[email protected] Subject
> > > .EDU> Re: [ADSM-L] select statement
> > >
> > >
> > > 08/29/2008 01:09
> > > AM
> > >
> > >
> > > Please respond to
> > > "ADSM: Dist Stor
> > > Manager"
> > > <[email protected]
> > > .EDU>
> > >
> > >
> > >
> > >
> > >
> > >
> > > Avy,
> > >
> > > I tried your query on my machine and it has worked fine.
> > > See results:
> > >
> > > ~~~~~~~~~~~~~~~~~~
> > > AUCFTSM01_PROD>select vu.node_name, ao.total_mb, count(distinct
> > > vu.volume_name) as tapes, ao.total_mb/count(distinct vu.
> > > volume_name) as "AVG MB/tape" from volumeusage vu, auditocc ao where
> > > vu.node_name=ao.node_name group by v u.node_name,
> > > ao.total_mb order by 4
> > >
> > > Session established with server AUCFTSM01_PROD: AIX-RS/6000
> > > Server Version 5, Release 4, Level 3.0
> > > Server date/time: 08/29/08 15:00:01 Last access: 08/29/08
> > > 12:46:42
> > >
> > > ANR2963W This SQL query may produce a very large result table, or
may
> > > require a significant amount of time to compute.
> > >
> > > Do you wish to proceed? (Yes (Y)/No (N)) y
> > >
> > > NODE_NAME TOTAL_MB TAPES AVG MB/tape
> > > ------------------ ----------- ----------- -----------
> > > FLEMTMH2_FS 531344 154 3450
> > > FLEMXPS3_FS 1122421 166 6761
> > > FLEMTDM2_FS 764482 50 15289
> > > FLEMXPS2_FS 2865024 172 16657
> > > AUCFTDWH01_FS 4078174 186 21925
> > > AUCFSAV01_FS 3604114 163 22111
> > > AUDCCFOMX006_EXCH 70208 3 23402
> > > FLEMXPS0_FS 7529458 213 35349
> > > AUCFVSQ1_FS 7168357 159 45084
> > > AUCFNIM01_FS 14523030 190 76437
> > > AUCFDW01_FS 48314333 233 207357
> > > .
> > > .
> > > .
> > > .
> > > .
> > > ~~~~~~~~~~~~~~~~~~~~~~~~
> > >
> > >
> > >
> > >
> > > Regards,
> > >
> > >
> > >
> > > Ankur Patel
> > >
> > > TSM Administrator.
> > > SYDNEY.
> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > >
> > >
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
Behalf
> Of
> > > Avy Wong
> > > Sent: Friday, 29 August 2008 5:36 AM
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Subject: [ADSM-L] select statement
> > >
> > > Hello,
> > > The following is a select statement to provide "a total data
> > > stored and tapes used per node in all storage pools".
> > > I have broken down the sql and double checked the tables and column
> > > names are all there. Can anyone see where the hangs ups are?
> > >
> > > select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as
> > > tapes, ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape"
> from
> > > volumeusage vu, auditocc ao where vu.node_name=ao.node_name group by
> > > vu.node_name, ao.total_mb order by 4
> > >
> > > ANR2956E Unable to access SQL base table 'VOLUMEUSAGE'.
> > >
> > > |
> > > ..........................V....................................
> > > me) as "AVG MB/tape" from volumeusage vu, auditocc ao where
> vu.
> > >
> > > ANS8001I Return code 26.
> > >
> > > thanks,
> > > Avy Wong
> > > Business Continuity Administrator
> > > Mohegan Sun
> > > 1 Mohegan Sun Blvd
> > > Uncasville, CT 06382
> > > (860)862-8164
> > > (cell) (860)961-6976
> > >
> >
>
************************************************************************************************
>
> >
> > >
> > > DISCLAIMER
> > >
> > > Confidential Communication: This email and any attachments are
> intended
> > for
> > > the addressee(s)
> > > only and are confidential. They may contain legally privileged or
> > copyright
> > > material. If you
> > > are not the intended recipient, please contact the sender
immediately
> by
> > > reply email and
> > > delete this email and any attachments. You must not read, copy, use,
> > > distribute or disclose
> > > the contents of this email without consent and Harvey Norman
Holdings
> > > Limited ACN 003 237 545
> > > (and its related subsidiaries) (“Harvey Norman”) does not accept
> > > responsibility for any
> > > unauthorised use or reliance on the contents of this email.
> > >
> > > Harvey Norman does not represent or warrant that the integrity of
this
> > > email has been maintained
> > > or that it is free from errors, viruses, interceptions or
> interference.
> > Any
> > > views expressed by
> > > the sender do not necessarily represent the views of Harvey Norman.
> > >
> > > This notice should not be removed from this email.
> > >
> >
>
************************************************************************************************
>
> >
> > >
> > >
> >
>
|
