onstat -g his ( Log Space for Select)

Hi! IDS 11.50FC5 In onstat -g his output for SELECT Stmt Type Log Space not 0. Statement text: SELECT COUNT(*) FROM work_alloc SELECT using table [ work_alloc ] Iterator/Explain ================ ID Left Right Est Cost Est Rows Num Rows Partnum Type 1 0 0 1 1 1 0 Group Statement information: Sess_id User_id Stmt Type Finish Time Run Time TX Stamp PDQ 389 201 SELECT 17:46:33 0.0136 25616af7 0 Statement Statistics: Page Buffer Read Buffer Page Buffer Write Read Read % Cache IDX Read Write Write % Cache 0 61 100.00 0 0 4 100.00 Lock Lock LK Wait Log Num Disk Memory Requests Waits Time (S) Space Sorts Sorts Sorts 25 0 0.0000 892 B 0 0 0 Total Total Avg Max Avg I / O Wait Avg Rows Executions Time (S) Time (S) Time (S) IO Wait Time (S) Per Sec 1 0.0138 0.0138 0.0136 0.000000 0.000000 73.5278 Estimated Estimated Actual SQL ISAM Isolation SQL Cost Rows Rows Error Error Level Memory 1 1 1 0 0 DR 16016 Why "Log Space" more 0 ?

It appears this is undocumented in the v11.50 Information Center (http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/ com.ibm.adref.doc/ids_adr_0535.htm?resultof=%22%6f%6e %73%74%61%74%22%20%22%2d %67%22%20%22%67%22%20%22%68%69%73%22%20%22%68%69%22%20 ). I have submitted the page for review with a comment about the page. My guess would be that since you are using DR (Dirty Read) and you are not manipulating data ( i.e. Update, Insert, or Delete) there would not be any logical log record generated by this SELECT statement. I bet if you rerun your test with a DML statement, you will see some value under this heading, assuming it is run the SQL against a logging database. Please run this test and let us know how it goes. HTH Russ

On 28 Aug, 15:22, "zaiets.ko...@gmail.com" <zaiets.ko...@gmail.com> wrote: > Hi! > IDS 11.50FC5 > In onstat -g his output  for SELECT Stmt Type Log Space not 0. >  Statement text: >    SELECT COUNT(*) FROM work_alloc> >   SELECT using table [ work_alloc ] > >  Iterator/Explain >  ================ >     ID   Left  Right   Est Cost   Est Rows   Num Rows    Partnum Type >      1      0      0          1          1          1          0 Group > >  Statement information: >   Sess_id  User_id  Stmt Type        Finish Time    Run Time   TX > Stamp   PDQ >   389              201      SELECT           17:46:33       0.0136 > 25616af7   0 > >  Statement Statistics: >   Page       Buffer     Read              Buffer     Page > Buffer     Write >   Read       Read       % Cache    IDX Read   Write      Write      % > Cache >   0            61           100.00                0 > 0          4          100.00 > >   Lock          Lock       LK Wait    Log        Num        Disk > Memory >   Requests   Waits      Time (S)   Space      Sorts      Sorts > Sorts >   25                 0          0.0000     892 B      0 > 0            0 > >   Total           Total        Avg         Max          Avg        I / > O Wait   Avg Rows >   Executions Time (S)   Time (S)   Time (S)   IO Wait    Time (S) > Per Sec >   1                0.0138     0.0138     0.0136      0.000000 > 0.000000   73.5278 > >   Estimated  Estimated  Actual     SQL        ISAM       Isolation > SQL >   Cost          Rows        Rows       Error       Error > Level      Memory >   1               1              1              0 > 0             DR         16016 > > Why "Log Space" more 0 ? use onlog to check the log for the time the sql was run.