Hi, I must migrate a database from one server to another.
My Problem:
The newly created database has no users (except for dbm) and I can not create the admin user.
I tried this: db_online -> ok util_connect dbm,dbm -> ok util_activate dba,dba -> ERR -24988,ERR_SQL: sql error -101, SQL statement not available in this mode
To migrate the database, I first created a new database, then restored a full data backup of the source database into the destination databse and finally I made a full backup of my newly created database (because it is in mode readonly, right?)
ANY HELP APPRECIATED!!! Claudia
===========================================================
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2004-05-27 09:55:38 0xF5C 19769 INFO Starting SERVERDB: 'RESTORE'
2004-05-27 09:55:38 0xF5C 19770 INFO SERVERNODE: 'adonai'
2004-05-27 09:55:38 0xF5C 19771 INFO Process ID: 3924
2004-05-27 09:55:38 0xF5C 19773 INFO Date: 2004-05-27
2004-05-27 09:55:38 0xF5C 19772 INFO Owner: 'SYSTEM'
2004-05-27 09:55:38 0xF5C 19775 INFO Processors: 2
2004-05-27 09:55:38 0xF5C 19782 INFO Fiber: 'YES'
2004-05-27 09:55:38 0xF5C 19776 INFO Max virtual memory: 2047 MB
2004-05-27 09:55:38 0xF5C 19777 INFO Total physical memory: 991 MB
2004-05-27 09:55:38 0xF5C 19778 INFO Available physical memory: 511 MB
2004-05-27 09:55:38 0xF5C 19779 INFO Kernel shared data size: 82 MB
2004-05-27 09:55:38 0xF5C 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;30000*us;compress
2004-05-27 09:55:38 0xF5C 19693 TCLUSTER number of 'BUP': 0
2004-05-27 09:55:38 0xF5C 19693 TCLUSTER number of ' DW': 8
2004-05-27 09:55:38 0xF5C 19693 TCLUSTER number of ' US': 5
2004-05-27 09:55:38 0xF5C 19693 TCLUSTER number of ' SV': 15
2004-05-27 09:55:38 0xF5C 19693 TCLUSTER number of ' EV': 0
2004-05-27 09:55:38 0xF5C 19693 TCLUSTER number of ' GC': 0
2004-05-27 09:55:38 0xF5C 19860 MEMORY RTE PageAllocator: 10000 Pages allocated
2004-05-27 09:55:38 0xF5C 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages
2004-05-27 09:55:38 0xF5C 19813 EVENTING No Eventbuffer created (0 entries 100 tasks)
2004-05-27 09:55:39 0xF5C 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0
2004-05-27 09:55:39 0xF5C 19832 TRACE_IO Disabled: No TraceMessagefiles wanted
2004-05-27 09:55:39 0xF7C 19688 THREAD CLOCK thread started
2004-05-27 09:55:39 0xF80 19688 THREAD TIMER thread started
2004-05-27 09:55:39 0xE20 19688 THREAD ASYNC0 thread started
2004-05-27 09:55:39 0xFAC 19688 THREAD CONSOLE thread started
2004-05-27 09:55:39 0xFB4 19688 THREAD REQUESTOR thread started
2004-05-27 09:55:39 0xFB0 19627 TASKING UKT started, TID:0xFB0
2004-05-27 09:55:39 0xFA8 19627 TASKING UKT started, TID:0xFA8
2004-05-27 09:55:39 0xFB8 19627 TASKING UKT started, TID:0xFB8
2004-05-27 09:55:39 0xFA4 19627 TASKING UKT started, TID:0xFA4
2004-05-27 09:55:39 0xAF0 19627 TASKING UKT started, TID:0xAF0
2004-05-27 09:55:39 0x910 19627 TASKING UKT started, TID:0x910
2004-05-27 09:55:39 0x910 19615 VOLUMEIO Attaching volume 'knltrace'
2004-05-27 09:55:39 0xFBC 19613 DBSTATE I/O thread for 'knltrace' started
2004-05-27 09:55:39 0x910 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:5
2004-05-27 09:55:39 0x910 54003 dynpool DYNP_A51_CACHE : 120
2004-05-27 09:55:39 0x910 54003 dynpool AK51SIZES user + 1 : 6
2004-05-27 09:55:39 0x910 54003 dynpool AK51SIZES headlist all : 24
2004-05-27 09:55:39 0x910 54003 dynpool AK51SIZES headlist elem: 4
2004-05-27 09:55:39 0x910 54003 dynpool AK51SIZES list all : 96
2004-05-27 09:55:39 0x910 54003 dynpool AK51SIZES list element : 16
2004-05-27 09:55:39 0x910 54003 dynpool INDEX FileListItemSize : 8
2004-05-27 09:55:39 0x910 54003 dynpool INDEX NumFileListItems : 2048
2004-05-27 09:55:39 0x910 54003 dynpool INDEX FileListSizeAll : 16384
2004-05-27 09:55:39 0x910 54003 dynpool INDEX FunnelItemSize : 8
2004-05-27 09:55:39 0x910 54003 dynpool INDEX QueueItemPtrSize : 4
2004-05-27 09:55:39 0x910 54003 dynpool INDEX QueueItemSize : 36
2004-05-27 09:55:39 0x910 54003 dynpool INDEX SortItemSize : 16
2004-05-27 09:55:39 0x910 54003 dynpool INDEX NumFunnelItems : 2048
2004-05-27 09:55:39 0x910 54003 dynpool INDEX FunnelSizeAll : 131072
2004-05-27 09:55:39 0x910 54003 dynpool DYNP_B49_IDXSIZE : 147456
2004-05-27 09:55:39 0x910 19600 VERSION 'Kernel 7.4.3 Build 014-120-037-952'
2004-05-27 09:55:39 0x910 19600 VERSION 'W32/INTEL 7.4.3 Build 014-120-037-952'
2004-05-27 09:55:39 0x910 54003 dynDATA DYND_K57_KB_PAGES : 11
2004-05-27 09:55:39 0x910 54003 dynDATA BACKUP RESTART REC (4K): 1
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP TASK LIST : 112
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP TAPE LIST : 304
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP DEVSP LIST : 80
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP SRR QUEUE : 368
2004-05-27 09:55:39 0x910 54003 dynpool DYNP_K38_SAVE_GLOB : 864
2004-05-27 09:55:39 0x910 54003 dynDATA DYND_K38_SAVE : 121
2004-05-27 09:55:39 0x910 54003 dynDATA BACKUP RESTART REC (4K): 1
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP TASK LIST : 32
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP TAPE LIST : 304
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP DEVSP LIST : 16
2004-05-27 09:55:39 0x910 54003 dynpool BACKUP SRR QUEUE : 128
2004-05-27 09:55:39 0x910 54003 dynpool DYNP_K38_AUTOSAVE : 480
2004-05-27 09:55:39 0x910 54003 dynDATA DYND_K38_AUTOSAVE : 41
2004-05-27 09:55:39 0x910 54003 dynpool KB50 mdesc item size : 232
2004-05-27 09:55:39 0x910 54003 dynpool KB90 mdesc items : 23
2004-05-27 09:55:39 0x910 54003 dynpool KB90 mdesc list size : 5336
2004-05-27 09:55:39 0x910 54003 dynpool KB90 mdesc list aligned: 5344
2004-05-27 09:55:39 0x910 54003 dynpool KB90 packet items : 16
2004-05-27 09:55:39 0x910 54003 dynpool KB90 packet desc size : 16
2004-05-27 09:55:39 0x910 54003 dynpool KB90 packet desc list : 256
2004-05-27 09:55:39 0x910 54003 dynpool KB90 packet size : 36656
2004-05-27 09:55:39 0x910 54003 dynpool KB90 packetsize aligned: 36656
2004-05-27 09:55:39 0x910 54003 dynpool KB90 packet list : 586496
2004-05-27 09:55:39 0x910 54003 dynpool KB90 parent list : 512
2004-05-27 09:55:39 0x910 54003 dynpool KB90 kbfunction_task : 22
2004-05-27 09:55:39 0x910 54003 dynpool KB90 parent items / 0.7: 31
2004-05-27 09:55:39 0x910 54003 dynpool KB90 parent desc size : 16
2004-05-27 09:55:39 0x910 54003 dynpool KB90 parentdesc aligned: 496
2004-05-27 09:55:39 0x910 54003 dynpool KB90 parent hash list : 124
2004-05-27 09:55:39 0x910 54003 dynpool KB90 parenthash aligned: 128
2004-05-27 09:55:39 0x910 54003 dynpool KB90 maxservertasks : 15
2004-05-27 09:55:39 0x910 54003 dynpool KB90 server desc size : 24
2004-05-27 09:55:39 0x910 54003 dynpool KB90 server list : 360
2004-05-27 09:55:39 0x910 54003 dynpool KB90 serverlist aligned: 368
2004-05-27 09:55:39 0x910 54003 dynpool DYNP_K90_DISTRIB : 593088
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 5
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:0
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 12
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:1
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 11
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:2
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 10
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:3
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 9
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:4
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 8
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:5
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 7
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:6
2004-05-27 09:55:39 0x910 14 Pager Start TaskId: 6
2004-05-27 09:55:39 0x910 15 Pager First DataCacheSegment:7
2004-05-27 09:55:40 0xF80 19601 DBSTATE SERVERDB is ready
============================================ begin of write cycle ==================
2004-05-27 09:55:40 0xFA8 19633 CONNECT Connect req. (T4, Node:'', PID:3836)
2004-05-27 09:55:40 0xFA8 19651 CONNECT Connection released, T4
2004-05-27 09:55:40 0xFA8 19633 CONNECT Connect req. (T4, Node:'', PID:3836)
2004-05-27 09:55:40 0xFA8 19651 CONNECT Connection released, T4
2004-05-27 09:55:40 0xFA8 19633 CONNECT Connect req. (T4, Node:'', PID:3836)
2004-05-27 09:55:40 0xFA8 19615 VOLUMEIO Attaching volume 'RESTORE_data_001'
2004-05-27 09:55:40 0xD34 19613 DBSTATE I/O thread for 'RESTORE_data_001' started
2004-05-27 09:55:40 0xFA8 19617 VOLUMEIO Single I/O attach, 'RESTORE_data_001', UKT:3
2004-05-27 09:55:40 0xFA8 19615 VOLUMEIO Attaching volume 'RESTORE_data_002'
2004-05-27 09:55:40 0xF9C 19613 DBSTATE I/O thread for 'RESTORE_data_002' started
2004-05-27 09:55:41 0xFA8 19617 VOLUMEIO Single I/O attach, 'RESTORE_data_002', UKT:3
2004-05-27 09:55:41 0xFA8 19615 VOLUMEIO Attaching volume 'RESTORE_log_001'
2004-05-27 09:55:41 0xFC4 19613 DBSTATE I/O thread for 'RESTORE_log_001' started
2004-05-27 09:55:41 0xFA8 19617 VOLUMEIO Single I/O attach, 'RESTORE_log_001', UKT:3
2004-05-27 09:55:41 0xFA8 19615 VOLUMEIO Attaching volume 'RESTORE_log_002'
2004-05-27 09:55:41 0xFC8 19613 DBSTATE I/O thread for 'RESTORE_log_002' started
2004-05-27 09:55:41 0xFA8 19617 VOLUMEIO Single I/O attach, 'RESTORE_log_002', UKT:3
2004-05-27 09:55:41 0xFA8 12 Pager Start Read Converter
2004-05-27 09:55:41 0xFA8 13 Pager Stop Read Converter, Pages: 32 IO: 32
2004-05-27 09:55:41 0xFA8 54003 dynpool DATA_CACHE_REGIONS : 8
2004-05-27 09:55:41 0xFA8 54003 dynpool B20_DATACACHE_HEAD : 79784
2004-05-27 09:55:41 0xFA8 54003 dynpool DATACACHE head num item: 9973
2004-05-27 09:55:41 0xFA8 54003 dynpool DATACACHE head item siz: 8
2004-05-27 09:55:41 0xFA8 54003 dynpool DATACACHE task queue : 576
2004-05-27 09:55:41 0xFA8 54003 dynpool US + SV + DW + 8 : 36
2004-05-27 09:55:41 0xFA8 54003 dynpool DATACACHE taskq elem : 16
2004-05-27 09:55:41 0xFA8 54003 dynpool B20_DATACACHE_TASKQ : 80360
2004-05-27 09:55:41 0xFA8 54003 dynDATA DATA_CACHE_PAGES : 1244
2004-05-27 09:55:41 0xFA8 54003 dynpool B20_DATACACHE_CB : 89568
2004-05-27 09:55:41 0xFA8 54003 dynpool DATACACHE num cblocks : 1244
2004-05-27 09:55:41 0xFA8 54003 dynpool DATACACHE cblock size : 72
2004-05-27 09:55:41 0xFA8 54003 dynpool DYNP_B20_DATACACHE :1359424
2004-05-27 09:55:41 0xFA8 54003 dynDATA DYND_B20_DATACACHE : 9952
2004-05-27 09:55:41 0xFA8 54003 dynpool TREELOCK_HEAD_LIST all : 40028
2004-05-27 09:55:41 0xFA8 54003 dynpool DATA_CACHE_PAGES*10/par: 10007
2004-05-27 09:55:41 0xFA8 54003 dynpool TREELOCK_HEAD_LIST elem: 4
2004-05-27 09:55:41 0xFA8 54003 dynpool TREELOCK_LIST all : 2112
2004-05-27 09:55:41 0xFA8 54003 dynpool (USER + SERVER + 2) * 2: 44
2004-05-27 09:55:41 0xFA8 54003 dynpool TREELOCK_LIST elem : 48
2004-05-27 09:55:41 0xFA8 54003 dynpool TREE_LOCK region count : 8
2004-05-27 09:55:41 0xFA8 54003 dynpool DYNP_B77_TREE_LOCK : 337120
2004-05-27 09:55:41 0xFA8 54003 dynpool DYNP_K51_LOCK_LIST : 671360
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK maxlocks : 2500
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK items : 9900
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK Regions : 24
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK TransRegions : 8
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK RegionGlob+Space : 2304
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK TransGlob : 640
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK SupplyItemsPerRgn : 100
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK SupplySize : 153600
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK RowHash entries : 2496
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK TabHash entries : 496
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK Row+Tab hash size : 12032
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK Trans entries : 88
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK trans_list size : 14848
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK TransPtrList : 352
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK TransHash entries : 88
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK TransHash size : 384
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK SupplyPoolSegments: 75
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK SupplyPoolSize : 481504
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK ObjColl_list size : 2816
2004-05-27 09:55:41 0xFA8 54003 dynpool LOCK ObjReq_list size : 1408
2004-05-27 09:55:41 0xFA8 7 Log 1 queues, flushmode is 'MinimizeSpace', devstate is 'Okay'
2004-05-27 09:55:41 0xFA8 8 Log Oldest not saved is ioseq 7400206 @ off 1
2004-05-27 09:55:41 0xFA8 10 Log LogVolume not completely written until now
2004-05-27 09:55:41 0xFA8 6 Log Restart from ioseq 7400214 @ off 3 to ioseq 7400214 @ off 3
2004-05-27 09:55:41 0xFA8 11 Log Result after checking the log device: 'Ok'
2004-05-27 09:55:41 0xAF0 43 Log recovering log from log_volume from IOSeq: '7400214'
2004-05-27 09:55:41 0xAF0 29 Log normal end of log found at off 3 lastseq 7400214.
2004-05-27 09:55:41 0xAF0 45 Log last-redo-read#1:TR-1(1542)[EMAIL PROTECTED]'SavepointEntry':20040527:94626
2004-05-27 09:55:41 0xFA8 41 Log Savepoint requested by T4 reason 'Restart' (started).
2004-05-27 09:55:41 0xAF0 4 Pager SVP(1) Start Write Data
2004-05-27 09:55:41 0xAF0 5 Pager SVP(1) Stop Data IO, Pages: 0 IO: 0
2004-05-27 09:55:41 0xAF0 6 Pager SVP(2) Wait for last split, TaskId: 29
2004-05-27 09:55:41 0xAF0 7 Pager SVP(2) Stop Wait for last split, Pages: 0 IO: 0
2004-05-27 09:55:41 0xAF0 53070 SAVPOINT B20PREPARE_SVP: 1544
2004-05-27 09:55:41 0xAF0 8 Pager SVP(3) Start Write Data
2004-05-27 09:55:41 0xAF0 9 Pager SVP(3) Stop Data IO, Pages: 1 IO: 1
2004-05-27 09:55:41 0xAF0 10 Pager SVP(3) Start Write Converter
2004-05-27 09:55:41 0xAF0 11 Pager SVP(3) Stop Converter IO, Pages: 2 IO: 2
2004-05-27 09:55:41 0xAF0 53071 SAVPOINT B20SVP_COMPLETED: 1544
2004-05-27 09:55:41 0xFA8 52612 RESTART LOCAL: ready
2004-05-27 09:55:41 0xFA8 54003 dynpool DYNP_A42_PARSEID : 60
2004-05-27 09:55:41 0xFA8 54000 OBJECT C:\OPENSOURCE\SAPDB\DEPEND\pgm\liboms
2004-05-27 09:55:41 0xFA8 53000 DATACACH Reduce Data Cache (pool): 1244
2004-05-27 09:55:41 0xFA8 19602 DBSTATE SERVERDB is in ONLINE state
2004-05-27 09:55:41 0xFA8 19651 CONNECT Connection released, T4
2004-05-27 09:55:41 0xFB8 19633 CONNECT Connect req. (T13, Node:'', PID:3836)
2004-05-27 09:55:41 0xFB8 53000 DATACACH Reduce Data Cache (pool): 1244
2004-05-27 09:55:41 0xFB8 19617 VOLUMEIO Single I/O attach, 'RESTORE_data_001', UKT:6
2004-05-27 09:55:41 0xFB8 19617 VOLUMEIO Single I/O attach, 'RESTORE_data_002', UKT:6
2004-05-27 09:55:41 0xFB8 19651 CONNECT Connection released, T13
2004-05-27 09:55:54 0xFA8 19633 CONNECT Connect req. (T4, Node:'', PID:3836)
-------------------------------------------- current write position ----------------
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
