invispix 10x10
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT41049 Status: Closed

INSERT STATEMENTS WITH USER-DEFINED SQL FUNCTIONS AND VALUES TABLE
FUNCTIONS MIGHT SHOW PERFORMANCE ISSUES.

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
Insert statements with user-defined SQL functions and VALUES
table functions might show performance issues.

Example:
   insert into t1 with temp(col1) as (values ('a'), ('b'), ...)
   select sql_user_function(col1) from temp

Reason:
   After the body of the user-defined function is embedded into
the internal query, correlation might be introduced.

Workaround:
   Apply the following registry setting using the optimization
guideline to the affected queries:
/*  
  */;
Problem Summary:
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.05.2022
26.05.2022
26.05.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10