Results 1 to 6 of 6
  1. #1
    Newcomer
    Join Date
    Apr 2010
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default SQL command stall

    Hello,

    I can't query the events table at all while using sql commands.
    i.e.:
    Code:
    select * from events
    When I run that sql command above, it just stall (command runs, but there is no output). I let it run over a 24h timeframe and still had no output from it.

    I need to ctrl+c to kill it.

    q events does work fine though.

    Anyone would have any idea why, or where to look to solve this? I would need to run a sql command to get me the number of failed events from the last day.

    thanks,

    Edit: I'm using TSM server 6.1.2
    Last edited by pjcyr; 04-15-2011 at 09:47 AM.

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,858
    Thanks
    4
    Thanked 228 Times in 223 Posts

    Default

    Which platform are you using? Have you tried to run with something specific other than *?

    If running with a specific search pattern and TSM still hangs, try updating the version to 6.1.5 (latest). Might be a bug.
    Last edited by moon-buddy; 04-15-2011 at 02:50 PM.
    Ed

  3. #3
    Member
    Join Date
    May 2005
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    hi,
    i have the same problem, see apar ic69141 and it's resolve with tsm server 6.1.4 or higher

  4. #4
    Newcomer
    Join Date
    Apr 2010
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Yea, I tried a couple of sql command and every one stall when polling the event table. I've been successful with any other table until now. I was also successful running select on the event table a couple of week ago.

    I believe nothing changed from before on the server.

  5. #5
    Member
    Join Date
    May 2005
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    hi, i had this problem few month ago, i remember that this problem is cause by a wrong entries in event table, and when this entry is remove from this table after somes day or week. the select will work until a new wrong entry appear in the event table.

  6. #6
    Newcomer
    Join Date
    Apr 2010
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks lnal001,

    it seems like you are right about the APAR ic69141.

Similar Threads

  1. Looking for a SQL-command
    By obiwan2 in forum TSM Server
    Replies: 1
    Last Post: 04-05-2011, 09:57 AM
  2. SQL update command?
    By tkunkel in forum Scripting
    Replies: 4
    Last Post: 02-11-2011, 05:29 AM
  3. SQL Select command - Last status for each SQL Database?
    By jcpatum in forum Microsoft SQL Server
    Replies: 4
    Last Post: 03-26-2009, 06:40 PM
  4. SQL Command for collocation
    By scottgassTSM in forum Scripting
    Replies: 2
    Last Post: 04-15-2008, 10:55 AM
  5. backup sessions stall after 5.1.5 upgrade?
    By ALT-G in forum TSM Server
    Replies: 0
    Last Post: 08-30-2003, 08:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •