Can't restart database after server taken down while database running

[Former Member]

Hi

My database is MAXDB 7.6.0.27 running on Windows 2003 server. The server was taken down while the database was running. The database won't restart. Here is an extract from the diagnostics file which might help :

2008-02-19 16:45:50 0x1B08 20006 Log 1 queues, flushmode is 'MaximizeSafety', devstate is 'HistoryLost'

2008-02-19 16:45:50 0x1B08 20007 Log Oldest not saved is ioseq NIL @ off 1

2008-02-19 16:45:50 0x1B08 20008 Log First known on LogVolume is ioseq 0 @ off 1

2008-02-19 16:45:50 0x1B08 20005 Log Restart from ioseq 0 @ off 1 to ioseq 1723 @ off 552

2008-02-19 16:45:50 0x1B08 20010 Log Result after checking the log device: 'Ok'

2008-02-19 16:45:50 0x1B08 53000 OBJECT Restarted Garbage coll: 1

2008-02-19 16:45:50 0x1B08 11 Rst 168 redo transactions readable and 64 redo tasks available.

2008-02-19 16:45:50 0xBCC 54000 RESTART Previous restart was interrupted.

2008-02-19 16:45:50 0xBCC 7 Restart recovering log from log_volume from IOSeq: '0'

2008-02-19 16:45:50 0xBCC ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.

2008-02-19 16:45:50 0xBCC ERR 32 SrvTasks + Server T151 Id63 dynamic: ''

2008-02-19 16:45:50 0xBCC 20012 Log last-redo-read#54:TR32(20)[12]@2.2952'InsertRecord':20080206:213906

2008-02-19 16:45:50 0xBCC ERR 46 SrvTasks After Job execution the job is still allocating 672 bytes.

2008-02-19 16:45:50 0xBCC ERR 32 SrvTasks + Server T153 Id64 dynamic: ''

2008-02-19 16:45:50 0x1B08 53000 OBJECT Stop active garbage coll: 1

2008-02-19 16:45:50 0x1B08 53000 OBJECT Garbage coll stopped: 0

2008-02-19 16:45:50 0x1B08 ERR 51080 SYSERROR -9407 unexpected error

2008-02-19 16:45:50 0x1B08 ERR 3 Admin Database state: OFFLINE

2008-02-19 16:45:50 0x1B08 ERR 2 Rst + Trans 11 failed during redo with 3 (ExecuteError)

2008-02-19 16:45:50 0x1B08 ERR 20078 Log + Trans: #11 redoExecute committed [1]

2008-02-19 16:45:50 0x1B08 ERR 6 KernelCo + BasisError, Errorcode 720 "file_not_found"

2008-02-19 16:45:50 0x1B08 ERR 6 KernelCo + error, Errorcode 720 "file_not_found"

2008-02-19 16:45:50 0x1B08 ERR 3 Log + Log_AfterImage: type=UpdateRecord/1 isdone=no seq=0 TR11

2008-02-19 16:45:50 0x1B08 ERR 6 Log + Action UpdateRecord.1 Length=112(32) ForceWriting=false WaitForWrite=false LocalCacheAllowed=true

2008-02-19 16:45:50 0x1B08 ERR 6 KernelCo + RedoError, Errorcode 720 "file_not_found"

2008-02-19 16:45:50 0x1B08 ERR 20079 Log + Trans: UndoFile, root:2147483647 last:2147483647 lastseq:4294967295 ()

2008-02-19 16:45:50 0x1B08 ERR 20079 Log + Trans: RedoFile, root:14892 last:14892 lastseq:4294967295 (0)

2008-02-19 16:45:50 0x1B08 ERR 20080 Log + Trans: Redo log writing is DISABLED.

2008-02-19 16:45:50 0x1B08 ERR 20081 Log + Trans: Session: -1.11.0

2008-02-19 16:45:50 0x1B08 ERR 20082 Log + Trans: T151 TRIDX:64

2008-02-19 16:45:50 0x1B08 ERR 20056 Data + Data_ChainSplitSpaceForwardReadChain::Iterator: space is not complete break=14892.80 (ForUpdate)

2008-02-19 16:45:50 0x1B08 ERR 20057 Data + PAM: t151 tr11 root=14892

2008-02-19 16:45:50 0x1B08 ERR 20052 Data + Data_SplitSpace: split space not assigned

2008-02-19 16:45:50 0x1B08 ERR 20051 Data + SplitSpaceReader: currpart=0 currlen=140 restlen=8 releasable

2008-02-19 16:45:50 0x1B08 ERR 20052 Data + Data_SplitSpace: split space not assigned

2008-02-19 16:45:50 0x1B08 19651 CONNECT Connection released, T69

2008-02-19 16:45:50 0x1B08 19621 DBSTATE Shutdown kill requested

2008-02-19 16:45:50 0x1774 ERR 7 Messages Begin of dump of registered messages

2008-02-19 16:45:50 0x1774 ERR 8 Messages End of the message list registry dump

2008-02-19 16:45:50 0x1B74 20000 Trace Start flush kernel trace

2008-02-19 16:45:50 0x1774 19684 TASKING Tracewriter termination timeout: 1200 sec

2008-02-19 16:45:50 0x1B74 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1

2008-02-19 16:45:52 0x1B74 20001 Trace Stop flush kernel trace

2008-02-19 16:45:52 0x1B74 20002 Trace Start flush kernel dump

2008-02-19 16:45:52 0x1B74 20003 Trace Stop flush kernel dump

2008-02-19 16:45:52 0x1B74 19619 TASKING Releasing tracewriter

2008-02-19 16:45:52 0x1774 19890 DIAGHIST Backup of diagnostic files will be forced at next restart

2008-02-19 16:45:52 0x1774 19600 VERSION 'Kernel 7.6.00 Build 027-123-124-939'

2008-02-19 16:45:52 0x1774 19654 DBSTATE SERVERDB 'POLPLANT' has stopped

-

---

current write position -

---

=========================================== end of write cycle ===================

Thanks

[Former Member]

This raises serious doubts about the viability of a strategy based on MaxDB - an application is useless if it can't recover after a system down.

[lbreddemann]

Hi Joe,

please...

you disabled the features to recover the database. What did you expect?

It's possible to do this with any other database as well. Is it sensible to do it? No it isn't. So - don't do it!

MaxDB is perfectly possible to recover - if you let it do it's job.

KR Lars

[Former Member]

I disabled this particular feature after several attempts to restart the database failed. I have another database to which the same thing happened with logging enabled - I followed the steps you suggested, and ended up in the same place with that database. So, my problem wasn't anything got to do with the enabling/disabling of logging. In any event, now I have an unrecoverable database. It is unacceptable to say to my users MaxDB is a viable option, if a solution can't be found here.

[lbreddemann]

HI Joe,

please show us the knldiag of the database where logging is enabled.

MaxDB works fine and reproducible recoverable for thousands of SAP customers - that means large systems and heavy business critical applications.

Backup/Recovery is daily business and often used for e.g. system copies.

What is the exact state of the database (the one with logging enabled) right now?

Is it still the issue where the database cannot be started (-9407 unexpected error).

Or are you talking about the load_systab problem?

KR Lars

[markus_doehr2]

Just to throw in my 0.02 € here:

We were and are running MaxDB/SAPDB/Adabase instances for 13+ years now and I never had any restart problems because of an unclean shutdown or a crash. We don´t use Windows and thus not in the need of rebooting often and/or cyclically.

I, however, understand your concern and this issue should be looked after, but you can´t say it´s not viable because you switched off the database´s ability to do so.

If you run an Oracle database in NOARCHIVE mode and you have such crash on a loaded system the same can happen there.

Markus

[Former Member]

I have another MaxDB (7.5) app running first on Windows 2003 for a couple of years, then on Linux - this trouble never occurred.

I also have 7.6.0.27 running on XP and regularly shut down without stopping the db - again without catastrophic consequences.

This is obviously a combination of 7.6.0.27 and Windows 2003. As I pointed out in another post on this thread, the log setting is irrelevant in this situation because I tried the same crash scenario with logging enabled on another db and that db is just as buggered.

I can't throw out our server and get a linux one, I don't want to research and learn a new db technology, but I can't guarantee no system crashes, so I have to get a database architecture that I can rely on. If there is a solution to my current dilemma, then great, but your trouble-free history is not even worth 0.02 € to me now.

[Former Member]

Lars

The knldiag is :

-

---

Date Time TID(hex) Typ MsgID Label Message-Text

-

---

2008-02-21 11:08:17 0x14E0 19705 CONNECT Loading default TCPIP-DLL, ( 'sqltcp.dll')

2008-02-21 11:08:17 0x14E0 19707 CONNECT WINSOCK: 2.0, SQLTCP-DLL: 7.6.0

2008-02-21 11:08:17 0x14E0 20233 RTE Dump of all kernel parameters start

2008-02-21 11:08:18 0x14E0 20206 RTE Using mode NORMAL for data volume 1

2008-02-21 11:08:18 0x14E0 20234 RTE ADMIN=1

2008-02-21 11:08:18 0x14E0 20234 RTE AKDUMP_ALLOWED=YES

2008-02-21 11:08:18 0x14E0 20234 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO

2008-02-21 11:08:18 0x14E0 20234 RTE AUTHENTICATION_ALLOW=

2008-02-21 11:08:18 0x14E0 20234 RTE AUTHENTICATION_DENY=

2008-02-21 11:08:18 0x14E0 20234 RTE AUTOSAVE=1

2008-02-21 11:08:18 0x14E0 20234 RTE AUTO_RECREATE_BAD_INDEXES=NO

2008-02-21 11:08:18 0x14E0 20234 RTE BACKUPRESULT=1

2008-02-21 11:08:18 0x14E0 20234 RTE BACKUP_BLOCK_CNT=8

2008-02-21 11:08:18 0x14E0 20234 RTE BACKUPHISTFILE=dbm.knl

2008-02-21 11:08:18 0x14E0 20234 RTE BACKUPMED_DEF=dbm.mdf

2008-02-21 11:08:18 0x14E0 20234 RTE CACHE_SIZE=2500

2008-02-21 11:08:18 0x14E0 20234 RTE CALLSTACKLEVEL=0

2008-02-21 11:08:18 0x14E0 20234 RTE CATCACHE_MINSIZE=262144

2008-02-21 11:08:18 0x14E0 20234 RTE CAT_CACHE_SUPPLY=1344

2008-02-21 11:08:18 0x14E0 20234 RTE CHECKDATA=1

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_BACKUP=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_COMMON=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_CONVERTER=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_DATACACHE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_DATAINDEX=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_DATAPAGELOG=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_FBM=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_HASHED_RESULTSET=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_IOMAN=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_KB_REGIONS=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_LOCK_SUPPLY=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_LOCK=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_LOGHISTORY=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_LOGPAGE=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_LOGTRANS=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_LOGVOLUME=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_REGIONS=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_SRVTASKS=0

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_TABLE_WIDTH=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_TRANSLIST=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_TREE_LOCKS=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CHECK_TREE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE CLUSTERED_IO=NO

2008-02-21 11:08:18 0x14E0 20234 RTE COLUMNCOMPRESSION=YES

2008-02-21 11:08:18 0x14E0 20234 RTE _COMMENT=

2008-02-21 11:08:18 0x14E0 20234 RTE CONTROLPASSWORD=***

2008-02-21 11:08:18 0x14E0 20234 RTE CONTROLUSERID=DBM

2008-02-21 11:08:18 0x14E0 20234 RTE CONVERTER_REGIONS=8

2008-02-21 11:08:18 0x14E0 20234 RTE DATABASEFULL=1

2008-02-21 11:08:18 0x14E0 20234 RTE DATACACHE_RGNS=8

2008-02-21 11:08:18 0x14E0 20234 RTE DATA_IO_BLOCK_COUNT=64

2008-02-21 11:08:18 0x14E0 20234 RTE DATA_VOLUME_GROUPS=1

2008-02-21 11:08:18 0x14E0 20234 RTE DATA_VOLUME_MODE_0001=NORMAL

2008-02-21 11:08:18 0x14E0 20234 RTE DATA_VOLUME_NAME_0001=d:\sdb\data\POLPLANT\data\DISKD0001

2008-02-21 11:08:18 0x14E0 20234 RTE DATA_VOLUME_SIZE_0001=131072

2008-02-21 11:08:18 0x14E0 20234 RTE DATA_VOLUME_TYPE_0001=F

2008-02-21 11:08:18 0x14E0 20234 RTE DATE_TIME_FORMAT=INTERNAL

2008-02-21 11:08:18 0x14E0 20234 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H

2008-02-21 11:08:18 0x14E0 20234 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L

2008-02-21 11:08:18 0x14E0 20234 RTE DDLTRIGGER=YES

2008-02-21 11:08:18 0x14E0 20234 RTE DEADLOCK_DETECTION=4

2008-02-21 11:08:18 0x14E0 20234 RTE DEFAULT_CODE=ASCII

2008-02-21 11:08:18 0x14E0 20234 RTE DELAYCOMMIT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE DELAYLOGWRITER=0

2008-02-21 11:08:18 0x14E0 20234 RTE DIAG_HISTORY_NUM=2

2008-02-21 11:08:18 0x14E0 20234 RTE DIAG_HISTORY_PATH=d:\sdb\data\wrk\POLPLANT\DIAGHISTORY

2008-02-21 11:08:18 0x14E0 20234 RTE DIAGSEM=0

2008-02-21 11:08:18 0x14E0 20234 RTE DWIO_AREA_FLUSH=50

2008-02-21 11:08:18 0x14E0 20234 RTE DWIO_AREA_SIZE=50

2008-02-21 11:08:18 0x14E0 20234 RTE DWLRU_TAIL_FLUSH=25

2008-02-21 11:08:18 0x14E0 20234 RTE ENABLE_CHECK_INSTANCE=YES

2008-02-21 11:08:18 0x14E0 20234 RTE ENABLE_SYSTEM_TRIGGERS=YES

2008-02-21 11:08:18 0x14E0 20234 RTE ERROR=3

2008-02-21 11:08:18 0x14E0 20234 RTE _EVENTFILE=knldiag.evt

2008-02-21 11:08:18 0x14E0 20234 RTE _EVENTSIZE=0

2008-02-21 11:08:18 0x14E0 20234 RTE EVENT=1

2008-02-21 11:08:18 0x14E0 20234 RTE EXPAND_COM_TRACE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE EXTERNAL_DUMP_REQUEST=NO

2008-02-21 11:08:18 0x14E0 20234 RTE FBMLOW_IO_RATE=10

2008-02-21 11:08:18 0x14E0 20234 RTE FBM_VOLUME_BALANCE=10

2008-02-21 11:08:18 0x14E0 20234 RTE FBM_VOLUME_COMPRESSION=50

2008-02-21 11:08:18 0x14E0 20234 RTE FILEDIR_SPINLOCKPOOL_SIZE=10

2008-02-21 11:08:18 0x14E0 20234 RTE FORBID_LOAD_BALANCING=NO

2008-02-21 11:08:18 0x14E0 20234 RTE FORMATTING_MODE=PARALLEL

2008-02-21 11:08:18 0x14E0 20234 RTE FORMAT_DATAVOLUME=YES

2008-02-21 11:08:18 0x14E0 20234 RTE HASHED_RESULTSET_CACHESIZE=262144

2008-02-21 11:08:18 0x14E0 20234 RTE HASHED_RESULTSET=YES

2008-02-21 11:08:18 0x14E0 20234 RTE HEAP_CHECK_LEVEL=0

2008-02-21 11:08:18 0x14E0 20234 RTE HIRES_TIMER_TYPE=CPU

2008-02-21 11:08:18 0x14E0 20234 RTE HS_STORAGE_DLL=libhsscopy

2008-02-21 11:08:18 0x14E0 20234 RTE HS_SYNC_INTERVAL=50

2008-02-21 11:08:18 0x14E0 20234 RTE IDXFILELIST_SIZE=0

2008-02-21 11:08:18 0x14E0 20234 RTE INDEX_LEAF_CACHING=2

2008-02-21 11:08:18 0x14E0 20234 RTE INIT_ALLOCATORSIZE=241664

2008-02-21 11:08:18 0x14E0 20234 RTE INSTANCE_TYPE=OLTP

2008-02-21 11:08:18 0x14E0 20234 RTE IOPROCSFOR_PRIO=1

2008-02-21 11:08:18 0x14E0 20234 RTE IOPROCSPER_DEV=1

2008-02-21 11:08:18 0x14E0 20234 RTE IOPROCSSWITCH=2

2008-02-21 11:08:18 0x14E0 20234 RTE JOIN_MAXTAB_LEVEL4=16

2008-02-21 11:08:18 0x14E0 20234 RTE JOIN_MAXTAB_LEVEL9=5

2008-02-21 11:08:18 0x14E0 20234 RTE JOIN_SEARCH_LEVEL=0

2008-02-21 11:08:18 0x14E0 20234 RTE JOIN_TABLEBUFFER=128

2008-02-21 11:08:18 0x14E0 20234 RTE _KERNELDIAGFILE=knldiag

2008-02-21 11:08:18 0x14E0 20234 RTE KERNELDIAGSIZE=800

2008-02-21 11:08:18 0x14E0 20234 RTE _KERNELDUMPFILE=knldump

2008-02-21 11:08:18 0x14E0 20234 RTE _KERNELTRACEFILE=knltrace

2008-02-21 11:08:18 0x14E0 20234 RTE KERNELTRACESIZE=1099

2008-02-21 11:08:18 0x14E0 20234 RTE KERNELVERSION=KERNEL 7.6.00 BUILD 027-123-124-939

2008-02-21 11:08:18 0x14E0 20234 RTE LOAD_BALANCING_CHK=0

2008-02-21 11:08:18 0x14E0 20234 RTE LOAD_BALANCING_DIF=10

2008-02-21 11:08:18 0x14E0 20234 RTE LOAD_BALANCING_EQ=5

2008-02-21 11:08:18 0x14E0 20234 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0

2008-02-21 11:08:18 0x14E0 20234 RTE LOCKSUPPLY_BLOCK=100

2008-02-21 11:08:18 0x14E0 20234 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H

2008-02-21 11:08:18 0x14E0 20234 RTE LOGFULL=1

2008-02-21 11:08:18 0x14E0 20234 RTE LOGSEGMENTFULL=1

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_BACKUP_TO_PIPE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_IO_BLOCK_COUNT=4

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_IO_QUEUE=50

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_MIRRORED=NO

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_QUEUE_COUNT=1

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_SEGMENT_SIZE=2133

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_VOLUME_NAME_001=d:\sdb\data\POLPLANT\log\DISKL001

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_VOLUME_SIZE_001=6400

2008-02-21 11:08:18 0x14E0 20234 RTE LOG_VOLUME_TYPE_001=F

2008-02-21 11:08:18 0x14E0 20234 RTE LRU_FOR_SCAN=NO

2008-02-21 11:08:18 0x14E0 20234 RTE MAXBACKUPDEVS=2

2008-02-21 11:08:18 0x14E0 20234 RTE MAXCPU=1

2008-02-21 11:08:18 0x14E0 20234 RTE MAXDATAVOLUMES=64

2008-02-21 11:08:18 0x14E0 20234 RTE _MAXEVENTS=100

2008-02-21 11:08:18 0x14E0 20234 RTE _MAXEVENTTASKS=2

2008-02-21 11:08:18 0x14E0 20234 RTE MAXGARBAGECOLL=1

2008-02-21 11:08:18 0x14E0 20234 RTE MAXLOCKS=2500

2008-02-21 11:08:18 0x14E0 20234 RTE MAXLOGVOLUMES=2

2008-02-21 11:08:18 0x14E0 20234 RTE MAXPAGER=64

2008-02-21 11:08:18 0x14E0 20234 RTE MAXRGN_REQUEST=-1

2008-02-21 11:08:18 0x14E0 20234 RTE MAXSERVERTASKS=134

2008-02-21 11:08:18 0x14E0 20234 RTE MAXTASKSTACK=1024

2008-02-21 11:08:18 0x14E0 20234 RTE _MAXTRANS=168

2008-02-21 11:08:18 0x14E0 20234 RTE MAXUSERTASKS=20

2008-02-21 11:08:18 0x14E0 20234 RTE MAXVOLUMES=67

2008-02-21 11:08:18 0x14E0 20234 RTE MAX_HASHTABLE_MEMORY=5120

2008-02-21 11:08:18 0x14E0 20234 RTE MAX_LOG_QUEUE_COUNT=0

2008-02-21 11:08:18 0x14E0 20234 RTE MAXMESSAGE_FILES=0

2008-02-21 11:08:18 0x14E0 20234 RTE MAX_MESSAGE_LIST_LENGTH=100

2008-02-21 11:08:18 0x14E0 20234 RTE MAX_RETENTION_TIME=480

2008-02-21 11:08:18 0x14E0 20234 RTE MAX_SERVERTASK_STACK=150

2008-02-21 11:08:18 0x14E0 20234 RTE MAX_SINGLE_HASHTABLE_SIZE=512

2008-02-21 11:08:18 0x14E0 20234 RTE MAX_SPECIALTASK_STACK=200

2008-02-21 11:08:18 0x14E0 20234 RTE MBLOCKDATA_SIZE=32768

2008-02-21 11:08:18 0x14E0 20234 RTE MBLOCKQUAL_SIZE=16384

2008-02-21 11:08:18 0x14E0 20234 RTE MBLOCKSTACK_SIZE=32768

2008-02-21 11:08:18 0x14E0 20234 RTE MBLOCKSTRAT_SIZE=12288

2008-02-21 11:08:18 0x14E0 20234 RTE MCOD=NO

2008-02-21 11:08:18 0x14E0 20234 RTE MEMORY_ALLOCATION_LIMIT=0

2008-02-21 11:08:18 0x14E0 20234 RTE MEM_ENHANCE_LIMIT=0

2008-02-21 11:08:18 0x14E0 20234 RTE MINI_DUMP=NORMAL

2008-02-21 11:08:18 0x14E0 20234 RTE MINREPLYSIZE=4096

2008-02-21 11:08:18 0x14E0 20234 RTE MINSERVERTASKS=134

2008-02-21 11:08:18 0x14E0 20234 RTE MIN_RETENTION_TIME=60

2008-02-21 11:08:18 0x14E0 20234 RTE MONITOR_READ=2147483647

2008-02-21 11:08:18 0x14E0 20234 RTE MONITOR_ROWNO=0

2008-02-21 11:08:18 0x14E0 20234 RTE MONITOR_SELECTIVITY=0

2008-02-21 11:08:18 0x14E0 20234 RTE MONITOR_TIME=2147483647

2008-02-21 11:08:18 0x14E0 20234 RTE MPDISP_LOOPS=1

2008-02-21 11:08:18 0x14E0 20234 RTE MPDISP_PRIO=DEFAULT

2008-02-21 11:08:18 0x14E0 20234 RTE MPRGN_BUSY_WAIT=DEFAULT

2008-02-21 11:08:18 0x14E0 20234 RTE MPRGN_DIRTY_READ=DEFAULT

2008-02-21 11:08:18 0x14E0 20234 RTE MP_RGN_LOOP=-1

2008-02-21 11:08:18 0x14E0 20234 RTE MPRGN_PRIO=DEFAULT

2008-02-21 11:08:18 0x14E0 20234 RTE MPRGN_QUEUE=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OFFICIAL_NODE=

2008-02-21 11:08:18 0x14E0 20234 RTE OMS_HEAP_BLOCKSIZE=10000

2008-02-21 11:08:18 0x14E0 20234 RTE OMS_HEAP_COUNT=1

2008-02-21 11:08:18 0x14E0 20234 RTE OMS_HEAP_LIMIT=0

2008-02-21 11:08:18 0x14E0 20234 RTE OMS_HEAP_THRESHOLD=100

