Hi Claudia, I am a little bit confused about the things you wrote, because I do not understand why you want to create a new sysdba after a successful database restore, because the sysdba is stored in the catalog, which is part of the data backup. Therefore the sysdba name and password of the destination system is equal to the sysdba name and password of the source system.
Note that it is not possible to bring a database in state online, if no sysdba is defined http://dev.mysql.com/doc/maxdb/en/df/ce87b70c35b441af249146c65f5776/frameset.htm Regards, Torsten SAP Labs Berlin -----Urspr�ngliche Nachricht----- Von: Claudia Henkel [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 27. Mai 2004 10:39 An: [EMAIL PROTECTED] Betreff: util_connect -> -101, SQL statement not available in this mode 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
