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