sysmaster:systabnames

Hi, select distinct dbsname from sysmaster:systabnames gives me follwing output dbsname dac dbsname domino dbsname dominodbs dbsname ifxadmin dbsname rootdbs dbsname sysmaster dbsname sysuser dbsname sysutils dbsname tempdbs The dac dbsname seems strange to me. Long time ago the dac database was removed from this system. But the sequences used on the domino database seems still have a connection with the dac database or dbspace. Can anyone help or explain this ? select * from syssequences a, systables b, sysmaster:systabnames c where a.tabid = b.tabid and b.partnum = c.partnum on my domino database gives me seqid 1 tabid 247 start_val 181430 inc_val 1 min_val 181430 max_val 9223372036854775807 cycle 1 restart_val cache 20 order 1 tabname seq_aa_formulieren owner informix partnum 3145922 tabid 247 rowsize 10 ncols 1 nindexes 0 nrows 0 created 04/13/2006 version 16252931 tabtype Q locklevel P npused 0 fextsize 16 nextsize 16 flags 0 site dbname type_xid 0 am_id 0 partnum 3145922 dbsname dac owner informix tabname seq_aa_formulieren collate en_US.57372 select * from sysmaster:sysdatabases gives : name sysmaster name sysutils name sysuser name domino name ifxadmin onstat -d gives : IBM Informix Dynamic Server Version 9.40.UC8 -- On-Line -- Up 17 days 09:00:00 -- 2119680 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 726129c8 1 0x40001 1 1 N B informix rootdbs 728f3958 2 0x42001 2 1 N TB informix tempdbs 728f3c98 3 0x40001 3 1 N B informix dominodbs 3 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 72612d08 1 1 0 500000 390848 PO-B /dev/informix/root 728f3648 2 2 0 500000 498897 PO-B /dev/informix/01 728f37d0 3 3 0 2000000 891088 PO-B /dev/informix/02 3 active, 32766 maximum Expanded chunk capacity mode: always

Looks like you created a table in database domino that referenced the sequence seq_aa_formulieren in database DAC. When you dropped the dac database the engine moved the underlying table supporting seq_aa_formulieren into domino but missed updating the dbsname field in the DATABASE TABLESPACE pages which underly the pseudo table sysdatabases. I'd call that a reportable bug. Open a support case, though it doesn't seem to have caused any harm. Art S. Kagel ----- Original Message ----- From: Nadine Dieltjens <ids@iiug.org> At: 4/20 9:39:41 Hi, select distinct dbsname from sysmaster:systabnames gives me follwing output dbsname dac dbsname domino dbsname dominodbs dbsname ifxadmin dbsname rootdbs dbsname sysmaster dbsname sysuser dbsname sysutils dbsname tempdbs The dac dbsname seems strange to me. Long time ago the dac database was removed from this system. But the sequences used on the domino database seems still have a connection with the dac database or dbspace. Can anyone help or explain this ? select * from syssequences a, systables b, sysmaster:systabnames c where a.tabid = b.tabid and b.partnum = c.partnum on my domino database gives me seqid 1 tabid 247 start_val 181430 inc_val 1 min_val 181430 max_val 9223372036854775807 cycle 1 restart_val cache 20 order 1 tabname seq_aa_formulieren owner informix partnum 3145922 tabid 247 rowsize 10 ncols 1 nindexes 0 nrows 0 created 04/13/2006 version 16252931 tabtype Q locklevel P npused 0 fextsize 16 nextsize 16 flags 0 site dbname type_xid 0 am_id 0 partnum 3145922 dbsname dac owner informix tabname seq_aa_formulieren collate en_US.57372 select * from sysmaster:sysdatabases gives : name sysmaster name sysutils name sysuser name domino name ifxadmin onstat -d gives : IBM Informix Dynamic Server Version 9.40.UC8 -- On-Line -- Up 17 days 09:00:00 -- 2119680 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 726129c8 1 0x40001 1 1 N B informix rootdbs 728f3958 2 0x42001 2 1 N TB informix tempdbs 728f3c98 3 0x40001 3 1 N B informix dominodbs 3 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 72612d08 1 1 0 500000 390848 PO-B /dev/informix/root 728f3648 2 2 0 500000 498897 PO-B /dev/informix/01 728f37d0 3 3 0 2000000 891088 PO-B /dev/informix/02 3 active, 32766 maximum Expanded chunk capacity mode: always ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.