From: Silke (Pieper78gmx.net)
Date: Mon Feb 23 2004 - 08:21:59 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all,
I've got a
- Windows 2000 system,
- Maxdb 7.5.0.08
running.

param_startsession
param_init
param_put MAXUSERTASKS 100
param_checkall
param_commitsession
db_reg
db_admin
db_activate dba,dba
load_systab -ud domain

after creation of a database with the script above the database is not able to start.
I can't activate the database instance. After setting up the command db_activate dba,dba the following error occurs: ERR -24988,ERR_SQL: sql error
What's wrong here?

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

Silke

knldiag file:

--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2004-02-23 14:06:06 0x3FC 19705 CONNECT Loading default TCPIP-DLL, ( 'sqltcp.dll')
2004-02-23 14:06:06 0x3FC 19707 CONNECT WINSOCK: 2.0, SQLTCP-DLL: 7.5.0
2004-02-23 14:06:08 0x3FC 19841 DIAGHIST Backup of diagnostic files is in progress
2004-02-23 14:06:11 0x3FC 19842 DIAGHIST Backup of diagnostic files has finished
2004-02-23 14:06:11 0x3FC 19769 INFO Starting SERVERDB: 'TESTDB'
2004-02-23 14:06:11 0x3FC 19770 INFO SERVERNODE: 'silke'
2004-02-23 14:06:11 0x3FC 19771 INFO Process ID: 1832
2004-02-23 14:06:11 0x3FC 19773 INFO Date: 2004-02-23
2004-02-23 14:06:11 0x3FC 19772 INFO Owner: 'SYSTEM'
2004-02-23 14:06:11 0x3FC 19775 INFO Processors: 1
2004-02-23 14:06:11 0x3FC 19782 INFO Fiber: 'YES'
2004-02-23 14:06:11 0x3FC 19776 INFO Max virtual memory: 2047 MB
2004-02-23 14:06:11 0x3FC 19777 INFO Total physical memory: 63 MB
2004-02-23 14:06:11 0x3FC 19778 INFO Available physical memory: 10 MB
2004-02-23 14:06:11 0x3FC 202 RTE Memory allocation not limited
2004-02-23 14:06:11 0x3FC 203 RTE System page cache usage enabled
2004-02-23 14:06:11 0x3FC 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;30000*us;compress
2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of 'BUP': 0
2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' DW': 8
2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' US': 100
2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' SV': 11
2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' EV': 1
2004-02-23 14:06:11 0x3FC 19693 TCLUSTER number of ' GC': 0
2004-02-23 14:06:16 0x3FC 19860 MEMORY RTE PageAllocator: 10000 Pages allocated
2004-02-23 14:06:17 0x3FC 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages
2004-02-23 14:06:17 0x3FC 19812 EVENTING Eventbuffer 100 events 1 tasks
2004-02-23 14:06:17 0x3FC 19815 EVENTING No AliveEvent generation
2004-02-23 14:06:18 0x3FC 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0
2004-02-23 14:06:18 0x3FC 19832 TRACE_IO Disabled: No TraceMessagefiles wanted
2004-02-23 14:06:18 0x76C 19688 THREAD CLOCK thread started
2004-02-23 14:06:18 0x750 19688 THREAD TIMER thread started
2004-02-23 14:06:18 0x720 19688 THREAD ASYNC0 thread started
2004-02-23 14:06:18 0x734 196 RTE CONSOLE thread started
2004-02-23 14:06:18 0x55C 19821 TASKING Thread 1372 starting
2004-02-23 14:06:18 0x738 19821 TASKING Thread 1848 starting
2004-02-23 14:06:18 0x5B8 19688 THREAD REQUESTOR thread started
2004-02-23 14:06:28 0x3FC 19649 CONNECT Kernel threads initialization timeout
2004-02-23 14:06:28 0x764 19821 TASKING Thread 1892 starting
2004-02-23 14:06:28 0x748 19627 TASKING UKT started, TID:0x748
2004-02-23 14:06:28 0x760 19627 TASKING UKT started, TID:0x760
2004-02-23 14:06:28 0x730 19627 TASKING UKT started, TID:0x730
2004-02-23 14:06:28 0x6C4 19627 TASKING UKT started, TID:0x6C4
2004-02-23 14:06:28 0x6A8 19627 TASKING UKT started, TID:0x6A8
2004-02-23 14:06:28 0x778 19627 TASKING UKT started, TID:0x778
2004-02-23 14:06:28 0x464 19627 TASKING UKT started, TID:0x464
2004-02-23 14:06:30 0x6A8 19615 VOLUMEIO Attaching volume 'knltrace'
2004-02-23 14:06:30 0x780 19613 DBSTATE I/O thread for 'knltrace' started
2004-02-23 14:06:31 0x6A8 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:6
2004-02-23 14:06:31 0x6A8 32 Admin Kernel state: 'ADMIN' reached
2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_A51_CACHE : 2424
2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES user + 1 : 101
2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES headlist all : 404
2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES headlist elem: 4
2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES list all : 2020
2004-02-23 14:06:31 0x6A8 54003 dynpool AK51SIZES list element : 20
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FileListItemSize : 8
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX NumFileListItems : 2048
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FileListSizeAll : 16384
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FunnelItemSize : 8
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX QueueItemPtrSize : 4
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX QueueItemSize : 36
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX SortItemSize : 16
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX NumFunnelItems : 2048
2004-02-23 14:06:31 0x6A8 54003 dynpool INDEX FunnelSizeAll : 131072
2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_B49_IDXSIZE : 147456
2004-02-23 14:06:31 0x6A8 19600 VERSION 'Kernel 7.5.0 Build 008-123-061-548'
2004-02-23 14:06:31 0x6A8 19600 VERSION 'W32/INTEL 7.5.0 Build 008-123-061-548'
2004-02-23 14:06:31 0x6A8 54003 dynDATA DYND_K57_KB_PAGES : 11
2004-02-23 14:06:31 0x6A8 54003 dynDATA BACKUP RESTART REC (8K): 1
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TASK LIST : 48
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TAPE LIST : 688
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP DEVSP LIST : 16
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP SRR QUEUE : 224
2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_K38_SAVE_GLOB : 976
2004-02-23 14:06:31 0x6A8 54003 dynDATA DYND_K38_SAVE : 73
2004-02-23 14:06:31 0x6A8 54003 dynDATA BACKUP RESTART REC (8K): 1
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TASK LIST : 32
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP TAPE LIST : 688
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP DEVSP LIST : 16
2004-02-23 14:06:31 0x6A8 54003 dynpool BACKUP SRR QUEUE : 128
2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_K38_AUTOSAVE : 864
2004-02-23 14:06:31 0x6A8 54003 dynDATA DYND_K38_AUTOSAVE : 41
2004-02-23 14:06:31 0x6A8 54003 dynpool KB50 mdesc item size : 232
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 mdesc items : 114
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 mdesc list size : 26448
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 mdesc list aligned: 26448
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet items : 12
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet desc size : 16
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet desc list : 192
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet size : 36656
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packetsize aligned: 36656
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 packet list : 439872
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent list : 2592
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 kbfunction_task : 113
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent items / 0.7: 161
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent desc size : 16
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parentdesc aligned: 2576
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parent hash list : 644
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 parenthash aligned: 656
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 maxservertasks : 11
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 server desc size : 24
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 server list : 264
2004-02-23 14:06:31 0x6A8 54003 dynpool KB90 serverlist aligned: 272
2004-02-23 14:06:31 0x6A8 54003 dynpool DYNP_K90_DISTRIB : 470016
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 5
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:0
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 12
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:1
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 11
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:2
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 10
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:3
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 9
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:4
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 8
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:5
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 7
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:6
2004-02-23 14:06:32 0x6A8 14 Pager Start TaskId: 6
2004-02-23 14:06:32 0x6A8 15 Pager First DataCacheSegment:7
2004-02-23 14:06:33 0x750 199 RTE Kernel state changed from STARTING to ADMIN
2004-02-23 14:06:33 0x750 19601 DBSTATE SERVERDB is ready

