Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Jul 2008
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default select count(*) from events stuck!

    Some days ago the old TSM Operational Reports stopped working - the reports were never generated or sent, instead the reporting was stuck at "Working... This may take several minutes to complete" and the progress bar wasn't moving. I noticed it was the first SQL command that apparently never completed:

    select count(*) as ASC from events where LENGTH(domain_name) IS NULL and scheduled_start between '2010-04-26 09:10:48' and '2010-04-27 09:10:47' and status='Completed' and result in (0, 11)

    Manually running this command in dsmadmc also has the same effect (you have to ctrl-c out):

    select count(*) from events

    Also I noticed some other errors in the log:

    ANR0102E admsql.c(5177): Error 1 inserting row in table "EVENTS.SQL". (SESSION: 4)

    Any ideas? Seems like a DB2 problem to me...

    Oskar

  2. #2
    Member
    Join Date
    Jul 2008
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Forgot to mention, we're running 6.1.3.3.

  3. #3
    Member
    Join Date
    Jul 2008
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    http://www-01.ibm.com/support/docvie...id=swg1IC62253 seems related, but 6.1.3.3 didn't fix the problem (just upgraded from 6.1.3.2).

  4. #4
    Member
    Join Date
    Jul 2008
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Just to follow up... I reported this problem to IBM, and after following their debug/trace procedure the problem solved itself somehow. The 'q event' command took 2-3 mins though, but after that it was smooth. There also turned out to be a deadlock directory related to the event table in some DB2 directory, and IBM recommended me cleaning it. Unfortunately I don't know if it would have helped because the problem solved itself anyway.

Similar Threads

  1. select node where count(*) = 0 ?
    By ChrisRees in forum Scripting
    Replies: 5
    Last Post: 07-30-2008, 05:40 PM
  2. The select from events
    By major in forum TSM Reporting & Monitoring
    Replies: 4
    Last Post: 03-14-2008, 09:57 AM
  3. Select Events
    By zsoltesz in forum Scripting
    Replies: 4
    Last Post: 03-03-2008, 12:46 AM
  4. select for volume count!!!
    By klee in forum Scripting
    Replies: 1
    Last Post: 04-12-2006, 08:39 AM
  5. Select * from events
    By christian in forum Scripting
    Replies: 7
    Last Post: 06-15-2004, 09:37 AM

Tags for this Thread

Posting Permissions

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