BUG NO.

COMPONENT

DESCRIPTION

172832

DBATOOLS - DBEXPORT

DBSCHEMA & DBEXPORT DO OUTPUT IN TABLE ORDER, DISREGARDING DEPENDENCIES BETWEEN THE TABLES; DBIMPORT (FOR INSTANCE) THEN FAILS ON THAT DATA

171517

ONLINE -  

DOC:PERFORMANCE GUIDE SHOULD MENTION THAT CHANGES OF VARCHAR COLUMNS ARE NOT DONE USING THE IN-PLACE ALTER MECHANISM

172461

ONLINE -  

INCONSISTENT BEHAVIOUR WHEN PASSING NCHAR INTO A PROCEDURE DEFINED AS CHAR SOMETIMES WORKS SOMETIMES FAILS WITH -674

172850

ONLINE -  

HEURISTICALLY ROLLED BACK GLOBAL TRANSACTION DOES NOT RELEASE RESOURCES UNTIL XA_FORGET IS CALLED

171093

ONLINE - BELIB

STACK TRACE OF A RUNNING THREAD IS NOT SUPPORTED YET WHEN RUNNING ONSTAT -G STK LIGHT OR ONSTAT -G STK ALL.

171215

ONLINE - BELIB

MT_SHM_MEMID ALLOWS ILLEGAL MEMORY REFERENCES TO SUBMERGE WITHOUT TRACE; THIS IS LIKE PLAYING RUSSIAN ROULETTE WITH SEGV'S, LEAKS, ETC.

172105

ONLINE - BELIB

WITH MANY CPUS AND CLIENT SORTS AND DISCONNECTS EXCESS TIME SPENT IN SEARCH_BITMAP

170916

ONLINE - CDR

CDR GROUPER COMPRESSION DOES NOT RESPOND TO 'CDR STOP'

167976

ONLINE - FRGM-DML

FRAGMENT ELIMINATION DOES NOT WORK FOR OUTER JOIN WHEN COLUMN IN OUTER TABLE IS ONLY IMPLICITLY SET TO A VALUE BY JOIN CLAUSE

171603

ONLINE - GENLIB

FLOATING POINT DIVISION WITH INTEGER MULTIPLICATION OVERWRITING STACK

169452

ONLINE - HDR

ALLOW SELECTS AGAINST COMPLEX TYPES ON HDR SECONDARY BEFORE THEY ARE DEFINED ON THE PRIMARY.

172355

ONLINE - HDR

