sorry, the second command should be "dbmcli ... db_state". > -----Original Message----- > From: Hahn, Uwe > Sent: Dienstag, 30. September 2003 13:28 > To: 'Andreas Ernst'; SAPDB > Subject: RE: -24988 sql error [sql_connect ...]; 1,database > not running > > > It seems to be a communication problem. > What does "x_cons AEONLINE show state" and "x_cons AEONLINE > show state" print out ? > Uwe > > > -----Original Message----- > > From: Andreas Ernst [mailto:[EMAIL PROTECTED] > > Sent: Dienstag, 30. September 2003 10:22 > > To: Zabach, Elke; SAPDB > > Subject: Re: -24988 sql error [sql_connect ...]; 1,database > > not running > > > > > > Hi Elke, > > > > Zabach, Elke schrieb: > > > > >Andreas Ernst wrote: > > > > > > > > >>Hi all, > > >> > > >>after a server crash, one of the two DBs will not start. > > >> > > >>I get the error > > >> > > >>-24988 sql error [sql_connect ...]; 1,database not running > > >> > > >>Searching in the list archiv is not possible (next link > > >>resets to 'all > > >>lists') and so i found nothing. > > >> > > >>db_cold/offline/warm don' t work - so what can i do? > > >> > > >> > > > > > >'don't work'... > > >what do they return/say? > > > > > AEONLINE - Simone> db_online > > OK > > AEONLINE - Simone> db_cold > > ERROR > > -24988 sql error [db_cold]; 1,database not running > > 1,database not running > > > > AEONLINE - Simone> db_offline > > ERROR > > -24988 sql error [db_offline]; 1,database not running > > 1,database not running > > > > AEONLINE - Simone> db_warm > > OK > > > > db_online/warm always says ok, but the database is still > not running. > > > > database protokoll manager (dbmprt): > > > > 2003-09-30 10:00:47 0x000053c5 0 DBM > > command db_online > > 2003-09-30 10:01:27 0x000053c5 0 DBM command > > param_startsession > > 2003-09-30 10:01:27 0x000053c5 0 DBM command > > param_abortsession > > 2003-09-30 10:01:56 0x000053c5 0 DBM command > > param_startsession > > 2003-09-30 10:01:57 0x000053c5 0 DBM command > > param_abortsession > > 2003-09-30 10:05:17 0x000053c5 0 DBM > command db_cold > > 2003-09-30 10:05:17 0x000053c5 ERR -24988 DBM > > ERR_SQL: sql error > > 0x000053c5 ERR -24988 DBM > 1,database not > > running > > 2003-09-30 10:05:21 0x000053c5 0 DBM > > command db_offline > > 2003-09-30 10:05:21 0x000053c5 ERR -24988 DBM > > ERR_SQL: sql error > > 0x000053c5 ERR -24988 DBM > 1,database not > > running > > 2003-09-30 10:05:25 0x000053c5 0 DBM > command db_warm > > 2003-09-30 10:06:42 0x000053c5 0 DBM > > command db_offline > > 2003-09-30 10:06:42 0x000053c5 ERR -24988 DBM > > ERR_SQL: sql error > > 0x000053c5 ERR -24988 DBM > 1,database not > > running > > > > I viewed all logsfiles (DBMGUI - Check - Diagnosis Files), > > but i did not > > find any message that could help me to get an idea, where > the problem > > is.... :-((( > > > > >what does knldiag says? > > >do you find some info in the archive when looking for that > > what knldiag tells you? > > > > > >Elke > > >SAP Labs Berlin > > > > > > > > > > > >>SuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build > 027-121-048-452 > > >> > > >>regards > > >>Andreas Ernst > > >> > > >> > > I have no idea what i can do, the fastest way to solve the > problem is > > dropping and installing the database, but this is not possible > > (db_cold/offline don't work). > > > > regards > > Andreas Ernst > > > > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
