Estimate compression UGH
Mike ran EXECUTE FUNCTION task("table estimate_compression", "agent", "policy2007", "informix") on 11.50.UC6 (Solaris 10) and got "No such table" errors in the online log, even though oncheck -pt showed the table existed and the syntax matched the manual. Another user reported the same misleading error on 11.50.FC7 (but not FC6W1), initially guessing the table was already compressed — which Mike confirmed it wasn't. IBM's John Miller noted a known confusion when a table and an index share the same name. No confirmed fix; Mike said he'd open a PMR.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
11.50.UC6W2X4
Solaris 10
I am on a roll today...
I am trying to run the following:
dbaccess sysadmin;
EXECUTE FUNCTION task
("table estimate_compression", "agent", "policy2007", "informix");
Getting:
(expression) FAILED: table estimate_compression policy2007:informix.agent
Online log says:
13:38:17 SCHAPI ERROR: validate policy2007:informix.agent failed
13:38:17 SCHAPI ERROR:policy2007:informix.agent-No such table
13:38:17 SCHAPI ERROR: table estimate_compression policy2007:informix.agent
failed.
BUT...
oncheck -pt policy2007:informix.agent
TBLspace Report for policy2007:informix.agent
Physical Address 238:1023277
Creation date 09/11/2010 21:12:32
TBLspace Flags 8801 Page Locking
TBLspace use 4 bit bit-maps
Maximum row size 344
Number of special columns 0
Number of keys 1
Number of extents 1
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 2
First extent size 290098
Next extent size 58020
Number of pages allocated 290098
Number of pages used 287197
Number of data pages 255232
...
WTF? Throw a maunal at me - but tell me what page as I have looked everywhere.
I even ran the 'enable compression' stmt after getting the error. Baffled.
MM
Hello.
I think your command syntax is incorrect.
Follow the official document:
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.admin.doc/id
s_admin_1246.htm?resultof=%22%65%73%74%69%6d%61%74%65%22%20%22%63%6f%6d%70%72%65
%73%73%69%6f%6e%22%20
Best regards.
Em 13/09/2010 14:43, MIKE MAGIE escreveu:
> 11.50.UC6W2X4
> Solaris 10
>
> I am on a roll today...
>
> I am trying to run the following:
>
> dbaccess sysadmin;
> EXECUTE FUNCTION task
> ("table estimate_compression", "agent", "policy2007", "informix");>
> Getting:
>
> (expression) FAILED: table estimate_compression policy2007:informix.agent
>
> Online log says:
>
> 13:38:17 SCHAPI ERROR: validate policy2007:informix.agent failed
> 13:38:17 SCHAPI ERROR:policy2007:informix.agent-No such table
> 13:38:17 SCHAPI ERROR: table estimate_compression policy2007:informix.agent
> failed.
>
> BUT...
>
> oncheck -pt policy2007:informix.agent>
> TBLspace Report for policy2007:informix.agent
>
> Physical Address 238:1023277
>
> Creation date 09/11/2010 21:12:32
>
> TBLspace Flags 8801 Page Locking
>
> TBLspace use 4 bit bit-maps
>
> Maximum row size 344
>
> Number of special columns 0
>
> Number of keys 1
>
> Number of extents 1
>
> Current serial value 1
>
> Current SERIAL8 value 1
>
> Current BIGSERIAL value 1
>
> Current REFID value 1
>
> Pagesize (k) 2
>
> First extent size 290098
>
> Next extent size 58020
>
> Number of pages allocated 290098
>
> Number of pages used 287197
>
> Number of data pages 255232
> ....
>
> WTF? Throw a maunal at me - but tell me what page as I have looked
everywhere.
> I even ran the 'enable compression' stmt after getting the error. Baffled.
>
> MM
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Informix Dynamic Server Certified Professional V10 / V11
And what part would be wrong? From the doc:
EXECUTE FUNCTION task
(table estimate_compression", table_name, database_name, owner_name);
My command:
EXECUTE FUNCTION task
("table estimate_compression", "agent", "policy2007", "informix");
The table is 'agent', the database is policy2007, and the owner is informix...
NEXT!
Sorry Mike,
I´ve got the same error here, if my table is already compressed, it
raises an error like yours.
Please check the oncheck -pT output, and watch if there´s a "Compressed
Data Summary" section.
I guess your table is already compressed.
But that error message is wrong, anyway. The table really exists.
If you could, open a PMR with IBM, if there isn´t already one for this
"in the oven", ok?
Best regards.
Em 13/09/2010 15:03, MIKE MAGIE escreveu:
> EXECUTE FUNCTION task
> ("table estimate_compression", "table_name", "database_name", "owner_name");>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Informix Dynamic Server Certified Professional V10 / V11
Mike,
one more thing:
Our 11.50.FC7 test instance returns that error, like yours.
But our 11.50.FC6W1 producton system does not. It displays the output,
with the "curr" column filled (table compressed).
Best regards!
Em 13/09/2010 15:38, Alexandre Marini escreveu:
> Sorry Mike,
> I´ve got the same error here, if my table is already compressed, it
> raises an error like yours.
> Please check the oncheck -pT output, and watch if there´s a "Compressed
> Data Summary" section.
>
> I guess your table is already compressed.
>
> But that error message is wrong, anyway. The table really exists.
>
> If you could, open a PMR with IBM, if there isn´t already one for this
> "in the oven", ok?
>
> Best regards.
>
> Em 13/09/2010 15:03, MIKE MAGIE escreveu:
>> EXECUTE FUNCTION task
>> ("table estimate_compression", "table_name", "database_name", "owner_name");>>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Informix Dynamic Server Certified Professional V10 / V11
Good info - I double checked, as I was sure we did not have compression enabled for any tables - and we do not. Guess I will open a pmr...
Mike: I was aware of an issue if you have the table and an index named the same it got confused. Not sure if this is your case?? John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/13/2010 02:50:44 PM: > [image removed] > > Re: Estimate compression UGH [21264] > > MIKE MAGIE > > to: > > ids > > 09/13/2010 02:51 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Good info - I double checked, as I was sure we did not have compression > enabled for any tables - and we do not. Guess I will open a pmr... > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >