• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 59 subscribers
  • Views 4708 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

In Top SQL Report. Why select sentence generate Direct Writes?

gareljos
over 6 years ago

I don't understood, why select generates writes? 

SELECT T0.IBITM, T0.IBLITM, T0.IBAITM, T0.IBMCU, T0.IBSRP1, T0.IBSRP2, T0.IBSRP3, T0.IBSRP4, T0.IBSRP5, T0.IBSRP6, T0.IBSRP7, T0.IBSRP8, T0.IBSRP9, T0.IBSRP0, T0.IBPRP1, T0.IBPRP2, T0.IBPRP3, T0.IBPRP4, T0.IBPRP5, T0.IBPRP6, T0.IBPRP7, T0.IBPRP8, T0.IBPRP9, T0.IBPRP0, T0.IBCDCD, T0.IBPDGR, T0.IBDSGP, T0.IBVEND, T0.IBANPL, T0.IBBUYR, T0.IBGLPT, T0.IBORIG, T0.IBROPI, T0.IBROQI, T0.IBRQMX, T0.IBRQMN, T0.IBWOMO, T0.IBSERV, T0.IBSAFE, T0.IBSLD, T0.IBCKAV, T0.IBSRCE, T0.IBLOTS, T0.IBOT1Y, T0.IBOT2Y, T0.IBSTDP, T0.IBFRMP, T0.IBTHRP, T0.IBSTDG, T0.IBFRGD, T0.IBTHGD, T0.IBCOTY, T0.IBMMPC, T0.IBPRGR, T0.IBRPRC, T0.IBORPR, T0.IBBACK, T0.IBIFLA, T0.IBABCS, T0.IBABCM, T0.IBABCI, T0.IBOVR, T0.IBSHCM, T0.IBCARS, T0.IBCARP, T0.IBSHCN, T0.IBSTKT, T0.IBLNTY, T0.IBFIFO, T0.IBCYCL, T0.IBINMG, T0.IBWARR, T0.IBSRNR, T0.IBPCTM, T0.IBCMCG, T0.IBFUF1, T0.IBTX, T0.IBTAX1, T0.IBMPST, T0.IBMRPD, T0.IBMRPC, T0.IBUPC, T0.IBSNS, T0.IBMERL, T0.IBLTLV, T0.IBLTMF, T0.IBLTCM, T0.IBOPC, T0.IBOPV, T0.IBACQ, T0.IBMLQ, T0.IBLTPU, T0.IBMPSP, T0.IBMRPP, T0.IBITC, T0.IBECO, T0.IBECTY, T0.IBECOD, T0.IBMTF1, T0.IBMTF2, T0.IBMTF3, T0.IBMTF4, T0.IBMTF5, T0.IBMOVD, T0.IBQUED, T0.IBSETL, T0.IBSRNK, T0.IBSRKF, T0.IBTIMB, T0.IBBQTY, T0.IBORDW, T0.IBEXPD, T0.IBDEFD, T0.IBMULT, T0.IBSFLT, T0.IBMAKE, T0.IBLFDJ, T0.IBLLX, T0.IBCMGL, T0.IBURCD, T0.IBURDT, T0.IBURAT, T0.IBURAB, T0.IBURRF, T0.IBUSER, T0.IBPID, T0.IBJOBN, T0.IBUPMJ, T0.IBTDAY, T0.IBTFLA, T0.IBCOMH, T0.IBAVRT, T0.IBPOC, T0.IBAING, T0.IBBBDD, T0.IBCMDM, T0.IBLECM, T0.IBLEDD, T0.IBMLOT, T0.IBPEFD, T0.IBSBDD, T0.IBU1DD, T0.IBU2DD, T0.IBU3DD, T0.IBU4DD, T0.IBU5DD, T0.IBXDCK, T0.IBLAF, T0.IBLTFM, T0.IBRWLA, T0.IBLNPA, T0.IBLOTC, T0.IBAPSC, T0.IBPRI1, T0.IBPRI2, T0.IBLTCV, T0.IBASHL, T0.IBOPTH, T0.IBCUTH, T0.IBUMTH, T0.IBLMFG, T0.IBLINE, T0.IBDFTPCT, T0.IBKBIT, T0.IBDFENDITM, T0.IBKANEXLL, T0.IBSCPSELL, T1.IMITM, T1.IMLITM, T1.IMAITM, T1.IMDSC1, T1.IMDSC2, T1.IMSRTX, T1.IMALN, T1.IMSRP1, T1.IMSRP2, T1.IMSRP3, T1.IMSRP4, T1.IMSRP5, T1.IMSRP6, T1.IMSRP7, T1.IMSRP8, T1.IMSRP9, T1.IMSRP0, T1.IMPRP1, T1.IMPRP2, T1.IMPRP3, T1.IMPRP4, T1.IMPRP5, T1.IMPRP6, T1.IMPRP7, T1.IMPRP8, T1.IMPRP9, T1.IMPRP0, T1.IMCDCD, T1.IMPDGR, T1.IMDSGP, T1.IMPRGR, T1.IMRPRC, T1.IMORPR, T1.IMBUYR, T1.IMDRAW, T1.IMRVNO, T1.IMDSZE, T1.IMVCUD, T1.IMCARS, T1.IMCARP, T1.IMSHCN, T1.IMSHCM, T1.IMUOM1, T1.IMUOM2, T1.IMUOM3, T1.IMUOM4, T1.IMUOM6, T1.IMUOM8, T1.IMUOM9, T1.IMUWUM, T1.IMUVM1, T1.IMSUTM, T1.IMUMVW, T1.IMCYCL, T1.IMGLPT, T1.IMPLEV, T1.IMPPLV, T1.IMCLEV, T1.IMPRPO, T1.IMCKAV, T1.IMBPFG, T1.IMSRCE, T1.IMOT1Y, T1.IMOT2Y, T1.IMSTDP, T1.IMFRMP, T1.IMTHRP, T1.IMSTDG, T1.IMFRGD, T1.IMTHGD, T1.IMCOTY, T1.IMSTKT, T1.IMLNTY, T1.IMCONT, T1.IMBACK, T1.IMIFLA, T1.IMTFLA, T1.IMINMG, T1.IMABCS, T1.IMABCM, T1.IMABCI, T1.IMOVR, T1.IMWARR, T1.IMCMCG, T1.IMSRNR, T1.IMPMTH, T1.IMFIFO, T1.IMLOTS, T1.IMSLD, T1.IMANPL, T1.IMMPST, T1.IMPCTM, T1.IMMMPC, T1.IMPTSC, T1.IMSNS, T1.IMLTLV, T1.IMLTMF, T1.IMLTCM, T1.IMOPC, T1.IMOPV, T1.IMACQ, T1.IMMLQ, T1.IMLTPU, T1.IMMPSP, T1.IMMRPP, T1.IMITC, T1.IMORDW, T1.IMMTF1, T1.IMMTF2, T1.IMMTF3, T1.IMMTF4, T1.IMMTF5, T1.IMEXPD, T1.IMDEFD, T1.IMSFLT, T1.IMMAKE, T1.IMCOBY, T1.IMLLX, T1.IMCMGL, T1.IMCOMH, T1.IMURCD, T1.IMURDT, T1.IMURAT, T1.IMURAB, T1.IMURRF, T1.IMUSER, T1.IMPID, T1.IMJOBN, T1.IMUPMJ, T1.IMTDAY, T1.IMUPCN, T1.IMSCC0, T1.IMUMUP, T1.IMUMDF, T1.IMUMS0, T1.IMUMS1, T1.IMUMS2, T1.IMUMS3, T1.IMUMS4, T1.IMUMS5, T1.IMUMS6, T1.IMUMS7, T1.IMUMS8, T1.IMPOC, T1.IMAVRT, T1.IMEQTY, T1.IMWTRQ, T1.IMTMPL, T1.IMSEG1, T1.IMSEG2, T1.IMSEG3, T1.IMSEG4, T1.IMSEG5, T1.IMSEG6, T1.IMSEG7, T1.IMSEG8, T1.IMSEG9, T1.IMSEG0, T1.IMMIC, T1.IMAING, T1.IMBBDD, T1.IMCMDM, T1.IMLECM, T1.IMLEDD, T1.IMPEFD, T1.IMSBDD, T1.IMU1DD, T1.IMU2DD, T1.IMU3DD, T1.IMU4DD, T1.IMU5DD, T1.IMDLTL, T1.IMDPPO, T1.IMDUAL, T1.IMXDCK, T1.IMLAF, T1.IMLTFM, T1.IMRWLA, T1.IMLNPA, T1.IMLOTC, T1.IMAPSC, T1.IMAUOM, T1.IMCONB, T1.IMGCMP, T1.IMPRI1, T1.IMPRI2, T1.IMASHL, T1.IMVMINV, T1.IMCMETH, T1.IMEXPI, T1.IMOPTH, T1.IMCUTH, T1.IMUMTH, T1.IMLMFG, T1.IMLINE, T1.IMDFTPCT, T1.IMKBIT, T1.IMDFENDITM, T1.IMKANEXLL, T1.IMSCPSELL FROM PRODDTA.F4102 T0,PRODDTA.F4101 T1 WHERE  (  ( T1.IMTMPL NOT IN  ( :KEY1,:KEY2,:KEY3,:KEY4,:KEY5,:KEY6,:KEY7,:KEY8,:KEY9,:KEY10,:KEY11,:KEY12,:KEY13,:KEY14,:KEY15,:KEY16,:KEY17,:KEY18,:KEY19,:KEY20,:KEY21,:KEY22,:KEY23,:KEY24,:KEY25,:KEY26,:KEY27 )  AND T0.IBMCU NOT IN  ( :KEY28,:KEY29,:KEY30,:KEY31,:KEY32,:KEY33,:KEY34,:KEY35,:KEY36,:KEY37,:KEY38,:KEY39,:KEY40,:KEY41,:KEY42,:KEY43,:KEY44,:KEY45,:KEY46,:KEY47,:KEY48,:KEY49,:KEY50,:KEY51,:KEY52,:KEY53,:KEY54,:KEY55,:KEY56,:KEY57,:KEY58,:KEY59,:KEY60,:KEY61,:KEY62,:KEY63,:KEY64,:KEY65,:KEY66,:KEY67 )  )  )  AND  ( T1.IMITM=T0.IBITM )  ORDER BY T1.IMITM ASC

 

Why?

Thanks

  • 0 over 6 years ago
    How many rows are in the tables PRODDTA.F4102 and PRODDTA.F4101?
    Is there also update and/or insert activity on those tables?

    It's quite possible that if the rows were updated/created before the select, that the blocks are getting marked as 'dirty' and need to be flushed from the buffer cache, hence, DBWR will cause writes to do that.