Re: SeqScans Statistics 7.3_uc6
Hi Matt, SIEBEL problem seems to be corrected in 7.30.UC7. What was the result of setting NO_SUBQF? David... BUGS FIXED IN 7.30.UC7 AS OF 1999-02-09 Number Submitter Entry Date Product Component/Version Class [84894][darrend ][11/19/1997][ONLINE ][EX ][ ][SW ] --------------------------------------------------- Short Description --------- [MGM ACTIVE/READY QUEUE BECOMES CORRUPT ON BUSY SYSTEM. THIS CAUSES THE ] [ONSTAT -G MGM OUTPUT TO BE GARBAGE BUT COULD ALSO CAUSE SEGV/BUS ERROR. ] Number Submitter Entry Date Product Component/Version Class [89957][kns ][02/17/1998][ONLINE ][HDR ][ ][SW ] --------------------------------------------------- Short Description --------- [LEGACY: SECONDARY FAILS DURING INDEX RECOVERY AFTER BECOMING READ ONLY.MA-S] [S. ] Number Submitter Entry Date Product Component/Version Class [90520][dwood ][02/25/1998][ONLINE ][RSAM ][ ][SW ] --------------------------------------------------- Short Description --------- [ENGINE HUNG ON CHECKPOINT: ARCBACKUP WAITING ON CHECKPOINT WHILE IN CRITICA] [L SECTION. ] Number Submitter Entry Date Product Component/Version Class [91404][dietmarw ][03/14/1998][BACKEND ][FRGM-DML][ ][SW ] --------------------------------------------------- Short Description --------- [SELECT ... FOR UPDATE IN KEY-FIRST CASE DOES NOT LOCK ROW BEFORE EVALUATING] [ KEY-FIRST FILTER IF INDEX IS DETACHED ] Number Submitter Entry Date Product Component/Version Class [91480][vijayg ][03/17/1998][ONUTILS ][ONBAR ][ ][SW ] --------------------------------------------------- Short Description --------- [ONBAR HANGS IN A CALL TO SQL_API_DISCONNECT(). THIS PROB IS SEEN WHEN DOIN] [G A LOG BACKUP WITH A BLOBSPACE DOWN. ] Number Submitter Entry Date Product Component/Version Class [91857][dietmarw ][03/25/1998][ONLINE ][SQL-DML ][ ][SW ] --------------------------------------------------- Short Description --------- [IN CASE OF SELECT ... FOR UPDATE AND KEY-FIRST FILTER U-LOCK IS NOT RELEASE] [D AT SUBSEQUENT FETCH AND FOR SOME NON-QUALIFYING ROWS (DATA FILTER) ] Number Submitter Entry Date Product Component/Version Class [92360][donh ][04/03/1998][ONUTILS ][ONPLOAD ][ ][SW ] --------------------------------------------------- Short Description --------- [HPLOAD UNLOAD JOB TO AN UNBUFFERED/BUFFERED LOGGING DATABASE WITH A WHERE C] [LAUSE THAT SPECIFIES 2 DIGIT YEAR UNLOADS ALL ROWS. 4 DIGIT YEAR WORKS. ] Number Submitter Entry Date Product Component/Version Class [95999][umuta ][06/17/1998][ONUTILS ][ONCHECK ][ ][SW ] --------------------------------------------------- Short Description --------- [ONCHECK -PT : HANGS IF THE ENGINE IS CONFIGURED AS TO RUN ] [ON A MULTIPROCESSOR COMPUTER. ] Number Submitter Entry Date Product Component/Version Class [96072][rwei ][06/18/1998][ONLINE ][MSGLIB ][ ][SW ] --------------------------------------------------- Short Description --------- [SERVER DOES NOT WRITE DAY/DATE/TIME/YEAR INTO MESSAGE LOG FILE IF SERVER ] [IS BROUGHT UP ON JANUARY FIRST IN ANY YEAR. BUG FOUND BY Y2000 TESTING. ] Number Submitter Entry Date Product Component/Version Class [97544][peterb ][07/21/1998][ONLINE ][SQL-DML ][ ][SW ] --------------------------------------------------- Short Description --------- [USING AN UPDATE CURSOR WHERE THERE IS AN IN-CLAUSE IN THE CURSOR DECLARATIO] [N YOU GET ERROR 290. ] Number Submitter Entry Date Product Component/Version Class [97885][holgerk ][07/28/1998][ONLINE ][SQL-DML ][ ][SW ] --------------------------------------------------- Short Description --------- [COMPLEX QUERY WITH CORRELATED SUBQUERY BASED ON A VIEW RESULTS IN WRONG ] [RESULTS -- SYSTEM HUNG OR SEGV -- DEPENDING ON QUERY AND ONLINE VERSION ] Number Submitter Entry Date Product Component/Version Class [98235][dwood ][08/04/1998][ONLINE ][SQL-SPL ][ ][SW ] --------------------------------------------------- Short Description --------- [ENGINE CRASH EXECUTING STORED PROCEDURE HAVING A SELECT AGGREGATE WHEN THE ] [STORE PROCEDURE PLAN WAS SAVED WITH PDQPRIORITY > 1 ] Number Submitter Entry Date Product Component/Version Class [98437][tomas ][08/06/1998][ONLINE ][BELIB ][ ][SW ] --------------------------------------------------- Short Description --------- [IT TAKES TOO LONG TO CONNECT FROM ONLINE 5 TO IDS 7.2 WHEN MAKING A LARGE ] [NUMBER OF CONNECTIONS ] Number Submitter Entry Date Product Component/Version Class [98475][bobw ][08/07/1998][ONLINE ][HDR ][ ][SW ] --------------------------------------------------- Short Description --------- [INITTING HDR USING PARALLEL BACKUP CAN CAUSE LOG RECORDS TO BE REPLAYED AND] [ CAUSE HDR TO FAIL ] Number Submitter Entry Date Product Component/Version Class [98789][priti ][08/13/1998][ONLINE ][BELIB ][ ][SW ] --------------------------------------------------- Short Description --------- [EXISTING IMPLEMENTATION OF KAIO WON'T WORK ON 6.5 UNDER STRESS CONDITIONS. ] [ ] Number Submitter Entry Date Product Component/Version Class [98884][simonr ][08/17/1998][ONLINE ][RSAM ][ ][SW ] --------------------------------------------------- Short Description --------- [SIGN EXTENSION OF PARTN->PN_FLAGS CAUSES INDEXES TO NOT BE UPDATED WHEN DEL] [ETING ROWS AFTER A LIGHT APPEND OPERATION. ] Number Submitter Entry Date Product Component/Version Class [99075][keithg ][08/20/1998][ONLINE ][SQOPTIM ][ ][SW ] --------------------------------------------------- Short Description --------- [SELECT VARCHAR CONTAINING A DECIMAL VALUE AFTER UPDATE STATISTICS MED/HIGH ] [W/DISTRIBUTIONS RETURNS A -1213 ERROR. ] Number Submitter Entry Date Product Component/Version Class [99153][steffenh ][08/21/1998][ONLINE ][BELIB ][ ][SW ] --------------------------------------------------- Short Description --------- [ONSTAT -Z CAN CRASH SERVER IN DOSPINLOCK() ] [ ] Number Submitter Entry Date Product Component/Version Class [100371][ravia ][09/18/1998][ONLINE ][SQL-SPL ][ ][SW ] --------------------------------------------------- Short Description --------- [ENGINE CRASHES IN THE MIDDLE OF EXECUTING STORED PROCEDURES - MEMORY ] [CORRUPTION ] Number Submitter Entry Date Product
David Andrieu wrote: > > Hi Matt, > > SIEBEL problem seems to be corrected in 7.30.UC7. > What was the result of setting NO_SUBQF? > > David... Select's and Update's with correlated subqueries are run the old-fashioned way: First the subquery is executed then the rest of the statement. It's done this way: NO_SUBQF=1; export NO_SUBQF $INFORMIXDIR/bin/oninit hth martin