Re: Quering the Sysmaster Database
Antonio Arthur wrote:
>
> Hi there,
>
> Some time ago, I saw one or two Select statements on the syssqexplain table
> to verify aspects of cost and sorts, scans, indexes and temp files. I
> believe the queries are these :
>
> select avg(sqx_estcost), count(*) num, sqx_statement
> from syssqexplain
> group by 3
> order by 1 desc;
>
> and
>
> select * from syssqexplain
> where sqx_seqscan =3D 1 or
> sqx_tempfile =3D 1 or
> sqx_autoindex =3D 1 or
> sqx_srtscan =3D 1
> order by sqx_estcost desc;>
> My problem is :
>
> Every time I execute one of these queries (or any other query on the
> sysmaster database) my machine hangs and I have to reboot the server. After
> reboot, I make an "onstat -m" and get a number of
> "Droping TBLSPACE temporary xxxxx. Recovering 8 pages".
>
> My configuration is :
>
> DEC ALPHA 1000 with 128 Mb RAM, 4 Gb HD
> INFORMIX 7.20=20
>
> This machine is used only in development and it has more or less 15 users,
> shared memory medium of 50 MB.
>
> If anyone knows what this can be I'd like to know. I already contacted the
> Tech Support and they don't know why is this occuring.
>
> Thanks
>
> Antonio Arthur
> ------------------------|----------------------------------
> Antonio Arthur Filho | Rio Sul Linhas A=E9reas S.A.
> | Brazilian Regional Airline
> | Av. Rio Branco, 85/6 andar
> Database Administrator | Centro - Rio De Janeiro - RJ
> | CEP:20040-004
> Database Manager | E-Mail : aarthur@montreal.com.br
> ------------------------|----------------------------------
Antonio: try checking that you haven't runout of logical log space (i.e.
the logs are full and not backed up). This will cause the server to
appear that it is hung.
--
+-----------------------------------------------+
| Mark Christmas mchristmas@crosskeys.com
| CrossKeys Systems Corp http://www.crosskeys.com
| 350 Terry Fox Dr
| Kanata, ON, Canada K2K 2W5
| Phone (613) 591-1600 Fax (613) 599-3626
+-----------------------------------------------+