Hi,
with the command dostats -d database --f file after a couple of successful
actions appears the following error:
FAILED: Cannot FETCH table data (a1). SQLCODE = -1215, ISAM = 0.
Statement is:
SELECT a.tabid, a.partnum, a.nrows, a.tabname, a.owner,indexkeyarray_out(b.indexkeys) AS allparts, 0 FROM
"informix".systables a, outer ("informix".sysindices b, outer
"informix".sysobjstate s) WHERE a.tabid = b.tabid AND tabtype = 'T' AND
a.tabid >= 100 AND a.tabid = s.tabid AND s.objtype = 'I' AND b.idxname =
s.name AND s.state != 'D' ORDER BY 1, 3, 4, 5;
dostats: Features Version 5.10, Source Revision: 1.137 !
Copyright 1996-2006 by Art S. Kagel.
License for private usage (including use by commercial enterprise
for its own needs) is granted. Commercial and exploitation rights
are reserved.
IDS 11.50.FC3, Solaris 9
The command was successful before I did "update statistics medium for table"
and "update statistcs for procedure". And I killed an update stats job not
sure what he did in that moment.
The query above works without an error in dbaccess.
Any ideas what causes the error?
Regards,
Reinhard