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: ADSM-L@VM.MARIST.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/[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" <ADSM-L@VM.MARIST.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 > [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: ADSM-L@VM.MARIST.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/[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" <ADSM-L@VM.MARIST.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@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of > > Avy Wong > > Sent: Friday, 29 August 2008 5:36 AM > > To: ADSM-L@VM.MARIST.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. > > > ************************************************************************************************ > > > > > >