By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

-101 on alter table statement

P: n/a
Hi,
I get an implicit -101 on an alter table statement on changing the length of
one column

ALTER TABLE XTRADE.LIEFERANT ALTER COLUMN ZENTRALE_NUMMER SET DATA TYPE
VARCHAR(13)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0727N An error occurred during implicit system action type "3".
Information returned for the error includes SQLCODE "-101", SQLSTATE "54001"
and message tokens "". SQLSTATE=56098

In db2diag.log I find:
2005-06-02-18.56.15.877370+120 I1661944A506 LEVEL: Error
PID : 372976 TID : 1 PROC : db2agent (XTRADE) 0
INSTANCE: db2xtest NODE : 000 DB : XTRADE
APPHDL : 0-240 APPID: *LOCAL.db2xtest.050602165614
MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view
DATA #1 : Hexdump, 20 bytes
0x0FFFFFFFFFFE9220 : 5844 455A 2E42 4856 5F46 4150 474C 5F54
XDEZ.BHV_FAPGL_T
0x0FFFFFFFFFFE9230 : 4C5F 4457 L_DW
I tried to increase Statement heap to its limt but it didnt help.
Is there a way to run the statement without explicitly dropping and
recreating the views?

Thanks
Klemens

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Klemens wrote:
Hi,
I get an implicit -101 on an alter table statement on changing the length of
one column

ALTER TABLE XTRADE.LIEFERANT ALTER COLUMN ZENTRALE_NUMMER SET DATA TYPE
VARCHAR(13)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0727N An error occurred during implicit system action type "3".
Information returned for the error includes SQLCODE "-101", SQLSTATE "54001"
and message tokens "". SQLSTATE=56098

In db2diag.log I find:
2005-06-02-18.56.15.877370+120 I1661944A506 LEVEL: Error
PID : 372976 TID : 1 PROC : db2agent (XTRADE) 0
INSTANCE: db2xtest NODE : 000 DB : XTRADE
APPHDL : 0-240 APPID: *LOCAL.db2xtest.050602165614
MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view
DATA #1 : Hexdump, 20 bytes
0x0FFFFFFFFFFE9220 : 5844 455A 2E42 4856 5F46 4150 474C 5F54
XDEZ.BHV_FAPGL_T
0x0FFFFFFFFFFE9230 : 4C5F 4457 L_DW
I tried to increase Statement heap to its limt but it didnt help.
Is there a way to run the statement without explicitly dropping and
recreating the views?

Thanks
Klemens

Which Release, fixpack are you on? This looks like IY45270
http://www.ibm.com/Search/?q=IY45270...&Search=Search

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
DB21085I Instance "db2xtest" uses "64" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "special_13197", "U498350_13197",
and
FixPak "7".
Product is installed at "/usr/opt/db2_08_01".

Seems to be a similar but not the same problem as I am on FP7 and the apar
should be fixed since FP4.

Thanks
Klemens

"Serge Rielau" <sr*****@ca.ibm.com> schrieb im Newsbeitrag
news:3g************@individual.net...
Klemens wrote:
Hi,
I get an implicit -101 on an alter table statement on changing the length of one column

ALTER TABLE XTRADE.LIEFERANT ALTER COLUMN ZENTRALE_NUMMER SET DATA TYPE
VARCHAR(13)
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0727N An error occurred during implicit system action type "3".
Information returned for the error includes SQLCODE "-101", SQLSTATE "54001" and message tokens "". SQLSTATE=56098

In db2diag.log I find:
2005-06-02-18.56.15.877370+120 I1661944A506 LEVEL: Error
PID : 372976 TID : 1 PROC : db2agent (XTRADE) 0 INSTANCE: db2xtest NODE : 000 DB : XTRADE
APPHDL : 0-240 APPID: *LOCAL.db2xtest.050602165614
MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view
DATA #1 : Hexdump, 20 bytes
0x0FFFFFFFFFFE9220 : 5844 455A 2E42 4856 5F46 4150 474C 5F54
XDEZ.BHV_FAPGL_T
0x0FFFFFFFFFFE9230 : 4C5F 4457 L_DW
I tried to increase Statement heap to its limt but it didnt help.
Is there a way to run the statement without explicitly dropping and
recreating the views?

Thanks
Klemens Which Release, fixpack are you on? This looks like IY45270

http://www.ibm.com/Search/?q=IY45270....x=0&Search.y=
0&Search=Search
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #3

P: n/a
Klemens wrote:
DB21085I Instance "db2xtest" uses "64" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "special_13197", "U498350_13197",
and
FixPak "7".
Product is installed at "/usr/opt/db2_08_01".

Seems to be a similar but not the same problem as I am on FP7 and the apar
should be fixed since FP4.

In this case I recommend opening a PMR.
Support will need a db2look to repro the view dependencies on the table

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.