============================================ begin of write cycle ==================

2004-02-23 14:06:34 0x748 19633 CONNECT Connect req. (T4, Node:'', PID:1856)
2004-02-23 14:06:34 0x748 19651 CONNECT Connection released, T4
2004-02-23 14:06:35 0x748 19633 CONNECT Connect req. (T4, Node:'', PID:1856)
2004-02-23 14:06:35 0x748 19651 CONNECT Connection released, T4
2004-02-23 14:06:35 0x748 19633 CONNECT Connect req. (T4, Node:'', PID:1856)
2004-02-23 14:06:35 0x748 WRN 10 IOMan The Data volume 1 is offline.
2004-02-23 14:06:35 0x748 ERR 17 IOMan EMERGENCY SHUTDOWN
2004-02-23 14:06:35 0x748 ERR 8 Admin ERROR '' CAUSED EMERGENCY SHUTDOWN
2004-02-23 14:06:35 0x748 19620 DBSTATE Shutdown normal requested
2004-02-23 14:06:35 0x6C4 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1
2004-02-23 14:06:35 0x3FC 19684 TASKING Tracewriter termination timeout: 1200 sec
2004-02-23 14:06:44 0x6C4 19619 TASKING Releasing tracewriter
2004-02-23 14:06:44 0x3FC 19890 DIAGHIST Backup of diagnostic files will be forced at next restart
2004-02-23 14:06:44 0x3FC 19600 VERSION 'Kernel 7.5.0 Build 008-123-061-548'
2004-02-23 14:06:44 0x3FC 19654 DBSTATE SERVERDB 'TESTDB' has stopped
-------------------------------------------- current write position ----------------

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]