If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Please give the solutions for these error codes

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-30-07, 01:16
abdulrehaman2005 abdulrehaman2005 is offline
Registered User
 
Join Date: Mar 2007
Posts: 4
Please give the solutions for these error codes

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:

Error Encountered

(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".)

Another one occurs after clicking on "Finish" during Offering creation.

(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_"


Another occurs during listing tables/schemas/... using eclipse plugin:

DB@ error:
sql code -443, sqlstate 38553, sqlerrmc:
SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805

or

Exception in DatabaseMetaData for "Saba DB2@Atlanta"
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLGETTYPEINFO;GETTYPEINFO;SYSIBM:CLI:-805


Thanks
Rehaman
Reply With Quote
  #2 (permalink)  
Old 05-30-07, 04:09
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
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.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On