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' with class loader XXXX,  see the next exception for details.
ERROR XSLAT: The log directory 'extinout<ps>crwombatlog<ps>log' 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' with class loader XXXX,  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' with class loader XXXX,  see the next exception for details.
ERROR XBM0Y: Backup database directory nobackup<ps>wombat 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' with class loader XXXX,  see the next exception for details.
ERROR XBM0Y: Backup database directory nobackup<ps>wombat 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' with class loader XXXX,  see the next exception for details.
ERROR XBM0Y: Backup database directory nobackup<ps>wombat 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' with class loader XXXX,  see the next exception for details.
ERROR XBM0Q: File extinout<ps>mybackup<ps>wombat<ps>service.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' with class loader XXXX,  see the next exception for details.
ERROR XSLAS: Log directory extinout<ps>mybackup<ps>wombat<ps>log 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' with class loader XXXX,  see the next exception for details.
ERROR XSDG6: Data segment directory not found in extinout<ps>mybackup<ps>wombat 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' with class loader XXXX,  see the next exception for details.
ERROR XBM0Q: File extinout<ps>mybackup<ps>wombat<ps>service.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' with class loader XXXX,  see the next exception for details.
ERROR XSLAS: Log directory extinout<ps>mybackup<ps>wombat<ps>log 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' with class loader XXXX,  see the next exception for details.
ERROR XSDG6: Data segment directory not found in extinout<ps>mybackup<ps>wombat 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>