sysptprof table
User asked about sysptprof table columns: what isreads/iswrites/isrewrites represent, whether pagereads/pagewrites are disk I/O, and the relationship between bufferwrites and pagewrites. Responses clarified that "is" stands for ISAM (logical reads/writes/updates), pagreads/pagewrites are disk I/O, and provided formula bufwrites/(pagewrites+bufwrites)*100 for write cache percentage.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, I want to clarify the info in sysptprof.( see attached) (1) what numbers are stored in :isreads, iswrites, isrewrites? (2) pagereads/pagewrites are pages read from/write to disk(disk IO R/W), correct? (3) any relationships between bufferwrites and pageswites? Thanks, Frank Profile information for a table is available only when a table is open. When the last user who has a table open closes it, the tblspace in shared memory is freed, and any profile statistics are lost. The following table provides information about the columns in the *sysptprof * table: Column Type Description *dbsname* char(128) Database name *tabname* char(128) Table name *partnum* integer Partition (tblspace) number *lockreqs * integer Number of lock requests *lockwts* integer Number of lock waits * deadlks* integer Number of deadlocks *lktouts* integer Number of lock timeouts *isreads* integer Number of isreads *iswrites* integer Number of iswrites *isrewrites* integer Number of isrewrites *isdeletes* integer Number of isdeletes *bufreads* integer Number of buffer reads *bufwrites* integer Number of buffer writes *seqscans* integer Number of sequential scans *pagreads* integer Number of page reads *pagwrites* integer Number of page writes --20cf300fb15f38379904d279e5a6
Messy table format in last email. reattach the sysptprof structure. Thanks Frank The following table provides information about the columns in the sysptprof table: Column Type Description dbsname char(128) Database name tabname char(128) Table name partnum integer Partition (tblspace) number lockreqs integer Number of lock requests lockwts integer Number of lock waits deadlks integer Number of deadlocks lktouts integer Number of lock timeouts isreads integer Number of isreads iswrites integer Number of iswrites isrewrites integer Number of isrewrites isdeletes integer Number of isdeletes bufreads integer Number of buffer reads bufwrites integer Number of buffer writes seqscans integer Number of sequential scans pagreads integer Number of page reads pagwrites integer Number of page writes On Fri, Jan 4, 2013 at 12:34 PM, FRANK <yunyaoqu@gmail.com> wrote: > Hello, > > I want to clarify the info in sysptprof.( see attached) > > (1) what numbers are stored in :isreads, iswrites, isrewrites? > > (2) pagereads/pagewrites are pages read from/write to disk(disk IO R/W), > correct? > > (3) any relationships between bufferwrites and pageswites? > > Thanks, > > Frank > > Profile information for a table is available only when a table is open. > When the last user who has a table open closes it, the tblspace in shared > memory is freed, and any profile statistics are lost. > The following table provides information about the columns in the > *sysptprof > * table: > Column Type Description *dbsname* char(128) Database name *tabname* > char(128) Table name *partnum* integer Partition (tblspace) number > *lockreqs > * integer Number of lock requests *lockwts* integer Number of lock waits * > deadlks* integer Number of deadlocks *lktouts* integer Number of lock > timeouts *isreads* integer Number of isreads *iswrites* integer Number of > iswrites *isrewrites* integer Number of isrewrites *isdeletes* integer > Number > of isdeletes *bufreads* integer Number of buffer reads *bufwrites* > integer Number > of buffer writes *seqscans* integer Number of sequential scans *pagreads* > integer Number of page reads *pagwrites* integer Number of page writes > > --20cf300fb15f38379904d279e5a6 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf3071d16a719dc704d279fbcd
Bufwrites / (pagewrites + bufwrites ) * 100 = write cache pct Hope that helps. Art On Jan 4, 2013 12:35 PM, "FRANK" <yunyaoqu@gmail.com> wrote: > Hello, > > I want to clarify the info in sysptprof.( see attached) > > (1) what numbers are stored in :isreads, iswrites, isrewrites? > > (2) pagereads/pagewrites are pages read from/write to disk(disk IO R/W), > correct? > > (3) any relationships between bufferwrites and pageswites? > > Thanks, > > Frank > > Profile information for a table is available only when a table is open. > When the last user who has a table open closes it, the tblspace in shared > memory is freed, and any profile statistics are lost. > The following table provides information about the columns in the > *sysptprof > * table: > Column Type Description *dbsname* char(128) Database name *tabname* > char(128) Table name *partnum* integer Partition (tblspace) number > *lockreqs > * integer Number of lock requests *lockwts* integer Number of lock waits * > deadlks* integer Number of deadlocks *lktouts* integer Number of lock > timeouts *isreads* integer Number of isreads *iswrites* integer Number of > iswrites *isrewrites* integer Number of isrewrites *isdeletes* integer > Number > of isdeletes *bufreads* integer Number of buffer reads *bufwrites* > integer Number > of buffer writes *seqscans* integer Number of sequential scans *pagreads* > integer Number of page reads *pagwrites* integer Number of page writes > > --20cf300fb15f38379904d279e5a6 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0447f05eaa636404d27a3096
"is" stands for ISAM - so logical reads, writes and rewrites (updates) most of those we hope to find in the "buffer" activity=20 but some of it will have to go to disk "pag" or page j. On Jan 4, 2013, at 12:34 PM, FRANK wrote: > Hello,=20 >=20 > I want to clarify the info in sysptprof.( see attached)=20 >=20 > (1) what numbers are stored in :isreads, iswrites, isrewrites?=20 >=20 > (2) pagereads/pagewrites are pages read from/write to disk(disk IO = R/W),=20 > correct?=20 >=20 > (3) any relationships between bufferwrites and pageswites?=20 >=20 > Thanks,=20 >=20 > Frank=20 >=20 > Profile information for a table is available only when a table is = open.=20 > When the last user who has a table open closes it, the tblspace in = shared=20 > memory is freed, and any profile statistics are lost.=20 > The following table provides information about the columns in the = *sysptprof=20 > * table:=20 > Column Type Description *dbsname* char(128) Database name *tabname*=20 > char(128) Table name *partnum* integer Partition (tblspace) number = *lockreqs=20 > * integer Number of lock requests *lockwts* integer Number of lock = waits *=20 > deadlks* integer Number of deadlocks *lktouts* integer Number of lock=20= > timeouts *isreads* integer Number of isreads *iswrites* integer Number = of=20 > iswrites *isrewrites* integer Number of isrewrites *isdeletes* integer = Number=20 > of isdeletes *bufreads* integer Number of buffer reads *bufwrites*=20 > integer Number=20 > of buffer writes *seqscans* integer Number of sequential scans = *pagreads*=20 > integer Number of page reads *pagwrites* integer Number of page writes=20= >=20 > --20cf300fb15f38379904d279e5a6=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20
I mentioned this recently. We cannot map directly isamreads to SELECTs, isamwrites to INSERTs, isamrewrites to UPDATEs and isamdeletes to DELETEs. This are internal counters, AFAIK of function calls used in the respective operations. The more isamreads the more SELECTs etc. But things like BATCHEDREAD* will impact (reduce) this counters for the same number of SQL operations. Regards On Fri, Jan 4, 2013 at 6:42 PM, Jack Parker <jack.parker4@verizon.net>wrote: > "is" stands for ISAM - so logical reads, writes and rewrites (updates) > most of those we hope to find in the "buffer" activity=20 > but some of it will have to go to disk "pag" or page > > j. > > On Jan 4, 2013, at 12:34 PM, FRANK wrote: > > > Hello,=20 > >=20 > > I want to clarify the info in sysptprof.( see attached)=20 > >=20 > > (1) what numbers are stored in :isreads, iswrites, isrewrites?=20 > >=20 > > (2) pagereads/pagewrites are pages read from/write to disk(disk IO = > R/W),=20 > > correct?=20 > >=20 > > (3) any relationships between bufferwrites and pageswites?=20 > >=20 > > Thanks,=20 > >=20 > > Frank=20 > >=20 > > Profile information for a table is available only when a table is = > open.=20 > > When the last user who has a table open closes it, the tblspace in = > shared=20 > > memory is freed, and any profile statistics are lost.=20 > > The following table provides information about the columns in the = > *sysptprof=20 > > * table:=20 > > Column Type Description *dbsname* char(128) Database name *tabname*=20 > > char(128) Table name *partnum* integer Partition (tblspace) number = > *lockreqs=20 > > * integer Number of lock requests *lockwts* integer Number of lock = > waits *=20 > > deadlks* integer Number of deadlocks *lktouts* integer Number of lock=20= > > > timeouts *isreads* integer Number of isreads *iswrites* integer Number = > of=20 > > iswrites *isrewrites* integer Number of isrewrites *isdeletes* integer = > Number=20 > > of isdeletes *bufreads* integer Number of buffer reads *bufwrites*=20 > > integer Number=20 > > of buffer writes *seqscans* integer Number of sequential scans = > *pagreads*=20 > > integer Number of page reads *pagwrites* integer Number of page > writes=20= > > >=20 > > --20cf300fb15f38379904d279e5a6=20 > >=20 > >=20 > > = > **************************************************************************= > *****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20= > > >=20 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7bdc06aa34851b04d27d5019
also a single isam read/write can hit multiple buffers... From: "Fernando Nunes" <domusonline@gmail.com> To: ids@iiug.org, Date: 01/04/2013 03:40 PM Subject: Re: sysptprof table [29194] Sent by: ids-bounces@iiug.org I mentioned this recently. We cannot map directly isamreads to SELECTs, isamwrites to INSERTs, isamrewrites to UPDATEs and isamdeletes to DELETEs. This are internal counters, AFAIK of function calls used in the respect= ive operations. The more isamreads the more SELECTs etc. But things like BATCHEDREAD* w= ill impact (reduce) this counters for the same number of SQL operations. Regards On Fri, Jan 4, 2013 at 6:42 PM, Jack Parker <jack.parker4@verizon.net>wrote: > "is" stands for ISAM - so logical reads, writes and rewrites (updates= ) > most of those we hope to find in the "buffer" activity=3D20 > but some of it will have to go to disk "pag" or page > > j. > > On Jan 4, 2013, at 12:34 PM, FRANK wrote: > > > Hello,=3D20 > >=3D20 > > I want to clarify the info in sysptprof.( see attached)=3D20 > >=3D20 > > (1) what numbers are stored in :isreads, iswrites, isrewrites?=3D20= > >=3D20 > > (2) pagereads/pagewrites are pages read from/write to disk(disk IO = =3D > R/W),=3D20 > > correct?=3D20 > >=3D20 > > (3) any relationships between bufferwrites and pageswites?=3D20 > >=3D20 > > Thanks,=3D20 > >=3D20 > > Frank=3D20 > >=3D20 > > Profile information for a table is available only when a table is =3D= > open.=3D20 > > When the last user who has a table open closes it, the tblspace in = =3D > shared=3D20 > > memory is freed, and any profile statistics are lost.=3D20 > > The following table provides information about the columns in the =3D= > *sysptprof=3D20 > > * table:=3D20 > > Column Type Description *dbsname* char(128) Database name *tabname*= =3D20 > > char(128) Table name *partnum* integer Partition (tblspace) number = =3D > *lockreqs=3D20 > > * integer Number of lock requests *lockwts* integer Number of lock = =3D > waits *=3D20 > > deadlks* integer Number of deadlocks *lktouts* integer Number of lock=3D20=3D > > > timeouts *isreads* integer Number of isreads *iswrites* integer Num= ber =3D > of=3D20 > > iswrites *isrewrites* integer Number of isrewrites *isdeletes* inte= ger =3D > Number=3D20 > > of isdeletes *bufreads* integer Number of buffer reads *bufwrites*=3D= 20 > > integer Number=3D20 > > of buffer writes *seqscans* integer Number of sequential scans =3D > *pagreads*=3D20 > > integer Number of page reads *pagwrites* integer Number of page > writes=3D20=3D > > >=3D20 > > --20cf300fb15f38379904d279e5a6=3D20 > >=3D20 > >=3D20 > > =3D > ***********************************************************************= ***=3D > *****=3D20 > > Forum Note: Use "Reply" to post a response in the discussion forum.= =3D20=3D > > >=3D20 > > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7bdc06aa34851b04d27d5019 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =