Control Center Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scoffer - 31 Mar 2006 14:17 GMT

Hi all,

I have a problem when I try to open the tables list on a database.
I work with 8.2.0 Enterprise Edition.

The control center return this error:

[IBM][CLI Driver][DB2/NT] SQL0104N E' stato trovato un token "SELECT
TabSchema, Tabname, Type, T" non previsto dopo "BEGIN-OF-STATEMENT". I token
previsti possono comprendere: "<query_expr_top>". SQLSTATE=42601

In english sounds like "an invalidi token "SELECT TabSchema, Tabname, Type,
T" is found after "BEGIN-OF-STATEMENT". The correct token can be
"<query_expr_top>". SQLSTATE=42601

Can you help me??
Thanks

Reply to this Message

Serge Rielau - 31 Mar 2006 14:55 GMT

> Hi all,
>
[quoted text clipped - 10 lines]
> T" is found after "BEGIN-OF-STATEMENT". The correct token can be
> "<query_expr_top>". SQLSTATE=42601

Please post the failing statement as well.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

scoffer - 31 Mar 2006 16:45 GMT

The SQL that the control center try to execute is:

SELECT TabSchema, TabName, Type, TBSpace, INDEX_TBSPACE, LONG_TBSPACE,
DataCapture, Definer, Remarks FROM SYSCAT.Tables WHERE Type in
('T','S','U','H') ORDER BY TabName FOR FETCH ONLY WITH UR

If i try to execute it from command center the sql runs without problem.

If I open the same database with a control center installed on another
machine i don't receive the error.

Is very strange, but I can't reinstall the DB2 'cause I have a database that
have a dimension of 100GByte!!

Do you have an idea??

>> Hi all,
>>
[quoted text clipped - 14 lines]
> Cheers
> Serge

Reply to this Message

Bob [IBM] - 31 Mar 2006 23:46 GMT

> The SQL that the control center try to execute is:
>
[quoted text clipped - 33 lines]
>> Cheers
>> Serge

I cannot help you with the Control Center error - but installing or
reinstalling DB2 has nothing do to with your database ... as long as you
know where your database is catalogued your should be able to reinstall
DB2 and then simply recatalog your database. Reinstalling does not drop
or remove your database. It simply would remove the entry in the system
catalogue directory (since a new one would be created).

Bob

Reply to this Message