-242 -106 ERROR RETURNED CREATING (FOREIGN KEY CONSTRAINT WITH LOCK MODE WAIT SET ON PRIMARY SERVER OF HDR PAIR.

172421

ONLINE - HDR

SECONDARY IN HDR PAIR CAN FAIL WITH PHYSICAL LOG FILE OVERFLOW. PLOG_OVERFLOW_PATH IGNORED. RESTART OF HDR REQUIRED.

172651

ONLINE - JAVA

A VAGUE ERROR MESSAGE IS RETURNED WHEN INSTALL_JAR CANNOT INSTALL JAR INTO DEFAULT SBSPACE

172844

ONLINE - JAVA

SELECT WITH LVARCHAR CAUSES EURO SYMBOL TO BE DISPLAYED INCORRECTLY WHEN USING KRAKATOA

172659

ONLINE - PARSER

SQLCODE -201 WHILE ATTEMPTING TO CREATE LARGE STORED PROCEDURE.

115066

ONLINE - RSAM

SYSTEM WITH LARGE NUMBER OF TABLES CAN CONSUME LARGE AMOUNTS OF MEMORY IN THE RSAM POOL

165801

ONLINE - RSAM

READING BUFFERS FROM A TABLE THAT IS IN MEMORY REQUIRES READ AHEADS WHICH IS INEFFICIENT

168136

ONLINE - RSAM

ALTER FRAGMENT DETACH ON THE FIRST FRAGMENT LISTED IN FRAGMENT CLAUSE LOCKS ALL OTHER FRAGMENT'S BLOBS WHILE ALL OTHERS ONLY LOCK THEIR BLOBS

168698

ONLINE - RSAM

BUFFER QUEUE ALLOCATIONS INCLUDE SIZEOF(QBUF_T) EVEN IF THEY ARE HANDLING REGULAR PAGES THIS LEADS TO HOLES IN MEMORY POOL

170714

ONLINE - RSAM

ROWALTER:PTOTYPECHG: RVALDATA FOR CONVERSION FROM THE OLDTYPE 0X2 TO NEWTYPE 0X0 RETURNED 0XFFFFFB49

171508

ONLINE - RSAM

SET LOCK MODE TO WAIT DON'T WAIT FOR ALL STATEMENTS.

171955

ONLINE - RSAM

DROP INDEX ONLINE BLOCKS THE SERVER IF THE TABLE IS LOCKED BY A CURSOR WITH HOLD

172047

ONLINE - RSAM

NEXT SIZE OF PARTITION IS DOUBLED ALTHOUGH ONLY SMALL EXTENTS WERE ALLOCATED

172332

ONLINE - RSAM

TEMP TABLE'S SBLOBS NOT CLEANED UP AT ENGINE START

172555

ONLINE - RSAM

ARCINFO LOG RECORDS GET SAME TXID AS EXISTING OPEN TX DURING FAST RECOVERY

172739

ONLINE - RSAM

PHYSIO() FUNC SHOULD PROVIDE A BIT MORE DIAGNOSTICS IN CASE OF BAD REQUEST

170856

ONLINE - RTREE

SELDATABASES SHOULD WRITE ERRORS TO STDERR -> CONRTREE.SH SHOULD HANDLE THEM APPROPRIATELY

171382

ONLINE - SLOB

UNABLE TO DROP BIG CHUNK FROM A SBSPACE

172626

ONLINE - SLOB

WHEN CDR SPOOLS THE TXN TO THE SBLOB, THE ENGINE ASSERT FAILS WITH THE MESSAGE "MUTEX HOLDER VALUE IS NOT NULL"

172828

ONLINE - SLOB

ARCHIVE OF SBLOBS CAN FAIL WITH I/O FAILURE WHEN SBLOB CHUNK IS A RAW DEVICE

161362

ONLINE - SQL

QUERY WITH EXISTS SUBQUERY RETURNS INCORRECT NUMBER OF ROWS WHEN SUBQUERY FLATTENING IS TURNED ON

163386

ONLINE - SQL

WHEN LVARCHAR IS USED AS A COLUMN TYPE, A WARNING OR ERROR SHOULD BE GENERATED WHEN THE SPECIFIED SIZE EXCEEDS 2048 IN 9.40

163632

ONLINE - SQL

IN VTS & ETX, THE MAPPING OF LOCAL VARIABLES "RETURNTYPE" IS BROKEN IF MORE THAN ONE CONTAINS CLAUSE IN A SELECT

166452

ONLINE - SQL

CURSOR WITH HOLD WITH SECONDARY QUERY WHICH USES A FOR READ ONLY CLAUSE SHOULD PERMIT THE USE OF PDQ IN THE SECONDARY QUERY

166543

ONLINE - SQL

EXCESSIVE SPIN LOCK WAITS DUE TO POOL CREATION ON EACH OPTIMIZER CALL !SAP!

166897

ONLINE - SQL

SELECT FROM A VIEW FOR REMOTE TABLES FAILS WITH 874 ERROR AND ASSERT FAILED: EXCEPTION CAUGHT. TYPE: MT_EX_OS, CONTEXT: MEM

168581

ONLINE - SQL

SELECT ON A TABLE GENERATES -874 AND ASSERT FAIL IN THE OPTIMIZER

170829

ONLINE - SQL

ERROR 640 WHEN RUNNING SPL WITH ENV VARIABLE NO_SUBQF AND THE UPDATE STATISTICS FOR PROCEDURE WITHOUT NO_SUBQF

170913

ONLINE - SQL

SELECT QUERY ON SYSTEM CATALOG TABLES WITH SUBSELECTS RETURNS FALSE RESULT.

170973

ONLINE - SQL

UPDATE THROUGH A VIEW WITH A SUBQUERY IN THE WHERE CLAUSE CRASHES THE SERVER IF PDQ IS USED

170988

ONLINE - SQL

ERROR 346/111 UPDATING A TABLE WITH AN INDEX USING CURRENT OF

171115

ONLINE - SQL

ENGINE CRASH AFTER CREATE AN INDEX IN A TEMP TABLE USING PREPARED STATEMENTS

171124

ONLINE - SQL

INSTALLATION OF 9.4 CREATES FILES OR DIRECTORIES MAKING IT VERY DIFFICULT TO IMPLEMENT HA VIAS USE OF PRODUCTS LIKE HACMP

171279

ONLINE - SQL

ASSERT FAILURES IN FUNCTION OPFINDEQCOL WHEN THE OPTIMIZER MUST CHOOSE BETWEEN A DATE (BTREE) INDEX OR A GEODETIC (RTREE) INDEX

171569

ONLINE - SQL

CREATE VIEW CAN CAUSE SEGV IN DECRREFCOUNT WHEN DD CACHE LIMITS ARE REACHED

171969

ONLINE - SQL

UPDATING DIFFERENT COLUMNS IN A SINGLE ROW WITH TWO (OR MORE) UPDATE CURSORS WITHIN AN APPLICATION IS NOT BEHAVING AS EXPECTED, LAST UPDATE WINS

171998

ONLINE - SQL

SELECT OWNER FROM SYSTABLES WHERE TABNAME = ' VERSION' RETURNS 9.50C1 , SHOULD BE 10.00C1

172167

ONLINE - SQL

ADDS EXTRA SPACE TO THE RESULT COLUMNS.

172359

ONLINE - SQL

INDEX CORRUPTION AFTER CREATE INDEX ON FRAGMENTED TABLE WITH CONCURRENT INSERTS

172520

ONLINE - SQL

ERROR 565 / 111 FROM A SPL WITH A CURSOR WHEN AN EXCEPTION OCCURS

172554

ONLINE - SQL

TRYING TO GET THE CURRENT VALUE OF A SEQUENCE RETURNS INSTEAD THE NEXT VALUE IN CASE OF AN PREPARED STATEMENT

172682

ONLINE - SQL

ENGINE CRASHES WHEN RUNNING A SELECT STATEMENT WITH 'ORDER BY' ON A TABLE THAT CONTAINS A COLUMN CALLED 'CARDINALITY', WHICH IS A RESERVED WORD.

172729

ONLINE - SQL

FUNCTION RETURNING 1 BOOLEAN AND AT LEAST 1 OTHER VALUE DOES NOT REPORT ERROR 9635 AND RETURN INCORRECT RESULTS

172800

ONLINE - SQL

MKROWID() FUNCTION CAN NOT HANDLE LOADS IN PARALLEL, AND RESULTS IN ERROR 239 AND ERROR 100.

172896

ONLINE - SQL

UPDATE TRIGGER FIRED TWICE WHEN INDEX IS PRESENT ON ANOTHER COLUMN(S) AND OPTCOMPIND IS 0

172900

ONLINE - SQL

VERY SLOW GRANT STATEMENTS ON 10.0/9.40 COMPARED TO 7.31

172384

ONLINE - SQL-DDL

CAST ERROR IN STORED PROC GIVES -800 MSG, RESULTS IN DEFECTIVE ENTRY IN SD_CTCAST CACHE, BREAKS ROLLBACK, PUTS JUNK IN LOGICAL LOGS

126859

ONLINE - SQL-DML

UPPER FUNCTION CANNOT BE USED IN A FUNCTIONAL INDEX

164036

ONLINE - SQL-SPL

FETCH FROM SPL FOREACH CURSOR CLOSED BY COMMIT DOESN'T RAISE AN EXCEPTION

171813

ONLINE - SQL-SPL

RUNNING A STORED PROCEDURE WITH COLUMN AS PART OF CASE CONDITION AND PART OF WHERE CONDITION OF SUBQUERY IN CASE RETURNS 722 AND AF

164860

ONLINE - SQOPTIM

SPECIFIC QUERIES HAVING SUBQUERIES WITH EXISTS CLAUSE RETURNS INCORRECT NUMBER OF ROWS AFTER RUNNING UPDATE STATISTICS (LOW, MEDIUM, OR HIGH)

171867

ONLINE - SQOPTIM

SELECT WITH NVL (..) != NVL (..) IN THE WHERE CLAUSE GIVES ERROR 874 AND ASSERT FAILES IN THE OPTIMIZER WHEN "SET EXPLAIN ON" IS SET

172548

ONLINE - SQOPTIM

874 AND AF IN FUNCTION OPINIT WHEN ALTERING A TABLE.

166866

ONLINE - UDR

CAST FUNCTION SEND WRONG DATA TYPE TO AN EXTERNAL UDR

171512

ONLINE - UDT

CREATE DISTINCT TYPE VARCHAR W/RESERVE, FOLLOWED BY DROP CAST, THEN BY CREATE IMPLICIT CAST, GIVES 9928 ERROR (DROP CAST SUPPOSED TO PREVENT THAT)

171933

ONUTILS - ONBAR

DURING LOGICAL RESTORE WE ARE NOT USING THE PHYSICAL LOG EXTENSION FEATURE

171947

ONUTILS - ONPLOAD

ONPLOAD OR IPLOAD CANNOT LOAD TABLES, PRODUCE ERROR 23197 WHEN DATABASE IS NOT CREATED WITH DEFAULT LOCALES, DBNLS=1 AND A PIPE IS USED AS DEVICES

172125

ONUTILS - ONPLOAD

HPL LOAD JOB FAILS WITH ERROR 271 ISAM 100 WHEN LOADING FROM MULTILPLE DATA FILES

172190

ONUTILS - ONPLOAD

HPL ERRORS WITH SQLCODE 271 ISAM 151 WHEN LOADING MAINFRAME NULLS (\0) INTO A VARCHAR COLUMN IN DELUXE MODE ONLY

172460

ONUTILS - ONPLOAD

ONPLOAD IGNORES THE COMMIT INTERVAL WHEN LOADING INTO ANSI DATABASES

172652

ONUTILS - ONSPACES

ONSPACES SHOULD NOT ALLOW CREATION OF SBSPACE WITH CONFLICTING/INCORRECT FLAGS.

172986

ONUTILS - ONSTAT

ONSTAT -G SRC LEADS TO CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION.

BUG NO.

COMPONENT

DESCRIPTION

171666

BACKEND - SQL

STORED PROCEDURE WITH UPDATE WITHIN BEGIN / END STATEMENT AND COMPARING LOCAL INT WITH REMOTE SMALLINT IN SUBQUERY AFS / -564 -172

172767

BACKEND - SQOPTIM

WHEN VIEW CREATED WHICH USES UDR TO RETURN COLUMN, THE RESULTS ARE DIFFERENT IN 9.4 VERSUS 9.3

170842

DBACCESS -  

WINDOWS: CAN'T LOAD DATA INTO LVARCHAR COLUMN IF THE VALUE CONTAINS RECORD SEPARATORS CODED AS 0X0D0A

172236

DBACCESS - SQLI

SYNTAX ERROR -201 DETECTED WHILE CREATING STORED PROCEDURES WHEN TWO CONSECUTIVES {

172015

DBATOOLS -  

VIRTUAL TABLE APPEAR AS AN ORDINARY TABLE FROM DBSCHEMA OR DBEXPORT

171269

DBATOOLS - DBLOAD

DBLOAD FAILS WITH "IT IS NOT POSSIBLE TO CONVERT BETWEEN THE SPECIFIED TYPES." WHEN LOADING BOOLEAN DATA TYPES.

167596

DBATOOLS - DBSCHEMA

DBSCHEMA TOO SLOW TO EXTRACT INDEX DEFINITIONS

171514

DBATOOLS - DBSCHEMA

DBSCHEMA ERRORS IN IMPLICIT CASTS; DATETIME, VARCHAR, DECIMAL, (LIKELY MONEY) NOT QUALIFIED. EXCESSIVE BLANK LINES OUTPUT FROM DBSCHEMA.

172004

DBATOOLS - DBSCHEMA

IF DBSCHEMA HITS A STORED PROC IT CAN'T PARSE, IT EXITS PREMATURELY WITH INSUFFICIENT CLUE AS TO WHY IT FAILED

171509

ONLINE -  

DROPPING A NON-EXISTING SEQUENCE WITH THE SAME NAME AS AN EXISTING TABLE CRASHES THE INSTANCE

171609

ONLINE -  

ALTER TABLE NEXT SIZE SETS PN_NXTSIZE TO A VALUE WHICH IS NOT A MULTIPLE OF DBSPACE PAGE SIZE

172407

ONLINE -  

CORRUPTION IN A VARCHAR COLUMN WHEN USING DBEXPORT -X / DBIMPORT -X WITH A GLS CONVERSION

172778

ONLINE -  

ENGINE ASSERT FAILES AFTER ENGINE DYNAMICALY ALLOCATES LOCKS

172181

ONLINE - ARCHECKR

ARCHECKER RETURNS MISLEADING ERROR MESSAGE LIKE "ERROR: BAD EXTENT NUMBER 0 -- ONLY 0 EXTENTS." WITH IN-PLACE ALTER TABLE PARTITION PAGES

172251

ONLINE - ARCHECKR

ARCHECKER TLR SHOULD GIVE A MORE INFORMATIVE ERROR MESSAGE ON THE CONSOLE IF IT CANNOT CONNECT TO THE DATABASE SERVER

168609

ONLINE - ASF

ENGINE CAN GET STUCK IN LONG TRANSACTION WITH A SESSION IN LONG TX AND IS WAITING ON A REMOTE INSTANCE

163620

ONLINE - BELIB

SET RESIDENT -1 IN ONCONFIG START SERVER RUN ONMODE -A VALUE RETURNS ERROR SHMCTL: ERRNO=1 SHARED MEMORY SEGMENT VALUE COULD NOT BE FORCED RESIDENT

171836

ONLINE - BELIB

ADM VP CAN SEGV IN SCAN_CHILD_LIST WHILE ATTEMPTING TO PROCESS THE CHILD LIST UNDER CERTAIN CONDITIONS

172305

ONLINE - BELIB

RUNNING SQL QUERY TWICE AGAINST SYSMASTER TABLES CRASHES ENGINE IN NXTPOOL (IDS 10.0 ONLY) MAY NEED TO BE RUN MORE THAN TWICE

170965

ONLINE - CDR

INEXPLICABLY HIGH DEADLOCK NUMBERS DUE TO FIX FOR PTS# 164116 - PUTTING ORDINARY LOCKS ON ER TRANSACTIONS

171506

ONLINE - CDR

NEITHER 'CDR START' NOR 'CDR STOP' WORKING IF CDRSTATE CONTAINS UNEXPECTED STATE VALUE

171994

ONLINE - CDR

CDR: STILL TRANSACTIONS APPLIED OUT OF ORDER TXH CDR:6 (ERROR: UPDATE ABORTED, ROW DOES NOT EXIST IN TARGET TABLE) / SQL:0 / ISAM:0

171997

ONLINE - CDR

CDR: DATASYNC THREAD CDRD_X MAY CRASH IN RMIRAISESHAREDLOCKS() AFTER TRANSACTION HAS BEEN ABORTED

172269

ONLINE - CDR

DATASYNC CAN SKIP "TXN DELETION PROCESS"(IS. CALL TO RMDELETEMSG()) EVENTHOUGH IT HAS PERFORMED "POST PROCESSING" AFTER COMMIT/ABORT.

152302

ONLINE - FRAGM

ON ROUND ROBIN FRAGMENTED TABLE, INSERTION FAILS WITH ERROR 271/164 IF ONE OF THE FRAGMENT DBSPACE IF FULL AND TABLE HAS PARTITION BLOBS

171934

ONLINE - FRAGM

RECREATING INDEX FRAGMENTATION CAN CAUSE PARALLEL DDL ON SAME TABLE TO CRASH IN FMFINDFRAG

164091

ONLINE - HDR

MOVING AN HDR SECONDARY TO STANDARD, BACKING UP, THEN TO PRIMARY, THEN ATTEMPTING TO RESTART HDR ON THE OLD PRIMARY FAILS WITH DR_DEBUG_ERR = -20

169631

ONLINE - HDR

DRNODE SET TO -1 AFTER UPGRADE TO 9.40 FROM 9.30 AND ARCHIVE IS TAKEN

169709

ONLINE - HDR

ONTAPE -P ON HDR ASKS FOR LEVEL 1 BACKUP AFTER A LEVEL 0 RESTORE. BUT SECONDARY SERVER CANNOT RESTORE ANY NON LEVEL-0 ARCHIVE