Thinking about your availability and recovery strategy shouldn't give you sleepless nights. Db2 understands the importance of keeping your database online 24x7 and with Db2 11.1 / 11.5 and its continuous delivery of new features and enhancements, you are on the right path of achieving such goals.
Moving to a new version or fix pack of DB2 should not be a scary event for databases using the high availability disaster recovery (HADR) feature. Fear of an outage or re initialization of your standby is no longer a concern.
A temporary table is a place to store relevant to your needs. Whether you are an application or some end-user. It is a place to keep data. It helps give SQL coding options. They can help reduce SQL complexity! You can break down complex SQL into smaller SQL chunks via temporary tables.
You can find a ton of articles about recursive SQL dating back as early as 2004, but for this article I was asked to provide actual real-world situations where recursive SQL was put to use. In all of the situations it was a great success!
If you are a serious Db2 user, chances are you have downloaded and used free Db2 versions for a few years. Db2 Express-C was a free way to learn Db2 on Linux, Unix and Windows, to practise and test your SQL skills and in later versions implement or ship Db2 with your small production application.