2008-02-21 11:08:18 0x14E0 20234 RTE OMSREGIONS=0

2008-02-21 11:08:18 0x14E0 20234 RTE OMSRGNS=7

2008-02-21 11:08:18 0x14E0 20234 RTE OMS_RUN_IN_UDE_SERVER=NO

2008-02-21 11:08:18 0x14E0 20234 RTE OMS_STREAM_TIMEOUT=30

2008-02-21 11:08:18 0x14E0 20234 RTE OMS_VERS_THRESHOLD=2097152

2008-02-21 11:08:18 0x14E0 20234 RTE ONLINE=1

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_AGGREGATION=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_FETCH_REVERSE=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_FIRST_ROWS=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_JOIN_HASHTABLE=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_JOIN_ONEPHASE=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_JOIN_OUTER=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_MIN_MAX=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_OPERATOR_JOIN=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_QUAL_ON_INDEX=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIMIZE_QUERYREWRITE=STATEMENT

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIM_CACHE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIM_INV_ONLY=YES

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIM_JOIN_FETCH=0

2008-02-21 11:08:18 0x14E0 20234 RTE OPTIM_MAX_MERGE=500

2008-02-21 11:08:18 0x14E0 20234 RTE OUTOFSESSIONS=3

2008-02-21 11:08:18 0x14E0 20234 RTE PACKETSIZE=131072

2008-02-21 11:08:18 0x14E0 20234 RTE PAGESIZE=8192

2008-02-21 11:08:18 0x14E0 20234 RTE PREALLOCATE_IOWORKER=NO

2008-02-21 11:08:18 0x14E0 20234 RTE PRIOBASE_COM=10

2008-02-21 11:08:18 0x14E0 20234 RTE PRIOBASE_IOC=80

2008-02-21 11:08:18 0x14E0 20234 RTE PRIOBASE_RAV=80

2008-02-21 11:08:18 0x14E0 20234 RTE PRIOBASE_REX=40

2008-02-21 11:08:18 0x14E0 20234 RTE PRIOBASE_U2U=100

2008-02-21 11:08:18 0x14E0 20234 RTE PRIOFACTOR=80

2008-02-21 11:08:18 0x14E0 20234 RTE PROTECT_DATACACHE_MEMORY=NO

2008-02-21 11:08:18 0x14E0 20234 RTE READAHEADBLOBS=32

2008-02-21 11:08:18 0x14E0 20234 RTE REQUEST_TIMEOUT=5000

2008-02-21 11:08:18 0x14E0 20234 RTE RESERVEDSERVERTASKS=69

2008-02-21 11:08:18 0x14E0 20234 RTE RESTARTTIME=600

2008-02-21 11:08:18 0x14E0 20234 RTE ROWRGNS=8

2008-02-21 11:08:18 0x14E0 20234 RTE _RTEDUMPFILE=rtedump

2008-02-21 11:08:18 0x14E0 20234 RTE RTE_TEST_REGIONS=0

2008-02-21 11:08:18 0x14E0 20234 RTE RUNDIRECTORY=d:\sdb\data\wrk\POLPLANT

2008-02-21 11:08:18 0x14E0 20234 RTE SEQUENCE_CACHE=1

2008-02-21 11:08:18 0x14E0 20234 RTE SERVERDBFOR_SAP=YES

2008-02-21 11:08:18 0x14E0 20234 RTE SESSION_TIMEOUT=900

2008-02-21 11:08:18 0x14E0 20234 RTE SET_VOLUME_LOCK=YES

2008-02-21 11:08:18 0x14E0 20234 RTE SHAREDSQL_COMMANDCACHESIZE=262144

2008-02-21 11:08:18 0x14E0 20234 RTE SHAREDSQL_EXPECTEDSTATEMENTCOUNT=1500

2008-02-21 11:08:18 0x14E0 20234 RTE SHAREDSQL=YES

2008-02-21 11:08:18 0x14E0 20234 RTE SHOW_MAX_KB_STACK_USE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE SHOW_MAX_STACK_USE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE STANDBY=1

2008-02-21 11:08:18 0x14E0 20234 RTE SUBTREE_LOCKS=NO

2008-02-21 11:08:18 0x14E0 20234 RTE SYMBOL_DEMANGLING=NO

2008-02-21 11:08:18 0x14E0 20234 RTE SYMBOL_RESOLUTION=YES

2008-02-21 11:08:18 0x14E0 20234 RTE SYSTEMERROR=3

2008-02-21 11:08:18 0x14E0 20234 RTE TABRGNS=8

2008-02-21 11:08:18 0x14E0 20234 RTE TASKCLUSTER01=tw;al;ut;2000sv,100bup;10ev,10gc;

2008-02-21 11:08:18 0x14E0 20234 RTE TASKCLUSTER02=ti,100dw;30000us;

2008-02-21 11:08:18 0x14E0 20234 RTE TASKCLUSTER03=compress

2008-02-21 11:08:18 0x14E0 20234 RTE TIME_MEASUREMENT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_AK=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_ALLOCATOR=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_CATALOG=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_CLIENTKERNELCOM=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_COMMON=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_COMMUNICATION=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_CONVERTER=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_DATACHAIN=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_DATAINDEX=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_DATAPAM=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_DATATREE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_DBPROC=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_DEFAULT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_DELETE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_FBM=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_FILEDIR=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_FRAMECTRL=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_INDEX=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_INSERT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_IOMAN=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_IPC=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_JOIN=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_KSQL=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_LOCK=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_LOGACTION=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_LOGHISTORY=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_LOGPAGE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_LOGTRANS=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_LOGVOLUME=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_LONG=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_MEMORY=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_MESSAGES=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OBJECTCONTAINER=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OBJECT_ADD=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OBJECT_ALTER=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OBJECT_FREE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OBJECT_GET=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OBJECT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_CONTAINERDIR=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_CONTEXT=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_ERROR=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_FLUSHCACHE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_INTERFACE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_KEYRANGE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_KEY=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_LOCK=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_MEMORY=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_NEWOBJ=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_SESSION=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_STREAM=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_VAROBJECT=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OMS_VERSION=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_OPTIMIZE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_ORDER_STANDARD=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_ORDER=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGER=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_BUP=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_EV=2

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_GC=20

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_LW=5

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_PG=3

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_SV=5

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_TI=2

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_US=10

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES_UT=5

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PAGES=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_PRIMARY_TREE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_QUERYREWRITE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_RUNTIME=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_SELECT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_SHAREDSQL=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_SQLMANAGER=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_SRVTASKS=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_STOP_ERRORCODE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_SYNCHRONISATION=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_SYSVIEW=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_TABLE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_TIME=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_UPDATE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE TRACE_VOLUME=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRANS_HISTORY_SIZE=0

2008-02-21 11:08:18 0x14E0 20234 RTE TRANSRGNS=8

2008-02-21 11:08:18 0x14E0 20234 RTE TRANS_THRESHOLD_VALUE=60

2008-02-21 11:08:18 0x14E0 20234 RTE UKT_CPU_RELATIONSHIP=NONE

2008-02-21 11:08:18 0x14E0 20234 RTE _UNICODE=YES

2008-02-21 11:08:18 0x14E0 20234 RTE UPDATESTAT_PARALLEL_SERVERS=0

2008-02-21 11:08:18 0x14E0 20234 RTE UPDATESTAT_SAMPLE_ALGO=1

2008-02-21 11:08:18 0x14E0 20234 RTE UPDSTATWANTED=1

2008-02-21 11:08:18 0x14E0 20234 RTE USED_MAX_LOG_QUEUE_COUNT=1

2008-02-21 11:08:18 0x14E0 20234 RTE USESELECTFETCH=YES

2008-02-21 11:08:18 0x14E0 20234 RTE USEVARIABLEINPUT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE USEASYNC_IO=YES

2008-02-21 11:08:18 0x14E0 20234 RTE USE_COROUTINES=YES

2008-02-21 11:08:18 0x14E0 20234 RTE USE_FIBERS=YES

2008-02-21 11:08:18 0x14E0 20234 RTE USEIOPROCS_ONLY=NO

