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.
> >
>
************************************************************************************************
>
> >
> >
>
|