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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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 > <[EMAIL PROTECTED] > OM> To > Sent by: "ADSM: [email protected] > 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/[EMAIL PROTECTED] > Internet e-mail: [EMAIL PROTECTED] > > 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" <[email protected]> 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 > > [EMAIL PROTECTED] (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 > > <[EMAIL PROTECTED] > > OM> To > > Sent by: "ADSM: [email protected] > > 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/[EMAIL PROTECTED] > > Internet e-mail: [EMAIL PROTECTED] > > > > 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" <[email protected]> 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: [email protected] > > > 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:[EMAIL PROTECTED] On Behalf > Of > > > Avy Wong > > > Sent: Friday, 29 August 2008 5:36 AM > > > To: [email protected] > > > 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. > > > > > > ************************************************************************************************ > > > > > > > > > > > >