2008-02-21 11:08:18 0x14E0 20234 RTE USE_MEM_ENHANCE=NO

2008-02-21 11:08:18 0x14E0 20234 RTE USE_OPEN_DIRECT=NO

2008-02-21 11:08:18 0x14E0 20234 RTE USE_SYSTEM_PAGE_CACHE=YES

2008-02-21 11:08:18 0x14E0 20234 RTE UTILITYPROTFILE=dbm.utl

2008-02-21 11:08:18 0x14E0 20234 RTE UTILITY_PROTSIZE=100

2008-02-21 11:08:18 0x14E0 20234 RTE VOLUMENO_BIT_COUNT=8

2008-02-21 11:08:18 0x14E0 20234 RTE WORKDATASIZE=8192

2008-02-21 11:08:18 0x14E0 20234 RTE WORKSTACKSIZE=8192

2008-02-21 11:08:18 0x14E0 20234 RTE XP_CONVERTER_REGIONS=0

2008-02-21 11:08:18 0x14E0 20234 RTE XP_DATA_CACHE_RGNS=0

2008-02-21 11:08:18 0x14E0 20234 RTE XP_MAXPAGER=0

2008-02-21 11:08:18 0x14E0 20235 RTE Dump of all kernel parameters done

2008-02-21 11:08:18 0x14E0 19600 VERSION 'Kernel 7.6.00 Build 027-123-124-939'

2008-02-21 11:08:18 0x14E0 19600 VERSION 'W32/INTEL 7.6.00 Build 027-123-124-939'

2008-02-21 11:08:18 0x14E0 19769 INFO Starting SERVERDB: 'POLPLANT'

2008-02-21 11:08:18 0x14E0 19770 INFO SERVERNODE: 'it-citrix.ITBS.local'

2008-02-21 11:08:18 0x14E0 19771 INFO Process ID: 1716

2008-02-21 11:08:18 0x14E0 19773 INFO Date: 2008-02-21

2008-02-21 11:08:18 0x14E0 19772 INFO Owner: 'SYSTEM'

2008-02-21 11:08:18 0x14E0 19774 INFO Product suite: 'Terminal Server'

2008-02-21 11:08:18 0x14E0 19783 INFO Processors: 1 ( logical: 2 )

2008-02-21 11:08:18 0x14E0 19782 INFO Fiber: 'YES'

2008-02-21 11:08:18 0x14E0 19776 INFO Max virtual memory: 2047 MB

2008-02-21 11:08:18 0x14E0 19777 INFO Total physical memory: 2047 MB

2008-02-21 11:08:18 0x14E0 19778 INFO Available physical memory: 1256 MB

2008-02-21 11:08:18 0x14E0 20219 RTE Memory allocation not limited

2008-02-21 11:08:18 0x14E0 20220 RTE System page cache usage enabled

2008-02-21 11:08:18 0x14E0 19692 TCLUSTER tw;al;ut;2000sv,100bup;10ev,10gc;ti,100dw;30000us;compress

2008-02-21 11:08:18 0x14E0 19693 TCLUSTER number of 'BUP': 0

2008-02-21 11:08:18 0x14E0 19693 TCLUSTER number of ' DW': 64

2008-02-21 11:08:18 0x14E0 19693 TCLUSTER number of ' US': 20

2008-02-21 11:08:18 0x14E0 19693 TCLUSTER number of ' SV': 134

2008-02-21 11:08:18 0x14E0 19693 TCLUSTER number of ' EV': 2

2008-02-21 11:08:18 0x14E0 19693 TCLUSTER number of ' GC': 1

2008-02-21 11:08:18 0x14E0 19692 TCLUSTER Total Number of UKT 7

2008-02-21 11:08:18 0x14E0 19692 TCLUSTER Number of UKT with User Tasks 1

2008-02-21 11:08:18 0x14E0 19860 MEMORY I/O buffer cache: 2500 Pages allocated

2008-02-21 11:08:18 0x14E0 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages

2008-02-21 11:08:18 0x14E0 19812 EVENTING Eventbuffer 100 events 2 tasks

2008-02-21 11:08:18 0x748 19821 TASKING Thread 1864 starting

2008-02-21 11:08:18 0x14E0 19831 TRACE_IO Configured MAXMESSAGE_FILES:0

2008-02-21 11:08:18 0x14E0 19832 TRACE_IO Disabled: No TraceMessagefiles wanted

2008-02-21 11:08:18 0xAE8 19688 THREAD CLOCK thread started

2008-02-21 11:08:18 0x1760 20213 RTE CONSOLE thread started

2008-02-21 11:08:18 0x1698 19821 TASKING Thread 5784 starting

2008-02-21 11:08:18 0x1050 19821 TASKING Thread 4176 starting

2008-02-21 11:08:18 0xDC4 19688 THREAD TIMER thread started

2008-02-21 11:08:18 0x1288 19688 THREAD ASYNC0 thread started

2008-02-21 11:08:18 0x1544 19821 TASKING Thread 5444 starting

2008-02-21 11:08:18 0x12AC 19688 THREAD REQUESTOR thread started

2008-02-21 11:08:18 0x220 19821 TASKING Thread 544 starting

2008-02-21 11:08:18 0x8D4 19821 TASKING Thread 2260 starting

2008-02-21 11:08:18 0x17FC 19821 TASKING Thread 6140 starting

2008-02-21 11:08:18 0x1604 19821 TASKING Thread 5636 starting

2008-02-21 11:08:18 0xEC4 19627 TASKING UKT started, TID:0xEC4

2008-02-21 11:08:18 0x1094 19627 TASKING UKT started, TID:0x1094

2008-02-21 11:08:18 0x724 19821 TASKING Thread 1828 starting

2008-02-21 11:08:18 0x1458 19627 TASKING UKT started, TID:0x1458

2008-02-21 11:08:18 0x1524 19627 TASKING UKT started, TID:0x1524

2008-02-21 11:08:18 0x135C 19627 TASKING UKT started, TID:0x135C

2008-02-21 11:08:18 0x744 19821 TASKING Thread 1860 starting

2008-02-21 11:08:18 0x162C 19821 TASKING Thread 5676 starting

2008-02-21 11:08:18 0x126C 19627 TASKING UKT started, TID:0x126C

2008-02-21 11:08:18 0x1594 19821 TASKING Thread 5524 starting

2008-02-21 11:08:19 0x169C 19627 TASKING UKT started, TID:0x169C

2008-02-21 11:08:19 0x169C 19615 VOLUMEIO Attaching volume 'knltrace'

2008-02-21 11:08:20 0xEF8 19613 DBSTATE I/O thread for 'knltrace' started

2008-02-21 11:08:20 0x169C 20040 Admin Kernel state: 'ADMIN' reached

2008-02-21 11:08:20 0x169C 20022 Pager Initialized without clustered IO

2008-02-21 11:08:20 0x169C 9 SrvTasks Available Servertasks: 134

2008-02-21 11:08:20 0x169C 54003 dynpool HIST_DIR item size : 8

2008-02-21 11:08:20 0x169C 54003 dynpool HIST_DIR num items : 20

2008-02-21 11:08:20 0x169C 54003 dynpool DYNP_B930_HIST_DIR : 160

2008-02-21 11:08:20 0x169C 54003 dynDATA DYND_K57_KB_PAGES : 11

2008-02-21 11:08:20 0x169C 54003 dynDATA BACKUP RESTART REC (8K): 1

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP TASK LIST : 1056

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP TAPE LIST : 672

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP DEVSP LIST : 512

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP VOL IDX LIST : 128

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP SRR QUEUE : 3200

2008-02-21 11:08:20 0x169C 54003 dynpool DYNP_K38_SAVE_GLOB : 5056

2008-02-21 11:08:20 0x169C 54003 dynDATA DYND_K38_SAVE : 1065

2008-02-21 11:08:20 0x169C 54003 dynDATA BACKUP RESTART REC (8K): 1

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP TASK LIST : 32

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP TAPE LIST : 672

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP DEVSP LIST : 16

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP VOL IDX LIST : 128

