could anyone help to answer the question ?
1) the customer execute the sql "select * from pobms into temp objtmptbl with
no log" in instance 73mcbs without exit dbaccess , this instance justly has on
temporary dbspace.
a) onstat -c |grep TEMP return the following information:
DBSPACETEMP tmpdbs # Default temp dbspaces
b)Run the "onstat -g sql" to check this session:
IBM Informix Dynamic Server Version 10.00.FC8W2X1 -- On-Line -- Up 28 days
18:04:49 -- 3289304 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
112010 - cbs CR Not Wait 0 0 9.29 Off
Last parsed SQL statement :
SELECT * FROM pobms INTO TEMP objtmptbl WITH
NO LOG
User-created Temp tables :
partnum tabname rowsize
5000e0 objtmptbl 117
c) oncheck -pe |grep objtmptbl display this table use two extents:
(0x5000e0) cbs:'mcbs'.objtmptbl 53 2688
(0x5000e0) cbs:'mcbs'.objtmptbl 2791 680
2).the customer execute the same sql" select * from pobms into temp objtmptbl
with no log" in another instance 73ocbs.
(a)、onstat -g sql:
IBM Informix Dynamic Server Version 10.00.FC8W2X1 -- On-Line -- Up 28 days
18:05:40 -- 3289304 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
336874 - cbs CR Not Wait 0 0 9.29 Off
Last parsed SQL statement :
SELECT * FROM pobms INTO TEMP objtmptbl WITH
NO LOG
doesn't disply the" user-created temp tables" information.
(b)onstat -c |grep TEMP :
DBSPACETEMP tmpdbs1,tmpdbs2,tmpdbs3,tmpdbs4,tmpdbs5,tmpdbs6
(c)、oncheck -pe |grep objtmptbl:
(0x500180) cbs:'ocbs'.objtmptbl 53 568
(0x600060) cbs:'ocbs'.objtmptbl 53 568
(0x700060) cbs:'ocbs'.objtmptbl 53 568
(0x8000a0) cbs:'ocbs'.objtmptbl 53 568
(0x900160) cbs:'ocbs'.objtmptbl 53 568
(0xa00180) cbs:'ocbs'.objtmptbl 53 568
The customer want to know why 2) doesn't display the "User-created Temp
tables",it's a difficult question for me.