9.3/9.4 tables
Can anyone please let me know as to which tables in 9.4 version of IDS are systables and sysfragments... I donot see the above 2 tables listed in 9.4 version...is the name changed... Thanks Venkatesh
Venkatesh,
They are still there, the following is a query I did on kcsu05.
Regards - Lester
$ dbaccess
$ onstat -VIBM Informix Dynamic Server Version 9.40.UC2
$ dbaccess - -
> database stores_demo;
Database selected.
> select * from systables where tabname in ("systables", "sysfragments" );
tabname systables
owner informix
partnum 1048589
tabid 1
rowsize 469
ncols 20
nindexes 2
nrows 60
created 05/06/2002
version 65543
tabtype T
locklevel R
npused 4
fextsize 16
nextsize 16
flags 0
site
dbname
type_xid 0
am_id 0
tabname sysfragments
owner informix
partnum 1048804
tabid 25
rowsize 592
ncols 18
nindexes 1
nrows 17
created 05/06/2002
version 65542
tabtype T
locklevel R
npused 3
fextsize 16
nextsize 16
flags 0
site
dbname
type_xid 0
am_id 0
2 row(s) retrieved.
>
Venkatesh K.... wrote:
> Can anyone please let me know as to which tables in 9.4 version of IDS are
systables and sysfragments...
> I donot see the above 2 tables listed in 9.4 version...is the name changed...
> Thanks
> Venkatesh
>
>
>
>
--
______________________________________________________________________
Lester Knutsen lester@advancedatatools.com
Advanced DataTools Corporation Voice: 703-256-0267
Visit our Web page: http://www.advancedatatools.com
Brio Mid Atlantic User Group:
http://www.advancedatatools.com/BrioUserGroup/index.html
Washington Area IBM-Informix User Group:
http://www.iiug.org/~waiug/
______________________________________________________________________
Do a select
on systables order by tabid. Youll see this list. System
tables are never listed in dbaccess -> tables -> info.
tabid tabname
1 systables
2 syscolumns
3 sysindices
4 systabauth
5 syscolauth
6 sysviews
7 sysusers
8 sysdepend
9 syssynonyms
10 syssyntable
11 sysconstraints
12 sysreferences
13 syschecks
14 sysdefaults
15 syscoldepend
16 sysprocedures
17 sysprocbody
18 sysprocplan
19 sysprocauth
20 sysblobs
21 sysopclstr
22 systriggers
23 systrigbody
24 sysdistrib
25 sysfragments
26 sysobjstate
27 sysviolations
28 sysfragauth
29 sysroleauth
30 sysxtdtypes
31 sysattrtypes
32 sysxtddesc
33 sysinherits
34 syscolattribs
35 syslogmap
36 syscasts
37 sysxtdtypeauth
38 sysroutinelangs
39 syslangauth
40 sysams
41 systabamdata
42 sysopclasses
43 syserrors
44 systraceclasses
45 systracemsgs
46 sysaggregates
47 syssequences
70 sysdomains
71 sysindexes
90 GL_COLLATE
91 GL_CTYPE
99 VERSION
Venkatesh K.... wrote:
>Can anyone please let me know as to which tables in 9.4 version of IDS are
systables and sysfragments...
>I donot see the above 2 tables listed in 9.4 version...is the name changed...
>Thanks
>Venkatesh
>
>
>
>
>
>
--
Gerd Kaluzinski Tel. :+49-(0)7541-585-5000
Fax :+49-(0)7541-585-5500
BYTEC GmbH mailto:support@bytec.de
Hermann-Metzger-Str.7 http://www.bytec.de
88045 Friedrichshafen