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.schofi...@lloydsbanking.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 zfor...@vcu.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