2008-02-21 11:08:20 0x169C 54003 dynpool BACKUP SRR QUEUE : 128

2008-02-21 11:08:20 0x169C 54003 dynpool DYNP_K38_AUTOSAVE : 960

2008-02-21 11:08:20 0x169C 54003 dynDATA DYND_K38_AUTOSAVE : 41

2008-02-21 11:08:20 0x169C 19930 TASKING Kernel initialization completed

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 5

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 68

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 67

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 66

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 65

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 64

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 63

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 62

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 61

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 60

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 59

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 58

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 57

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 56

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 55

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 54

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 53

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 52

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 51

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 50

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 49

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 48

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 47

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 46

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 45

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 44

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 43

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 42

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 41

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 40

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 39

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 38

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 37

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 36

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 35

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 34

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 33

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 32

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 31

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 30

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 29

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 28

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 27

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 26

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 25

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 24

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 23

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 22

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 21

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 20

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 19

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 18

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 17

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 16

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 15

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 14

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 13

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:0

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 12

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:1

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 11

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:2

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 10

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:3

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 9

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:4

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 8

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:5

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 7

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:6

2008-02-21 11:08:20 0x169C 20018 Pager Start TaskId: 6

2008-02-21 11:08:20 0x169C 20019 Pager First DataCacheSegment:7

2008-02-21 11:08:21 0x169C 31 SrvTasks Permanently reserved 66 servertasks for 'Backup / Restore'.

2008-02-21 11:08:21 0xDC4 3 RunTime State changed from STARTING to ADMIN

2008-02-21 11:08:21 0x169C 31 SrvTasks Permanently reserved 2 servertasks for 'Backup / Restore'.

2008-02-21 11:08:21 0x169C 31 SrvTasks Permanently reserved 1 servertasks for 'Savepoint'.

2008-02-21 11:08:21 0xDC4 19601 DBSTATE SERVERDB is ready

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

2008-02-21 12:24:24 0x126C 19633 CONNECT Connect req. (T69, Node:'', PID:2008)

2008-02-21 12:24:24 0x126C 19677 CONNECT Client has released connection, T69

2008-02-21 12:24:24 0x126C 19651 CONNECT Connection released, T69

2008-02-21 12:33:12 0x126C 19633 CONNECT Connect req. (T70, Node:'', PID:2008)

2008-02-21 12:33:13 0x126C 19651 CONNECT Connection released, T70

2008-02-21 12:33:29 0x126C 19633 CONNECT Connect req. (T71, Node:'', PID:2008)

2008-02-21 12:33:30 0x126C 19651 CONNECT Connection released, T71

2008-02-21 12:33:34 0x126C 19633 CONNECT Connect req. (T72, Node:'', PID:2008)

2008-02-21 12:33:35 0x126C 19651 CONNECT Connection released, T72

2008-02-21 12:33:47 0x126C 19633 CONNECT Connect req. (T73, Node:'', PID:2008)

2008-02-21 12:33:48 0x126C 19651 CONNECT Connection released, T73

2008-02-21 12:33:51 0x126C 19633 CONNECT Connect req. (T74, Node:'', PID:2008)

2008-02-21 12:33:51 0x126C 19651 CONNECT Connection released, T74

2008-02-21 12:33:52 0x126C 19633 CONNECT Connect req. (T75, Node:'', PID:2008)

2008-02-21 12:33:53 0x126C 19651 CONNECT Connection released, T75

2008-02-21 13:01:42 0x126C 19633 CONNECT Connect req. (T76, Node:'', PID:2008)

2008-02-21 13:01:42 0x126C 19615 VOLUMEIO Attaching volume 'd:\sdb\data\POLPLANT\data\DISKD0001'

2008-02-21 13:01:42 0x1280 19613 DBSTATE I/O thread for 'd:\sdb\data\POLPLANT\data\DISKD0001' started

2008-02-21 13:01:43 0x126C 19617 VOLUMEIO Single I/O attach, 'd:\sdb\data\POLPLANT\data\DISKD0001', UKT:7

2008-02-21 13:01:43 0x126C 19615 VOLUMEIO Attaching volume 'd:\sdb\data\POLPLANT\log\DISKL001'

2008-02-21 13:01:43 0x17DC 19613 DBSTATE I/O thread for 'd:\sdb\data\POLPLANT\log\DISKL001' started

2008-02-21 13:01:43 0x126C 19617 VOLUMEIO Single I/O attach, 'd:\sdb\data\POLPLANT\log\DISKL001', UKT:7

2008-02-21 13:01:43 0x126C 20016 Pager Start Read Converter

2008-02-21 13:01:43 0x126C 20017 Pager Stop Read Converter, Pages: 8 IO: 8

2008-02-21 13:01:43 0x126C 53000 DATACACH Begin data cache restart

2008-02-21 13:01:43 0x126C 54003 dynpool DATA_CACHE_REGIONS : 8

2008-02-21 13:01:43 0x126C 54003 dynpool B20_DATACACHE_HEAD : 79784

2008-02-21 13:01:43 0x126C 54003 dynpool DATACACHE head num item: 9973

2008-02-21 13:01:43 0x126C 54003 dynpool DATACACHE head item siz: 8

2008-02-21 13:01:43 0x126C 54003 dynpool DATACACHE task queue : 2512

2008-02-21 13:01:43 0x126C 54003 dynpool US + SV + DW + 8 : 157

2008-02-21 13:01:43 0x126C 54003 dynpool DATACACHE taskq elem : 16

2008-02-21 13:01:43 0x126C 54003 dynpool B20_DATACACHE_TASKQ : 82296

2008-02-21 13:01:43 0x126C 54003 dynDATA DATA_CACHE_PAGES : 303

2008-02-21 13:01:43 0x126C 54003 dynpool B20_DATACACHE_CB : 21816

2008-02-21 13:01:43 0x126C 54003 dynpool DATACACHE num cblocks : 303

2008-02-21 13:01:43 0x126C 54003 dynpool DATACACHE cblock size : 72

2008-02-21 13:01:43 0x126C 54003 dynpool DYNP_B20_DATACACHE : 832896

2008-02-21 13:01:43 0x126C 54003 dynDATA DYND_B20_DATACACHE : 2424

2008-02-21 13:01:43 0x126C 53000 DATACACH Finish data cache restart

2008-02-21 13:01:43 0x126C 53000 B*TREE LOB file directory restart successful

2008-02-21 13:01:43 0x126C 7 FileDir File directory restarting

2008-02-21 13:01:43 0x126C 8 FileDir File directory restart completed

2008-02-21 13:01:43 0x126C 20061 Log History: 20 (20) files existing

2008-02-21 13:01:43 0x126C 20064 Log History: all history files registered, GC is ready

2008-02-21 13:01:43 0x126C 54003 dynpool DYNP_K51_LOCK_LIST : 773952

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK maxlocks : 2500

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK items : 9900

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK Regions : 24

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK TransRegions : 8

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK RegionGlob+Space : 3072

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK TransGlob : 640

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK SupplyItemsPerRgn : 100

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK SupplySize : 172800

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK RowHash entries : 2496

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK TabHash entries : 496

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK Row+Tab hash size : 12032

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK Trans entries : 168

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK trans_list size : 32256

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK TransPtrList : 672

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK TransHash entries : 168

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK TransHash size : 768

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK SupplyPoolSegments: 75

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK SupplyPoolSize : 541504

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK ObjColl_list size : 5376

2008-02-21 13:01:43 0x126C 54003 dynpool LOCK ObjReq_list size : 3360

2008-02-21 13:01:43 0x126C 20006 Log 1 queues, flushmode is 'MaximizeSafety', devstate is 'HistoryLost'

2008-02-21 13:01:43 0x126C 20007 Log Oldest not saved is ioseq NIL @ off 1

2008-02-21 13:01:43 0x126C 20008 Log First known on LogVolume is ioseq 0 @ off 1

2008-02-21 13:01:43 0x126C 20005 Log Restart from ioseq 3 @ off 2 to ioseq 3 @ off 2

2008-02-21 13:01:43 0x126C 20010 Log Result after checking the log device: 'Ok'

2008-02-21 13:01:43 0x126C 53000 OBJECT Restarted Garbage coll: 1

2008-02-21 13:01:43 0x126C 11 Rst 168 redo transactions readable and 64 redo tasks available.

2008-02-21 13:01:43 0x135C 7 Restart recovering log from log_volume from IOSeq: '3'

2008-02-21 13:01:43 0x135C 20044 Log normal end of log found at off 2 lastseq 3.

2008-02-21 13:01:43 0x135C 20012 Log last-redo-read#1:TR4294967295(6)[3]@2.92'SavepointEntry':20080221:110812

2008-02-21 13:01:43 0x135C 1 Savepoin Savepoint (Distance) started by T153

2008-02-21 13:01:43 0x135C 20004 Pager SVP(1) Start Write Data

2008-02-21 13:01:43 0x135C 20005 Pager SVP(1) Stop Data IO, Pages: 20 IO: 6

2008-02-21 13:01:43 0x135C 20006 Pager SVP(2) Wait for last task: 156

2008-02-21 13:01:43 0x135C 20007 Pager SVP(2) Stop Wait for last task, Pages: 0 IO: 0

2008-02-21 13:01:43 0x135C 53070 SAVPOINT B20PREPARE_SVP: 8

2008-02-21 13:01:43 0x135C 20008 Pager SVP(3) Start Write Data

2008-02-21 13:01:44 0x135C 20009 Pager SVP(3) Stop Data IO, Pages: 2 IO: 2

2008-02-21 13:01:44 0x135C 20010 Pager SVP(3) Start Write Converter

2008-02-21 13:01:44 0x135C 20011 Pager SVP(3) Stop Converter IO, Pages: 8 IO: 8

2008-02-21 13:01:44 0x135C 53071 SAVPOINT B20SVP_COMPLETED: 8

2008-02-21 13:01:44 0x126C 5 Rst RedoControl: End of redo processing

2008-02-21 13:01:44 0x126C 4 Rst + RedoControl: OldestCommitSeq: NIL, RedoTasks: 64 , MaxRedoTrans: 168

2008-02-21 13:01:44 0x126C 6 Rst + RedoControl: EndOfLogReached: true, RedoIsAborted: false, RedoProcessingDisabled: false

2008-02-21 13:01:44 0x126C 12 Rst + RedoControl: redo reader T0 wait reason: isNotWaiting, waiting redo executer: 0

2008-02-21 13:01:44 0x126C 8 Rst + RedoControl: Transactions processed: 0 (0)

2008-02-21 13:01:44 0x126C 1 Savepoin Savepoint (Restart) started by T76

2008-02-21 13:01:44 0x135C 20004 Pager SVP(1) Start Write Data

2008-02-21 13:01:44 0x135C 20005 Pager SVP(1) Stop Data IO, Pages: 0 IO: 0

2008-02-21 13:01:44 0x135C 20006 Pager SVP(2) Wait for last task: 156

2008-02-21 13:01:44 0x135C 20007 Pager SVP(2) Stop Wait for last task, Pages: 0 IO: 0

2008-02-21 13:01:44 0x135C 9 Log The number of active logging-queues has been increased to 1

2008-02-21 13:01:44 0x135C 53070 SAVPOINT B20PREPARE_SVP: 9

2008-02-21 13:01:44 0x135C 20008 Pager SVP(3) Start Write Data

2008-02-21 13:01:45 0x135C 20009 Pager SVP(3) Stop Data IO, Pages: 2 IO: 1

2008-02-21 13:01:45 0x135C 20010 Pager SVP(3) Start Write Converter

2008-02-21 13:01:45 0x135C 20011 Pager SVP(3) Stop Converter IO, Pages: 4 IO: 4

2008-02-21 13:01:45 0x135C 53071 SAVPOINT B20SVP_COMPLETED: 9

2008-02-21 13:01:45 0x126C 20039 Admin Kernel state: 'REDO LOG' finished

2008-02-21 13:01:45 0x126C 54000 OBJECT d:\program files\sdb\7600\pgm\liboms

2008-02-21 13:01:45 0x126C WRN 5 KernelCo could not create upgrade protocol,RETURNCODE=-4030

2008-02-21 13:01:45 0x126C 3 RunTime State changed from ADMIN to ONLINE

2008-02-21 13:01:45 0x126C 20217 RTE Used physical memory 484 MByte

2008-02-21 13:01:45 0x126C 20041 Admin Kernel state: 'ONLINE' reached

2008-02-21 13:01:45 0x126C 19651 CONNECT Connection released, T76

2008-02-21 13:01:45 0x126C 19633 CONNECT Connect req. (T77, Node:'', PID:2008)

2008-02-21 13:01:46 0x126C 19651 CONNECT Connection released, T77

2008-02-21 13:02:13 0x126C 19633 CONNECT Connect req. (T78, Node:'', PID:2008)

2008-02-21 13:02:14 0x126C 19651 CONNECT Connection released, T78

2008-02-21 13:02:50 0x126C 19633 CONNECT Connect req. (T79, Node:'', PID:2008)

2008-02-21 13:02:50 0x126C 19651 CONNECT Connection released, T79

2008-02-21 13:05:54 0x126C 19633 CONNECT Connect req. (T80, Node:'', PID:2008)

2008-02-21 13:05:55 0x126C 19651 CONNECT Connection released, T80

2008-02-21 13:06:05 0x126C 19633 CONNECT Connect req. (T81, Node:'', PID:2008)

2008-02-21 13:06:06 0x126C 19651 CONNECT Connection released, T81

-

---

current write position -

---

[lbreddemann]

Hi Joe,

well this knldiag shows: database is online.

Why do you think it has not recovered from the crash?

Concerning the load_systab problem: Melanie has hit the nail on the head - the logon data used for the SYSDBA are just wrong.

It appears as if the load_systab was never run on these databases. Could this be the case?

regards

Lars

[Former Member]

Thanks Lars

load_systab has never been run because it appears to need the sysdba user. I cannot connect as the sysdba user because of what I assume to be corrupt system tables.

The database doesn't start correctly because I can't log on or none of the state information (data space usage, log file usage, etc.) appears on the dbmgui, nor can I log on the db, nor can I see the system view dual, etc.

Joe

[lbreddemann]

Hi Joe,

hmm... without load_systab the database can't be installed or correctly patched.

So at least when the database was installed the DBA-Password was known.

The fact that the DBMGUI does not show the status information correctly does not mean the database is not up and running. It "just" means : the system views are invalid and need to be reloaded.

BTW: I read your theory about the corrupted user-table. I don't see how that should happen. The database has recovered all data changes sucessfully (it is online now). This includes updates to the USER table.

If you really doubt that the USER table is consistent, that I would propose you restore a backup of your database into a second instance and check what the password is there.

Can you really connect with

sql_connect dba,dba 

there?

regards,

Lars

[Former Member]

Lars

The only backups of the corrupted databases are those taken after the crashes. However, I am 100% sure that the sysdba is dba. I cannot connect with any user/password combo, other than dbm,dbm.

Joe

[lbreddemann]

Hi Joe -

hmm... the only existing backups for your mission critical database that exist are taken after the crash???

Have you perhabs setup the XUSER logon credentials when the database was still running? Have you had an entry for the dba user setup? If so, you could try to connect to the database like this

dbmcli -d <DBSID> -u dbm,dbm -USQL <xuserkey for dba>

regards,

Lars

[Former Member]

Lars

I'm giving up on this - thanks for your help and that of all other contributors.

I will try again with the latest maxdb build and see if it behaves better in a system crash. If not, I will look to another db architecture.

Joe

[Melanie]

Hello Joe,

although you want to give up on this - I don't.

If you do have a backup of the system after the crash - could you send it to me?

I mean, if it is not too large. I could do some tests and traces to figure out what is going wrong.

