|
Problem IT37052
|
Status: Closed |
"CREATE TABLE ... AS SELECT ..." NOT SETTING STATCHANGE CORRECTLY
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
STATCHANGE value in onconfig:
onstat -g cfg full STATCHANGE:
IBM Informix Dynamic Server Version 12.10.FC14 -- On-Line -- Up
00:01:31 -- 189444 Kbytes
Configuration Parameter Info
id name type maxlen units rsvd
tunable
255 STATCHANGE INT4 12 % *
min/max : 0,100
default : 10
onconfig: 10
current : 10
1.Now create table test1:
Create table test1(val1 int);
2. creating another table test1_new using test1:
create table test1_new as select * from test1;
3. Now running dbschema:
dbschema -d stores_demo -t test1_new -ss
DBSCHEMA Schema Utility INFORMIX-SQL Version 12.10.FC14
{ TABLE "informix".test1_new row size = 4 number of columns = 1
index size = 0 }
create table "informix".test1_new
(
val1 integer
) extent size 16 next size 16 lock mode page statchange 0;
revoke all on "informix".test1_new from "public" as "informix";
As you can see from dbschema output that statchange is set to 0
though in onconfig STATCHANGE is set to 10.
The same issue can be reproduced in 14.10.Fc5 too. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when *
* available). *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when *
* available). *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC7. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.05.2021
23.08.2021
23.08.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
