DB2 FOR LUW / DB2FORLUW / 970 - DB2

Should the view that you want to create reference a table name 
that does not exist or the name given to the view be a duplicate 
name to an existing database object, the create statement may 
wrongly return error SQL0873N "Not enough storage is available 
in the "AGENT_STACK_SZ" heap or stack to process the statement" 
 
Consider the following scenario: 
db2 "create database MyTstDB" 
db2 "connect to MyTstDB" 
db2 "create table existingObj ( c1 char(10))" 
 
Both the following statements might return SQL0973N instead of 
an error pertaining to the wrong use of an object name: 
 
$ db2 "CREATE VIEW existingObj AS SELECT * FROM existingObj, 
(VALUES 'T') AS X(SOURCE_TAB)" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0973N  Not enough storage is available in the 
"AGENT_STACK_SZ" heap or 
stack to process the statement.  SQLSTATE=57011 
 
$ db2 "CREATE VIEW notFoundObj AS SELECT * FROM notFoundObj, 
(VALUES 'T') AS X(SOURCE_TAB)" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0973N  Not enough storage is available in the 
"AGENT_STACK_SZ" heap or 
stack to process the statement.  SQLSTATE=57011

**************************************************************** 
* USERS AFFECTED:                                              * 
* all creating views                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.7 FP11                                  * 
****************************************************************

First fixed in version 9.7 FP11

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

30.06.2014
06.10.2015
06.10.2015

9.7.FP11