Hello Hirosh, -9026 means "System error: BD Bad datapage" (which perfectly matches your knldiag.err)
The options are: 1.) If the data page contained an index, maybe that can be dropped and recreated later. 2.) If it's a table and the database would be in state warm the -9026 could be eventually cured by a "check table <tablename>". 3.) If it's a table containing only data generated from other tables and the database is in state warm, it could be regenerated. 4.) If all fails, recover your database. In any case you should check your hardware for errors, and if you are by any chance a SAP customer, please contact SAP's support before trying anything of the above. Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Dabui, Hirosh [mailto:H.Dabui@;asconsa.de] Sent: Dienstag, 29. Oktober 2002 18:23 To: '[EMAIL PROTECTED]' Subject: sapdb 7.2.5 problem I have a problem with our sapdb database. When i will start the database with startdb, that following message is coming: /usr/sap/IDS/SYS/exe/run/startdb: Terminating with error code Starting database Starting Database Instance... OK Opening Database... ERR -24988,ERR_SQL: sql error -9026,Message not available Or here a clip from knldiag.err: -29 16:49:00 28336 ERR 54001 I/O page BE4E0C00010D0200...BE4E0C00010D0200 10-29 16:49:00 28336 ERR 54001 I/O BAD DATA PAGE 1 10-29 16:49:00 28336 ERR 54001 I/O on DEVNO 8 DEV_OFFSET 38576 10-29 16:49:00 28336 ERR 53016 I/O /sapdb/IDS/sapdata/DISKD0008 10-29 16:49:02 28336 ERR 54001 I/O page BE4E0C00010D0200...BE4E0C00010D0200 10-29 16:49:02 28336 ERR 54001 I/O BAD DATA PAGE 1 10-29 16:49:02 28336 ERR 54001 I/O on DEVNO 8 DEV_OFFSET 38576 10-29 16:49:02 28336 ERR 53016 I/O /sapdb/IDS/sapdata/DISKD0008 10-29 16:49:04 28336 ERR 54001 I/O page BE4E0C00010D0200...BE4E0C00010D0200 10-29 16:49:04 28336 ERR 54001 I/O BAD DATA PAGE 1 10-29 16:49:04 28336 ERR 54001 I/O on DEVNO 8 DEV_OFFSET 38576 10-29 16:49:04 28336 ERR 53016 I/O /sapdb/IDS/sapdata/DISKD0008 10-29 16:49:04 28336 ERR 51080 SYSERROR -9026 Message not available 10-29 17:29:04 --- Starting --- 10-29 17:29:11 28691 ERR 54001 I/O page BE4E0C00010D0200...BE4E0C00010D0200 10-29 17:29:11 28691 ERR 54001 I/O BAD DATA PAGE 1 10-29 17:29:11 28691 ERR 54001 I/O on DEVNO 8 DEV_OFFSET 38576 10-29 17:29:11 28691 ERR 53016 I/O /sapdb/IDS/sapdata/DISKD0008 10-29 17:29:13 28691 ERR 54001 I/O page BE4E0C00010D0200...BE4E0C00010D0200 10-29 17:29:13 28691 ERR 54001 I/O BAD DATA PAGE 1 10-29 17:29:13 28691 ERR 54001 I/O on DEVNO 8 DEV_OFFSET 38576 10-29 17:29:13 28691 ERR 53016 I/O /sapdb/IDS/sapdata/DISKD0008 knldiag.err lines 1-23/82 27% What can I do ? bye Hirosh _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
