dostats error on procedure nvl
Hi, we uses the dostats from Art. With the Informix IDS 11.50UC3 we got the following error on the procedure nvl. # dostats -h ph450_tli -d pro_schul -p -v2 Verbose mode level 2 ENABLED.... PDQPRIORITY for table processing set to: 0. Stored Procedure processing ENABLED.... Default PDQ priority for procedures set to: 0. Standard Engine handling DISABLED... Shared Memory Connection handling DISABLED... Expanded Reporting DISABLED... Expanded Time Reporting DISABLED... Force Distributions Only DISABLED... Release 5 handling DISABLED... Statistics Levels ENABLED.... Distributions Only clauses ENABLED.... System catalog processing DISABLED... Table Name Template NOT SUPPLIED... Only Stored Procedures will be processed. Host Name SUPPLIED (ph450_tli)... Command Execution IMMEDIATE... Optimized server handling override DISABLED... Lock mode set to wait 10 seconds. Optimized server detected (IBM Informix Dynamic Server 11.50.C3). Optimizations followed. PDQPRIORITY for table processing reset to: 10% to support optimized server. Warning! Optimized servers produce statistics fastest with PSORT_NPROCS set. Warning! Optimized servers produce statistics fastest with PSORT_DBTEMP set. Warning! Optimized servers produce statistics fastest with DBUPSPACE set. Working on database: pro_schul. Procedures: ifx_load_module...SUCCESSFUL ifx_replace_module...SUCCESSFUL ... larten_k69...SUCCESSFUL md_b10...SUCCESSFUL nvl...FAILED Cannot Update statistics for procedure: nvl. SQL=-201, ISAM=0. # Version: dostats: Features Version 6.00, Source Revision: 1.163 ! A statistic update with "update statistics for procedure nvl" works without any problem. No errors/warnings in the online.log It's a potentiell problem with the database or a known problem with the dostats? Thanks, Sebastian
Add a '-f somefile' to the line and send me the file plus a dbschema/mysche=
ma output for the procedure.=20
Art=20
-----Original Message-----
From: SEBASTIAN WOLSCHKE <swolschke@googlemail.com>
Sent: Thursday, September 03, 2009 10:51 AM
To: ids@iiug.org
Subject: dostats error on procedure nvl [16851]
Hi,=20
we uses the dostats from Art.=20
With the Informix IDS 11.50UC3 we got the following error on the procedure=
=20
nvl.=20
# dostats -h ph450_tli -d pro_schul -p -v2=20
Verbose mode level 2 ENABLED....=20
PDQPRIORITY for table processing set to: 0.=20
Stored Procedure processing ENABLED....=20
Default PDQ priority for procedures set to: 0.=20
Standard Engine handling DISABLED...=20
Shared Memory Connection handling DISABLED...=20
Expanded Reporting DISABLED...=20
Expanded Time Reporting DISABLED...=20
Force Distributions Only DISABLED...=20
Release 5 handling DISABLED...=20
Statistics Levels ENABLED....=20
Distributions Only clauses ENABLED....=20
System catalog processing DISABLED...=20
Table Name Template NOT SUPPLIED...=20
Only Stored Procedures will be processed.=20
Host Name SUPPLIED (ph450_tli)...=20
Command Execution IMMEDIATE...=20
Optimized server handling override DISABLED...=20
Lock mode set to wait 10 seconds.=20
Optimized server detected (IBM Informix Dynamic Server 11.50.C3).=20
Optimizations followed.=20
PDQPRIORITY for table processing reset to: 10% to support optimized server.=
=20
Warning! Optimized servers produce statistics fastest with PSORT_NPROCS set=
.=20
Warning! Optimized servers produce statistics fastest with PSORT_DBTEMP set=
.=20
Warning! Optimized servers produce statistics fastest with DBUPSPACE set.=20
Working on database: pro_schul.=20
Procedures:=20
ifx_load_module...SUCCESSFUL=20
ifx_replace_module...SUCCESSFUL=20
....=20
larten_k69...SUCCESSFUL=20
md_b10...SUCCESSFUL=20
nvl...FAILED=20
Cannot Update statistics for procedure: nvl. SQL=3D-201, ISAM=3D0.=20
#=20
Version: dostats: Features Version 6.00, Source Revision: 1.163 !=20
A statistic update with "update statistics for procedure nvl" works without=
=20
any problem.=20
No errors/warnings in the online.log=20
It's a potentiell problem with the database or a known problem with the=20
dostats?=20
Thanks, Sebastian=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Hi Art,
dbschema -->
create procedure nvl(val nvarchar(254), rep nvarchar(254)) returningnvarchar(254);
begin
if val is not null then
return val;
else
return rep;
end if;
end
end procedure;
dostats file output( i think you dont need the whole file?) -->
....
UPDATE STATISTICS FOR PROCEDURElarten_k69(integer,integer,datetime,datetime,nvarchar);
UPDATE STATISTICS FOR PROCEDURE md_b10(integer);
UPDATE STATISTICS FOR PROCEDURE nvl(nvarchar,nvarchar);
UPDATE STATISTICS FOR PROCEDURE pd_abbereich(integer,integer);
UPDATE STATISTICS FOR PROCEDURE pd_abfehler(integer,integer);
UPDATE STATISTICS FOR PROCEDURE pd_ablauf(integer,integer);....
Thanks
Sebastian