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/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
06/05/2003 03:13
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
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 -+-
[EMAIL PROTECTED] -+- 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.
