Unanswered: Virtual storage or database resource is not available
I am using DB2 UDB v7 on Aix system. When I execute a sql procedure, i get this error while executing the 'DECLARE GLOBAL TEMPORARY TABLE' statement. Table space name is not specified in the above declaration. There exists an user temporary table space that is managed by DATABASE created in a buffer pool which is also used by one regular table space (managed by system) and one system temporary table space(managed by system).
I am new to DB2 on Aix system. Thanks & hope to hear your feedback.
Please also point to me some resource related to this topic/your comment.