ADSM-L

Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX

2003-06-05 10:44:02
Subject: Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 5 Jun 2003 07:42:23 -0700
Yes, I this is a bug.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




David Rigaudiere <david.rigaudiere AT FR.ABNAMRO DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
06/05/2003 03:13
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        cc: 
        Subject:        (bug?) bad results with select from nodes table whith 
5.1.6.3 on AIX



Hello *SMers,
Server AIX 5.1.6.3

I have a curious result with select on nodes table.

I want select
NODE_NAME,LASTSESS_IDLEWAIT,LASTSESS_COMMWAIT,LASTSESS_MEDIAWAIT from 
nodes
where node_name='FooBar'

the result is empty except for NODE_NAME.

I have to include LASTSESS_DURATION in the request to have
LASTSESS_IDLEWAIT, LASTSESS_COMMWAIT and LASTSESS_MEDIAWAIT with values in
result.


sample:

select NODE_NAME,LASTSESS_IDLEWAIT,LASTSESS_COMMWAIT,LASTSESS_MEDIAWAIT
from nodes where node_name='FooBar'
NODE_NAME                   LASTSESS_IDLEWAIT          LASTSESS_COMMWAIT
LASTSESS_MEDIAWAIT
------------------     ----------------------     ----------------------
----------------------
FOOBAR


select
NODE_NAME,LASTSESS_DURATION,LASTSESS_IDLEWAIT,LASTSESS_COMMWAIT,LASTSESS_MEDIAWAIT
 from nodes where node_name='FooBar'
NODE_NAME                   LASTSESS_DURATION          LASTSESS_IDLEWAIT
LASTSESS_COMMWAIT         LASTSESS_MEDIAWAIT
------------------     ----------------------     ----------------------
----------------------     ----------------------
FOOBAR                 +2.96670000000000E+002     +1.89307985303535E+001
+4.81342906259480E+000     +0.00000000000000E+000

do you have a reason for this ?


--
David  Rigaudiere  -+-  Administration  TSM  -+-
Paris -+- 40, rue de Courcelles -+- 4e étage -+-
david.rigaudiere AT fr.abnamro DOT com -+- 01.5621.7802

---------------------------------------------------------------------------
This message (including any attachments) is confidential and may be
privileged. If you have received it by mistake please notify the sender by
return e-mail and delete this message from your system. Any unauthorised
use or dissemination of this message in whole or in part is strictly
prohibited. Please note that e-mails are susceptible to change.
ABN AMRO Bank N.V. (including its group companies) shall not be liable for
the improper or incomplete transmission of the information contained in
this communication nor for any delay in its receipt or damage to your
system. ABN AMRO Bank N.V. (or its group companies) does not guarantee 
that
the integrity of this communication has been maintained nor that this
communication is free of viruses, interceptions or interference.
---------------------------------------------------------------------------

Le présent message (y compris tous les éléments attachés) est confidentiel
et est destiné aux seules personnes qu'il vise. Si vous l'avez reçu par
erreur, merci de l'indiquer à son expéditeur par retour et de procéder à 
sa
destruction dans vos systèmes. Toute utilisation ou diffusion non 
autorisée
de son contenu, dans sa totalité ou en partie, est strictement interdite.
Merci de noter que les e-mails sont susceptibles d'être altérés. ABN AMRO
Bank N.V. (et les entités membres du Groupe ABN AMRO) ne saurait être tenu
pour responsable ni de la transmission erronée ou incomplète des
informations contenues dans ce message,  ni des délais de réception ou des
dommages causés à votre système. ABN AMRO Bank N.V. (et les entités 
membres
du Groupe ABN AMRO) ne garantit ni que l'intégrité de la communication ait
été maintenue ni que cette transmission soit exempte de virus,
d'interceptions ou d'interférences.

<Prev in Thread] Current Thread [Next in Thread>