Control Center Error

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??

"Serge Rielau" ha scritto nel messaggio

> scoffer wrote:
>> 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
> Please post the failing statement as well.
>
> Cheers
> Serge
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
 >> Stay informed about: Control Center Error 

scoffer wrote:
> 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??
>
> "Serge Rielau" ha scritto nel messaggio
>
>
>> scoffer wrote:
>>
>>> 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
>>>
>> Please post the failing statement as well.
>>
>> Cheers
>> Serge
>> --
>> Serge Rielau
>> DB2 Solutions Development
>> IBM Toronto Lab
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
 >> Stay informed about: Control Center Error