home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT02854 Status: Geschlossen

CREATION OF A VIEW MIGHT RESULT IN SQL0973N ERROR

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all creating views                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 10.5 FP5                                  * 
****************************************************************
Local-Fix:
Lösung
First fixed in version 10.5 FP5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.06.2014
19.01.2016
19.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList