Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: reorg hangs freequently

    Hi all,

    I am using db2 10.5 on AIX.

    My reorg command

    "Reorg table abc.mytab" got hang most of the times, It is a master table and contain about 2077 records only. application mostly use selects and very less insert and updates are there.

    it has a unique index as below

    CREATE UNIQUE INDEX "ABC "."MYIDX" ON "ABC "."MYTAB"
    ("USER_ID" ASC)


    How to find the root cause of the problem ?

    I have compared it with another master table in different schema with 20552 records, but that never create a problem. in fact this table is more busy than my problem table.

    Please suggest.

    regards
    sumit
    ssumit

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this command is offline reorg
    table can not be selected anymore while executing the reorg
    db2 list utilities should show some info
    db2 list applications and db2 get snapshot for application agentid xx should also give some indication
    db2 diaglog indicating any problem ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Thanks Guy Przytula,
    Does it also mean that offline reorg cant be done (it hangs) when any select is/are in progress. what may be the possible causes for the hang ?
    ssumit

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    reorg can be in lock wait because of others
    check with list applications | grep db2bp
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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