Is there a way, or are there ways (GUI + command line/SQL API) to turn
off AUS?

In sysadmin.ph_task set the column tk_enable to 'f'alse for all of the
records with tk_group = 'PERFORMANCE' AND tk_name matches 'Auto Update
Statistics*'

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.



On Thu, Jun 11, 2009 at 11:17 AM, red_valsen (AT) yahoo (DOT) com <red_valsen (AT) yahoo (DOT) com

red_valsen (AT) yahoo (DOT) com schrieb:
Hi,

as I am testing IDS11.50.UC4 in the virtual appliance, where
OAT is preistalled, I did what Art just posted and also
was able switch it off and on using the OAT, tab 'schedules'

Art's approach is the better one, as I cannot see
me using OAT in a customer environment, which is under
security auditing.
So far I could not find any logging of what was done using OAT,
'inside OAT' or near it (that is: on the front end).
Of course one can enable auditing for the sysadmin db
But I am not finished with my exploring & testing.

But if you use a shell script to run your updates on the
sysadmin database, it is easy to log what was done when
and even why.

And as I described in the previous post, it is sufficient
to bypass the startup of dbScheduler and dbWorker threads by
creating a file named 'stop' in directory
$INFORMIXDIR/etc/sysadmin and there will be no automatic
update statistic.

dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe

I am currently running IDS 10.00.FC8 on AIX 5.30 TL10 and I am attempting to upgrade Informix. I have resolved all of the in place alter issues and after installing the engine and bringing 11.50.FC4 up, it converts all of the partition headers just fine and then moves to my first database named CLASS. I get this failure:

10:08:50 processing class
10:08:50 Converting database class ...
10:09:07 Execution of the following statement failed. If you are
currently in conversion, you may have to restore
from level 0 archive, take corrective action and then
restart conversion.
10:09:07 create AGGREGATE informix.genxmlelem
with (
INIT = init_aggrelem,
ITER = iter_aggrelem,
COMBINE = comb_aggrelem,
FINAL = final_aggrelem,
HANDLESNULLS
);
10:09:07 Conversion failed with SQLCODE = -9400 ISAMCODE = 0
10:09:07 The conversion of the database class has failed.
10:09:07 Conv/rev: Failed to convert component SQL to component version 29
10:09:07 Conversion failed for component SQL : entity_ver 29 != target version 31
10:09:07 Assert Failed: Conv/rev: Failed to convert for component SQL
10:09:07 IBM Informix Dynamic Server Version 11.50.FC4X1
10:09:07 Who: Session(8, informix@ibm171, 0, 7000000206246c0)
Thread(28, convert, 7000000205e6a98, 1)
File: framework.c Line: 673
10:09:07 Results: Dynamic Server must abort
10:09:07 Action: Restart conversion after fixing the problem.
10:09:07 stack trace for pid 176492 written to /wic/scratch/af.4046e03
10:09:07 See Also: /wic/scratch/af.4046e03
10:09:10 framework.c, line 673, thread 28, proc id 176492, Conv/rev: Failed to convert for component SQL.
10:09:14 The Master Daemon Died
10:09:15 PANIC: Attempting to bring system down

The version 10 database had the genxml blade installed into it. Prior to the upgrade I ran the genxml_d.sql script to uninstall it, but apparently, it does not clean up after itself very well. My question is , how would I identify all of the AGGREGATES that I would need to look for to make sure that were deleted prior to starting this upgrade over again?

Joe Plugge

Ok, Actually found the system table, SYSAGGREGATES ... my question is why doesn't the genxml_d.sql clean them up properly then?

From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of Plugge, Joe R.
Sent: Wednesday, July 01, 2009 9:17 AM
To: informix-list (AT) iiug (DOT) org
Subject: Problem upgrading from IDS10.00.FC8 to IDS11.50.FC4

I am currently running IDS 10.00.FC8 on AIX 5.30 TL10 and I am attempting to upgrade Informix. I have resolved all of the in place alter issues and after installing the engine and bringing 11.50.FC4 up, it converts all of the partition headers just fine and then moves to my first database named CLASS. I get this failure:

10:08:50 processing class
10:08:50 Converting database class ...
10:09:07 Execution of the following statement failed. If you are
currently in conversion, you may have to restore
from level 0 archive, take corrective action and then
restart conversion.
10:09:07 create AGGREGATE informix.genxmlelem
with (
INIT = init_aggrelem,
ITER = iter_aggrelem,
COMBINE = comb_aggrelem,
FINAL = final_aggrelem,
HANDLESNULLS
);
10:09:07 Conversion failed with SQLCODE = -9400 ISAMCODE = 0
10:09:07 The conversion of the database class has failed.
10:09:07 Conv/rev: Failed to convert component SQL to component version 29
10:09:07 Conversion failed for component SQL : entity_ver 29 != target version 31
10:09:07 Assert Failed: Conv/rev: Failed to convert for component SQL
10:09:07 IBM Informix Dynamic Server Version 11.50.FC4X1
10:09:07 Who: Session(8, informix@ibm171, 0, 7000000206246c0)
Thread(28, convert, 7000000205e6a98, 1)
File: framework.c Line: 673
10:09:07 Results: Dynamic Server must abort
10:09:07 Action: Restart conversion after fixing the problem.
10:09:07 stack trace for pid 176492 written to /wic/scratch/af.4046e03
10:09:07 See Also: /wic/scratch/af.4046e03
10:09:10 framework.c, line 673, thread 28, proc id 176492, Conv/rev: Failed to convert for component SQL.
10:09:14 The Master Daemon Died
10:09:15 PANIC: Attempting to bring system down

The version 10 database had the genxml blade installed into it. Prior to the upgrade I ran the genxml_d.sql script to uninstall it, but apparently, it does not clean up after itself very well. My question is , how would I identify all of the AGGREGATES that I would need to look for to make sure that were deleted prior to starting this upgrade over again?

Joe Plugge