ij> -- -- Licensed to the Apache Software Foundation (ASF) under one or more -- contributor license agreements. See the NOTICE file distributed with -- this work for additional information regarding copyright ownership. -- The ASF licenses this file to You under the Apache License, Version 2.0 -- (the "License"); you may not use this file except in compliance with -- the License. You may obtain a copy of the License at -- -- http://www.apache.org/licenses/LICENSE-2.0 -- -- Unless required by applicable law or agreed to in writing, software -- distributed under the License is distributed on an "AS IS" BASIS, -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. -- CREATE PROCEDURE RENAME_FILE(LOCATION VARCHAR(32000), NAME VARCHAR(32000), NEW_NAME VARCHAR(32000)) DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.FTFileUtil.renameFile' PARAMETER STYLE JAVA; 0 rows inserted/updated/deleted ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.storage.logArchiveMode'); 1 -------------------------------------------------------------------------------------------------------------------------------- NULL ij> --check whether log archive mode enabling method is working call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 0); 0 rows inserted/updated/deleted ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.storage.logArchiveMode'); 1 -------------------------------------------------------------------------------------------------------------------------------- true ij> --check whether the logArchive Mode is persistent across boots disconnect; ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> connect 'wombat'; ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.storage.logArchiveMode'); 1 -------------------------------------------------------------------------------------------------------------------------------- true ij> --check whether log archive mode disabling method is working call SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(1); 0 rows inserted/updated/deleted ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.storage.logArchiveMode'); 1 -------------------------------------------------------------------------------------------------------------------------------- false ij> --check whether the logArchive Mode disabling persistent across boots disconnect; ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> connect 'wombat'; ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.storage.logArchiveMode'); 1 -------------------------------------------------------------------------------------------------------------------------------- false ij> -- reenable the log archive mode again to see whether the -- disabling has any side effects. call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 0); 0 rows inserted/updated/deleted ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.storage.logArchiveMode'); 1 -------------------------------------------------------------------------------------------------------------------------------- true ij> disconnect; ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> connect 'wombat'; ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.storage.logArchiveMode'); 1 -------------------------------------------------------------------------------------------------------------------------------- true ij> --END OF PROPERTY ARCHIVE CHECKS ---PERFORM DIFFERENT TYPES OF RESTORE create table t1(a int ) ; 0 rows inserted/updated/deleted ij> insert into t1 values(1) ; 1 row inserted/updated/deleted ij> insert into t1 values(2) ; 1 row inserted/updated/deleted ij> insert into t1 values(3 ) ; 1 row inserted/updated/deleted ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 0); 0 rows inserted/updated/deleted ij> insert into t1 values(4) ; 1 row inserted/updated/deleted ij> insert into t1 values(5); 1 row inserted/updated/deleted ij> insert into t1 values(6); 1 row inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --performa rollforward recovery connect 'wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat'; ij> select * from t1 ; A ----------- 1 2 3 4 5 6 ij> insert into t1 values(7); 1 row inserted/updated/deleted ij> insert into t1 values(8); 1 row inserted/updated/deleted ij> insert into t1 values(9); 1 row inserted/updated/deleted ij> --take a backup again call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> insert into t1 values(10); 1 row inserted/updated/deleted ij> insert into t1 values(11); 1 row inserted/updated/deleted ij> insert into t1 values(12); 1 row inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --perform complete version restore connect 'wombat;restoreFrom=extinout/mybackup/wombat'; ij> select * from t1 ; A ----------- 1 2 3 4 5 6 7 8 9 ij> insert into t1 values(10); 1 row inserted/updated/deleted ij> insert into t1 values(11); 1 row inserted/updated/deleted ij> insert into t1 values(12); 1 row inserted/updated/deleted ij> insert into t1 values(13); 1 row inserted/updated/deleted ij> insert into t1 values(14); 1 row inserted/updated/deleted ij> insert into t1 values(15); 1 row inserted/updated/deleted ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --create a new database using wombat db backup copy with a different database name connect 'wombat1;createFrom=extinout/mybackup/wombat'; ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 ij> insert into t1 values(16); 1 row inserted/updated/deleted ij> insert into t1 values(17); 1 row inserted/updated/deleted ij> insert into t1 values(18); 1 row inserted/updated/deleted ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> connect 'wombat1;shutdown=true'; ERROR 08006: Database 'wombat1' shutdown. ij> disconnect; ij> ---BACKUP AND RESTORE USING LOGDEVICE. connect 'crwombat;createFrom=extinout/mybackup/wombat;logDevice=extinout/crwombatlog'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('crwombatlog',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),11); 1 ----------- crwombatlog ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 ij> insert into t1 values(19); 1 row inserted/updated/deleted ij> insert into t1 values(20); 1 row inserted/updated/deleted ij> insert into t1 values(21); 1 row inserted/updated/deleted ij> connect 'crwombat;shutdown=true'; ERROR 08006: Database 'crwombat' shutdown. ij> disconnect; ij> --do a plain boot , we should have the log device specified earlier. connect 'crwombat'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('crwombatlog',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),11); 1 ----------- crwombatlog ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 ij> insert into t1 values(22); 1 row inserted/updated/deleted ij> insert into t1 values(23); 1 row inserted/updated/deleted ij> insert into t1 values(24); 1 row inserted/updated/deleted ij> connect 'crwombat;shutdown=true'; ERROR 08006: Database 'crwombat' shutdown. ij> disconnect; ij> ---check the error case of log device only existing when -- we try to do createFrom . --following connection shoul fail. connect 'erwombat;createFrom=extinout/mybackup/wombat;logDevice=extinout/crwombatlog'; ERROR XJ040: Failed to start database 'erwombat', see the next exception for details. ERROR XSLAT: The log directory 'extinoutcrwombatloglog' exists. The directory might belong to another database. Check that the location specified for the logDevice attribute is correct. ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat;logDevice=extinout/wombatlog'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('wombatlog',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),9); 1 --------- wombatlog ij> select * from t1 ; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 ij> insert into t1 values(19); 1 row inserted/updated/deleted ij> insert into t1 values(20); 1 row inserted/updated/deleted ij> insert into t1 values(21); 1 row inserted/updated/deleted ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --restore again from backup case to make sure --backups are getting the log device property. connect 'wombat;restoreFrom=extinout/mybackup/wombat'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('wombatlog',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),9); 1 --------- wombatlog ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 ij> insert into t1 values(22); 1 row inserted/updated/deleted ij> insert into t1 values(23); 1 row inserted/updated/deleted ij> insert into t1 values(24); 1 row inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --do a vannila boot and see the device to make sure the log device is still intact. connect 'wombat'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('wombatlog',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),9); 1 --------- wombatlog ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 ij> autocommit off; ij> insert into t1 values(25); 1 row inserted/updated/deleted ij> insert into t1 values(26); 1 row inserted/updated/deleted ij> insert into t1 values(27); 1 row inserted/updated/deleted ij> rollback; ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --performa rollforward recovery with logDevice specified at backup connect 'wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('wombatlog',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),9); 1 --------- wombatlog ij> select * from t1 ; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 ij> insert into t1 values(25); 1 row inserted/updated/deleted ij> insert into t1 values(26); 1 row inserted/updated/deleted ij> insert into t1 values(27); 1 row inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --perform a rollforward recovery with log device is moved --to some other place than what it was when backup was taken. --move the log to different dir name. connect 'dummycondb;createFrom=extinout/mybackup/wombat;logDevice=extinout/wombatlog1'; ij> call RENAME_FILE(null,'extinout/wombatlog','extinout/wombatlogmoved'); 0 rows inserted/updated/deleted ij> disconnect; ij> connect 'wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat;logDevice=extinout/wombatlogmoved'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('wombatlogmoved',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),14); 1 -------------- wombatlogmoved ij> select * from t1 ; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 25 26 27 ij> insert into t1 values(30); 1 row inserted/updated/deleted ij> insert into t1 values(31); 1 row inserted/updated/deleted ij> insert into t1 values(32); 1 row inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --do a plain boot and verify the log device. connect 'wombat'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('wombatlogmoved',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),14); 1 -------------- wombatlogmoved ij> select * from t1 ; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 25 26 27 30 31 32 ij> insert into t1 values(33); 1 row inserted/updated/deleted ij> insert into t1 values(34); 1 row inserted/updated/deleted ij> insert into t1 values(35); 1 row inserted/updated/deleted ij> --take a fresh backup again with moved log device. call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --restore and check the results; connect 'wombat;restoreFrom=extinout/mybackup/wombat'; ij> values SUBSTR(SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'), LOCATE('wombatlogmoved',SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')),14); 1 -------------- wombatlogmoved ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 25 26 27 30 31 32 33 34 35 ij> insert into t1 values(36); 1 row inserted/updated/deleted ij> insert into t1 values(37); 1 row inserted/updated/deleted ij> insert into t1 values(38); 1 row inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --simulate OS type copy and then boot(Commented because it does not work in nightlies) --connect 'dummycondb'; --call RENAME_FILE('rollForwardBackup', 'wombat', 'wombat.old'); --call RENAME_FILE(null, 'extinout/mybackup/wombat', 'rollForwardBackup/wombat'); ---disconnect; ---connect 'wombat'; --Following SHOULD SHOW NULL value. --values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'); --select * from t1; --call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( -- 'extinout/mybackup', 1); --connect 'wombat;shutdown=true'; --disconnect; ---createFrom without logDevice specified on URL should have null value. connect 'tempwombat;createFrom=extinout/mybackup/wombat'; ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'); 1 -------------------------------------------------------------------------------------------------------------------------------- NULL ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 25 26 27 30 31 32 33 34 35 ij> insert into t1 values(39); 1 row inserted/updated/deleted ij> insert into t1 values(40); 1 row inserted/updated/deleted ij> insert into t1 values(41); 1 row inserted/updated/deleted ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> connect 'tempwombat;shutdown=true'; ERROR 08006: Database 'tempwombat' shutdown. ij> disconnect; ij> connect 'wombat;restoreFrom=extinout/mybackup/tempwombat'; ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice'); 1 -------------------------------------------------------------------------------------------------------------------------------- NULL ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> ---Using plain backup mechanism rstore/recreate db using restoreFrom/createFrom connect 'wombat'; ij> call SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(1); 0 rows inserted/updated/deleted ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 25 26 27 30 31 32 33 34 35 39 40 41 ij> insert into t1 values(42); 1 row inserted/updated/deleted ij> insert into t1 values(43); 1 row inserted/updated/deleted ij> insert into t1 values(44); 1 row inserted/updated/deleted ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup'); 0 rows inserted/updated/deleted ij> --following inserted values should not be there --when we do restore from the above backup. insert into t1 values(45); 1 row inserted/updated/deleted ij> insert into t1 values(46); 1 row inserted/updated/deleted ij> insert into t1 values(47); 1 row inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat'; ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 25 26 27 30 31 32 33 34 35 39 40 41 42 43 44 ij> insert into t1 values(45); 1 row inserted/updated/deleted ij> insert into t1 values(46); 1 row inserted/updated/deleted ij> insert into t1 values(47); 1 row inserted/updated/deleted ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup'); 0 rows inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> connect 'wombatnew;createFrom=extinout/mybackup/wombat'; ij> select * from t1; A ----------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 19 20 21 22 23 24 25 26 27 30 31 32 33 34 35 39 40 41 42 43 44 45 46 47 ij> insert into t1 values(48); 1 row inserted/updated/deleted ij> insert into t1 values(49); 1 row inserted/updated/deleted ij> insert into t1 values(50); 1 row inserted/updated/deleted ij> connect 'wombatnew;shutdown=true'; ERROR 08006: Database 'wombatnew' shutdown. ij> disconnect; ij> --enable the log archive mode again. connect 'wombat'; ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( 'extinout/mybackup', 1); 0 rows inserted/updated/deleted ij> connect 'wombat;shutdown=true'; ERROR 08006: Database 'wombat' shutdown. ij> disconnect; ij> --NEGATIVE TEST with RESTORE FLAGS -- with createFrom option should give erro on existing database connect 'wombat;createFrom=extinout/mybackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XBM0J: Directory DBLOCATION/wombat already exists. ij> -- specify conflictint attributes; it should fail. connect 'wombat;create=true;createFrom=extinout/mybackup/wombat'; ERROR XJ049: Conflicting create attributes specified. ij> connect 'wombat;create=true;rollForwardRecoveryFrom=extinout/mybackup/wombat'; ERROR XJ049: Conflicting create attributes specified. ij> connect 'wombat;create=true;restoreFrom=extinout/mybackup/wombat'; ERROR XJ049: Conflicting create attributes specified. ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat'; ERROR XJ081: Conflicting create/restore/recovery attributes specified. ij> connect 'wombat;createFrom=extinout/mybackup/wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat'; ERROR XJ081: Conflicting create/restore/recovery attributes specified. ij> -- With wrong back up path name it shoud fail. connect 'wombat;rollForwardRecoveryFrom=nobackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XBM0Y: Backup database directory nobackupwombat not found. Please make sure that the specified backup path is right. ij> connect 'wombat;restoreFrom=nobackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XBM0Y: Backup database directory nobackupwombat not found. Please make sure that the specified backup path is right. ij> connect 'wombat2;createFrom=nobackup/wombat'; ERROR XJ040: Failed to start database 'wombat2', see the next exception for details. ERROR XBM0Y: Backup database directory nobackupwombat not found. Please make sure that the specified backup path is right. ij> --Simulate missing files by renaming some files in backup(like a corrupted backup and check --whether we get proper error messages --Get a connection because it is required to make any calls in ij connect 'wombat2;restoreFrom=extinout/mybackup/wombat'; ij> call RENAME_FILE('extinout/mybackup/wombat/','service.properties','service.properties.old'); 0 rows inserted/updated/deleted ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XBM0Q: File extinoutmybackupwombatservice.properties not found. Please make sure that backup copy is the correct one and it is not corrupted. ij> call RENAME_FILE('extinout/mybackup/wombat/','service.properties.old','service.properties'); 0 rows inserted/updated/deleted ij> call RENAME_FILE('extinout/mybackup/wombat/','log','log.old'); 0 rows inserted/updated/deleted ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XSLAS: Log directory extinoutmybackupwombatlog not found in backup during restore. Please make sure that backup copy is the correct one and it is not corrupted. ij> call RENAME_FILE('extinout/mybackup/wombat/','log.old','log'); 0 rows inserted/updated/deleted ij> call RENAME_FILE('extinout/mybackup/wombat/','seg0','data.old'); 0 rows inserted/updated/deleted ij> connect 'wombat;restoreFrom=extinout/mybackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XSDG6: Data segment directory not found in extinoutmybackupwombat backup during restore. Please make sure that backup copy is the right one and it is not corrupted. ij> call RENAME_FILE('extinout/mybackup/wombat/','data.old','seg0'); 0 rows inserted/updated/deleted ij> --try error cases with createFrom;if root created is not getting cleaned up, --next createFrom call will fail with DBLOCATION/wombat exist error. call RENAME_FILE('extinout/mybackup/wombat/','service.properties','service.properties.old'); 0 rows inserted/updated/deleted ij> connect 'wombat;createFrom=extinout/mybackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XBM0Q: File extinoutmybackupwombatservice.properties not found. Please make sure that backup copy is the correct one and it is not corrupted. ij> call RENAME_FILE('extinout/mybackup/wombat/','service.properties.old','service.properties'); 0 rows inserted/updated/deleted ij> call RENAME_FILE('extinout/mybackup/wombat/','log','log.old'); 0 rows inserted/updated/deleted ij> connect 'wombat;createFrom=extinout/mybackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XSLAS: Log directory extinoutmybackupwombatlog not found in backup during restore. Please make sure that backup copy is the correct one and it is not corrupted. ij> call RENAME_FILE('extinout/mybackup/wombat/','log.old','log'); 0 rows inserted/updated/deleted ij> call RENAME_FILE('extinout/mybackup/wombat/','seg0','data.old'); 0 rows inserted/updated/deleted ij> connect 'wombat;createFrom=extinout/mybackup/wombat'; ERROR XJ040: Failed to start database 'wombat', see the next exception for details. ERROR XSDG6: Data segment directory not found in extinoutmybackupwombat backup during restore. Please make sure that backup copy is the right one and it is not corrupted. ij> call RENAME_FILE('extinout/mybackup/wombat/','data.old','seg0'); 0 rows inserted/updated/deleted ij> drop procedure RENAME_FILE; 0 rows inserted/updated/deleted ij>