Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rdevarajan

    total memory used

    Hi is there a way to find out the total memory used by Db2 at any given instant. i used db2mtrk and get snapshot. But not sure if tehre is any direct paramteer to check. I heard there is something new in version 8.. any ideas? cheers, raj
  2. rdevarajan

    Acess plan for update query does not come up

    Thanks I am able to explain the statment on ascii... so not sure why am not bale to do the same on control center GUI cheers R
  3. rdevarajan

    Acess plan for update query does not come up

    We are using db2 UDB on aix v8 Through control centre I am trying to get the access plan for an update statment update orders set (orstat, orustmp) = (?, current timestamp) where orrfnbr = ? and orstat =? WE have around 4 triggers attached to the orders table. When i try getiing the...
  4. rdevarajan

    Primary index not used

    Thanks. Even when i use aliases, it does not work. Yes i did run runstats to update everything beofre trying the query Also if i add orrfnbr = ? in the where clause immedietly the accessplan picks up the index . But we cannot use this separately and hence are joining orrfnbr ( order...
  5. rdevarajan

    Primary index not used

    SELECT ORRFNBR, ORMENBR, ORSHNBR, ORMORDER FROM ORDERS, ordext, SLOTRESERVATION, SLOTSERVICE WHERE srornbr = orrfnbr AND orrfnbr = oeornbr AND srstat IS NULL AND srservice = ssrfnbr AND srbrnbr = ? and oereviewed = 0 and orshnbr = srshnbr...

Part and Inventory Search

Back
Top