Re: Temporary Tables and SYSPTPROF. Questions
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote:
>
> Hi everybody,
> Something about the temporary ( dbspace ) ( tables ) always
> fasinates me. I
> have more questions. I was monitoring the progress of a temporary
> table created by a process, and here's what I found.
> 1. If the process creates a temporary table with logging, ( say
> select *
> from tab1 into temp tmptab1 ) then you can get the exact number of > rows
> read/written/updated by the SYSPTPROF view ( isreads, iswrites and
> isrewrites )
> in the sysmaster database. You also get only ONE row in the sysptprof
> with the
> partnum the same as specified in the onstat -g ses output
> BUT
The table is created in the same dbspace as the database or rootdbs.
> 2. If the process creates a temporary with NO LOG , then we get
> two rows in
> SYSPTPROF ( ie two rows in systabnames ), but different partnum , and
> neither of
> the partnum(s) match what is shown in the onstat -g ses. Morover, the
> isreads,
> iswrites and isrewrites in the sysptprof have no connection to the
> actual number
> of rows read/written/updated.
The table is fragmented across your temp dbspaces. I would guess you
have two defined?
> Does anybody know what is going on ?? How do I follow the progress
> of a
> temporary table. On the same note, if we use sysptprof to follow the
> progress of
> permanent tables, would it be accurate ( albeit a little off by time
> ). I do know that onperf reports a more accurate count.
> Any suggestions ??
I haven't got a clue which SMI tables to look at. If you use:
onstat -g ses <sid>
You will get a list of temp tables created by that session at the end.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+