 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / June 2006Error =?iso-8859-1?Q?=EDn?= DB2 6.1
Hi, I know DB2 6.1 is out of service. Please don't send any messages according to this point. An application without any documentation throws an error message: SQLCODE: -702 SQLSTATE: 57011 SQLERRMC: 49 Searching this error message in Google gives no senseful result. Do you have any ideas? Thanks in advance for any support Dirk Possibly 57011 table unavailable no primary key index exists Check other sources of diagnostics, db2diag.log, tracing etc, but it may be a simple problem. > Hi, > [quoted text clipped - 14 lines] > > Dirk mike <_link98@yahoo.com>: > Possibly > 57011 table unavailable no primary key index exists Hmmm ... > Check other sources of diagnostics, db2diag.log, tracing etc, but it > may be a simple problem. Unfortunately I don't have any entry in db2diag.log ... Thanks for your support! Regards Dirk > mike <_link98@yahoo.com>: > >> Possibly >> 57011 table unavailable no primary key index exists db2 => ? 57011; SQLSTATE 57011: Virtual storage or database resource is not available. When do you get this message. bump teh DIAGLEVEL to 4 and see what DB2 dimps then into the db2diag.log Cheers Serge  SignatureSerge Rielau DB2 Solutions Development IBM Toronto Lab IOD Conference http://www.ibm.com/software/data/ondemandbusiness/conf2006/ Serge Rielau <srielau@ca.ibm.com>: > When do you get this message. bump teh DIAGLEVEL to 4 and see what DB2 > dimps then into the db2diag.log DIAGLEVEL and NOTIFYLEVEL are both set to 4 but I can't see any results in db2diag.log. Can it be, that there is a client problem? Regards Dirk > Serge Rielau <srielau@ca.ibm.com>: > [quoted text clipped - 5 lines] > > Can it be, that there is a client problem? Which interface are you using? Can you get the complete SQLCA out? Cheers Serge SignatureSerge Rielau DB2 Solutions Development IBM Toronto Lab IOD Conference http://www.ibm.com/software/data/ondemandbusiness/conf2006/ Serge Rielau <srielau@ca.ibm.com>: > Which interface are you using? Can you get the complete SQLCA out? Many thanks for your support. The application connects several (undocumented) data sources. Now it is clear, that the error occurs on the mainfram sql/ds. We have to contact a host developper to fix. Thanks again, Dirk > Serge Rielau <srielau@ca.ibm.com>: > [quoted text clipped - 4 lines] > The application connects several (undocumented) data sources. Now it is > clear, that the error occurs on the mainfram sql/ds. SQL/DS? Wow! SignatureSerge Rielau DB2 Solutions Development IBM Toronto Lab IOD Conference http://www.ibm.com/software/data/ondemandbusiness/conf2006/ Serge Rielau <srielau@ca.ibm.com>: >> The application connects several (undocumented) data sources. Now it is >> clear, that the error occurs on the mainfram sql/ds. > SQL/DS? Wow! Yes. It is a historically grown construct ... Dirk Signaturehttp://www.deimeke.net/dirk/blog/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.