IBM Data & AI

Welcome to the idea forum for IBM Data & AI (Formerly Analytics) Clients! 


IBM Employees:

The correct URL for entering your ideas is



Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.


If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.


Implicit logged temp tables should use logged spaces listed in DBSPAETEMP

The documentation suggests that logged temp tables will be stored in any logged dbspaces listed in the DBSPACETEMP parameter/client environment variable. Yet when selecting from a view based on a union query, we find that the root dbspace is always used for the implicit temp table used to instantiate the view, even when we have both logged and non-logged dbspaces listed in DBSPACETEMP. Ideally, implicit temp tables would never be logged. The documentation in fact suggests this is the case. But if it is necessary for an implicit temp table to be logged, it should at least be stored in any logged dbspaces listed in DBSPACETEMP.
  • Guest
  • Dec 24 2018
  • Future Consideration
Why is it useful?
Who would benefit from this IDEA?
How should it work?
Idea Priority High
Priority Justification
Customer Name HALO Branded Solutions
Submitting Organization
Submitter Tags
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions