[luciddb-users] Missing BACKUP_DATABASE/RESTORE_DATABASE routines?

[Vassil K. <vas...@gm...>]

Hi All,

Today I tried to backup my LucidDB 0.7.4 instance and to my surprise I found
out that the backup/restore routines were missing from the SYS_ROOT schema.
I ran the following SQL statement on sqllineClient:
call SYS_ROOT.BACKUP_DATABASE('/usr/luciddb-0.7.4/catalog/full_archive',
'FULL', 'COMPRESSED');
...which yielded the following message:
Error: From line 1, column 15 to line 1, column 94: No match found for
function signature BACKUP_DATABASE(<CHARACTER>, <CHARACTER>, <CHARACTER>)
(state=,code=0)

When I checked the list of registered routines by running SQL:
select * from SYS_ROOT.dba_routines;

I got the following list of routines where I cannot see BACKUP_DATABASE, nor
can I see RESTORE_DATABASE.
Am I missing something?

The list of routines I'm getting is:

ADD_DAYS
ADD_HOURS
CALENDAR_QUARTER
CHAR_REPLACE
CHAR_TO_DATE
CHAR_TO_TIME
CHAR_TO_TIMESTAMP
CLEAN_PHONE
CLEAN_PHONE_INTERNATIONAL
CONTAINS_NUMBER
CONVERT_DATE
CURRENT_DATE_IN_JULIAN
DATE_TO_CHAR
DAY_FROM_JULIAN_START
DAY_IN_YEAR
DAY_NUMBER_OVERALL
DAYS_DIFF
FISCAL_MONTH
FISCAL_QUARTER
FISCAL_YEAR
HOURS_DIFF
INTERNAL_DATE
JULIAN_DAY_TO_DATE
JULIAN_DAY_TO_TIMESTAMP
LEFTN
RAND
REPEATER
RIGHTN
STR_REPLACE
TIME_TO_CHAR
TIMESTAMP_TO_CHAR
CONVERT_CWM_INDEX_ATTRIBUTES_TO_TYPE
CONVERT_CWM_NULLABLE_TO_INT
CONVERT_CWM_NULLABLE_TO_STRING
CONVERT_CWM_PARAM_KIND_TO_INT
CONVERT_CWM_STATISTIC_TO_INT
CONVERT_CWM_TYPENAME_TO_LITERAL_PREFIX
CONVERT_CWM_TYPENAME_TO_LITERAL_SUFFIX
NULL_IDENTIFIER
NULL_REMARKS
BROWSE_CONNECT_FOREIGN_SERVER
BROWSE_FOREIGN_SCHEMAS
CHAR_TO_DATE
CHAR_TO_TIME
CHAR_TO_TIMESTAMP
DATE_TO_CHAR
EXPORT_CATALOG_XMI
EXPORT_QUERY_TO_FILE
EXPORT_SCHEMA_TO_FILE
FLUSH_CODE_CACHE
GET_TABLE_TYPE_BY_MOF_CLASS_NAME
KILL_SESSION
KILL_STATEMENT
KILL_STATEMENT_MATCH
OBJECTS_IN_USE
PERFORCE_CHANGELISTS
PERFORMANCE_COUNTERS
REPOSITORY_INTEGRITY_VIOLATIONS
REPOSITORY_LOB_TEXT
REPOSITORY_PROPERTIES
SESSION_PARAMETERS
SESSIONS
SET_OPT_RULE_DESC_EXCLUSION_FILTER
SLEEP
STAT_GET_CARDINALITY
STAT_GET_ROW_COUNT
STAT_GET_SELECTIVITY
STAT_SET_COLUMN_HISTOGRAM
STAT_SET_PAGE_COUNT
STAT_SET_ROW_COUNT
STATEMENTS
SYSTEM_INFO
THREAD_STACK_ENTRIES
THREADS
TIME_TO_CHAR
TIMESTAMP_TO_CHAR
ALTER_JAVA_PATH
INSTALL_JAR
REMOVE_JAR
REPLACE_JAR
UPDATE_CONFIGURATION
UPDATE_SYSTEM_OBJECTS

Thanks in advance,
Vassil