Quote:
|
Originally Posted by abdulrehaman2005
Operating system: AIX
I am using DB2 8.2 version
i am getting these errors while performing below operations.
First exception occurs during rebuilding index:
|
What does "rebuilding index" mean in your context? The message you show is not a DB2 message but rather wrapped by some other component/software.
Quote:
(99999) An unknown error occurred. Please try again. If the situation persists, please contact the site administrator. (An error occurred during
implicit system action type "1". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "/* Insert session
based offering */ /* In|BEGIN-OF-STAT".)
|
Have a look at DB2 message SQL0104 and insert the message tokens to understand it better. Maybe something is wrong with your comments at the beginning of some SQL statement?
Quote:
|
Another one occurs after clicking on "Finish" during Offering creation.
|
You will have to explain which tool you are using and where you click "Finish". DB2 doesn't have a GUI - but it comes with some tools to administer it. (It's just that the mentioned tools don't raise such errors as above.)
Quote:
(99999) An unknown error occurred. Please try again. If the situation
persists, please contact the site administrator. (An error occurred during
implicit system action type "1". Information returned for the error
includes SQLCODE "-104", SQLSTATE "42601" and message tokens "/* create
template ent|BEGIN-OF-STATEMENT|<create_method_"
|
Same as above: you have a syntax problem in your SQL statements.
Note that the SQL standard says that a double-dash (--) initiates a comment. DB2 honors that. I'm not sure on the support of /* ... */ style comments in DB2.
Quote:
|
Another occurs during listing tables/schemas/... using eclipse plugin:
|
Again, which plugin?
Quote:
DB@ error:
sql code -443, sqlstate 38553, sqlerrmc:
SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
|
That is error SQL0805. A package was not found. You should refer to the document of your application (the eclipse plugin) to figure out which configuration steps it requires.