Furthermore an email with the latest log files of the database could help (knldiag.err, dbm.prt, knldiag, knldiag.old, dbm.utl.

Thanks,

Melanie

[Melanie]

Melanie

I tried to recreate the corrupted database yesterday by bringing down 
the server with the database online, but the database came back online 
with no corruption after the server rebooted (I had already deleted the 
files of the corrupted databases - this is why I am trying to recreate 
the problem). On Tuesday, our network admin people, who brought down the 
system when the database first got corrupted, will be working on the 
server, so hopefully they can repeat what they did before. In the 
meantime, everything seems to be fine with my current database.

Joe

Hello Joe,

please let us know, if you can reproduce the problem. Please update the forum then. As I'm on vacation starting tomorrow, I won't be able to answer any emails.

Best regards,

Melanie

[Former Member]

Melanie

Both 7.6.3 and 7.6.0 databases have come back up successfully after the network shutdown yesterday. I can't reproduce the original problem and I have deleted the corrupted database files.

I will revisit this thread if the problem occurs again.

Thanks

Joe

[lbreddemann]

Hi Joe,

from the error message it appears that for this database instance log-writing had been disabled:

ERR 51080 SYSERROR -9407 unexpected error ERR 3 Admin Database state: OFFLINE ERR 2 Rst + Trans 11 failed during redo with 3 (ExecuteError) ERR 20078 Log + Trans: #11 redoExecute committed [1] ERR 6 KernelCo + BasisError, Errorcode 720 "file_not_found" ERR 6 KernelCo + error, Errorcode 720 "file_not_found" ERR 3 Log + Log_AfterImage: type=UpdateRecord/1 isdone=no seq=0 TR11 ERR 6 Log + Action UpdateRecord.1 Length=112(32) ForceWriting=false WaitForWrite=false LocalCacheAllowed=true ERR 6 KernelCo + RedoError, Errorcode 720 "file_not_found" ERR 20079 Log + Trans: UndoFile, root:2147483647 last:2147483647 lastseq:4294967295 () ERR 20079 Log + Trans: RedoFile, root:14892 last:14892 lastseq:4294967295 (0) ERR 20080 Log + Trans: Redo log writing is DISABLED. ERR 20081 Log + Trans: Session: -1.11.0 ERR 20082 Log + Trans: T151 TRIDX:64

As the database crashed in a inconsistent state it now tries to recover - from the log that had not been written...

What you can try is:

1) perform a data backup in ADMIN mode

2) perform a CLEAR LOG afterwards and check if you can get the database online.

You will loose the changes that had been done after the last successfull savepoint, but at least the database will reopen.

If it does, make sure that you activate Redo log writing again and that you employ a sound and solid backup strategy.

KR Lars

[Former Member]

Thanks Lars

I did the backup and CLEAR LOG. Now, when I start the db, I get :

-24988 sql error [info state -d]; -4004, unknown table name: INFO_STATE

There are no errors in the knldiag files.

Joe

[Melanie]

Hello Joe,

please load the system tables - either in DBMGUI -> Configuration -> Upgrade system tables or with dbmcli command load_systab.

You migth have to specify the SYSDBA user (defaults are superdba or dba).

Best regards,

Melanie

[Former Member]

Thanks Melanie

Getting worse here. I get

-24907 wrong sysdba [load_systab]

The sysdba user dba - I can see this in dbmgui/configuration/dbm oprtator. I even created a new user called dba1, but still error -24907.

Joe

[lbreddemann]

Hi Joe,

please stop creating users - that's not going to help here.

Please perform the following:

1. Shutdown the database

2. rename the two "user profile container"-files:

/sapdb/data/config/<dbsid>.upc --> <dbsid>.upcold

/sapdb/data/wrk/<DBSID>/wrk/dbm.upc -> dbm.upcold

3. In commandline run the following command:

dbmcli -s -d <DBSID> -u dbm,<pw> dbm_version

4. This command should have recreated the *.upc files. Doublecheck this.

5. Retry to load the systemtables.

KR Lars

[Melanie]

Hi Joe,

this is what I meant with 'migth have to specify the SYSDBA user'. Sorry, that I did not explain that further.

When executing the load_systab command, you should enter:

load_systab -u dba,<password>

Regards,

Melanie

[Former Member]

Thanks Lars

I've created the upc files, but still get the -24907 wrong sysdba error - I think that only the dbm user exists now in the configuration.

Joe

[Melanie]

Hello Joe,

did you try to specify the sysdba user during load_systab as recommended in my previous reply?

Are you sure that your sysdba is called dba?

What is the result of statement "sql_execute select sysdba from dual"?

Try to establish a sql connection with this user: "sql_connect <sysdba>,<password>"

If this does work, try to load the system tables again: "load_systab -u <sysdba>,<password>"

Please post the results of these statements here.

Regards,

Melanie

[Former Member]

Melanie

I have tried load_systab using the sysdba user which I am sure is dba, i.e.,

load_systab -u dba,dba

but I get -24936 ERR_DBNORUN

I can only get the db into admin mode, db_start gets a response of OK, but the db_start command then returns a state of ADMIN.

The sql_execute statement is also not possible in this state.

I can fool dbmcli into thinking the db is online by trying to start it using dbmgui. The db_state then gives :

dbmcli on polplant>db_state

OK

State

ONLINE

The sql_execute statement in dbmcli then tells me :

dbmcli on polplant>sql_execute select sysdba from dual

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name:DUAL

dbmcli on polplant>db_state

OK

State

ONLINE

[Melanie]

Hello Joe,

1. db_start does start the database only in admin mode - this is how it should work.

To start the db on ONLINE mode, use command db_online.

2. You don't fool the dbmcli by starting the database with DBMGUI - DBMGUI just starts the database using the correct command.

3. When the database is ONLINE, please try the sql_connect command with dba user.

4. Also the load_systab command only works when the database is in ONLINE mode. Please try again!

Regards,

Melanie

[Former Member]

Melanie

Here's the latest :

dbmcli on polplant>db_online

OK

---

dbmcli on polplant>db_state

OK

State

ONLINE

dbmcli on polplant>sql_connect dba,dba

ERR

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination

---

dbmcli on polplant>sql_execute select sysdba from du

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name:DUAL

---

dbmcli on polplant>

dbmcli on polplant>load_systab -ud

ERR

-24909,ERR_DBAUNKNOWN: SYSDBA unknown

---

dbmcli on polplant>load_systab -u dba,dba

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

---

Joe

[Melanie]

Hello Joe,

>

> dbmcli on polplant>sql_connect dba,dba

> ERR

> -24988,ERR_SQL: SQL error

> -4008,Unknown user name/password combination

This error means, that user dba with password dba is not correct!

>

> ---

> dbmcli on polplant>sql_execute select sysdba from du

> ERR

> -24988,ERR_SQL: SQL error

> -4004,Unknown table name:DUAL

This error is caused by the not loaded system tables - it cannot work right now.

If you use the same users/passwords on all database instances, you can check the select statement on a system which does not have the same problem. What does it return there?

>

> ---

> dbmcli on polplant>

>

> dbmcli on polplant>load_systab -ud

> ERR

> -24909,ERR_DBAUNKNOWN: SYSDBA unknown

>

> ---

> dbmcli on polplant>load_systab -u dba,dba

> ERR

> -24907,ERR_DBAWRONG: wrong SYSDBA

>

This just confirms the error returned by the sql_connect. dba is not the sysdba user!

Concerning the knldiag from your last reply: The database was successfully started. What is the problem with this database?

Melanie

P.S.: In the future please do not copy the complete knldiag file with all empty lines into a thread. We just need the rows containing text...

[Former Member]

Thanks Melanie

Apologies from the clunky knldiag.

The sysdba is dba. To be on the safe side, I also tried sysdba and dbadmin and every combination of username/password, e.g., sysdba/sysdba sysdba/dba, etc.

I tried the select against another db and here is the outcome :

dbmcli on polplant>sql_execute select sysdba from dual

OK

END

'DBA'

imho, the -24909,ERR_DBAUNKNOWN: SYSDBA unknown is occurring because the user table has become corrupted. It is therefore impossible to connect to the db as other than dbm.

Joe

[markus_doehr2]

If you're a SAP customer I highly suggest you open a call for this.

Markus