ADSM-L

LOADDB and RESTORE DB fails

1998-05-27 10:36:38
Subject: LOADDB and RESTORE DB fails
From: Gerhard Hansmair <PromptSoftware AT T-ONLINE DOT DE>
Date: Wed, 27 May 1998 16:36:38 +0200
Environment: ADSM Server V2R1M12 on OS/2

Problem: After halting the server, shutting down the machine and putting it
 to another location  dsmserv failed to start with a
failore ANR9999D dballoc.c... Zero bit count (sorry, I don't have the exact
 message available).

Next we tried a DSMSERV DUMPDB DEVCL=MANTAPE and it worked, but brought
some errors at the end about something it can't read.

After making a new database with DSMSERV INSTALL 1 E:\ADSMDBASE\LOG01.DSM 2
 E:\ADSMDBASE\DB01.DSM 500 E:\ADSMDBASE\DB02.DSM 500
we tried to load the database dump with DSMSERV LOADDB DEVCL=MANTAPE
VOL=DSM054 and we get the following messages

 ANR4039I LOADDB: Loaded 274000 database entries (cumulative).
 ANR4039I LOADDB: Loaded 275000 database entries (cumulative).
 ANR4039I LOADDB: Loaded 276000 database entries (cumulative).
 TABLE ERROR 777 - Please get the following information to ADSM
development:
 Col = 0
 type1 = 2 (x2)
 t ype2 = 3 (x3)

 Key 1 (ascii) ->(3C0C)(00000000)<-
 Key 2 (ascii) ->(CF000000)(00000000)<-

 Key 1 (ebcdic) ->(3C0C)(00000000)<-
 Key 2 (ebcdic) ->(CF000000)(00000000)<-

 Key 1 (hex) ->(3C0C)(00000000)<-
 Key 2 (hex) ->(CF000000)(00000000)<-

 ANR9999D pkthread.c(741): Run-time assertion failed: "type1 == TBCOL_NULL
||
 type2 == TBCOL_NULL", Thread 0, File tbcol.c, Line 761.
 ANR7836S Server initialization terminated.
 ANR7837S Internal error TBCOL777 detected.


After several tries with new databases on different drives we decided to
restore an old database backup.
Creating a new database and starting DSMSERV RESTORE DB TODATE=TODAY we
get:

 ANR4639I Restored 45888 of 60530 database pages.
 ANR4639I Restored 49744 of 60530 database pages.
 ANR4639I Restored 53600 of 60530 database pages.
 ANR4639I Restored 57456 of 60530 database pages.
 ANR4640I Restored 60530 pages from backup series 6 operation 0.
 ANR0306I Recovery log volume mount in progress.
 ANR9999D dballoc.c(823): Zero bit count mismatch for SMP page addr 9216;
Zero
 Bits = 601, HeaderZeroBits = 0.
 ANR0361E Database initialization failed: error initializing database page
 allocator.
 ANR9999D icrest.c(1257): Unable to initialize database.
 ANR1364I Input volume DSM013 closed.
 ANR2032E RESTORE DB: Command failed - internal server error detected.

Then we upgraded the server to V2R1M14 --> the same.

Does anybody know, what's going on, how to get out of this situation ?
Why to make database backups, when I can't use them later on ?


Thanks

Gerhard
<Prev in Thread] Current Thread [Next in Thread>