we've got a
- SuSE 7.3 Linux system, - kernel 2.4.20 and - Sapdb 7.4.3.14
running.
As a filesystem for the working directory of Sapdb we are using a software-RAID 1 with a ext3 filesystem on it.
param_startsession param_init param_put MAXUSERTASKS 10 param_checkall param_commitsession param_addvolume 1 LOG LOG_001 F 25000 param_addvolume 1 DATA DAT_001 F 3400000 db_admin util_connect util_execute INIT CONFIG util_activate dba,dba load_systab -ud db
after creation of a database with the script above, which should create a log with 200MByte and a devspace with approx. 27GByte located on the Raid 1 partition, the database is not able to start.
As I can see out of the diag file the devspaces are started correct.
Ok I think I have used the wrong password for the domain user, but the load_systab command should be not the reason.
After setting up the db_warm command in the dbmcli: ERR -24895,ERR_SHUTDOWN: shutdown of database occured -71,connection broken
TIA for your help
Georg
knldiag-file:
...
<snip-snap>
2003-03-12 09:17:15 2517 11007 COMMUNIC wait for connection T24
2003-03-12 09:17:16 2491 11000 New Kernel State 'ADMIN'(22)
======================================= end of startup part ====================
2003-03-12 09:17:16 2491 11570 startup complete
2003-03-12 09:17:16 2492 11561 COMMUNIC Connecting T24 local 2480
2003-03-12 09:17:16 2517 11561 COMMUNIC Connected T24 local 2480
2003-03-12 09:17:16 2517 11560 COMMUNIC Releasing T24
2003-03-12 09:17:16 2517 11007 COMMUNIC wait for connection T24
2003-03-12 09:17:16 2492 11561 COMMUNIC Connecting T24 local 2480
2003-03-12 09:17:16 2517 11561 COMMUNIC Connected T24 local 2480
2003-03-12 09:17:16 2517 11560 COMMUNIC Releasing T24
2003-03-12 09:17:16 2517 11007 COMMUNIC wait for connection T24
2003-03-12 09:27:53 2492 11561 COMMUNIC Connecting T24 local 2480
2003-03-12 09:27:53 2517 11561 COMMUNIC Connected T24 local 2480
2003-03-12 09:27:53 2493 11597 IO Open 'DAT_001' successfull, fd: 19
2003-03-12 09:27:53 2624 12821 TASKING Thread 2624 starting
2003-03-12 09:27:53 2493 11597 IO Open 'DAT_001' successfull, fd: 20
2003-03-12 09:27:53 2624 11565 startup DEVi started
2003-03-12 09:27:53 2625 12821 TASKING Thread 2625 starting
2003-03-12 09:27:53 2517 11000 vattach 'DAT_001' devno 1 T24 succeeded
2003-03-12 09:27:53 2625 11565 startup DEVi started
2003-03-12 09:27:54 2493 11597 IO Open 'LOG_001' successfull, fd: 22
2003-03-12 09:27:54 2626 12821 TASKING Thread 2626 starting
2003-03-12 09:27:54 2493 11597 IO Open 'LOG_001' successfull, fd: 23
2003-03-12 09:27:54 2626 11565 startup DEVi started
2003-03-12 09:27:54 2627 12821 TASKING Thread 2627 starting
2003-03-12 09:27:54 2517 11000 vattach 'LOG_001' devno 2 T24 succeeded
2003-03-12 09:27:54 2627 11565 startup DEVi started
2003-03-12 09:27:54 2517 12 Pager Start Read Converter
2003-03-12 09:27:54 2517 13 Pager Stop Read Converter, Pages: 4 IO: 4
2003-03-12 09:27:54 2517 54003 dynpool DATA_CACHE_REGIONS : 8
2003-03-12 09:27:54 2517 54003 dynpool B20_DATACACHE_HEAD : 79784
2003-03-12 09:27:54 2517 54003 dynpool DATACACHE head num item: 9973
2003-03-12 09:27:54 2517 54003 dynpool DATACACHE head item siz: 8
2003-03-12 09:27:54 2517 54003 dynpool DATACACHE task queue : 608
2003-03-12 09:27:54 2517 54003 dynpool US + SV + DW + 8 : 38
2003-03-12 09:27:54 2517 54003 dynpool DATACACHE taskq elem : 16
2003-03-12 09:27:54 2517 54003 dynpool B20_DATACACHE_TASKQ : 80392
2003-03-12 09:27:54 2517 54003 dynDATA DATA_CACHE_PAGES : 1248
2003-03-12 09:27:54 2517 54003 dynpool B20_DATACACHE_CB : 84864
2003-03-12 09:27:54 2517 54003 dynpool DATACACHE num cblocks : 1248
2003-03-12 09:27:54 2517 54003 dynpool DATACACHE cblock size : 68
2003-03-12 09:27:54 2517 54003 dynpool DYNP_B20_DATACACHE :1322048
2003-03-12 09:27:54 2517 54003 dynDATA DYND_B20_DATACACHE : 9984
2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_HEAD_LIST all : 40028
2003-03-12 09:27:54 2517 54003 dynpool DATA_CACHE_PAGES*10/par: 10007
2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_HEAD_LIST elem: 4
2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_LIST all : 2304
2003-03-12 09:27:54 2517 54003 dynpool (USER + SERVER + 2) * 2: 48
2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_LIST elem : 48
2003-03-12 09:27:54 2517 54003 dynpool TREE_LOCK region count : 8
2003-03-12 09:27:54 2517 54003 dynpool DYNP_B77_TREE_LOCK : 338656
2003-03-12 09:27:54 2517 54003 dynpool DYNP_K51_LOCK_LIST : 673056
2003-03-12 09:27:54 2517 54003 dynpool LOCK maxlocks : 2500
2003-03-12 09:27:54 2517 54003 dynpool LOCK items : 9900
2003-03-12 09:27:54 2517 54003 dynpool LOCK Regions : 24
2003-03-12 09:27:54 2517 54003 dynpool LOCK TransRegions : 8
2003-03-12 09:27:54 2517 54003 dynpool LOCK RegionGlob+Space : 2304
2003-03-12 09:27:54 2517 54003 dynpool LOCK TransGlob : 640
2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplyItemsPerRgn : 100
2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplySize : 153600
2003-03-12 09:27:54 2517 54003 dynpool LOCK RowHash entries : 2496
2003-03-12 09:27:54 2517 54003 dynpool LOCK TabHash entries : 496
2003-03-12 09:27:54 2517 54003 dynpool LOCK Row+Tab hash size : 12032
2003-03-12 09:27:54 2517 54003 dynpool LOCK Trans entries : 96
2003-03-12 09:27:54 2517 54003 dynpool LOCK trans_list size : 16128
2003-03-12 09:27:54 2517 54003 dynpool LOCK TransPtrList : 384
2003-03-12 09:27:54 2517 54003 dynpool LOCK TransHash entries : 96
2003-03-12 09:27:54 2517 54003 dynpool LOCK TransHash size : 384
2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplyPoolSegments: 75
2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplyPoolSize : 481504
2003-03-12 09:27:54 2517 54003 dynpool LOCK ObjColl_list size : 3072
2003-03-12 09:27:54 2517 54003 dynpool LOCK ObjReq_list size : 1536
2003-03-12 09:27:54 2517 ERR 59 Log RESTART ERROR '6416' => SHUTDOWN IS FORCED
2003-03-12 09:27:54 2517 12696 DBSTATE Change DbState to 'SHUTDOWN'(24)
--------------------------------------- current write position -----------------
+++++++++++++++++++++++++++++++++++++++ Kernel Exit ++++++++++++++++++++++++++++
2003-03-12 09:27:54 2483 12845 DBSTATE Kernel exited normal
2003-03-12 09:27:54 2483 12890 DIAGHIST Backup of diagnostic files will be forced at next restart
2003-03-12 09:27:54 2483 12808 DBSTATE Flushing knltrace pages
2003-03-12 09:27:54 2483 11560 COMMUNIC Releasing T24
2003-03-12 09:27:54 2483 12696 DBSTATE Change DbState to 'OFFLINE '(28)
--------------------------------------- current write position -----------------
****************May the sapdb be with you****************
This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
