What is your platform/OS?   I recently upgraded from 6.3.4.300 to 6.3.5.100
and am seeing lots of problems with selects not return consistent/correct
results as their non-select counterparts.

The reason I ask about the OS is IBM has stated there are known problems
with RedHat 6 kernels causing DB2 issues.

Today's example of inconsistent results is the difference between a "Q
SESSIONS" and "SELECT from sessions"

*8:16:04 AM   WIND : select
session_id,session_type,client_name,start_time,bytes_sent,bytes_received,wait_seconds,state
from sessions*
    SESSION_ID: 11
  SESSION_TYPE: Admin
   CLIENT_NAME: TSMMANAGER
    START_TIME: 2014-12-18 10:20:11.000000
    BYTES_SENT: 58684271
BYTES_RECEIVED: 149
  WAIT_SECONDS: 0
         STATE: Run
    SESSION_ID: 47452
  SESSION_TYPE: Admin
   CLIENT_NAME: TSMMANAGER
    START_TIME: 2014-12-30 14:39:41.000000
    BYTES_SENT: 156
BYTES_RECEIVED: 350
  WAIT_SECONDS: 0
         STATE: Run

*8:16:07 AM   WIND : q sess*
  Sess Comm.  Sess     Wait   Bytes   Bytes Sess    Platform Client Name

Number Method State    Time    Sent   Recvd Type
------ ------ ------ ------ ------- ------- ------- --------
------------------
47,452 Tcp/Ip Run      0 S      156     350 Admin   WinNT    TSMMANAGER

54,060 Tcp/Ip Run      0 S   31.4 M     149 Admin   WinNT    TSMMANAGER

78,034 Tcp/Ip IdleW   21 S    1.3 G 952.2 K Node    WinNT    DENPAC

78,041 Tcp/Ip RecvW    0 S  273.6 K 202.8 G Node    WinNT    DENPAC

79,547 Tcp/Ip RecvW    0 S   28.3 K  13.0 G Node    TDP MSS-
DSS20LOG.VCU.EDU
                                                     QL Win-

                                                     64

79,589 Tcp/Ip Run      0 S      156     235 Admin   WinNT    ZFORRAY



On Fri, Jan 9, 2015 at 6:21 AM, Schofield, Neil (Storage & Middleware,
Backup & Restore) <Neil.Schofield AT lloydsbanking DOT com> wrote:

> I've just tried the select statement on v6.3.5.0 that Margaret tried below
> in 2012 and it still returns no rows. Does anyone have a work-around that
> can be used?
>
> Regards
> Neil
>
> On 6/21/2012 9:55 AM, Clark, Margaret wrote:
> > Using TSM server 6.2.3.1, the following SQL command no longer works:
> >
> > select node_name from nodes where node_name not in (select node_name
> > from filespaces)
> >
> > It still works correctly if you take out the "not".
> >
> > Any ideas?
> >
> >
> > -          Margaret
> >
>
>
>
> Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ.
> Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank
> plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in
> England and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc.
> Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no.
> SC327000. Telephone: 08457 21 31 41. Cheltenham & Gloucester plc.
> Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England
> and Wales 2299428. Telephone: 0845 603 1637
>
> Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential
> Regulation Authority and regulated by the Financial Conduct Authority and
> Prudential Regulation Authority.
>
> Cheltenham & Gloucester plc is authorised and regulated by the Financial
> Conduct Authority.
>
> Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester
> Savings is a division of Lloyds Bank plc.
>
> HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in
> Scotland no. SC218813.
>
> This e-mail (including any attachments) is private and confidential and
> may contain privileged material. If you have received this e-mail in error,
> please notify the sender and delete it (including any attachments)
> immediately. You must not copy, distribute, disclose or use any of the
> information in it or any attachments. Telephone calls may be monitored or
> recorded.
>



--
*Zoltan Forray*
TSM Software & Hardware Administrator
BigBro / Hobbit / Xymon Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
zforray AT vcu DOT edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html