invispix 10x10

DB2 - Solutions to problems

Here you can find, daily actualized, the list of reported problems assorted after APAR-Numbers.

Due to restrictions of the IBM APAR-Numbers (IBM DB2 Problem-Numbers) which are branded with a lock-symbol can only be seen by registered users.

Move your mouse over an APAR-Number to show the bug description in a Tooltip.

If you click on the number, the complete description will appear in a new tab.

For full text search for bug descriptions click here

Problems reported sorted by APAR number
IT37196 IF NODE FAILURE RECOVERY OCCURS AFTER END OF TRANSACTION, THE NEXT OPERATION CAN RECEIVE SQL1229
IT37190 REBIND FAILING WITH SQL0100W
IT37180 Instance may crash with sqliDumpInxCursor on the stack when dumping FODC diagnostics (-901 or trap)
IT37178 A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
IT37164 POSSIBLE TRAP IN SQLO_SLATCH_CAS64::RELEASECONFLICT WHEN CLEANING UP FEDERATED FMP
IT37160 JSON_UPDATE FUNCTION MIGHT WORK UNEXPECTEDLY.
IT37149 SYSTEM TEMP TABLESPACE CAN BE LEFT IN REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY
IT37146 SYSTEM TEMP TABLESPACE CAN BE LEFT IN REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY
IT37136 SQL1659 is not returned even when a RDMA device cannot be openedduring db2start, and db2diag.log is spammed with error messages
IT37132 SQL0180N IS RETURNED WHEN TRY TO INSERT ODBC FORMAT TIMESTAMP.
IT37130 Open error on primary log path could lead to forced database shutdown and panic
IT37126 ARRAYINDEXOUTOFBOUNDSEXCEPTION OCCURS DURING MULTITHREADED SQLJ APPLICATION PROFILE PROCESSING.
IT37114 QUERIES REFERENCING MULTIPLE IDENTICAL SCALAR SUB-QUERIES IN THESELECT LIST MAY RETURN INCORRECT RESULTS
IT37104 POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGISTER AN INVALID SERVICE CLASS ID OF 0"
IT37103 PURESCALE DELETE ROWS PERFORMANCE REGRESSION ON RDMA NETWORKS
IT37102 APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED
IT37095 DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004
IT37088 A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND.
IT37087 NX842 BACKUP AND LOG FILE COMPRESSION MIGHT FAIL
IT37084 APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED
IT37043 FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP
IT37042 IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG
IT37037 DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY
IT37034 EXECUTING A PROCEDURE AFTER TRANSFER OWNERSHIP OF SPECIFIC PROCEDURE RESULTS IN SQLCODE -551 REPORTED FOR ORIGINAL OWNER.
IT37032 IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG
IT37015 CORRECT THE HANDLING OF THE DEFERRED SYNOPSIS TUPLE ROLLBACK SCENARIO.
IT37006 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT37005 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT36961 FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP
IT36937 IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE.
IT36932 SVT CSI BLUSEL: DB2_V111M1FP1: ASSERTION: WRONG SIBLING FOR (56,0) FOUND WITH ID:0,0,0
IT36928 IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE.
IT36927 EXECUTING A PROCEDURE AFTER TRANSFER OWNERSHIP OF SPECIFIC PROCEDURE RESULTS IN SQLCODE -551 REPORTED FOR ORIGINAL OWNER.
IT36915 AN INDOUBT TRANSACTIONS MAY BE CREATED UNNECESSARILY WHEN USING AN XA TRANSACTIONS ON PURESCALE WITH A FEDERATED DATABASE
IT36903 -901 ERROR WITH REASON "NO PLAN FOUND"
IT36902 -901 ERROR WITH REASON "NO PLAN FOUND"
IT36894 "TOO MANY ARGUMENTS" MESSAGE WHEN RUNNING DB2CM -CREATE -DB IN HADR WITH PACEMAKER WITH MULTIPLE STANDBY SETUP
IT36883 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT36851 WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2.
IT36847 WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2.
IT36839 DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY
IT36834 XML NODE MANAGER THROWS -901 ERROR WHILE RUNNING MANUAL RUNSTATSON XML TABLE.
IT36825 SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK.
IT36821 SET EVENT MONITOR STATE STATEMENTS MAY BE INCORRECTLY QUEUED BY THE ADAPTIVE WORKLOAD MANAGER
IT36818 POSSIBLE DATA LOSS IF DELETE AND RUNSTATS/REORG ARE IN A SINGLE TRANSACTION AND THE TRANSACTION IS THEN ROLLEDBACK
IT36816 DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2
IT36812 Instance may crash with sqliDumpInxCursor on the stack when dumping FODC diagnostics (-901 or trap)
IT36810 FODC TRAP might occur when using UTL_MAIL module
IT36770 IMPORT MAY BE TERMINATED IF SQL0437W IS DETECTED, ALTHOUGH IT CAN BE IGNORED IN MOST SCENARIOS.
IT36769 DB2FMCD.SERVICES GETS DELETED IF THERE ARE TWO DB2 SETUPS AND ONE GETS REMOVED
IT36757 CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USESIBM.DATA.DB2 .NET provider
IT36751 EXTERNAL TABLES WITH LFINSTRING OPTION MAY FAIL IF DATA CONTAINSA FIELD INCLUDING A NON ESCAPED DELIMITER CHARACTER
IT36748 DB2EGCF CAUSES TRACE FLOODING DUE TO MEMORY SEG FAULT
IT36742 SQL0901N WHEN DB2 QUERY HAS CDE TABLE AND JOIN PREDICATE HAS TYPE MISMATCH
IT36731 ADMIN_MOVE_TABLE FAILS WITH SQL0010N - WHEN RUNSTATS STATS_PROFILE IS GREATER THAN 1024 CHARACTERS.
IT36721 REORGCHK F6 REPORTING INCORRECT VALUES
IT36692 STORED PROCEDURE CREATED USING THE OUT PARAMETER, WILL CAUSE DB2TO CRASH WHEN USED WITH FEDERATION
IT36689 REORGCHK F6 REPORTING INCORRECT VALUES
IT36682 QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNIONMAY GET INCORRECT RESULT
IT36666 REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING (ITC) TABLES CAN RESULT IN FODC_INDEXERROR
IT36665 REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING (ITC) TABLES CAN RESULT IN FODC_INDEXERROR
IT36658 MON_GET_APPL_LOCKWAIT MIGHT HANG IN PURESCALE
IT36654 LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOADCOPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION
IT36653 LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOADCOPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION
IT36648 CRASH RECOVERY CAN FAIL WITH SQLCODE "-10003"
IT36639 DB2 PURESCALE CLUSTER MEMBERS MAY CRASH DUE TO CERTIAN DISK IO ISSUES IN A CF NODE
IT36633 DB2IPERIODICWATCH TIMEOUT MESSAGE
IT36583 CONNECTION SLOWNESS/HANG DUE TO MORE LATCH WAIT AT GROUP AUTHENTICATION STEP.
IT36581 A QUERY MAY HANG IN A MULTI-NODE ENVIRONMENT.
IT36572 FEDERATED QUERY MULTIBYTES CHARACTERS RETURNING '001A' USING THEODBC WRAPPER
IT36568 A DATABASE OUTAGE IS REQUIRED IN ORDER FOR A NEW CERTIFICATE FORHADR WITH SSL TO TAKE EFFECT
IT36564 DROPPING A MEMBER USING DB2IUPDT -DROP MIGHT RUN INTO MEMORY FAULT
IT36563 TRAP IN SQLERSENDFMPSTART DUE TO SENDBUFFER BEING NULL
IT36559 TRAP IN SQLERSENDFMPSTART DUE TO SENDBUFFER BEING NULL
IT36535 INTERNAL LATCHING LOGIC ERROR FROM TABLE QUEUE SERVICES LEADS TODATABASE SHUTDOWN
IT36527 DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET
IT36525 TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY
IT36524 TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY
IT36521 SQL405N REPORTED BY DB_MEMBERS AND DB_PARTITIONS TABLE FUNCTIONSIF NETNAME EXCEEDS 128 CHARACTERS IN DB2NODES.CFG
IT36512 DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET
IT36499 901 COLUMN NUMBER OUT OF RANGE WHEN GB IN OJ AND GB COLUMN NOT USED IN OJ OR ABOVE (RELATED TO IT29755)
IT36498 DB2 MAY RETURN -901 WHEN IMPLICITLY CASTING NON-STRING TO A STRING AND THE ENVIRONMENT DEFAULT STRING UNITS ARE CODEUNITS32.
IT36493 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT.
IT36476 HANG DURING INSERT FROM NODES SENDING HISTOGRAMS
IT36473 TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS
IT36467 A TRUNCATE TABLE STATEMENT ON A COLUMN ORGANIZED TABLE WITH LOBSMAY RETURN SQLCODE -964 (TRANSACTION LOG IS FULL).
IT36462 BLU QUERY CAN TRAP IN EVALUATIONROUTINE::GETQUERYLITERAL
IT36461 ACTIVATE DATABASE ON ONE MEMBER IN PURESCALE HUNG WHEN ANOTHER MEMBER IS EXECUTING CREATE INDEX ON HADR PRIMARY DATABASE
IT36454 SQL0901N - INVALID FEDERATED THREE PART NAME
IT36449 DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR.
IT36444 SETTING DB2_DPS_RLOG_SHR_MEMBYTES CAUSES EXCESSIVE AMOUNT OF INFORMATION IN DB2DIAG.LOG
IT36443 SETTING DB2_DPS_RLOG_SHR_MEMBYTES CAUSES EXCESSIVE AMOUNT OF INFORMATION IN DB2DIAG.LOG
IT36441 DB2 QUERY PERFORMS BAD WHEN USING SUBQUERY PREDICATE WITH OR
IT36427 MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N
IT36420 THE "DB2CLUSTER -CFS -EXIT -MAINTENANCE -ALL" COMMAND FAILS IN ASINGLE HOST PURESCALE CLUSTER
IT36418 LDAP PLUGIN NOW ALLOWS CONFIGURATION TO CHECK LDAP PASSWORDPOLICYRESPONSE
IT36416 WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N.
IT36408 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS
IT36404 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36402 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36401 901-COLUMN NUMBER OUT OF RANGE DURING QUERY COMPILATION, FORM_CSE CALL STACK
IT36400 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36393 CIB ATTRIBUTE FAILED TO SET DURING PRIMARY REBOOT
IT36388 UNEXPECTED SQL206 WHEN COLUMN NAME OR COLUMN NAME QUALIFIER HAS TRAILING SPACES
IT36387 A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES
IT36386 A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES
IT36384 UPDATE STATEMENT WITH IN/EXISTS MAY GENERATE SQLCODE -913
IT36380 GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER
IT36378 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT.
IT36376 EXPORT RETURNS SQL0204N "SYSTEM.SYSCAT.FUNCTIONS" IS UNDEFINED.
IT36366 DB2ICRT EXITS WITH DBI20000E AND FAILS TO CREATE A PURESCALE INSTANCE IN AN ENVIRONMENT WITH MANY NSD
IT36362 DB2CFEXP FAILS TO EXPORT SSL_CLNT_KEYDB AND SSL_CLNT_STASH DBM CFG PARAMETERS FROM A CLIENT INSTANCE
IT36337 PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST
IT36333 INCORRECT CONNECTION DETAIL TOKEN STRINGS FOR A CLP CONNECTION USING A DBALIAS GREATER THAN DBNAME
IT36331 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTINGTO DATABASES CAN LEAD TO INSTANCE ABEND
IT36323 MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX
IT36320 QUERY EXECUTION MAY FAIL FOR OUTER JOIN QUERIES WITH PREDICATES WITH CAST FUNCTIONS
IT36311 WHEN RUNNING NLJN against COLUMNAR TABLES IT IS POSSIBLE TO GET SQL0901N ERROR
IT36285 INSTANCE TRAPPED DURING SNAPSHOT MONITORING IN FUNCTION SQLPGETDBMONLOG()
IT36279 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36276 UNEXPECTED SQL0206N FROM FEDERATED VIEW USING WITH CLAUSE.
IT36275 UNCATALOG SYSTEM ODBC DATA COURCE FAILS WITH DB21036E
IT36270 EXPLAIN_FROM_SECTION GENERATES EXPLAIN FILE WITH NEGATIVE VALUESWHEN NUMBER OF ROWS IS UPPER THAN INT LIMIT (2147483647)
IT36266 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS
IT36259 SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERRAND SQL0901N
IT36256 DB2 PREP COMMAND FAILS WITH SQL4003N 'THE SQL STATEMENT IS NOT SUPPORTED ...' OR SQL0104N 'UNEXPECTED TOKEN ...' ERROR
IT36253 SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK.
IT36248 INSTANCE CRASH USING WEB SERVICES WRAPPER
IT36245 SQL QUERY MAY BE SLOW WHEN USING DBMS_LOB.SUBSTR FUNCTION IN A VIEW
IT36242 ADMIN_GET_MSGS() MAY RETURN MIX OF MESSAGE UNDER RARE TIMING HOLE.
IT36236 POSSIBLE DB2BP TRAP/HANG UNDER THE EXIT() FUNCTION IF A SIGNAL IS RECEIVED.
IT36232 HANDLE THE ISSUE WHEN 'NULL' VALUE RETURNED FOR NO SHREDDER WORKER, TO AVOID A MEMBER CRASH IN PURESCALE.
IT36230 DB2 TRAP IN FUNCTION EXTRAPAYLOADITERATOR::COPYPAYLOADSTO
IT36227 PUSHDOWN ON DECFLOAT CAN RETURN -901 IN SOME CASES
IT36226 FAILURE TO BIND PORT DURING DB2START MAY RESULT IN SUCCESSFUL DB2START AND BLOCK FAILOVER IN HADR ENVIRONMENT
IT36225 HADR START SCRIPT MAY INCORRECTLY RETURN SUCCESSFUL WHEN INSTANCE IS DOWN
IT36221 INSTANCE CRASH USING WEB SERVICES WRAPPER
IT36216 TIMERTHREAD MAY HOLD COM.IBM.DB2.JCC.AM.* OBJECTS WHICH IN TURN CONTAINS LARGE ARRAYLISTS
IT36210 IN VERY RARE CASE OF CDE RIGHT OUTER JOIN PROCESSING TRAP IS POSSIBLE.
IT36207 TARGET DATABASE CAN FAIL STARTUP AFTER RESTORE INTO WHEN ACCESSING SOURCE DATABASE'S LOG FILES/TAG
IT36203 ADMIN_MOVE_TABLE WITH COPY_STATS OPTION MIGHT FAIL WITH SQL2102NRC 28
IT36201 A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT
IT36200 A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT
IT36199 POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INFO() WHEN RUNNING FEDERATED QUERY
IT36192 WHEN SSL IS USED FOR HADR COMMUNICATION DB2HADRS EDU IS SPINNINGAFTER HADR GRACEFUL TAKEOVER.
IT36183 DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE
IT36178 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG
IT36166 DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE
IT36150 ADMIN_MOVE_TABLE CANNOT BE USED TO MOVE TABLE HAVING DOUBLE QUOTES IN NAME
IT36146 WITH ENABLESYSPLEXWLB SET TO TRUE, CONNECTION ABORT RESULTS IN -913 UNDER GLOBAL TRANSACTION WORKLOAD
IT36141 STATS_ROWS_MODIFIES REPORTS 4294967295 FROM MON_GET_TABLE AND ADMIN_GET_TAB_INFO
IT36140 PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS
IT36139 PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS
IT36131 UNEXPECTED ERROR SEVERITY CODE 8 ERRORCODE=-4228, SQLSTATE=NULL WHEN USING PREPARED STATEMENT WITH SETARRAY METHOD
IT36128 ERROR -901 IN CONCATINFO.HPP ENCOUNTERED WHILE RUNNING A QUERY
IT36113 V11.5.5 ONLY: DB2ADUTL COMMAND FAILS WITH SQL1031N IN PURESCALEON ALL MEMBERS EXCEPT MEMBER 0.
IT36108 INTERRUPTING "ALTER TABLESPACE REDUCE MAX" MAY CAUSE A MEMBER SHUTDOWN
IT36106 SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN
IT36104 DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION
IT36095 ZRC=0xFFFFFFFF=-1 error in db2diag.log when using purescale withSSL
IT36094 DB2CLUSTER -CFS -LIST -IGNOREMOUNTERROR -HOST FAILS WITH INTERNAL DB2CLUSTER ERROR
IT36093 DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED
IT36088 DB2CLUSTER -VERIFY MIGHT FAIL DURING RDMA PING DUE TO SEG FAULT
IT36086 DB2CLUSTER -VERIFY POTENTIAL HANG
IT36085 DB2 11.5.5 MAY ENCOUNTER SQL30082N RC 15 WHEN USING GSS_SERVER_ENCRYPT OR KRB_SERVER_ENCRYPT AUTHENTICATION
IT36077 SQL WITH A PREDICATE "X=UDF()" MIGHT CAUSE DB2 TRAP IF LENGTH(X)IS GREATER THAN LENGTH(UDF())
IT36076 EXECUTING ADMIN_MOVE_TABLE ON A TABLE WITH SOME KINDS OF STATEMENTS > 64KB SIZE, WILL RETURNED SQL0104N OR SQL1224N
IT36074 PRECOMPILER STRIPS C STYLE COMMENTS FROM SQL, CANNOT USE INLINEDOPTIMIZATION GUIDELINES
IT36060 IN RARE INSTANCES, DB2 11.5.5 MAY CRASH DURING DB2START WHEN JWTAUTHENTICATION IS ENABLED
IT36058 INSTALLFIXPACK TRIES TO EXIT MAINTENANCE MODE WHEN IT SHOULDN'T
IT36054 THE DB2MOVE COMMAND DOES NOT EXPORT PARTITIONED TABLES WHEN USED WITH OPTION: TS
IT36048 COMMUNICATION FAILURE BETWEEN DB2AGENT AND DB2FMP FOR SOME COMBINATIONS OF DATA SIZES AND APPLICATION SUPPORT LAYER HEAP SIZES
IT36046 PANIC MAY OCCUR IN HADR TAKEOVER
IT36041 ALTER TABLESPACE WITH NO FILE SYSTEM CACHING OPTION FAILS ON LINUX390
IT36027 IMPROVEMENTS TO CDE JOIN MEMORY USAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS.
IT36026 TRAP IS OCCURRING IN SQLDDELTCB WHEN USING A CGTT TABLE IN AN ANONYMOUS BLOCK.
IT36015 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT36014 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT36013 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT35997 SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR
IT35994 TRAP IN SQLNGREORDERAGGOPS WHEN ATTEMPTING TO COMPILE A JASON ARRAY
IT35993 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG
IT35992 SQL0811N when there is scalar subquery with Fetch First 1 rows
IT35987 "114 ATTEMPT TO ACCESS ITEM BEYOND BOUNDS OF MEMORY" ERROR OCCURRED IN 32 BIT MODE.
IT35986 SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES.
IT35984 A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT
IT35983 MON_GET_APPL_LOCKWAIT TABLE FUNCTION MIGHT RETURN INCORRECT 'HLD_MEMBER' IN PURESCALE
IT35979 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR
IT35976 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG
IT35972 HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL
IT35969 DB2 11.5 MAY FAIL TO CREATE REBOOT SERVICE ON UBUNTU.
IT35968 WHILE QUERYING THE WEB SERVICE NICKNAME, FEDERATION SERVER REPORTS ERROR SQL1822N
IT35965 REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN
IT35964 REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN
IT35954 MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK
IT35953 INSERT FROM COMPLEX SELECT WITH ORDER BY IN DPF MODE MIGHT LEAD TO SEGV TRAP
IT35950 LEFT JOINS ARE NOT PUSHED DOWN IN A FEDERATED ENVIRONMENT
IT35949 OUT OF MEMORY: SIGNAL #11 DATABASETABLEACCESSOR::DESTROYDELETEREPLICATOR
IT35943 QUERIES REFERENCING AN EXISTS SUB-QUERY WITH FETCH FIRST 1 ROW REFERENCED IN A CASE STATEMENT IN THE SELECT LIST MAY RESULT IN I
IT35936 DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION
IT35933 SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING
IT35925 DISTRIBUTION KEY ORDER IS NOT INHERITED FROM THE AS-RESULT-TABLEWHEN COISBAR IS ENABLED
IT35891 WRONG RESULT MIGHT BE RETURNED WHEN SUBSTR WITH IF ELSE CLAUSES WAS USED AND THE COLUMN WAS CREATED IN CODEUNIT32
IT35883 INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE
IT35880 DB2 11.5 PERF DEGRADATION ON LINUX: O_SYNC AND NOT O_DSYNC USED
IT35879 DB2 WAS UNABLE TO FORCE THE QUERY BECAUSE IT WAS STUCK EXECUTINGA HSJOIN
IT35877 SEVERE ERROR MESSAGE WRITTEN TO DB2DIAG.LOG WHEN ACCESSING A TABLE THAT IS IN A RESTRICTED STATE
IT35874 RARE TIMING WINDOW IN GETPARTITIONSTATSSUMMARY CAUSES DB2 SERVER/ DB2SYSC TO ABEND / TRAP
IT35864 FUNCTION GENERATE_UNIQUE() USED IN A MERGE STATEMENT RETURNS A NULL VALUE
IT35855 MEMORY LEAK ENCOUNTERED WHEN YOU HAVE MORE THEN 1COLUMN OF SAME TYPE FROM TIMESTAMP/TIME/DATE WITH DB2 FORMAT SPECIFIED FOR IT
IT35853 AUDIT EVENT LOAD_TABLE EVENT STATUS 3534 FILLING UP AUDIT LOG
IT35841 THE REBIND PACKAGE COMMAND MIGHT FAIL WITH SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR.
IT35840 THE REBIND PACKAGE COMMAND MIGHT FAIL WITH SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR.
IT35833 SQL1585N is incorrectly returned for certain types of queries
IT35832 SQLCODE -1229 CONTINOUSLY WRITTEN IN DB2DIAG.LOG AFTER NODE FAILURE
IT35831 MISLEADING MESSAGE IN DB2DIAG.LOG FROM SQLRI_BUFFER_DISK_READ
IT35828 "DB2CLUSTER -CFS -SET -OPTION CCRENABLED -VALUE NO" COMMAND TIMES OUT
IT35820 A TRAP MAY OCCUR WHEN CALLING THE ENV_GET_DB2_EDU_SYSTEM_RESOURCES FUNCTION IN RAPID SUCCESSION.
IT35819 Configure GPFS parameter failure due to MMSDRSERV PROCESS DIDN'TSPAWN AFTER CFS ENTER INTO MAINTENANCE MODE Since V11.5.4
IT35802 DB2 QUERY PLAN DOES NOT CHOOSE INDEX WHEN IN PREDICATE HAS PARAMETER MARKER.
IT35801 MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE HADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED. THIS SHO
IT35800 DIAGNOSTICS DUMPING MAY HANG WHEN DUMPING PACKAGE CACHE INFORMATION
IT35798 SLOW PERFORMANCE IN DPF OR CDE WHEN RUNNING A QUERY WITH SCALAR SUBQUERIES AND AN OUTER JOIN
IT35770 OOM HIT WHILE RUNNING External Table with Netezza INTERNAL FORMAT MIGRATION.
IT35764 EXTENT MOVER CAN HANG WAITING FOR SQLO_LT_SQLB_POOL_CB__READLOTCH WHILE HOLDING SQLO_LT_SQLB_EXTENT_DESC__EXTENTLATCH
IT35758 AN OUTER JOIN QUERY MIGHT BE WRONGFULLY RE-WRITTEN TO AN INNER JOIN QUERY WHEN MQT MATCHING IS ENFORCED FOR SHADOW TABLES.
IT35750 THE FUNCTION WHICH TESTS THE 'FAILOVER' MEMBER DOES NOT TAKE SSLINTO ACCOUNT.
IT35749 UNION ALL MIGHT BEHAVE INCONSISTENT WHEN THE ORDER OF SQL'S IN IT IS CHANGED.
IT35741 SQL1585N is returned when the optimizer does not select a possible plan under some circumstances
IT35739 DB2 QUERY MAY NOT GENERATE TRAILING SPACE WHEN MINUS/EXCEPT IS USED IN THE QUERY.
IT35734 SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING
IT35728 SQL0407N WHEN COMMON SUBQUERY HAS VALUES
IT35720 PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILURES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION.
IT35719 SQL0407N WHEN COMMON SUBQUERY HAS VALUES
IT35712 PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILURES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION.
IT35710 Intermittent fast preallocation failures on AIX
IT35705 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE
IT35695 INCORRECT HADR_TARGET_LIST CONFIGURATION IN PURESCALE CAN RESULTIN UNEXPECTED SQL1776 RC 6
IT35692 SQL0407N WHEN COMMON SUBQUERY HAS VALUES
IT35691 NO ROWCOMPESTIMATE FROM DB2INSPF OUTPUT WITH -TSI OPTION
IT35690 NO ROWCOMPESTIMATE FROM DB2INSPF OUTPUT WITH -TSI OPTION
IT35689 Query with 'ORDER BY' and referencing a common subexpression over column-organized tables may return rows in the wrong order
IT35685 Query with 'ORDER BY' and referencing a common subexpression over column-organized tables may return rows in the wrong order
IT35682 POSSIBLE FMPTRAP IN CHECK_CREATE() WHEN RUNNING DB2LOOK IF AN OBJECT GETS DROPPED WHILE THE TOOL IS RUNNING
IT35681 CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS
IT35680 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR
IT35679 UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT.
IT35678 UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT.
IT35672 UPDATING NETNAMES HIT ISSUE SAYING RSCT PEER IN REGISTRY DOES NOT MATCH ACTIVE DOMAIN NAME
IT35670 REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAYRESULT IN -901
IT35667 DB2DIAG.LOG MAY CONTAIN ERROR MESSAGE "ENVIRONMENT NOT GUARANTEED"
IT35663 A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP
IT35662 CREATE TABLE STATEMENTS ARE HANGING DUE TO RDMA COMMUNICATION TIMEOUTS BETWEEN MEMBER AND CF ON ZLINUX
IT35610 POSSIBLE DB2BP TRAP/HANG UNDER THE EXIT() FUNCTION IF A SIGNAL IS RECEIVED.
IT35609 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR
IT35578 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN DISTRIBUTED TRANSACTION
IT35576 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN A DISTRIBUTED TRANSACTION
IT35573 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN DISTRIBUTED TRANSACTION
IT35566 MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX
IT35558 SIGNAL 11 TRAPS DURING CTSNAPS AFTER ROCE CABLE PULLS
IT35553 DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG.JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT.
IT35552 CF CHANGE TO ADD BREATHING POINT FOR DAT_EVD_DEQUEUE
IT35550 BLU TABLE SELECT CAUSES INSTANCE CRASH TRAP ON WINDOWS
IT35548 HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL
IT35546 -901 SQLCODE during rebind for packages bound with certain bind options
IT35542 JAVA STORED-PROCEDURE THROWS NULLPOINTEREXCEPTION WHEN SETTING BOOLEAN OUTPUT PARAMETER
IT35538 TRAP WHEN MULTIPLE UNION BRANCHES WITH SAME TABLE
IT35521 CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS
IT35518 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE
IT35517 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE
IT35509 RESTORE DOESN'T PRESERVE THE ORIGINAL TABLESPACE LAYOUT LIKE THESOURCE DATABASE
IT35501 INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE
IT35494 WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE.
IT35491 POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGISTER AN INVALID SERVICE CLASS ID OF 0"
IT35486 DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG.JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT.
IT35485 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE
IT35472 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR
IT35446 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT35445 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT35444 MULTIPLE MEMORY LEAKS IN GEO-SPATIAL CALLS WHEN EXECUTING CERTAIN GEO-SPATIAL FUNCTIONS
IT35439 DB2ADV_VPC.LIC CAN MAKE Q REP FUNCTIONS AVAILABLE, IT IS NOT THEEXPECTED RESULT
IT35436 VALUE OF STATISTIC COLUMN AVGENCODEDCOLLEN IS INCORRECTLY COLLECTED DURING THE LOAD
IT35435 IMPROVE DETECTION/TOLERATION/REPORTING OF BAD INDEX PAGES.
IT35426 ON DB2/AIX, POST FROM THREAD_POST CAN BE SKIPPED/DEFERRED BY WAITER INTERRUPTED IN THREAD_WAIT , LEADING TO PANIC/SHUTDOWN
IT35418 SELECT DISTINCT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")
IT35416 INSERTS MAY INTERMITTENTLY RETURN SQL0289N WHILE TABLE SPACE EXTENT MOVEMENT IS IN-PROGRESS
IT35405 CAN'T CONNECT TO DB2 VIA EXCEL 2016 USING DATA --> ?GET EXTERNALDATA? WHEN UPGRADING RUNTIME CLIENT TO 11.5
IT35402 STRIPTNULLS MODIFIER IN LOAD AND IMPORT COMMANDS TRUNCATE NULLS (0X00) FROM GRAPHIC (FIXED-LENGTH) COLUMN, BUT IT SHOULD NOT
IT35400 WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATAPART TABLE ON THE INNER AND NULL KEYS.
IT35399 FEDERATED SERVER OPTION CONCURRENT_ACCESS_RESOLUTION='W' CAUSES CLI019E INVALID ATTRIBUTE ERRORS
IT35385 QUERY COULD FAIL WITH -901 WHEN MQT IS USED
IT35384 Private memory leak during DDL on column-organized tables in DPFenvironment
IT35381 NON ADMIN USER SHOULD NOT BE ABLE TO ADD A LICENSE TO THE DB2COPY ON WINDOWS
IT35380 UNION ALL MIGHT BEHAVE INCONSISTENT WHEN THE ORDER OF SQL'S IN IT IS CHANGED.
IT35377 WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATAPART TABLE ON THE INNER AND NULL KEYS.
IT35376 DB2 MIGHT CAUSE EXCESSIVE LOGGING (SQL0952N MESSAGES) WHEN A QUERY IS INTERRUPTED.
IT35309 DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE -901 REASON CODE "CONSTANT OF UNSUPPORTED TYPE"
IT35308 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35307 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35306 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35305 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35303 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35294 Authorization errors in accessing CGTTs after a transfer owner of a SQL routine.
IT35292 SECURITY: - IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND. CVE-2020-5024
IT35291 SECURITY: - IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND. (CVE-2020-5024)
IT35290 SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024)
IT35289 SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024)
IT35270 Authorization errors in accessing CGTTs after a transfer owner of a SQL routine.
IT35265 FEDERATED QUERY COULD LEAD TO DB2 INSTANCE CRASH WITH FODC_PANICIN SQLQGINSERT
IT35257 DB2 TERMINATES ABNORMALLY COMPILING A QUERY.
IT35256 DB2 TERMINATES ABNORMALLY COMPILING A QUERY.
IT35247 DB2 11.1 DB2LOOK -PRINTDBCFG FAILS WITH SQL5066W THE DB CFG PARAMETER VALUE FOR TOKEN "SQLF_DBTN_APPLHEAPSZ"
IT35245 PROCESS CRASHES WITH SIGNAL 11 (MEMORY VIOLATIONS) WHEN APPLICATION CALLS SQLCONNECT OR SQLDRIVERCONNECT
IT35241 HOST FAILURE DETECTION TIME CAN GO OUT OF SYNC IF ADDING NEW NETWORK INTERFACES TO AN ALREADY EXISTING DB2 PURESCALE CLUSTER
IT35237 IXORING PLAN WITH ONLY PARTS OF A SUBTERM APPLIED IN A COMPLEX OR PREDICATE MIGHT RESULT IN CARDINALITY UNDERESTIMATE AT RIDSCN
IT35236 DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS.
IT35231 ONE COMPLEX QUERY TAKES VERY LONG TIME TO FINISH AFTER MIGRATINGFROM V10.5
IT35226 CREATE OR REPLACE NICKNAME ON REMOTE DB2I SERIES (AS400) FAILS WITH SQL0901 AND DUMP FOLDER FODC_APPERR IS CREATED
IT35221 WLM ADMISSION CONTROL DOES NOT PROPERLY TRACK ACTUAL MEMORY HISTORY FOR SHORT QUERIES
IT35216 OOM: REQUEST MEMORY IS FAILING UNNECESSARILY EARLY WHEN THERE ISCONTENTION TRYING TO STEAL MEMORY FROM OTHER CONSUMERS
IT35211 POSSIBLE SIGSEGV IN Q Replication due to incorrect log records for column-organized DGTT in DPF ENVIRONMENT
IT35208 DB2 : SET WRITE RESUME COMMAND HANGS
IT35200 REBIND FAILING WITH SQL0100W
IT35198 A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED
IT35195 ERROR OCCURS WHEN BATCH INSERT CONTAINS REGULAR RECORDS FOLLOWEDBY RECORDS WITH READONLY COLUMN USING IBM ENTITY FRAMEWORK CORE
IT35185 DB2 MIGHT TRAP IN SQLRWTABLEMETRICSBUILDER::EXECUTE DURING EXECUTION OF THE MON_GET TABLE FUNCTION
IT35183 POOR QUERY PERFORMANCE WHEN IN SUBQUERY PREDICATE WITH NO DISTINCT.
IT35182 CLEANUP OF IN-MEMORY STRUCTURE WHEN LOADING OF THE DICTIONARY FAILS (ADD CODE TO HANDLE EXCEPTIONS GRACEFULLY).
IT35180 BOOLEAN DATA TYPE GETS TRANSLATED AS SHORT-TEXT IN MS-ACCESS VIAODBC
IT35178 DB2 MIGHT ABEND WHEN EXECUTING A QUERY USING FIRST_VALUE AND REFERENCING TABLES ORGANIZED BY COLUMN
IT35165 DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE.
IT35163 DB_MIGRATE HANGS WHEN USING ORDER BY CLAUSE
IT35161 DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS
IT35159 DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS
IT35158 REDUCE LIKELIHOOD OF SQL0954C FOR COLUMNAR ORGANIZED HSJN PLANS
IT35150 UNEXPECTED SQL0538 WITH NTILE BUILTIN FUNCTION
IT35124 CLASS NOT FOUND EXCEPTION: COM.IBM.DB2.INSTALL.CODEGEN.NLPACK INITIALIZER IN DB2SETUP.ERR
IT35119 RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED
IT35118 POSSIBLE WRONG RESULT WITH ALWAYS-FALSE PRED OR EXISTS PRED
IT35117 DB2HAICU -DISABLE FAILS ON ZLINUX
IT35115 RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED
IT35113 EVENT MONITOR ACT_EXEC_TIME WRAP AROUND AS AN INTEGER NOT AS BIGINT
IT35107 NO MESSAGE TO THE ADMINISTRATION NOTIFICATION LOG FOR DEADLOCKS WHEN MON_LCK_MSG_LVL IS SET TO 2 OR HIGHER
IT35101 SQL0901N IN GETJOINPAYLOADEVALUATOR.CPP:152
IT35086 SQL2536W DURING BACKUP
IT35085 DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE"
IT35082 High CPU and decreased performance with high concurrency of index creation (on TEMP TABLES)
IT35075 SELECTING FROM AN EXTERNAL TABLE THAT USES LFINSTRING ON CAN FAIL WITH SQL5199N
IT35071 RESTORE DOESN'T PRESERVE THE ORIGINAL TABLESPACE LAYOUT LIKE THESOURCE DATABASE
IT35070 QUERY EXECUTION FAILS WITH -901 "SQLRIDERIVEDUMMY FUNCTION SHOULD NEVER BE ACTUALLY CALLED"
IT35069 SELECT-STATEMENT INCORRECTLY RETURNS SQL20264N DURING EXECUTION
IT35068 DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED
IT35067 SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS
IT35066 LPAD OR RPAD BUILTIN FUNCTION FAIL WITH -901 "VALUE IS TOO LARGEFOR THE BUFFER"
IT35065 Basic predicate "DECFLOAT != BIGINT" results in poor query performance
IT35064 DESCRIBE VIA ADMIN_CMD CAN SOMETIMES GIVE WRONG COLUMN ORDER.
IT35063 JDBC DatabaseMetaData.getTableTypes missing SYNONYM
IT35062 CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE
IT35061 WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORGFROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC
IT35060 BOOLEAN PREDICATES RETURN WRONG RESULT WITH NULL INPUT
IT35059 LPAD, RPAD or REPLACE may result in SQLCODE -901 when source-string references a column-organized table column
IT35058 SUBSTR IN COLUMN ORGANIZED COLUMN COMPARISON RETURN WRONG RESULTS
IT35057 WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORGFROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC
IT35056 CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE
IT35055 DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE
IT35047 POOR UPDATE PERFORMANCE AFTER MIGRATING TO V11.5.4
IT35045 PACKAGE CONTAINING XML FUNCTIONS MAY RESULT IN -901 WHEN REBINDING WITH APREUSE
IT35043 SQL0901N ERROR MAY OCCUR WHEN COMMON TABLE EXPRESSION HAS "SYSPUBLIC" SCHEMA NAME
IT35033 CUSTOMERS ENCOUNTERING ASN0569E DUE TO OUT-OF-ORDER REPLICATION LOG RECORDS DURING SAVEPOINT ROLLBACK
IT35030 DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
IT35029 DB2 MAY INCORRECTLY INCREMENT ROLLBACK_SQL_STMTS AND TOTAL_APP_ROLLBACKS MONITOR ELEMENTS WHEN CALLING AUTONOMOUS PROCEDURES
IT35021 High CPU and decreased performance with high concurrency of index creation (on TEMP TABLES)
IT35017 CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERENCING NULL POINTER
IT34998 DB2 CAN CRASH DURING COMPILATION IF THE SAME EXPRESSION IS USED IN BOTH AN EQUALITY JOIN PREDICATE AND AN EXPRESSION-BASED INDEX
IT34991 QUERY WITH OLAP MIGHT FAIL WITH SQL0955C IN CDE
IT34987 DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION
IT34970 ABNORMAL TERMINATION OF DATABASE WITH "ERROR DURING LOG PAGE VALIDATION." FROM SQLPGWLP, PROBE:390.
IT34960 DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS.
IT34956 NLJN cannot be pushed down
IT34955 PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING
IT34941 QUERY ON NICKNAME RESULTS with VALUES TRUNCATED on MARIADB
IT34940 WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE.
IT34936 HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLEAND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES
IT34931 PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST
IT34929 ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH
IT34928 DB2 MAY PANIC DURING ForceDBShutdown
IT34924 DB2DART AND INSPECT COMMANDS FOUND ERROR TYPE VARIABLE-LENGTH DATA AT OFFSET XXXX IS READ INCORRECTLY. THE EXPECTED OFFSET IS 0
IT34919 THE OPTIMIZER MAY CHOOSE A SUBOPTIMAL PLAN FOR QUERY WITH MULTIPLE CORRELATED SCALAR SUBQUERIES WHEN USING GREEDY JOIN ENUM
IT34916 APPLYING DB2 V11.5 FIX PACK FOR WINDOWS TO V11.5 GA LEVEL FAILS WITH 'ERROR APPLYING TRANSFORMS.' IN NON-ENGLISH LOCALE.
IT34913 SQL1227N ERROR WITH RC 11 WHEN RESETTING AVGPARTITION_CLUSTERRATIO COLUMN VALUE DURING INDEX STATS RESET.
IT34912 NEW OPTION FOR DB2LOOK -M NOT TO GENERATE RESET INDEX AND COLUMNSTATS IN THE OUTPUT VIA NEW ENVIRONMENT VARIABLE
IT34911 APAR IT17532 INTRODUCED RESET OF COLUMN STATS IN DB2LOOK MIMIC OUTPUT, CAUSING LOCKING BEHAVIOUR WITH ONLINE RUNNING APPS.
IT34910 CRASH IN UPLUG_INIT_44_DB2
IT34885 SIMPLIFIED SSL CONNECTIONS MAY FAIL WITH GSKIT ERROR 414 WHEN A STASH FILE IS IN USE
IT34884 SIMPLIFIED SSL CONNECTIONS MAY FAIL WITH GSKIT ERROR 414 WHEN A STASH FILE IS IN USE
IT34883 INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL
IT34882 INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL
IT34881 GSKKM_StoreCACert: GSKit Error = 100 errors in db2diag.log
IT34871 USING WRONG DELIMITER MIGHT CAUSE THE INSTANCE CRASH
IT34869 DB2PD -DBPTNMEM CAN CRASH IF USING USING MEMBER NUMBERS GREATER THAN 9
IT34866 ADDITIONAL FIX TO APAR IT13674, TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT
IT34860 DB2 QUERY MAY HANG WITH REGISTRY SETTING DB2_EXTENDED_OPTIMIZATION="INJ_DUMMY_PRD4JOIN"
IT34853 JAVA EXTERNAL ROUTINE MIGHT RETURN TRUNCATED CLOB
IT34852 WHEN REMOVING LICENSE, THE CORRECT ITLM TAG IS NOT CONVERTED BACK TO .DB2TAG FILE.
IT34844 DB2LOOK -XD DOES NOT SHOW ALL DATABASE AUTHORIZATION STATEMENTS GRANTED AT DATABASE CREATION TIME
IT34794 CLONE OPERATION MAY FAIL AFTER INITIAL CONFIGURATION OF THE CLONE HOST USING SETUP__UI.SH
IT34787 MON_UOW_EXECLIST CONSUMES MONHEAP EVEN WHEN OFF
IT34786 ACTIVATE COMMAND UNABLE TO START HADR DUE TO CLIENT CONNECT SESSION TERMINATED
IT34779 DURING RESTORES SPECTRUM PROTECT SNAPSHOT SHOWS FMM0644E ERROR VARYONVG: THE VOLUME GROUP IS ALREADY VARIED ON IN OTHER NODE
IT34775 SQL STATEMENT CALLING NTILE FUNCTION FAILS WITH : -901 BAD DYN INDEX. IDX=4294967294 SIZE=87 (OFF=5)
IT34774 For special queries DISTINCT is pulled up above the UNION level in the optimized statement, what may cause wrong results
IT34771 DB2GETROWPARTNUM() API RETURNS WRONG RESULT FOR BINARY/VARBINARYCOLUMN AND NULL VALUE
IT34768 DOTNET APPLICATION CRASHES WITH ACCESSVIOLATIONEXCEPTION FOR ARRAY INSERT WHEN DB2TRC IS ON
IT34765 JCC returns UNKNOWN SQL TYPE (-100008) for SYS_REFCURSOR Output parameter for stored procedure
IT34764 SLOW PERFORMANCE IN REGULAR EXPRESSION FUNCTIONS ON BIG ENDIAN PLATFORMS
IT34758 SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR
IT34755 DB2 MAY RETURN SQL0901N WITH ERROR MESSAGE "UNEXPECTED ERROR AT MINMAXPARTIALEVALUATOR.CPP"
IT34748 UPDATE STATEMENT SLOW PERFORMANCE CAUSED BY LATCH CONTENTION DURING THE MEMORY ALLOCATIONS.
IT34740 INSPECT ON A COLUMN-ORGANIZED SYNOPSIS TABLES MIGHT FAIL WITH FODC_APPERR
IT34731 RUNSTATS ON KEY COLUMNS SET PROFILE ON COLUMN-ORGANIZED TABLE WITH NO INDEXES MIGHT LATER LEAD TO SQLCODE -901
IT34723 TRAP/PANIC DURING SQLU_REGISTER_TABLE_UNLOAD ON CDE TEMPORAL TABLE
IT34721 SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR
IT34719 DECIMAL FUNCTION ON COLUMN-ORGANIZED TABLE MIGHT FAIL WITH SQL0413N
IT34715 MISSING INFORMATION IN DB2DIAG.LOG WHEN USERID AND PASSWORD ARE CORRECT, BUT THE USER IS REVOKED/DISABLED/LOCKED
IT34714 [MVP]CDE query which has "LIMIT 1"  or "FETCH FIRST 1 ROW ONLY" clause can be hang
IT34702 LOAD MIGHT HANG AFTER HITTING SQL0359N IDENTITY COLUMN VALUE EXHAUSTED
IT34701 FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL
IT34697 DB2BATCH FAILS TO CAPTURE MONITORING STATISTICS FOR REMOTE INSTANCES IN A KERBEROS ENVIRONMENT
IT34696 MEMORY CRASH/TRAP WITH LOCAL PREDICATE ON OJ SUBSELECT
IT34693 DB2UNINS OF DATA SERVER CLIENT REMOVES SHARED C++ REG KEYS
IT34672 PLAN with EARLY_OUT NLJOIN AND CTQ IN THE INNER CAN HANG IN COMPLEX SCENARIOS.
IT34671 MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK
IT34670 ACCESSING HIDDEN COLUMNS WITH FEDERATION RECEIVES SQL0206N
IT34668 INSERT INTO COLUMN-ORGANIZED TABLE FROM COMPLEX SUBSELECT CAN TRAP DURING QUERY OPTIMIZATION
IT34658 DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS
IT34655 A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
IT34654 WARNING MESSAGES ARE GETTING LOGGED AS SEVERE MESSAGES
IT34634 ENHANCEMENT: DB2IUPDT CHECKS ROOT USER'S .PROFILE HAS DB2PROFILE
IT34619 ENHANCEMENT: SETUP.EXE CHECKS CURRENT DIRECTORY NAME WHETHER IT HAS SPACE(S) OR NOT ON WINDOWS
IT34615 THE DB2CLI COMMAND OR EXCEL MAY CRASH (PROGRAM STOPS WORKING) INFULL DB2 CLIENT WHEN USING A DSN FOR CONNECTION
IT34614 SECURITY: SEVERAL BUFFER OVERFLOW VULNERABILITIES AFFECT DB2
IT34613 INCORRECT RESULTS WITH DB2_EXTENDED_OPTIMIZATION='MQTENFORCE REPLICATED'
IT34609 QUERY SUCCCEED BUT GET ERROR MESSAGE WINNING PLAN STILL NEEDS GLUE IN DB2DIAG.LOG
IT34608 INCORRECT OUTPUT OF INQUIRE_DETAIL_CLONE COMMAND IN MULTI-NODE DB2 DPF ENVIRONMENT
IT34607 DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS.
IT34606 USING CFGREFRESHINTERVAL IN A MULTI-THREADED CLI APPLICATION LEADS TO SEGMENTATION FAULT
IT34602 Reorg start time unexpectedly updated during reorg reclaim extents on an ITC
IT34589 ON WINDOWS PLATFORM CLIDRIVER CAN LOG SQL1531N DURING CONNECT EVEN WHEN CONNECTION IS SUCCESSFUL WITH SQL_SUCCESS_WITH_INFO
IT34588 SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER (VARIABLE) VIA JDBC
IT34587 DB2TRC FMT -CLI CRASHES ON WINDOWS FOR SQLFREEHANDLE API
IT34585 DB2STOP FAILED WITH TIMEOUT WHEN MULTIPLE SEGMENTS FOR DBMS SET ARE ALLOCATED AND SQLO_ADDR_CONFLICT IS REPORTED BY DB2WDOG
IT34579 DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY WILL FAIL WITH SQL2079N ERROR
IT34560 DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR
IT34559 ELEMENT ALLOCATION ISSUE, TRAP ON FUNCTION "ibm_cde::query::EvaluationRoutine::getQueryLiteral"
IT34556 FEDERATION FMP COMMUNICATION BUFFER CAUSES "SQL10003C THERE ARENOT ENOUGH SYSTEM RESOURCES TO PROCESS THE REQUEST
IT34547 DIA8550C MESSAGES FILLING UP DB2DIAG.LOG WHEN LOG PATH IS MAPPEDTO AN UNC PATH in Windows environment
IT34539 TWO PHASE COMMIT SQL0901N
IT34534 Db2 Administrative Task Scheduler stops executing scheduled tasks
IT34517 Newly created tablespace is missing on HADR standby due to disk full during replay
IT34510 DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION
IT34504 GSKKM_StoreCACert: GSKit Error = 100 errors in db2diag.log
IT34500 REORG RECLAIM CODE CAN LEAD TO DEADLATCH
IT34483 HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK WHEN ENCOUNTERING A LOG FILE WITH CORRUPTED XHD
IT34474 SECURITY: SEVERAL BUFFER OVERFLOW VULNERABILITIES AFFECT DB2
IT34472 SECURITY: SEVERAL BUFFER OVERFLOW VULNERABILITIES AFFECT DB2
IT34469 CLIENT GETS -901 DTS MISMATCH BETWEEN REQUEST AND CACHE INSTEAD OF -910
IT34465 DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION
IT34443 A COLUMN MASK DEFINED ON A COLUMN WITH STRING LENGTH UNIT CODEUNITS32 MAY RESULT IN SQL20478N
IT34440 ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE
IT34432 FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL
IT34429 CRASH SIGNAL#11 SQLEHDIR__FP8SQLE_BWA IN DB2 V11.1.4.5
IT34425 HANGING QUERY IN CLOB TYPE STATEMENTS
IT34418 QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED
IT34417 QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED
IT34398 GET DB CFG FOR CAN FAIL IF GATEWAY CATALOGS TARGET DB WITH DIFFERENT NAME
IT34397 A MERGE STATEMENT CAN FAIL WITH AN SQL0901N: REASON (UNEXPECTEDERROR AT TSNRANGEITERATOR.CPP:841)
IT34396 PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING
IT34395 HADR GRACEFUL TAKEOVER FAILED DUE TO XML DICTIONARY CREATION ON PRIMARY THAT CANNOT BE FORCED OFF IN A TIMELY MANNER
IT34393 HADR GRACEFUL TAKEOVER FAILED DUE TO XML DICTIONARY CREATION ON PRIMARY THAT CANNOT BE FORCED OFF IN A TIMELY MANNER
IT34384 DB2PREREQCHECK CHECKS FOR JAVA, BUT WE BUNDLE JAVA WITH DB2
IT34382 POOR PERFORMANCE WHEN IN-LIST TO JOIN CAUSING EARLY COMPENSATION
IT34381 A DEADLOCK MAY RESULT WHEN MULTIPLE APPLICATIONS CONCURRENTLY INSERT INTO A COLUMN-ORGANIZED TABLE WITH AN IDENTITY COLUMN
IT34356 FMP TRAP WHILE USING -FORMAT INTERNAL DUE TO SCHEMA MISMATCH
IT34352 DURING START DB2DIAG.LOG MAY BE FLOODED WITH "NO HADR RESOURCE DEFINED" INFO MESSAGES IN AN ACTIVE-PASSIVE TOPOLOGY
IT34348 .NET DRIVER CRASH DUE TO A TIMING HOLE
IT34347 MONTHS_BETWEEN FUNCTION IN NPS MODE RETURN NEGATIVE
IT34327 USING ODBC ADMINISTRATOR FOR DB2 CLI ODBC DRIVER WITH SSL FOR A DSN THROWS SQL1042C ERROR ON TEST CONNECT
IT34317 SECURITY: DENIAL OF SERVICE CONDITION INSIDE THE "DB2 MANAGEMENT SERVICE"
IT34316 SECURITY: DENIAL OF SERVICE CONDITION INSIDE THE "DB2 MANAGEMENT SERVICE"
IT34315 SECURITY: DENIAL OF SERVICE CONDITION INSIDE THE "DB2 MANAGEMENT SERVICE" (CVE-2020-4642)
IT34314 SECURITY: IBM® Db2® is vulnerable to a Denial of Service on Windows (CVE-2020-4642)
IT34311 Query with alias for complex column used in group by clause traps and generates FODC
IT34308 REPLICATED MQT MATCH MAY FAIL IN SOME SPECIFIC SITUATIONS
IT34306 OPTIMIZER USES QUANTILE STATS FOR UNIQUE COLUMNS TO COMPUTE THE EQUALITY PREDICATE FILTER FACTOR WHICH LEADS TO OVER-ESTIMATION
IT34304 SQL0344N ERROR MAY OCCUR IN NON-UNICODE, VARCHAR2 ENABLED DATABASE WHEN QUERY REFERENCES SYSIBM.SYSDUMMY1 or SYSIBM.DUAL
IT34294 SECURITY: IBM Db2 is vulnerable to a Denial of Service on Windows (CVE-2020-4642)
IT34284 SORT MEMORY HARD CAPPING AND OVER-ESTIMATION ERROR CORRECTION FIXES IN WLM
IT34280 CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP'
IT34261 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTINGTO DATABASES CAN LEAD TO INSTANCE ABEND
IT34257 DB2 WLM MAY CAUSE UNNECESSARY QUEUING AFTER INSERTS TO EXTERNAL TABLES IN A PARTITIONED DATABASE

© Icons by Mark James www.famfamfam.com

invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Feature RequestFeature Request

Feature Request

Release NotesRelease Notes

Release Notes

Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service and SupportService and Support

Service and Support

IBM Db2 for purchasersIBM Db2 for purchasers

IBM Db2 for purchasers

IBM Software for ISVsIBM Software for ISVs

IBM Software for ISVs

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.