-101 on alter table statement

Klemens

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

Subscribe Post Reply

6757

Serge Rielau

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

Klemens

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

Serge Rielau

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

by: Dylan Nicholson | last post by:

Seems that Oracle 9.2 (using MS ODBC driver) requires extra parentheses when adding multiple columns to a table: ALTER TABLE MyTable ADD (MyColumn1 VARCHAR(255), MyColumn2 VARCHAR(255)) vs ...

Oracle Database

Multiple items in an ALTER TABLE statement

by: Adam Fortuno | last post by:

Was in the midst of doing something today and I attempted to drop a number of columns in a table with the following: ALTER TABLE tmp DROP COLUMN col_1, col_2, col_3, col_4; Unfortunately MySQL...

MySQL Database

Alter table weird bug?

by: Jon Combe | last post by:

I have created the following test SQL code to illustrate a real problem I have with some SQL code. CREATE TABLE JCTable ( CustomerName varchar(50) ) ALTER TABLE JCTable ADD CustomerNo int...

Microsoft SQL Server

ALTER TABLE ... ADD COLUMN with SQL Server

by: Mike L | last post by:

Hello all I'm trying to migrate a BE from Access to SQL Server. I've been making changes to the Access BE from the FE with SQL statements, and want to do the same with the BE in SQL Server. ...

Microsoft Access / VBA

Alter Table statment: adding foreign key WITHOUT referential integrity

by: moskie | last post by:

Is there a way to run an alter table statement that adds a constraint for a foreign key, but does *not* check the existing data for refrential integrity? I'm essentially looking for the equivalent...

Microsoft Access / VBA

DB2 - XML and Spatial data in same column - can't alter table once created - PLEASE HELP

by: vasilip | last post by:

I'm testing out db2 for a project I'm starting that requires proper xml support and I can't seem to get both xml and spatial data to work well in the same table. Once having created a table...

DB2 Database

"The statement is too long or too complex".for a simple Alter table statement from CLP

by: Rahul Babbar | last post by:

Hi, I ran the scripts in a file from Command Line Processor and it gave the error for all the constraints being added, but not the indexes being added. For a simple statement like Alter...

DB2 Database

rejected table name in add column quary

by: ahmed222too | last post by:

when i use this quary to add new column, the engine reject the table name and focus on (-) in the table name alter table AH10-A1*1*1-101006 add column sss note: this schema of table name...

Microsoft Access / VBA

ALTER TABLE statement producing Syntax Error

by: JenavaS | last post by:

I am trying to create a macro to change a data type in a column. The table was created using a "make-table" query, and the column(s) I want to modify were created using a calculation in my query. ...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

-101 on alter table statement

Similar topics