Welcome to the Jazz Community Forum
Query consumes 100G of temporary tablespace
Hi,
Twice this week our AIX DB2 server has hit transient full file system which I've traced most recently to a query that starts this way (or at least what's reported).
The temporary tablespace is mentioned in the DB2 diagnostic log. This condition is a rare occurrence most often triggered by a poor query (e.g. a join of tables w poor or no join criteria along with order by). The total sql is several hundred characters long, Time of occurrence 17:20 pm so it's not likely to have been the dw stuff.
Anyone out there recognize this SQL ?
Twice this week our AIX DB2 server has hit transient full file system which I've traced most recently to a query that starts this way (or at least what's reported).
with ctx(ctx_uuid) as (select CONTEXT_UUID from REPOSITORY.CONTEXT_MEMBERS where MEMBER_UUID in('_8lNyYNwSEd2pIJ5QVwgQGg', '_E-k30VfXEd6KGeozX9EKiQ') union values ('_E-k30VfXEd6KGeozX9EKiQ')) select t1.ITEM_ID, t1.CONTEXT_ID, t1.MODIFIED, t1.STATE_ID, SUM(t1.ID), t1.INTERNAL_STATE, t1.INTERNAL_RESOLUTION, t1.RESOLUTION_DATE,
The temporary tablespace is mentioned in the DB2 diagnostic log. This condition is a rare occurrence most often triggered by a poor query (e.g. a join of tables w poor or no join criteria along with order by). The total sql is several hundred characters long, Time of occurrence 17:20 pm so it's not likely to have been the dw stuff.
Anyone out there recognize this SQL ?