Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

TDS instance need to tune

 4 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Chitta
Basic Member
Posts: 19
Basic Member
10/3/2011 10:47 AM
    Hi,
    I am getting frequent warning "

    09/15/11 13:54:27 GLPRDB091W Attribute lwsnssoallattrvaluelist is not indexed but is used in searches 1000 times" in ibmslapd.log file

    I have followed the IBM document to create index but am not aware whether Index created or not?
    i couldn't find any object by that name lwsnssoallattrvaluelist"

    can any one help me to create Index on the attribute.
    I not well in IBM db2 db.
    please can any one help me?

    Chitta
    Basic Member
    Posts: 19
    Basic Member
    10/4/2011 7:52 AM
      Can any one help ?
      Chitta
      Basic Member
      Posts: 19
      Basic Member
      10/5/2011 7:23 AM
        i have created the index.ldif file by performanceanalyze.pl script but the .ldif doest have any entries except teh header information. can any one help why this is happening, and how to generate the index.ldif file to create the index on attributes?
        Chitta
        Basic Member
        Posts: 19
        Basic Member
        10/23/2011 9:29 AM
          any one can help?
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          10/24/2011 12:44 PM
            I believe you have to run perfanalyze_indexes.pl next to generate the actual ldif file that has the index entries in it. (It's been a while for me now though, so the details aren't that clear.)