Re: New feather in IDS for NT version 7.3
In article <6joc73$j95$1@nnrp1.dejanews.com>, zandy@skyinet.net writes >In article <3i7YUDAoJ4W1Ew5v@smooth1.demon.co.uk>, > David Williams <djw@smooth1.demon.co.uk> wrote: >> >> In article <3556DCB3.6E52@dati.lv>, Leonid Vorontsov >> <Leonids.Voroncovs@dati.lv> writes >> >The statement >> > >> > SELECT TABNAME TBNAME,OWNER CREATOR,TABTYPE TYPE,NCOLS COLCOUNT,'' >> > REMARKS,"LABEL" LABELS from "informix".SYSTABLES T where >> >(USER=T.OWNER or >> > USER='informix' or exists(select GRANTEE from "informix".SYSTABAUTH >> >where >> > (GRANTEE= USER or GRANTEE='public') and TABID=T.TABID and >> > (TABAUTH[1,1]='s' or TABAUTH[1,1]='S'))) and (TABTYPE = 'T') and >> >not >> > ((OWNER='informix' or OWNER='pcuser') and TABNAME in >> > ('sysblobs','syschecks','syscolauth', >> > 'syscoldepend','syscolumns','sysconstraints','sysdefaults', >> > 'sysdepend','sysdistrib', 'sysfragments', 'sysindexes','sysopclstr', >> > 'sysprocauth', 'sysprocbody','sysprocedures','sysprocplan', >> > 'sysreferences','syssynonyms', 'syssyntable','systabauth', >> > 'systables','systriggers','systrigbody', 'sysusers','sysviews', >> > 'gtitables','gticonvert1','gticolumns', 'gtiextrtab','gtitabauth', >> > 'gticolauth','gtisyssyntab','gtisynonyms', >> >'gtiindexes','gticonvert2', >> > 'gticonvert3','gticonvert4','gticonvert5', 'gtikeys')) ORDER BY >> >TBNAME ASC; >> > >> >brings server down. >> >Any comments? Leonid. ( Leonids.Voroncovs@dati.lv ) >> >> What does the online.log say? >> >> -- >> David Williams >> > >I've also tested this on 7.3 TC2. >It freezes the engine! >I could not even shut it down! >Have to reboot the machine for it to work again > I'd log a call with Informix..and PLEASE TRY TO COORDINDATE YOUR CALLS TOGETHER... >Zandy > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care