Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX
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.966700E+002 +1.89307985303535E+001 +4.81342906259480E+000 +0.00E+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.
Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX
APAR IC36460 has been opened to address this problem. 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. Andrew Raibeck/Tucson/[EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06/05/2003 07:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX 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.966700E+002 +1.89307985303535E+001 +4.81342906259480E+000 +0.00E+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.
Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX
Thanks a lot Andrew, congratulations for your reactivity et your job on this mailing list. -- David Rigaudiere -+- Administration TSM -+- Paris -+- 40, rue de Courcelles -+- 4e étage -+- [EMAIL PROTECTED] -+- 01.5621.7802 |-+--- | | Andrew Raibeck | | | [EMAIL PROTECTED]| | | COM| | | Sent by: ADSM: | | | Dist Stor | | | Manager| | | [EMAIL PROTECTED]| | | T.EDU | | | | | | | | | 05/06/2003 17:41| | | Please respond | | | to ADSM: Dist | | | Stor Manager | | | | |-+--- ---| | | |To: [EMAIL PROTECTED] | |cc: | |Subject: Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX | ---| APAR IC36460 has been opened to address this problem. 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. Andrew Raibeck/Tucson/[EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06/05/2003 07:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: (bug?) bad results with select from nodes table whith 5.1.6.3 on AIX 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.966700E+002 +1.89307985303535E+001 +4.81342906259480E+000 +0.00E+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
(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.966700E+002 +1.89307985303535E+001 +4.81342906259480E+000 +0.00E+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.
