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

[Rahul Babbar]

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 table A add constraint A_const foreign key(col1) references
B(col2);

it gives the error like "The statement is too long or too complex".

However, it doesn't give the error for the indexes being created.

If i run this statement in some other tool(or start a new session of
CLP), it works fine.

Before running this file, i ran a big file (around 138 MB) containing
insert scripts.

Could it have caused this unexpected behaviour?
What else could be the reason of this?

Rahul

[Serge Rielau]

Rahul Babbar wrote:

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 table A add constraint A_const foreign key(col1) references
B(col2);

it gives the error like "The statement is too long or too complex".

However, it doesn't give the error for the indexes being created.

If i run this statement in some other tool(or start a new session of
CLP), it works fine.

Before running this file, i ran a big file (around 138 MB) containing
insert scripts.

Could it have caused this unexpected behaviour?
What else could be the reason of this?

Looks like something was leaking memory. Can you open a PMR?
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab